Search results

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.

Not sure if this a report or form question but here goes. I have a form that has a number of Command Buttons that fire off various reports. When users have been entering data elsewhere or printed of some reports, some of the Command Buttons will not work correctly and reports appear with error...

Seen these. I want the user to specify the destination that is why I posted the question the way I did!

Has anyone got a bit of code to run Tools, Database Utilities, Back Up Database on exiting the database. Probably involes the old fashioned Keys command which I've forgotten how to use. :( Ta

I use the following simple following module for all my printing. ---------------------------------------------------------------- Option Compare Database Option Explicit Public strDocName As String 'Report Public strCriteria As String Sub stdPrint() DoCmd.OpenReport strDocName...

The following did it. Thanx Gemma ="Please find below details of collections made during the period " & Format([Forms]![criteriafrm6]![Combo0],"d mmmm yyyy") & " and " & Format([Forms]![criteriafrm6]![Combo3],"d mmmm yyyy") & " inclusive."