Search results

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 ---...

Galaxiom/JHB, I'm trying another solution. I created SQL code in VBA that checks if the "Reconciled" checkbox is checked, sums all found records. I then store the value is the TextBox. Thanks for your help ! ! !

Frothingslosh, FYI ! ! ! . . . I just tried this and all my threads did not show up.

Galaxiom, May I clarify your instructions (based on current structure) ? I will . . . 1. Created a column (i.e. 'Reconciled_Yes' in the table that is used in the query for 'RecordSource' of the Form 2. In the TextBox "Control Source" enter Reconciled_Yes: Iif([Reconciled]...

JHB, The examples did not help me with what I'm trying to do. Thanks ! ! !

Can anyone see what is wrong with the below "Iif" statement in "Expression Builder" of a form "TextBox ? I'm trying to add all rows for the "Total" column in a table called "Reconciled", if the "CheckBox" is checked (i.e. Yes). Currently, I'm getting an incorrect value and if I check...

I got it . . . See below . . . DoCmd.RunSQL "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ('" & strCheckNumber & "')"

Any idea why ?

Galaxiom, Still does not work.