Search results

  1. W

    Control source for text box on a form

    Thankyou so much! That works perfectly! :D
  2. W

    Control source for text box on a form

    #error !!!
  3. W

    Control source for text box on a form

    It's: =[frmOrderSubform].[Form]![txtsub] but it keeps changing itself to: =frmOrderSubform.Form!txtsub
  4. W

    Control source for text box on a form

    I've done that but i still get #error in the text box thats on the main form. I've looked at the northwind and done what they've done but its still not working. I think i may have missed something somewhere.
  5. W

    Control source for text box on a form

    would this work? me!yourSubformName.form!yourTextboxName No, it brings up #Name in the txt box.
  6. W

    Control source for text box on a form

    tried that. It says #error. Its frmOrder
  7. W

    Control source for text box on a form

    I have a form with a text box on it and also a subform. I want the text box to calculate the sum of a field in the subform. What is the control source code for this?
  8. W

    orientation of reports

    When setting up my reports using the wizard, i am selecting to have the layout landscape but for some reason whenever i go to print preview or page layout view, it is shown in portrait. Does anyone know why this is?
  9. W

    Date criteria in querys

    I have a date field in a query. How do i set the criteria so that the query searches for dates between today's date and the date 7 days from now?
  10. W

    Subform based on a qry

    I just cant see what uve dun. U havent got unit price in qrySubfrom in yours and yet somehow its in the list of available control sources. Could you explain what you did to get it to work if you dont mind?
  11. W

    Subform based on a qry

    how do i refer to the 3rd column in vb?
  12. W

    Subform based on a qry

    I know, when i change it to it being from the tblProducts it looks the value up fine but then it wont input it into the order details table.
  13. W

    Subform based on a qry

    I have a subform on a form (frmOrder) based on a qry (qrySubform), and one of the text boxes on the subform needs to be looking up the unit price from tblProducts using the ProductID selected in the subform, but its not working. Can anyone see where ive gone wrong?
  14. W

    qry for a form based on 3 tables

    I have made a query to base a form on. The query collects shop address details from tblshop, customer address details from tblcustomer and order details from tblorder. The shop and the order details are working fine on the form, but for some reason the text boxes ive put on for the customer...
  15. W

    Lookup Code

    I have a table (tblOrderDetails) with a foreign key in it (ProductID) which i am using to lookup up data from another table. So far in the Row source of the lookup ive got the following code: SELECT DISTINCTROW [ProductID], [ProductName] FROM tblProducts; I want to also display the Product...
  16. W

    Forms and subforms

    Thanx, i can see now that the northwind db is exactly how i need mine to be. This should speed things along now. Thankyou for all your help.
  17. W

    Forms and subforms

    If i do that is it then possible to have it automatically fill in the type text box and the linings text box using the selection made in that combo?
  18. W

    Forms and subforms

    Its on qrysf subform1 on frmorder4, and its called ProductName. This particular combo isnt filtered off another, but once ive got this one working im gonna set up a second to filter off the ProductName combo, and then one to filter off that one etc.
  19. W

    Forms and subforms

    Spoke 2 soon! One tiny problem now. In the pricelist table there are about 20 different types of curtains, 15 bedsheets etc. At the moment the row source for the combo is: SELECT [tblPricelist].[PriceID], [tblPricelist].[Product] FROM tblPricelist; Ive tried changing it to SELECT DISTINCT...
  20. W

    Forms and subforms

    Thanx 4 that. Took a few tries but seems to be working now.
Back
Top Bottom