Recent content by wort0987654321

  1. W

    totals

    to calculate the car price and the subtotal for the extras i am simply using a query and the code can bee seen on the screen shot that i have taken thanks for the interest
  2. W

    totals

    i am having trouble adding the total up for my report. i have one field which displays the price of the car rental. i then have another part to the report which displays the prices for the extra items. there can be four different extra items added. i want to be able to make up a sub total of...
  3. W

    calculating multiple fields

    i have a system that will allow a user to add four different types of extras to a booking. the problem that i am having is when there are three different extras on my report i am unable to add all of the fields toghether to get a sub total, i am using the text =[Price]*[Quantity], this brings up...
  4. W

    dates past todays date

    it seems to be working now for some reason, thanks for the interest though
  5. W

    dates past todays date

    this is probably a really easy one but, i want my query to return any cars that have not been returned to the company past the date they where suposed to have been returned. i tried using the formula >Date() but this doesnt seem to work and the access help is a load of crap. can anyone help...
  6. W

    [OFF TOPIC] Black Square on Screen

    not really to do with access but thought someone might be able to help whenever i right click on something the menu that appears is covered by black until you run the mouse over it. the computer can surely not be at fault as its brand new from dell and cost £2000 !!!!!!!!!! i wonder if anyone...
  7. W

    forms in combo

    refering to mile o philes answer, i began by typing your code into the computers at school which are crap, i then typed it in again when i got home and all of the form names are brought up like i wanted. but when i click on the names of the forms i want them to be opened. is this at all...
  8. W

    forms in combo

    the boxes where already checked off
  9. W

    forms in combo

    i am missing the nodemgr 1.0 type library and the ITIsyscheckpbject 1.0 type library is this where my proble lies and if so how can i fix it
  10. W

    forms in combo

    this brings up the error message underfined function "mid" in expression
  11. W

    forms in combo

    is there any way that i can select forms from my combo box or even macros, or is there another way that i can make a drop down list for speedily opening forms
  12. W

    clock

    is there any simple way that i can have a clock on my forms that changes time without having to go off the form and then back onto it. any help would be much appriciated thanks
  13. W

    auto popup

    i am unable to post my database
  14. W

    auto popup

    here is part of my system, i had to cut it down alot. i want a form to open once the main menu has opened that tells the user that there is a car due back today (if there are any cars due back today). i would like the form to contain a command button which will open the form showing cars that...
  15. W

    auto popup

    here is part of my system, i had to cut it down alot. i want a form to open once the main menu has opened that tells the user that there is a car due back today (if there are any cars due back today). i would like the form to contain a command button which will open the form showing cars that...
Top Bottom