Recent content by sdawson

Looking for earliest version of Access in which I can format a report as a PDF file to attach to email. Using this at present - DoCmd.SendObject acSendReport, "Myreport", acFormatHTML Want to use this - DoCmd.SendObject acSendReport, "Myreport", acFormatPDF Thanks

OK, here we go. If the user wants to input today's date, they would in put "0". The date field would then be populated with today's date. The user would then carry on inputing data. The user would then move onto the next record. This requires yesterday's date to be entered so the operator...

In plain English............ To input today's date, input "0" Yesterday = "-1" A week ago = "-7" and so on.

As I understand it, Datepicker is normally set with Onload when opening a form. I require a to input a variety of dates when the form is open. I'll look at some code then. Thanks

If memory serves me right, I've seen code or maybe a shortcut somewhere for inputting a date value in a form along the following lines. ' To input today's date, input "0" Yesterday = "-1" A week ago = "-7" and so on. Any ideas?

Yes Bob I do understand this. I my haste to get an quick answer I may have used incorrect terms.

Yes, but got a lot of complicated answers to a simple question. You gave me the simple answer I needed. Thanks

Yes, found some complicated answers to what I belived was a simple question. You have given me the simple answer. Thanks.

I need to replicate the navigation buttoms in a form viz. First record, Next record, Previous record, Last record, New record, Total records etc. All these are easy but I'm struggling with the record number of the current record displayed viz. 1 of 50, 2 of 50, 33 of 50 etc. Any threads or code...

Works fine if the db is not open but gives a Runtime error on the open file. Thanks for reply sportsguy.

Not quite what I was looking for. When there are multiple forms where data can be changed, this gets a little tiresome. I was looking for something like the DOS command attrib +r. Guess I'll have to stick with that!

Is it possible to put some code in start up form to make the whole of the db read only. I know this is an option from the File,Open on the menu bar but I need to make sure that this archived data is never changed. Thanks

Tried DBEngine.Idle dbRefreshCache but no change. Have narrowed it down a bit though. The db has a number of Combo Boxs where the user has to select a customer. Any attempt to run reports after a box has been opened causes the problem described in the original post.

Will give it a go. Ta.

Done this. All forms are closed before the pint menus are accessed.