Search results

Dear All, I have made Data Saving program in Access. This program saves Data from various mdb files using various queries. Right now, first i have to import tables from mdb files 1 by 1 and run the queries. I want to make a store procedure or any other command that select all mdb files at...

can you give me exact code?

I want to import tables from one mdb file to another mdb file without relationship using code. Anyone have the code? Thanks.

Actualy i want to delete complete mdb file from the system. Because it is in my hand to give them again a copy of that application. So thats why i want need the code of schedule delete file i.e. 2nd date of every month. Thanks.

I hv made application in access and i hv to give it to some one for use. I need to know about the code that my application mdb file automaticaly delete on the 2nd date of every month. Is it possible? if yes thn what would be the code. Please advise. Thanks.

It is neccesary, I have to transfere some tables to xyz.mdb file.

I want to export my tables to another new mdb file using only one click button command. Means when i click export button, prompt me to create new mdb file and then immediatly transfer to required tables in newly created mdb file and confirm or completed msg box appear. Can any one help me in...

Thanks. Can you explain, how and where can i fit my Query and Macro function in this code. Regards.

I have some querys and macro command. All that executed just one click button. Now I need to set a Progress Bar with percentage option over all the process. All the query and macro commands executed behind the progress bar till the 100%. Can any one hv the code? plz advise.

I want to stop/skip appending of those records who match in main data table "MCIGMMS" on the basis [PORTCD] [IGMNO] fields in "PCIGMMS2". When Match found Msg Box appear and appending skip or stop of those records. Can any one help me or give me code. Regards. SQL CODE: INSERT INTO MCIGMMS (...

Dear thanks for reply. I tried select distinct command but query shows only one record remaining 5 records are hide. I need all six record should be displayed but 1st records shows value 4 and remaining 5 records shows value 0.

Attaching a sample mdb file. I have TABLE1, TABLE2 and QUERY1, QUERY2 in my mdb file. I want Query1 Value 4 once in Query2. It should not be repeated again with [SBNO] values 5 time. Value 4 in Query 2 shows with only 1st record and remaing 5 records shows 0 value instead of 4. How is it...

I have the following tables and fields. SBcnt Table: [SBNO] ----------- 013180 013180 013180 above 3 are unique records SBnet Table: [SBNO ] -------- 013180 013180 013180 013180 013180 013180 [SBNOTOTAL] ------------- 3 3 3 3 3 3 above 6 records are also important for me but the...