Search results

  1. P

    set date to certain day

    I have an ActiveX calendar popup but need to limit user choice to Friday only so if they choose other day it prompts them to ONLY choose a Friday, or how can I populate date field to Friday only based from other date field?
  2. P

    need help on form

    please see example code when I click close button from second combo or change to other tab page I get 3201 error. I do have Referential Integrity on, but need to get rid of the error. Can anyone shed some light on this?
  3. P

    exit form

    I have a form with 4 tab pages on the 2 tab page I have a subform that adds records to a table via 2 combo boxes. I have been able to stop user from leaving a combo control blank or skipping to the next combo control, but if user clicks the Exit command button on the main form, from the 2nd...
  4. P

    combo box on tab form

    I have a tabbed form and on tab one there is a combo box to autofill address, city, state and zip fields when user selects from combo. I use the: Me.address = Me.Combo108.Column(1) etc...to populate the fields..no problem until I get to the 2nd tab and I want to use the same combo box copied to...
  5. P

    time and date calculation

    OK so I have a form with the following fields which are all date/time type apptTime timerOn pickupDate reminder - combo box with 1 hour, 2 hour...etc up to 10 hours so what happens is when user enters apptTime say 18:30 with pickupDate set for current days date 10/14/2006 then chooses 2 hours...
  6. P

    vba on Access 2002

    I wrote code on Access 2003 and the default db is set to 2000, but when code is run on Access 2002, lots of errors and certain elements won't work. Is there that much difference between these VBA versions? If so, how can I correct this so users can run program on 2002?
  7. P

    subtracting time

    I have 2 textboxes one has military time entered by user. I want to subtract 2hours from this entry and place it into textbox2... so if user enters 13:00 in Textbox1, how can I get Textbox2 to show 11:00? I have tried several calcs, but can't seem to get it right.
  8. P

    flash textbox on time

    how can I make a textbox flash when a certain time has been reached such as a delivery time textbox...so if delTime is set to 11:00am and you want its textbox to flash if delTime is 9:00am.
  9. P

    refreshing forms

    I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to...
  10. P

    refresh of subform

    I have a form with one subform that lists trucking loads. The form is set to run modal. There is one button on the form to add new loads which when clicked opens a popup form to enter new load. When you click on the Save button on the popup form it saves load to table and closes taking you back...
Back
Top Bottom