Search results

Forms!frmSupplierRepoet!intFilter should work, but I am concerned about the order of the data. 23, 58 will work, but 58, 23 will not! This is why I want to use In()

Get error that expression is typed incorrectly or too complex to be evaluated

I want to filter the records in a combo box (cboSupplier) using the In() function. On the form I have an unbound control called "intFilter". It contains the following string: 23, 58 The SQL statement for the combo box isSELECT SupplierID, SupplierName FROM tblSupplier ORDER BY SupplierName;In...

I have the tables: "tblProduct", "tblProductType" & "tblCustomer" Tables "tblProduct" & "tblProductType" have a one-many relationship, using the field "ProductId" On a Customer Order form I want to limit the type of products a customer can order. for example, Customer: * ABC can order ALL...

On I form I have a combo box called cboMobileStatus. Its row source type is "Value List" The row source is: 1;" All";2;"Has";3;"None" I have a query based on table "tblCustomerContacts" and I want to limit the records returned based on the value of the combo box. So if the user selects: * All...

I use the following to fill a list box with the names of files in a folder Private Sub GetFileList() Dim LoadFiles As String Dim strFill As String Dim FileFolder As String FileFolder = "C:\Temp\20132014\Orders" LoadFiles = Dir$(FileFolder & "\*.pdf") Do While LoadFiles > "" strFill =...

The pop up form is called "frmSelectWebOrderToOpen"

frmSelectWebOrderToOpen is open because this is the form on which the list box resides

On a pop up form I have a list box. The row source for the list box is SELECT tblWebOrder.WebOrderId AS [Web Order No], tblWebOrder.CustomerWebOrderNumber, Format([WebOrderDate],"dd/mm/yyyy") AS [Order Date], tblCustomer.CustomerName AS [Customer Name], tblArea.Area FROM (tblCustomer LEFT JOIN...

I have a recordset because I want to loop through each record in form "frmCustomerProductReturnProducts" The value of "cboInvoiceId" is different for each record

I need to write data to a table from a sub form, so I using a Form.RecordSetClone. On the subform I have a combo box called "cboInvoiceId" and I need the data in column 4 This is what I have Dim db As DAO.Database Dim intCustomerReturnsShipmentsId As Long Dim rst As DAO.Recordset Dim...

Graphic attached Many thanks

Unfortunately not!

I have the table "tblProductionForecast" with the following fields: ProductionForecastProductId ProductionForecastMonth ProductionForecastQuantity I want to show this in a report, similar to an spreadsheet, with: ProductionForecastProductId = Rows ProductionForecastMonth = Columns...

I need to track deliveries from suppliers against purchase orders. i.e I generate a purchase order on a supplier. The supplier may deliver: * all products in one delivery * products over a couple of deliveries * may substitute product with an alternative I am racking my brains on how to set the...

I have code that exports data to a csv file. When I open the csv file with NotePad++ I notice that the last character in some of the fields, in some of the records, may be a non keyboard character. Examples of characters returned include a carriage return, ascii character 32 How can I remove...

I need to know when: * a new record has been created * data on a record has been changed Does the On Dirty event capture this, or can I just use the forms On Change event?

Enabled = Yes Locked = No

I have a main form with a sub form. I cannot enter new records into the sub form! Only existing records are displayed. If I open the record source of the sub form, I can enter new records The subform's Allow additions, deletions & Edits are all "Yes" What is causing this...

I need help with the syntax for an if statement! If pubEmailAddress <> "No Valid Email Address" Or pubEmailAddress <> "No Email Address" Then ...... Else ....... End Id So if pubEmailAddress = "an email address" then the code must run before "Else" If pubEmailAddress <> an email address, then...