Search results

  1. 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?
  2. 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?
  3. 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?
  4. 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?
  5. 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...
  6. 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...
  7. W

    Brackets in VBA code

    Can anyone see whats wrong with this code? Private Sub Form_Open(Cancel As Integer) IIF(([Forms]![frmOrder]![CustomerID])= Null([Forms]![frmCustomer]![CustomerID]), [CustomerID],[Forms]![frmOrder]![CustomerID]) End Sub It's in the 'On open' section of my code for the form.
  8. W

    Forms and subforms

    I have 2 forms. One to input customer details with a subform to input orders for each customer. The second shows order details at the top and has a subform to input each of the individual products for a particular order. At the moment the Order form is allowing me to input orders, which i do...
  9. W

    code for command buttons on forms

    I have two forms, frmCustomer and frmOrder. Frmcustomer inputs customer details, frmOrder inputs order details and also has a subform to input different products for each order. All of this is working fine. I have a primary key in tbl customer called customerID and this is also a foreign key...
  10. W

    Subforms problem

    I have a form for which i want to be able to input order details into the database. On the main form the actual order details will be input (Order date, Order number, etc). However, each order can have lots of products e.g. Order no. 256 1. 1 pair curtains 2. 2 Tiebacks I need a subform...
  11. W

    Explanation of code

    Could someone please explain to me what this code does. It works, theres nothing wrong with it, i would just like to understand what it means so i can adapt it in the future.
  12. W

    Numeric validation in a table

    Is there anything similar to: IsNumeric([CustomerSurname])=False But instead i want it to prevent text being entered instead of numbers. This is to go in the validation rule of the field properties for one of the fields in my table.:D
  13. W

    Maximising Forms

    Is there any other way other than using a macro on open, to have a form automatically maximised?
  14. W

    Increasing a date entered

    A user inputs an order date into the system which will go into a table. I also have another field in the table called 'DueDate'. I need to put in the default value in the field properties a string to take the date from the first date field and add 35 days (or 5 weeks) to it. How do i do this?
  15. W

    Text field in table

    I want to make one of my text fields in a table only allow text entry. I know i need to put something in the 'validation rule' box but what is the codes?
  16. W

    Including the value in a text box in a calculation

    I want to use the value in a text box in a calculation for a Select Case statement in VBA. The code i am trying to use is: Case "-----" Text75 = (cboQuantity)*(cboUnitPrice)*(txtWidth) The calculation works untill i put the txtwidth on the end. Have i missed something out?
  17. W

    IF Functions

    I was just wondering if there was an MS Access equivalent to the IF Functions in MS Excel.
  18. W

    Combo boxes

    Is there any way to make a combo box automatically select the top value (or only value) in the list with having to specify a value in the properties? This is because the options in my combo change each time.
  19. W

    #error

    What does #error mean when it comes up in a text box. Ive put some code into the control source of this text box to make it do a dlookup.
  20. W

    #name

    What does it mean if this comes up in a text box that should show data found using a Dlookup function?
Back
Top Bottom