Search results

  1. W

    Goto record in subform

    Hi, I have a main form and a subform which both have show records from the same stocklist table. The main form has a summary of one record while the subform is unlinked and shows a list view of all records. On the main form i have an unbound control box that a stock number can be typed into...
  2. W

    UNION SELECT & INNER JOIN to join three tables

    I’m not sure how to word this, but I want to use the UNION SELECT command to join two tables together and then link another table to this joined query. I have two invoice tables (InvoiceCompanyA & InvoiceCompanyB) which are identically setup. I then have a InvoiceDetail which lists all the...
  3. W

    Run-time error ‘3464’

    I have an Invoices form (frmInvoices) which has a sub form linked to it (subfrmInvoiceDetails). These get their data from the two tables, tblInvoice and tblInvoiceDetail. Basically, I would like to take the subtotal of the subform and write that value to the main form (value to be stored in...
  4. W

    Date default field shows "#Name?"

    HI, I have a table that I have a date field with "Date()" as the default value. The tables sits on a linux server. The frontend is copied to each workstation. The forms that access this table works perfectly fine on my computer (Win7) and notebook (WinXP), but on some workstations, the field...
  5. W

    Form to select which table to use

    HI, I would like to know if there is a way to have a form (checkbox or similar) select which table to use. My problem is that I am trying to add invoicing to my database, but the database has two companies linked to it. The invoices for company_1 is stored in table_A and the invoices for...
  6. W

    run-time error '3464' - Data Type Mismatch

    Hi, I am trying to sum up a list of invoiced items (data stored in table tblInvoiceDetail) and write this value to the “Total” field in the table tblInvoices. I want this to update after each record is typed in the subform. I was given the below code from friend, but neither of us can get it...
  7. W

    Filter Sub that does not work in Windows 7

    Hi, I have a filter sub that has worked perfectly fine in Windows XP, but will not work when used in Windows 7. The database is in 2003 format. Basically, I have a text box in the form header (frmStockInfo). When you type in a keyword and press enter, it searches the table "tblStocklist"...
Back
Top Bottom