Search results

  1. T

    queries/switchboard manager??

    how do i add queries into a form of my switchboard using the manager? what option is it? thanks
  2. T

    Private Sub Form_Current() says syntax error?

    this part of one of my codes Private Sub Form_Current() doesnt work, it says that there is a syntax error in it, what is wrong?!
  3. T

    Option Buttons

    I have 4 forms and 1 form used as a switchboard. The forms i link to are car, customer, tyre, and invoice. I'd like to create an option group on the switchboard form, so that the user will see all 4 forms listed with an option button next to them. clicking on the option button will make it...
  4. T

    annoying problem (relationships?)

    i have 4 tables in my db, customer, car, invoice and tyre. a customer has their car fitted with new tyres, and the db is used to store their car info and tyres fitted and personal details. i can make a form with the car and customer info together so i can enter it all at once fine. but if i want...
  5. T

    relationships dont seem to work - driving me mad!

    okay, attachment one is a screenshot of my relationships. the database is for a project im doing. customers take their cars to be fitted with new tyres, and charged as applicable depending on the type of the tyre. i have created a autoform from a query 'invoice entry'. this query allows me to...
  6. T

    "filter by form" problem

    hi, ive had this excersise to do as ict homework. one of the questions asked me to use the filter by form function to show only all the sailings from portsmouth that are priced between £90 and £130. i have attached a screenshot with the problem on it as i wasnt sure how to explain. ive just got...
  7. T

    show numbers to two decimal places

    im trying to change two of my fields, start time and end time so that they show two decimal places. in design view i changed the properties as shown in the attachment, but it isnt working. what have i done wrong as this should be really simple but i cant fix it!! thanks
  8. T

    confused about invoices

    i have to produce invoices in a project i am doing for my as in computing. however i really dont understand what to do, i know that invoices are usually produced as reports but i dont have any idea how to do calculations in access??? can anyone give me the basic idea, thank you very much for...
  9. T

    changing button colour?

    I was wondering if it is possible to change the colour of the command buttons, as I don't like them grey. Thanks
  10. T

    option group in switchboard problem

    I am creating a switchboard for my database from stratch. I wanted to have an option group, which I have created, and the options in it are the names of the forms in my database. I currently have it set up so that when the user clicks the option button, the form is opened immediately. However...
Back
Top Bottom