Search results for query: *

If I use a Query name instead of the table name, will it work dbjob.Execute "INSERT INTO [Level1 Data] SELECT * FROM import_area" , The import_area is the name of a query

Dear PHV, Thank you verymuch! It worked. Mini

The code below shows a query which will get me the row souce data for a combo box(level2) depending on the first combo box selection (level1). The code is simple if it to be used for one form. But I need to use it for so many forms, hence I would like to make function which can dynamically...

Thanks both PHV & Roy. The direct aplication make things much better and trouble free. mini

Hai, I have maintenance database program which uses the following function to join the date and time values into a single date property for easier calculation. My user requires the date and time entry in differrent fields, where its easy for me to have it in same field in database for all...

its a great tip , wonderful!

Some times we ourself post the question and find the answer. I tried the above problem and came out with an easy solution. In loops I was opening the recordset, but closing not properly before again opening. Once i closed the recordset before reopening everytimein the loop, every thing works...

thank you fancie, finally i am doing the way you suggested

thank you VBuser 77 and hkwranger. tek-tips the great!

Hai, I would like to know how can i dynamically assign the recordsource of a report or form. 1. from another forms VBA where I wnat to set the report/Forms Recordsource just befor opening? 2. or the only way is to do it whithin the forms / reports code kindly help me! Mini

Thnaks Fancie and VB slammer. But for a very low level user will it not be more convenient if we provide a complete package (new) then ask gim to use the option to import if he would like to ? I was thinking of using SQL queries to get the whole data into the new one, but I expect direct method !

Hai, I have distributed an access database package for maintenence monitoring in my company. many users have been using it for awhile. Now I have come out with new version which contains advanced features. The problem is how can I automate the process of importing the tables from the old mdb...

The following is the structure for VBA SQL application for Access 2000 dtatabse. Code: ------------------------------------- Open table 1, collect a parameter set ** Open table 2, collect a parameter set ** Loop1: For each table1 parameter Loop2: For each table2 parameter Open a source...