Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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
  7. W

    auto popup

    i have a form that displays any records of rentals that are due back on todays date. is there anyway that i can get the form to automatically open at 6:00am when there is a record present, and not open if there arent any rentals due back today. a like the date manager function on the computer clock
  8. W

    Difference Between Dates

    les ferdinand is quality i have a date in and a dat out field. i want to be able to find the total amount of days between each of the fields. can anyone help
  9. W

    Subtotal in Subform

    another bloomin problem i have a form that is a sub form. the subform allows the user to add extra items to a booking. i want to be able to make a subtotal of the extra items that have been booked for each seperate booking ID. can someone please help me, but please make the instructions fairly...
  10. W

    Background Colour

    background colour this is going to sound like a pretty stupid question but here goes. does anyboady know the red, green, blue colour content of the preloaded background on a form. or does anone know the hue, sat, lum colour content any help would be a big help. thank you.
  11. W

    Creating Circles On Forms

    going round in circles i want to add circles to the design of my forms but cant seem to find a circle button. is it possible to make circles at all
  12. W

    datasheet view

    i have made a form with the form wizard and selected the datasheet view. when the form is opened i want to be able to give the user the option of printing the form out, is there any way of doing this
  13. W

    pop up resizing

    why the hell does my report resize itself when i close and re open it. the report is set to pop up with auto resize set to 'no'
  14. W

    pop up forms

    i have made many of my forms pop ups as i feel they make my system look more professional. i am having a problem though when i open a table and i guess when i open a query the same will happen, the form is always ontop and you cant access the table without closing the form. is there a way...
  15. W

    On Timer

    on timer i want to open a report in print preview. then open a form over the top of this report with a message on. i then want the report to close. i then want the form to close i then want the report to print. i want all of these things to happen with a gap of a second and a half between...
  16. W

    Hiding A Form's Name

    me again!!!!!!!!!!!!!!! i have a form that i have removed the close and maximise and minimize buttons from, is there any way that i can remove the name of the form from the top of the form
  17. W

    a really easy one im sure

    i have made a report but when i go to print preview mode i dont want all of the records to be displayed. i just want to be able to printout the report with the text box outlines etc please help me. thank you
  18. W

    multi sizes

    is there anyway that i can have some of the windows that open in my database full size any then a certain few that will open to the size that i want them to
  19. W

    calculating between 2 date fields

    i have two fields that contain to date records i want to be able to add up the total amount of days that there have been between the 2 dates anyone help?
  20. W

    Calendar Form

    calender form i want to be able to create a form where i can select a month of the year from a combo box and the dates and days will be shown for that month. i also want to be able to display any rentals that are due back to the company for each day. is there any way of doing this any help...
Top Bottom