Search results

Macro calls query where date is been passed as parameter. Query as below... Select * from tbl where dte>=[Dt];

I have builded macro in msAccess which calls query1 which takes date as parameter. I have to call this macro from VB6.0 application along with date value? I tried below code which prompts date value when executed from VB6.0 Dim app As New Access.Application app.OpenCurrentDatabase...

Great! it worked for me... Thanks:)

No i want to delete the records!

I have only one text column field in a table. I want to delete duplicate records i.e., if it has duplicate value, it should leave first record and delete the rest of the records. Is there any row number concept in Access?? Pls advice. Thanks in Advance.

I have build a query which returns 200 thousand records, and when trying to export, it only exports 65000 (approx) and the rest are lost. Is there any conventional way to select top 50000 records or between 50000 to 100000?? Thanks in Advance...

I want to import data from *.txt file to a table in access. i want to accomplish this through VBA not by wizard. Advance Thanks for any suggestions and solution :mad:

I want to maintain my database work log i.e., who ever opens the database (not through application) and changing the table should be saved in work log. Any way to acheive this?

My MDB FILE uses Oracle linked table, i use a linked text file which has the keys to filter the oracle linked table. when i build query using these 2 tables, it executes for long time i.e hang out. how could be this resolved? Table 1: linked text file Table 2: linked Oracle DB table Query...

code LInked Tables in code when the DB is opened i need to change the linked table path to the current path. so how can i would access the table object to change the physical path of the table?

My Database has a linked text file which is in the same path of mdb file. when i copy my mdb file in different path (along with the text file) it should access only the file in that path. how to change the path of the linked file through VBA or is there any other way to do it?

i'm using Master and Detail table. Master table i have TaskId, ResId where ResId is mapped to Detail table which contains resource working on the task. i want to generate a query where for each task i want to display resource id in single column like below. Task Id Resource Id 1...