Search results for query: *

Using VBA and ADO/recordset's and/or queries, I need to update 3 related master tables from 3 unrelated temp tables. Can someone please show me how. I 've been away from Access for some time and appreciate your input. I have 3 tables a main with (CAMERAID), 2nd table TESTS with (TESTID, and...

Using VBA and recordset's I need to update 3 relational master tables from 3 unrelated temp tables. Can someone please show me how. TIA

Can someone show me how to call a VBA procedure from within another VBA procedure in an Excel module.

Access VBA Newbee - how do I move data from a temp table created/imported via TransferSpreadsheet from Excel and update a related table in the same Access DB. Help - TIA

How do I correctly define the range in the transfer spreadsheet function. Here is what I have defined: Sub TransExcel2Access() 'Import specified Excel worksheet / range of data DoCmd.TransferSpreadsheet TransferType:=acImport, SpreadSheetType:=SpreadsheetTypeExcel9, _...

Will someone please provide me with a vba code example of calling/executing from Access, a macro in Excel and retrieving the result back to Access. I have been able to use the DoCmd import excel worksheet into Access and creating a new table but I need to import the data into an existing...

How do I call/execute an Excel macro from Access 2003. TIA

Using VBA I need to create a new table and move data from a single field in an existing table to (10) separate fields in the new table. Existing table: aaa bbb ccc ddd eee fff ggg hhh...

In each of my records I have 6 date fields using the format:08/13/2002. I need to initialize the entire table recordset (date fields only), following a copy of the table to archive. How can this be done using Access 2000 VBA? TIA....

I have updated from FP2000 to FP2002. Prior to the update I did not experience any problems with file folder access. Now with FP2002 when I try to select a different folder I my wait from 20 seconds on up. I am experiencing the same slowness on my laptop (win2kPro) as I am with my desktop...

I am about to update from FP 2000 to FP 2002. Can anyone tell if there are any issues that I should be aware of. TIA

I am using Win2K Pro on a Sony laptop and installed Frontpage 2000. I am just starting to learn FP and I want to start "by example" a web application that uses Access 2000 database access. I found the IIS 5.0 component in Win2k Pro and ran the install. No errors were encountered...