Search results

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?

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?

update sample of error when you click on command button or tab to other page

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...

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...

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...

I would guess you mean on the 2002 machine... and not to look stupid, but don't think I have ever done it...can you clue me in on it? I have imported one db to another, but don't think that is the same.

too much code to post, but I do know that the 2002 machine is running 10.0 Object Library and I am running 11.0 Object Library. Also on the help & About Visual Basic the 2002 version has Form3:11.0.5709 and mine has 11.0.6550. When you try to go into the design view on the 2002 version, it pops...

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?

I was able to get it with: At least it seems to work correctly Me.Text8 = (Me.Text0 - 0.083333332) then I can do this: If Time() >= (Me.Text8) Then here is where I then change background color to red to alert user

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.

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.

form2 is not a dialog box, it is a tabbed form. I have tried to requery on various events on form1 and form2, but still won't refresh form1 data.

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...

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...