Recent content by wildexodus

  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...
See more
Back
Top Bottom