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

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?

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...

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

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...

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 have a text box in a report with the following in the Control Source Property:- ="Please find below details of collections made during the period " & Forms!criteriafrm6!Combo0 & " and " & Forms!criteriafrm6!Combo3 & " inclusive." Combo0 and Combo6 are input by the user in the format ddmmyy...

I use the module below to return the week number (ISOWeekNum) for a date input in usual format (dd/mm/yy). I now need to return the week ending date (Sunday) from an input week number in a query. That is, I input the week number and the query filters the data up to the week ending date for the...

I have a form based on a Find Unmatched Query. I need the functionality of the No Data event found on reports to launch a message or cancel the Open Form event. How can I do this on a form? Ta

There must be a simple explaination to this. I have a Combo Box based on a query which is blank. The query when run displays the correct data but as the Row Source for the Combo Box, nothing. Attached is a sample from the db. Please, someone put me out of my misery. Ta

I have a subform A in a form B. When a certain field is updated on the subform A, the value of a field in the form B is changed. This is executed by the code Forms!form B!formfield = "99” on the After Update Event Procedure on the subform A. Simple and works OK. I have put the form B with the...

Got a command button that fires of a routine to duplicate a record, reset some fields in the new record and requery the form. Easy. Because the form is not ordered by the record ID number (alpha numerically by customer) I can not then us goto last record to start data entry in the newly created...

I use the following in a command button:- DoCmd.DoMenuItem acFormBar, acRecordsMenu, 3, , acMenuVer70 Is it possible to set a default Look In: field and Match: option?

I have a continuous form with a tickbox to select records. A command button then kicks off a print routine to print the selected records. Well, all but the last one selected! I suspect I need to requery the form's query (or maybe the report query) to capture the last record selected. I have...

Is it possible on a report to display all field values of 0 (zero) as blanks?

I have a menu form that users can select one of two criteria to print a report, fields [Area] or [immediate]. The code I have to set the criteria is set out below. The strCriteria = "[Area]=""" & Me![Combo17] & """" works fine but the first part strCriteria = "[immediate]=""" & True & """" is...

I am trying to hide a label in a report which is conditional on the results of the value of a text box (=Sum([Field])) calculated when the report is run. The Visible = False/True function does not appear to be available in Reports. Or is it? Failing this is there a way round this? :confused:

I’m using a combo box to select real names and using the following event to filter Private Sub Combo45_Click() Me.Filter = "[CustomerName] = '" & [Combo45] & "'" Me.FilterOn = True Me.GHSpickups.SetFocus End Sub Simply stuff so far. The problem is a real name such as O’Reilly gives...

I’m using a combo box to select real names and using the following event to filter Private Sub Combo45_Click() Me.Filter = "[CustomerName] = '" & [Combo45] & "'" Me.FilterOn = True Me.GHSpickups.SetFocus End Sub Simply stuff so far. The problem is a real name such as O’Reilly gives...

I am trying to print a report and exclude from the report records that do not match the results of an expression in a query. I have tried endless combinations and still can not get the report to print the records only matching the criteria. I've attached an extract of the db to best explain...