Search results

  1. C

    Calculating MPG

    I know this must have been covered before but I'm really struggling with this. I want to calculate MPG between fill ups for one vehicle only. I have a table that has the following fields: fuel ID Gallons Odometer TankMiles 1 12 19340 2 6...
  2. C

    Printing help Please

    Thank you all so much for your inputs and help, especially Arnelgp who has made it work for me for the first time in about 6 months (I'm obviously a slow learner). I shall Study the changes that yu have made and try to learn for myself for the future. Meanwhile I can begin to update the tables...
  3. C

    Printing help Please

    Thanks for both of your prompt responses. Here is a copy of the Db I am not too sure what is behind the buttons but it is the print record button on the customer form. I have tried writing code to make the button work :banghead: specifically using the me. Statement in vba (thinking this is what...
  4. C

    Printing help Please

    Hi I have a working database my work (self employed driver). Up to now I have been using a hand written form to record my jobs but I would like to have all this computerized. I have a Customer Table (CustT) with Customer Details And a Job Table (BookingJobT) with Details of my runs. My...
  5. C

    Stuck in a rut

    Mike you are an absulute gem. Thank you so so much for your invaluable help. I'm going to try to keep learning this until I'm not so stupid, I needed help over this hurdle, been stuck here for months!
  6. C

    Stuck in a rut

    Thank You Mike One of the problems that I have is posing the correct question. I have data in my version which I can't share on an open forum, but as a simple database it seems to work well. If I run a search query from the Switchboard it finds and opens the customer form and I can open...
  7. C

    Stuck in a rut

    Here is a copy for you but i fear it doesnt work too well as i tried to enter data for you and the job table sent back note saying it could not be saved. Now I feel very stupid.
  8. C

    Stuck in a rut

    I will do. Thank you so much.
  9. C

    Stuck in a rut

    Thanks for this. I have seen this option but for simplicity I would like to keep one form to each page as the job form is quite complex. As things stand I can call up a new empty job form from my switchboard, but I have to fill in all the customer details again by hand to get it all to work. I...
  10. C

    Stuck in a rut

    I'm new to this forum and quite new to Access. I know that I can’t be the first to ask this question, but I’m struggling to find the answer. :banghead: I have a Customer Table and a Job Table, plus their two respective forms. They are related by a one to many relationship between Customer ID...
  11. C

    Hi From Confuseduk

    Hi Guys So glad to find people willing to share their skills and help others. Im a complete noob who has been trying to designing a database for my own small one man company in Somerset UK. Proud of what I have acchieved so far, but now hit a bit of a wall. Hoping to get a leg up. :)Nigel
Top Bottom