No announcements
Found 108033 threads
-
0 VotesVBA looping statements
1.Difference between FOR Loop and DO..WHILE and DO..UNTIL looping statements in VBA? brief difference between DO..WHILE and DO..UNTIL looping ...Unanswered | 1 Replies | 580 Views | Created by rammi y - Wednesday, September 9, 2015 6:28 PM | Last reply by George123345 - Thursday, September 10, 2015 2:18 AM
-
1 Votes
How to increase MaxLocksPerFile?
I'm trying to figure out how to change this setting. I can't find it in any options, and I can't understand the syntax I should use in VBA to do it in code using the SetOptions method. WhatAnswered | 2 Replies | 1566 Views | Created by HTHP - Friday, July 31, 2015 4:37 PM | Last reply by HTHP - Friday, July 31, 2015 5:29 PM -
10 Votes
looping and for statements
this is the assignment and I am stuck on how to do it. I don't need you to do it for me but if you would help me get the program to work I would love that. I am bad at programming and my teacher ...Answered | 7 Replies | 594 Views | Created by iHatePrograming - Friday, October 2, 2015 7:21 PM | Last reply by Ed Price - MSFT - Sunday, October 4, 2015 8:36 AM -
0 Votes
Help with VBA Looping
Thank you mogulman52. I think I was focused on a VBA solution because I have so much other VBA code in this particular Excel workbook. I should have considered SQL a little more ...Answered | 5 Replies | 475 Views | Created by VBA3522 - Monday, July 11, 2016 4:14 PM | Last reply by mogulman52 - Wednesday, July 13, 2016 3:50 PM -
0 Votes
Looping if statements in other text boxes
Question, So I have a 3 combo boxes with items inside. Ex: Water, Soda, Beer. I have a button when clicked it would add the sum of prices in another textbox. Inside the button I have if ...Answered | 5 Replies | 486 Views | Created by DTAP09 - Wednesday, October 29, 2014 5:59 PM | Last reply by pvdg42 - Friday, October 31, 2014 1:24 PM -
0 Votes
Creating multiple table appends using a range on a form?
of my process wth actual queries (append/update) and have not had much luck using recordsets and insert statements via VBA so i'm looking for suggestions and some ...Answered | 12 Replies | 3865 Views | Created by Wannabe guy - Wednesday, January 26, 2011 5:58 AM | Last reply by Wannabe guy - Wednesday, February 23, 2011 10:20 AM -
1 Votes
Read one column values from Access database and sort randomly and put the sorted values into other column
Hi Manjunath, You can use VBA code to execute SQL statements, select some field from a table into a RecordSet, use "order by" clause to sort the records, ...Answered | 4 Replies | 545 Views | Created by Manjunath L - Monday, November 24, 2014 2:49 PM | Last reply by Caillen - Thursday, November 27, 2014 9:43 AM -
0 Votes
VBA code not looping
I wrote a VBA code to change a field in my access table. It will change the first row but then stop. Public Sub Editrecordset()Unanswered | 2 Replies | 286 Views | Created by Laesan - Thursday, January 31, 2019 9:02 PM | Last reply by Ken Sheridan - Thursday, January 31, 2019 10:58 PM -
0 Votes
VBA looping Macro
I need update cell B2 in sheet1 equal to a PM name in a list in sheet 2, Row A, The build in formulas in sheet1 will populate cells in the worksheet based on the PM name and I ...Unanswered | 1 Replies | 770 Views | Created by Lily Wang100 - Thursday, April 18, 2013 11:09 PM | Last reply by OssieMac - Saturday, April 20, 2013 1:24 AM -
0 Votes
Looping variable array in sql statements
Hi there, I am trying to loop an array in a sql insert statement but i can't get it working. Anybody knows how? Below is a demo i'm trying to get it running. I ...Answered | 4 Replies | 3657 Views | Created by AmazingTrans - Tuesday, July 5, 2011 10:23 PM | Last reply by AmazingTrans - Wednesday, July 6, 2011 12:48 PM -
0 Votes
VBA: Slow macro looping through paragraphs
And in thisUnanswered | 1 Replies | 509 Views | Created by Mimmi-Nor - Wednesday, February 22, 2017 3:24 PM | Last reply by VBATools - Wednesday, February 22, 2017 7:16 PM -
0 Votes
Using Excel VBA to run Sql statements
built-in stuff. Alternatively if you do want to go VBA, set a reference to the Microsoft Activex Data Objects 2.x Library from within the VBA ...Proposed | 4 Replies | 420 Views | Created by sleggio - Monday, May 22, 2017 2:46 PM | Last reply by Chenchen Li - Wednesday, June 7, 2017 2:47 AM -
0 Votes
Looping through Summary Tasks in VBA
Thanks Rod - That solution worked. John - I have VBA code that grabs information from an access database and brings it into the project file but I only need the data ...Answered | 5 Replies | 1149 Views | Created by pd240 - Thursday, May 18, 2017 12:39 PM | Last reply by John - Project - Friday, May 26, 2017 1:50 AM -
2 Votes
VBA for MS Project, looping through tasks
Project VBA Book and VBA developer. www.project-systems.co.nzAnswered | 4 Replies | 9648 Views | Created by PhilipDay - Tuesday, August 30, 2016 11:32 AM | Last reply by PhilipDay - Thursday, September 1, 2016 7:29 AM -
1 Votes
Excel VBA macro with looping email function
; Range("A23").Select ActiveCell.FormulaR1C1 = "=R[-22]C" I know this won't do what I need it to, don't know enough about ...Answered | 4 Replies | 1898 Views | Created by Alex000001 - Wednesday, January 2, 2013 11:21 AM | Last reply by Alex000001 - Wednesday, January 2, 2013 12:31 PM -
0 Votes
Looping
Without Looping no better way ?Answered | 6 Replies | 3087 Views | Created by Carrie17 - Tuesday, February 19, 2008 7:56 AM | Last reply by Giorgi Dalakishvili - Tuesday, February 19, 2008 10:11 AM -
1 Votes
Looping functoid not looping
I set the Max and Min Occurs like you have here, and the looping looks to be working now. Thank you very much!Answered | 14 Replies | 887 Views | Created by Sisk0Kid - Wednesday, June 21, 2017 5:16 PM | Last reply by Sisk0Kid - Thursday, June 22, 2017 1:52 PM -
3 Votes
looping
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx Check this link which iterates through text files and put thge records inAnswered | 5 Replies | 3658 Views | Created by snorlaks - Wednesday, December 2, 2009 3:05 PM | Last reply by Manish Sharma - ETL - Wednesday, December 2, 2009 5:58 PM -
0 Votes
looping through excel cells using VBA
You can do this just as easily using Excel formulas (no VBA). Just concatenate status and project into one column (IE - project1yes, project2yes, project1noAnswered | 3 Replies | 4338 Views | Created by Born2Achieve - Monday, October 6, 2008 9:58 AM | Last reply by Born2Achieve - Tuesday, October 7, 2008 5:25 AM -
0 Votes
If then else for looping in VBA
Hello I need help with this VBA. Here’s what I am trying, based on a query called ...Proposed | 1 Replies | 592 Views | Created by Stephen-BSCI - Monday, November 11, 2013 7:32 PM | Last reply by Hans Vogelaar MVP - Monday, November 11, 2013 7:57 PM - Items 1 to 20 of 108033 Next ›
No announcements
