Search results

  1. A

    Sum, Forms and Query prob with #Name? error

    Hey all, K, I have a form called frmInvoice and on that form I have a list box which shows all the invoice items relating to this invoice using an invoiceID field which is unique to each invoice. I want to display the total £ (pounds) of the invoice so I have a textbox called txtTotal which has...
  2. A

    Count in a textbox

    Hey all, How come I either get a #name or #Error in my textbox when I try to count the records from my query I have tried: =Count([query1!invoiceid]) which give me an #error and I have tried setting the Totals in my query to Count but that gives me a #Name :/ Please help!
  3. A

    Running a Query

    Could someone please tell me how to run a query in a macro (I cant see what command to use?) I want to run: qryDeleteCustomerInvoiceRecord then qryDeleteCustomer please help
  4. A

    Forms and Reports

    Hey all, Ok, I have to print a customers member card. I have a table "tblCustomers" which stores the usual FirstName, LastName etc... and i have a form which I can edit this data through. What I want to do is create a button on my form which when clicked will print all of the customers...
  5. A

    SELECT and INSERT query

    Hey all When I click a button on my form I want it to add the title, firstname and lastname from the fields on the form to my existing customers table but I am stuck when it comes to the autonumber. I tried using: DoCmd.RunSQL "INSERT INTO Table1 values(cboTitle.value, txtFirstname...
  6. A

    Combo box and labels

    Hey all This question has probably been answered over and over again but I'll ask again anyway :) Ok, I have one table of customers called "tblCustomers". I created a form (totaly blank), called "frmPurchase" and placed a combo box onto the form called "cboCustomers". I also placed a label...
Back
Top Bottom