Search results

I have 2 combo boxes on a form to filter records selected. I have used these filters before on another form however they're not working on this new one and not sure why: First one a date field lookup & second an item number lookup Private Sub Combo23_AfterUpdate() Me.Filter = "(([Date]) =...

I have a pivot chart query that is inserted into a form. The user can choose to print that form or close. If print is chosen, printed and then the exit button used, a dialog box always prompts: 'Do you want to save changes to the layout of query 'Supplier Issues per Month Pivot Chart Query?' It...

I have a report that is attached to an email as a pdf doc. It is a generic name currently and it's been pointed out to me that it would be better for the name to have the issue number in it's name, e.g. "Non Conformity 34.pdf". This number would be taken from the field NonConformID on the...

I have a query that pulls off all items that we have an issue with per quarter per supplier. This is displayed in pivot chart format. I have then inserted that pivot chart into a form. I put a combo box on the form in the header as a lookup of suppliers based on the query. However, when I...

Hi I have a pivot chart on a form and have put a button on it. The code to make the button invisible on click: [Supplier Issues per Month Query].SetFocus Command1.Visible = False I want to be able to print the form and with it printing in colour. If I put DoCmd.PrintOut, it prints in...

I have a hyperlink field and would like the user to click a button which opens a file dialogue box (being defaulted to a folder location on a server) where a file is selected and the hyperlink to that file stored. Is this possible? How can I do this?

I'm having trouble completing the code for my form. It updates a table if the item doesn't exist in the combo box. The following error displays: Run-time error '3464': Data type mismatch in criteria expression. If DCount("Reason", "NonConformity", "Reason = '" & Me.Reason.Text & "'") = 0...

I can add a combo box to the header to lookup an item on the main form, however, how do I get all records to be returned for a specific item if there are a number of them? E.g. 25 records of which 3 have the item code NLA2222011. Currently, the lookup will just show all 25 records in a list...

I've got a lookup field on my main data entry form "Supplier Issue Detail" where a type of 'cause' for the issue can be selected. This is restricted to the records in the 'Cause' table. How can I add to the 'Cause' table on the fly if a particular cause doesn't exist in the drop down list...

Hi, I have the following that currently takes the email address from the field Contact on a form, however, I now want to be able to pull off multiple emails should there be, from a subform. Is this possible? This is the current one. .To = Forms![nonconformity]![Contact] Form -...

Hi, I'm inserting a report based on the current open record into Outlook email. It all works fine except for a couple of things. If the email is cancelled, an error displays along with the report being left open - due to debugging. (Run-time error '2501': The SendObject action was cancelled)...

I have the following vba that takes current data off a form and puts it into a report: Private Sub Command25_Click() DoCmd.OpenReport "nonconformity", acViewPreview, , "[nonconformid]=" & Me.NonConformID End Sub I want to take that report and have it attached to an email as pdf doc. Also...