Search results

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?

Hi, I'm experiencing problems when requerying a subform (Form_subform.Requery). I'm looking to get a total value from that subform to update on my main form. At times I'm getting 0 as the value as the requery has not complete. Is it possible to add a delay to the code to wait until the...

Dan, I'm not looking to give the user the option. I want the data to be sorted by ALL fields ie sort by Field1 AND field2 AND field3 and Field4 ...

Hi, I have a continuous form that is made up of a number of fields. On opening of the form and clicking of a button I would like the form to be sorted by a number of these fields ie sort by field1, field2, field3 and field4. How would I go about this? Thanks in advance

Hi there, I have a continuous form that has a number of columns on it. I would like to hide a couple of columns on the click of a check box (from prying eyes!!) and show the column again when the check box is set to true after a correct password has been entered. My VBA is not the best so...

Hi, I'm looking to create a form for a table that has a number of jobs on it. The table has an autonumber primary key as well as a job date. I would like to be able to view/edit/add the jobs on the form for only a selected date. How do I go about this? Thanks in advance.