Recent content by robthedog

Ah! Maybe I didn't make the question clear... What I need to do is produce hard copies from Access Reports. The web version isn't a problem. Cheers Rob

Hi All; Any advice would be much appreciated…. I have a db of products which drives an ASP website, and includes links to images, which I have now stored locally (with the image path amended to point to the local images folder) along with the images folder containing all the images. What I...

Have a look at the following which may help http://www.access-programmers.co.uk/forums/showthread.php?p=344568#post344568

Hey! Where’s your sense of adventure? – I did say that it was an ‘arse around tit way’ but I like it because once the functions are in place then you can use the same query over again passing the parameters from wherever, not just your original form. I also find validation easier using VBA...

Have a look at attached......

Try using a sub rather than function ie: Public Sub Timing() Call opentimingmain End Sub

Create a sub using the timer to switch the colours, then call it from the click event of your button. Good luck...

You may be able to use the timer property of your form. Look up 'On Timer' & 'Timer Interval' in Help..

Chill out now for Xmas....

Add a text box to your form, then in the ControlSource property enter: =[End_ord_date]-[Start_Ord_Date] (Obviously use your field names!!) This should display the no of days elapsed...

Maybe the simplest way to do this is to build a query including the start and end date fields, then just subtract the start date from the end date to give you the number of days: Enter the following in the field row to the right of your dates. NoOfDays: [End_Ord_date]-[Start_Ord_Date] Cheers

Have a look for Printer Property / Printers Property in the VBA Help files: The following changes the default printer to the one specified in 'PrinterIndex' The Printers collection is indexed beginning with zero. If you refer to a printer by its index, the first printer is Printers(0), the...

Did you build the system in work's time?

I get round similar situations by assigning the required values to variables, then creating a little function which you can use in the criteria of your query to retrieve the values – this may be an arse around tit way of doing it, but it works! Create the variables in a new module, then build...

Is the type mismatch because your'e using Yes/No field? Anyway, why not try something like the following:: The easy way... dim sSql as string sSql="UPDATE Faults SET Faults.printed = 1 WHERE (((Faults.printed)=False));" DoCmd.RunSQL stSql If your're not...