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

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

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

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

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

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.