Search results for query: *

Thanks for getting back to us.

I copied your code and created a similar Publisher file. It seemed to work some times but not always. I had a hesitation in the code as Publisher was attempting to retrieve printer information. I have a wireless printer as my default. If I waited for the printer dialog to disappear, there was no...

Give users an xlsm with a small subscript that sets trusted locations.

I assume you have considered upgrading to supported Access and Windows versions.

Have you considered creating a VBA function that returns the appropriate values. You might even find one on line. Your massive expressions seem unmanageable to me.

It looks like you have the link master/child set to the PrefixID. There is no reason to set this in the recordsource.

If this were my application, I would get rid of the lookup tables and replace with combo boxes. Also use only Link Master child to the two fields from tblCatDetails.

Are you using the link master child? This is the recommended method which allows you to remove the WHERE clause from your recordsource.

Why all of the tables in your query. Typically the lookup tables aren’t included in the recordsource. Use combo boxes to display the descriptive fields.

There are data macros in Access that essentially create triggers that allow tracking data updates. I haven’t used these but I expect you could find some great resources on the web.

I guess I don't know your exact requirement but maybe I don't want to ;).

Is your problem resolved?

If the code is in a module, I expect that to mean it is not in a form otherwise you would have responded to my question "What form or subform hosts the code?". Since the code is in a module, I would expect any reference to a control on a form would begin with "Forms!". You can test your...

What form or subform hosts the code? Every expression on the page I linked to begins with either "FORM" or "Me." When referencing a subform, keep in mind the sorcerer object and control name might not be the same.

Where to begin… Your sql has FROM db which is a database object and should be a table or query. If subfrmIS-1a is a subform you need to reference it as a control on the main form. There may be other issues but these are the most obvious.

...SQL statement for the recordset. 'this is partial code and assumes Link1 is text rather than numeric. Dim strBase as String Set db = CurrentDb strBase = "SELECT * FROM … WHERE Link1 = """ & [subfrmIS-1c].[Form]![qryIS-1].[Link1] & """ Debug.Print strBase Set rstBase = db.OpenRecordset(strBase) …

Thanks for the update. I provided technical support for about 30 factories in North America. Each factory had to submit annual production targets for each product. I distributed Excel files that pulled in the previous results so they could plan for the next year. After updating possibly...

The “batch union“ has decreased the single stepping method drastically for me. It’s good to hear you have a workable solution.

I thought both tables were linked into an Access front-end. When I have had multiple records from Excel to append to SQL Server, I created an SQL statement that use a union query in the from. My VBA looped through rows of Excel data creating a union query of Into MyOracleTable (Field1, Field2...

Can't you use a simple append query? Insert Into MyOracleTable (Field1, Field2, Field3, ...) Select FieldA, FieldB, FieldC, ... from SQLServerTable