Search results

Hi, HiTechCoach Thanks for responding, sorry be how do I define the parameters?

Hi, I have a Crosstab query that gives me the message "The Microsoft Jet database does not recognize '[Forms]![frmMachineReports]![cmb_Machine_ID]' as a valid field or expression.". But if I type the criteria directly into the criteria field, the query works fine. Have I done something wrong?

There are a number of different programs running of the same computer each needs a different printer or settings. These are located on a factory shop floor I would rather be able to set the printer settings according to the program needs automaticly. I have found some code that allows me to...

Hi, I have several reports that print to a special label printer that is not set as the default printer. I wish to automaticly set the print settings to the label printer for when I need to print to it but not change the system default printer. Basiclly select the printer and the paper size...

Hi boblarson, Yes that is what I have done, but it does not highlight the problem code. I think the problem may be with my editing the data base from two different versions of Access 2002 at work and 1997 at home. I have gone back to a prvious backup copy of the file and will only edit code...

HiTechCoach Thanks for your reply That is part of my problem, there is no code being highlighted when the error appears, it does not matter which form or module I am in.

Hi All, I am getting the error when I compile the database I have tried selecting the Microsoft DAO 3.6 Object Library in User references but this has not worked Hope someone can help,

Hi I would like to automatically send a report by Email through Lotus Notes. Depending on certain criteria if possible. Can anyone help?

The data is in a date but is set as text because some of the data is grouped by year some by month and then some by week. the data needs to be sorted first by year then last 12 months then last 4 weeks then the next three months. sort by date doesnt work nor by alphabet I think I need to add a...

Hi, I have data in a table that I need to sort in a specific order, and it is not alphabetical or numeric, can I add a field in a query to add a set of values that I can use to sort by? hope this is clear enough

Thank you Pbaldy, I have done it using FollowHyperlink Regards Gezza

Thank you for reply, could you please copy and paste the code you suggested?

I'm looking for a way of opening an excel file directly after running a report to export to excel using vba code