Recent content by jamesormi

Hi, Does anyone have any idea on how to send an email with a file attached using VBA? Any code examples would be greatly appreciated. Thanks in advance.

Hi, Is it possible to send an email from access (using SendObject) without the attached warning appearing? Thanks in advance.

Hi, Is there a way to send a SMS (Text Message) from Access 2007? Any example would be greatly appreciated. Thanks in advance.

Hi, I have a table which contains a number of customer records. When a customer is selected I would like to check the customers table to see if a Yes/No Data Type field has been set so that different operations can be performed when this option has been selected. My question is... How do...

That works a treat!!!! :) Thanks Guys!!!

At present I have the following in my criteria for my query: [Forms]![FormName]![Control] Or [Forms]![FormName]![Control] Is Null This is not working for me.:confused:

Hi, I've now realised that this can be done (make the subform data source a query). I would like the user to be able to search without completing all the on my form and still show data in my subform. Using this method I have to complete all fields before any information is shown in the...

Hi, I have a form that has a number of controls on it and a subform (displaying a datasheet of the same table used in the main form). I would like to filter the subform with the values I have selected in the controls. I don’t want to have to complete all the controls in order to see the data...

What I'm looking to do is to stop the user from entering the same invoice twice by mistake. Belt and Braces if you like...

Hi, I have a form into which the user enters details from customer invoices. I would like to add a check to make sure that an invoice number is not duplicated for the customers. The table has the fields OurRef (Prim Key), Customer and Invoice Number. Is there a way I can check that for a...

docmd.GoToRecord acDataForm, "FRM_Name", acNewRec I was using this method previously. The user may only want to review the data entered. At the moment the first record in the table is being shown. I would like it to be blank until the user selects a value in the combo box.

Hi, I have a form that has a number of controls and a subform. When the form is opened by the user I would like the controls and the subform to be blank until the user has selected a value from a combo box. Is there a simple way to do this? Thanks in advance.

Hi, I have a form that shows a number of jobs done for a customer. Each job has a date. I would like to filter the form to show the jobs done in a month for each customer. I would also like my combo box (on which the filter will be applied) to only show the months where a job was done for...

This is exactly what I was looking for. Thanks

Is it possible to wait until the requery has been completed?