Search results

Thanks CJ_London plog, you are 100% correct. Just wasn't thinking straight. Think it is time to quit for the day and have a glass off....

I am looking for a query that will return records from a table that have related records in another table. Opposite to the Unmatched Query Wizard I have two tables: tblSupplier and tblSupplierProducts The two tables are related by the field "SupplierId" I need the query to only return...

Hi CJ Many thanks for this Can you please explain: [CustomerStatusId]=[optCustomerActive] Or [optCustomerActive]=3 I don't understand the logic!

Hi CJ I have taken the liberty of attaching a breakdown There is only on form and I have highlighted the option button not working. Many thanks

My numbers are numbers! Is the following correct? One of the fields in the query for "lstCustomer" is "CustomerType" and its criteria is set as follows: [Forms]![frmPrintHowCustomersPaidInvoice]![FilterListBox] when FilterListBox = In (1,2)

Thanks CJ Understand using In(), however FilterListBox = In (1,2) does not work! Am I missing a quote?

On a form I have a: control called "FilterListBox" list box called "lstCustomer" option Box called "optCustomerType" When the user selects an option in the option box, "FilterListBox" is updated to either "1", "2" or "1 or 2" One of the fields in the query for "lstCustomer" is "CustomerType"...

Thanks guys Suppose I get used to knowing when to use "Select" and when not too!

I need to freeze the panes in an Excel spreadsheet form within Access I have the following code: Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Set ApXL = CreateObject("Excel.Application") Set xlWBk = ApXL.Workbooks.Add Set xlWSh = xlWBk.Worksheets(1) With xlWSh.Range("B5")...

perfect thanks

I am using Access 2010 I need to format cells inside the Excel spreadsheet Here is my code Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Dim intColumn As Long Set ApXL = CreateObject("Excel.Application") ApXL.Application.ScreenUpdating = True ApXL.Visible = True Set xlWBk =...

If a user opens the form and does nothing, then I am not interested However if the user changes any data, than I only to know this when the form closes.

I want to keep track of when data in a form was last changed. I only need to track this when the form is closed. not every time a record is changed. What event should I use?

Perfect. Thank you

On a form I have a list box with the following recordset: SELECT tblCustomer.CustomerID, tblCustomer.CustomerName FROM tblCustomer WHERE (((tblCustomer.CustomerName) Like [Forms]![Form1]![txtCompanyName] & "*")) ORDER BY tblCustomer.CustomerName; Also on the form I have a text box called...

Thanks guys

I need to create a production forecast form based on previous sales history. The history is based a sales and grouped by month & year So on the form, which needs to be a continuous form, I want products to show as rows and months as columns The sales history per month needs to be displayed as...

Thank you very much

How can a I round to the nearest 10 cents e.g 10.04 = 10.00 10.06 = 10.10 10.28 = 10.30 ........ Thanks

Using Access 2010 How do I send the command "^G" to a device connected via serial port (RS-232) number 3? Many thanks