Recent content by accesslevel

  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

    k, I'll ask another question in a seperate topic
  3. A

    Count in a textbox

    just to clarify: I want to count the amount of records found in a table with a criteria attached. To do this I have created a query that looks into a table called tblInvoice and has a criteria on the field marked invoiceID (the criteria is: [forms]![frmInvoice].[InvoiceCode] which is the...
  4. 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!
  5. A

    Running a Query

    s'k Its ok I got it :) OpenQuery duh!! hehe
  6. 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
  7. A

    Forms and Reports

    Thanks, that works fine now :)
  8. 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...
  9. A

    SELECT and INSERT query

    Thanks Thanks Nouba You sorted my problem :) I had made a work around using a random number generator to create my ID field but now I can use the unique autonumber instead. I had gone wrong because I was missing the center : (Title, Firstname, lastname) :/ Regards
  10. 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...
  11. A

    Combo box and labels

    Thanks Thanks mate, that sorted the prob... half the battle when learning something like Access is understanding the syntax and how to send and receive data. Thanks to you I now know this sort of operation isn't as hard as I thought! Now that my prob is sorted... maybe you could help me with...
  12. 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...
See more
Back
Top Bottom