Recent content by traceya
-
T
Inventory: add/remove stock qty from table
Could someone please quote the correct syntax that should have been used here as I'm trying to figure out a similar problem myself and don't have much Access knowledge. Thanks -
T
Enter Parameter Value
Hi Galxiom Thanks for the reply I now have the following code in the row source for ProductCode, but am still being asked to enter a parameter value. Is the syntax I'm using correct? SELECT distinct tblProducts.ID, tblProducts.Description, tblProducts.RetailPrice FROM tblProducts WHERE... -
T
Enter Parameter Value
The subform is called fmSalesOrderDetails The row source for the combo box (Combo9) on this subform is a value list: "Antique";"Reproduction" The row source for an autofill combo box (ProductCode) on the same subform is: SELECT distinct tblProducts.ID, tblProducts.Description... -
T
Enter Parameter Value
I have a form that uses a value list as the row source for a combo box. This works fine. I then added this form as a sub form of another form. When I open the form I get an error message to "Enter Parameter Value". Why is this happening and what do I need to do to remove the error message? Thanks -
T
Populating table field from a text box on a form
Hi Bob Thanks for getting back to me. I've added the original formula back to the text box on the form as this worked OK and displays the correct result on the form. Eventually I want to be able to pull up a report from the Product table which will show all the product codes for a specific... -
T
Populating table field from a text box on a form
Might be getting myself into knots....... My query has: SupplierCode, Category, ID from Product table and Expression 1 =[SupplierCode] & "-" & [Category] & "-" & [ID] When run it returns the correct ProductCode What I need to do is add the relevant row to either the Products table or... -
T
Populating table field from a text box on a form
Hi Bob I have used the link you sent to build a query and used this as the record source for the form. However, the rest of the fields on the form are now showing error messages. The original record source of the form was tblProducts. Should I revert back to this as the form's record source... -
T
Populating table field from a text box on a form
OK now I'm lost? How do I add a query to the form? Thanks again PS: This self taught stuff is harder than it looks :-) -
T
Populating table field from a text box on a form
Hi Bob Tried putting Trevor's code there too and it still doesn't work...... Any ideas? Thanks -
T
Populating table field from a text box on a form
Hi Trevor I've tried this but it doesn't populate the field in the table. The expression in the disabled text box is: =[cboSupplierCode] & "-" & [cboCategory] & "-" & [ID] This combines the 3 previous fields on the form to give the ProductCode in the text box. This is the field that isn't... -
T
Populating table field from a text box on a form
Using Access 2007 I am using a form (fmProducts) to populate a table (tblProducts) On the form I have a disabled text box (tbProductCode) which is populated using an expression. I need this information to be added to the relevant field (ProductCode) in the associated table but this isn't...