Search results

Yes I started like this only.I think it is working.I have taken that libraray and opened the recordset and did some excel formating. It is working but still i have to check with my manager what exactly he wants but thanks a ton. I have another question. I have to 2 access databases and one...

I do not have a direct query.I am buliding a query based on the filtering criteria 's from the form that i provided. so when i pass that query or that string it gives me query not found i used this DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, StrSq, "filename.xls this also...

I have a form from which you can filter and after filtering I know how to show access report but I do not know how to show the result on excel report please help i am very confused in making excel report on just one button click.

Now after all this just make strsq as public string and on open event of report pass this as a recordsource for a report me.recordsource = form_name.strsq it really works try it

I did the same thing in my project..kepp all the query on back of the form means on click button and put a where clause with cases and in query put where = & that string name. make this query as public and paas this query as a recordsource on open event of report. it worked for me perfectly...

I have 2 Access databases which contain 10 tables in each.I want to make a sync of 2 tables from both of the databases with mysql tables. In mysql I just have the same structure of those 4 tables and i need record from access databases tables. Whenever anyone do any updates in access tables...