Search results

I have the below code and to link a subform and a form based on the combobox value. I get a data type mismatch on the code highlighted in orange. It is a number field so I am not sure why the error. Also the subform is based on a query. Any help is appreciated. Private Sub...

Hi Everyone, I am trying to create an html formatted table in Outlook that displays the results of a query. I can get the 2 tables to display on the email but they merge together into one. I also would like to write text above the second table. Below is my code. Any suggestions? Function...

I am writing a select statement to bring back the data for two plants 00BB and 01FT from the tblTrucks table, Plant column. The below query only brings back the data for 00BB but nothing for 01FT. Not sure what I am missing. Any help is appreciated. strSQL = "SELECT * FROM tblTrucks WHERE...

I am using the below code to search in a number field. When I enter text in the field, it asks for a parameter value before throwing an error. How can I get it to throw an error that says "Please enter a numeric value" instead? If Not IsNull(Me.number) Then strWhere = strWhere &...

I want to add a new column to my query called order month that pulls the month out of a text string from another column in my table. For example in column PO# I have 12 ABCCHAMP and in the new column order_month I want it to pull December from the the numbers in front of the text. So if it is...

I am trying to add a signature to an outgoing outlook message through access. I am using the below code which only adds the signature to the email and does not include the body of the email. I also get the run-time error 287: Application-defined or object-defined error. This application will...

I am currently working on code in a module that once you make a selection in a listbox it will open up an email with the selection from the listbox populated in a table. Right now my code is bringing back everything that is in the access table and not just the selection in the listbox. I am...

I am working on a CDO email database that has a multi-select listbox. When I make a selection in the listbox and click on the send e-mail button, it will send an e-mail based on the record(s) selected in the listbox. The issue that I am having is, I can make a selection int the listbox but it...