Search results

The code is part of a form (i.e. "Form_Questions"). The textbox are "A1" through "A80". This form is a survey and I'm trying to loop through the answers from the survey with VBA.

This did not work either. Do I have to change the form name (i.e. "Form_Questions") to something else ?

I tried that . . . I just get the text value, but not the value of the testbox. Aout = "Forms![Form_Questions]!" & "[A" & i & "]"

In a VBA variable

How can I create a loop to retrieve the value of multiple textboxes ? For example "A1" would become "A2" . . . "A55". I would then retrieve and display the value of the textbox. The below syntax will display the value of my form "Form_Questions" and textbox "A1":banghead...

Brian, I calculated the overdue in the query (i.e. subtracted 'End_Date from 'Due_Date'). Thanks for the information ! ! ! :o

I have a table with three (3) dates. The dates are 'Start_Date', 'End_Date' and 'Due_Date'. I want calculate the difference between 'End_Date' and 'Due_Date' in number of days in a query. Can this be done in a query ?

Thanks to everyone who responded ! ! ! I already applied Jraw's solution and it worked fine.

JDraw, I'll try and report back. I was hoping to find a solution that would check if a drive letter exists, then point the backup routine to the existing PC flashdrive drive letter. The drive letters that are used by the PC flashdrive(s) are "E" and "F".

JDraw, Thanks ! ! ! . . . I took a look at the solution. Is there anyway to check if a drive letter exists ? The drive letters that are used are "E" and "F". If I knew which drive letter existed, then I could point the backup routine to the existing drive letter.

Is there anyway to determine the drive letter of a flashdrive inserted into a PC ? I have a backup routine that backs up a MS Access database to a flashdrive. I need to determine the flashdrive letter.

fat controller, I solved this with VBA ("Event Procedure) with "On Load". Thanks for your response ! ! !

I have a report that displays my "Start" and "End" dates correctly, but when I the report, the dates appear as #Name?. This happens on multiple printers. What is causing this ? The "Control Source" is as follows: =[Form]! [Category_Totals_Form]! [StartDate]

Plog, Never mind, you don't have to respond. It seems you are frustrated with my responses. I'll seek a resolution elsewhere. Thanks for your responses ! ! !

Plog, There is no "C" table. The final result will be an updated "Table1" with the "Payee" in the blank fields.

Plog, Are the tables ("Table1" and "Table2") in the database ("Test") ? I created a "Test" database and query (i.e. "QueryUpdate_Payee_In_Table1") to make it easy for you. If you can assist with the "Test" database, that will be fine. Hopefully, this is not a problem. Thanks ! !

Plog, I tried to first put what I wanted in words. I created a "Test" database hoping to clarify what I needed. Is it still unclear ?

Plog, Here ya go ("Test.mdb") . . . I'm trying to update the blank field ("Payee") in Table1 with the value in Table2 ("PayeeSelectBox"). The "Account" in Table1 must match "Category" in Table2. Thanks again for your help ! ! !

Plog, I added an additional column to both tables (i.e. "Accountx" and "Categoryx") and changed the "Update" query. I'm getting the same results. Did I understand your recommendations correctly ? Below is the current code. Thanks for your help ! ! ! UPDATE Table1 INNER JOIN Table2 ON...

I'm trying to update a value in a table from another table. I'm getting zero records in return. Can anyone see why my query does not work. The tables and "Update" query are below. Table1 --- Column to be replaced Payee --- Category John --- Manager ---...