Recent content by reboot_computers

  1. R

    How to turn off macro error when clicking blank part of form

    Hi I seem to get a cant find macro error when I click on an empty part of a form, if there a way to stop this please
  2. R

    Products Subform/Subtotal

    Hi Thanks for all the advice. I do use google a lot and as I am a pc repair guy and have my own shop , I have been fixing pc's for 19 years so I am always using google for that. I normally only come and ask the question after I get to the stage where my brain is hurting and I just can't...
  3. R

    Products Subform/Subtotal

    Hi Again I have 2 questions as i'm not sure which direction to go in now. I have a job form which gets most of its information from a table called jobs and on this form I have a subform which is linked to an sales table . All the subform has is a combo box for services and a price , which...
  4. R

    Unbound text box

    That's great, thank you
  5. R

    Unbound text box

    hi iam having a problem trying to use an unbound text box on a form in access 2007. I am trying to pull the first name out of a table called customer where the id matches the same customer id used on the form(Frm_jobs using this code =DLookUp("FirstName","Customer","CustomerID=" &...
  6. R

    Qry linked form wont allow to add text box

    Hi I am using Office 2007 and have a form that is linked to a query, also I have a sub form linked to the same query. I cant understand why both forms say in their properties that they are linked to a query but when I try and add a text box to show customer ID it tries to show data from a table
  7. R

    Relationships versus Queries

    Thanks for that Pat. The only other thing it is really bugging me is when I add a drop box and it says unbound, which I think is because the form isn't bound to a table but to be honest I'm not sure if I'm looking at the wright property box. Thanks again to everyone for their time. Paul Edwards
  8. R

    Relationships versus Queries

    Thanks David I'm the sort of person that will keep trying to do something without using the wizards because I want to know I can fix it when it goes wrong so I probably waste a lot of time as I won't feel comfortable until I know exactly how it works. Is it possible to have a drop down list...
  9. R

    Relationships versus Queries

    Hi I am I but confused as whether I need to use relationships or queries for drop down boxes in a form or table in access 2007 as I did have a couple of drop down boxes working but having say a customer table and say a title table and using a primary key on the customer table and a foreign key...
  10. R

    Greetings

    Hi and hello to everyone I am Quite new to Access , I hope to learn new things here and hope to be able to help others too. My background is as follows . I have been fixing and building computers for about 18 years, I have a small shop in a small village , we also build websites. I have an...
Back
Top Bottom