Search results

Is it possible to set up a button on a form, and have that button open up an external program? If so, can anyone give me example code? Specifically, someone asked if a shortcut on the desktop could be launched via a button in an Access form. The reason why is simply to make the users life...

This has all been most helpfull...thanks all. What I've ended up doing is basically what Jack suggested (two queries). These queries are MakeTable queries giving me the data I need to do the comparisons so my report is based on them. I've just set up a button that runs the two queries (asking...

You are a star...I didn't know about that function. Thanks! Ste

Okay.... EDIT ------ Sorry...posted twice!

Okay.... OK...I've created a new query and put the table in twice, and linked it with the Primary Key. I've also linked them both to a customers table (key is account number) and sales rep (key is rep number)...now I'm stuck again. I can't figure out what to do from this point to get the data...

I have six reports which I have to print for six people. Each reports takes a start and end date (usually just todays date), and the reports show various information about the days production, sales, deliveries blah de blah. Currently, I push a button for each report and input the date...I...

Hi all. I have a table with a couple of years worth of figures and want to compare figures from 2001 and 2002 on a month by month basis. The query I have asks for start and end invoice dates in the format 20021001 (for October 1st 2002). The dates are in this format because our old mainframe...

I have a report which at the moment looks something like this... <Edited...table doesn't show properly...commas added for clarity> Product & Company, Inv. Value, Cont. KSM Board, £34,663, £45.78, A&A Corrugated, £ 4,645, £56.45, Bridgeshire, £...

I want specific reports to be printed automatically at 4:00pm every day. Is there a nice easy way of doing this? Also, can the same technique be used for automatically importing data from a text file at 3:00pm? If it takes a little coding, I'm not afraid to give it a whirl. ) Regards,