Search results

  1. G

    Query Button

    I have a button on my form that when you press it I want it to ask what Field ID's do you want to view. Right now, it opens them all. Here is the procedure code I am using... I would like to add to this code and not add it to my query table... Private Sub Command111_Click() On Error GoTo...
  2. G

    Select Option on Combo Box update return date?

    I have a table with a field name called reture date and the default value is: =DateAdd("d",21,Date()) In my form when you select Daily from the Combo box, I want return date to equal current date + 21 ( I have this part working) If you select monthly, I want the return date to add 1 month and...
  3. G

    Total time for the month

    I have a form where you enter the down time and the up time and it gives you the difference for the day. What I need it to do now is tell me the total for the month. Not just the day. I'm fairly new at this and have no clue as to where to begin... Also - the field that gives the difference...
  4. G

    Downtime - Uptime = differencedowntime

    Jatfill, I am adding the statement: Format([uptime]-[downtime],"hh:nn") to the totaldowntime textbox under data and defualt value but it always sticks in a date instead of a time. Any clues?
  5. G

    Downtime - Uptime = differencedowntime

    I have 2 fields created for my downtime and uptime. When I enter the times I want the totaldowntime field to update and tell me the difference between the 2. I have been at this for some time and keep getting errors. Any clues on how to do this??
  6. G

    Updating Return Date??

    I am working on a tracking form to track backup tapes. Right now, when you add a record, the return date is 10 days from the current date. I would like it to update it if you select monthly tapes (drop down box)to change the return date to reflect 1 year or if you select daily to add 10 days to...
Back
Top Bottom