I have a dropdown combo box. A user can either select a date from the list or type on in. The problem is when I start to type in a date, the box auto fills with the bound column which is not the ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23037041.ht...
Zones:
Access FormsDate Answered: 12/20/2007 Grade: A Views: 54
When the user clicks on the Add button I use the followng code to write to two different tables. Once the data is written to the tables I want the newly added info to display on the form. How do ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23045229.ht...
I am trying to use the following error handling code so that if a user wants to enter a brand new client the code takes them to the first field and doesn't let them leave until they fill it out. O...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23051327.ht...
Zones:
Access FormsDate Answered: 01/03/2008 Grade: A Views: 22
I need code that does not allow the user to leave the page/tab until all the data is filled out. With the following code I read through the records On Deactivate and display a message if the user ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23054506.ht...
Zones:
Access FormsDate Answered: 01/02/2008 Grade: A Views: 0
How do I use this input mask 99/99/00;0;_ with Date Time Picker. Whenever I set the input mask the date Time Picker no longer shows. Is there something else I can do.
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23054698.ht...
Zones:
Access FormsDate Answered: 01/03/2008 Grade: A Views: 180
I have a combo box with a row source of
CaseNotesID 'key to the table
Date: Format([CaseNotesDate],"mm/dd/yy") 'date field seen by the user
ClientFileNo 'numeric field foreign key
If I...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23057531.ht...
Zones:
Access FormsDate Answered: 01/03/2008 Grade: A Views: 4
What would be the syntax if I want to have a findfirst for when the user selects from a combo box list and another for when they type something in?
'if user selects from the dropdown ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23057581.ht...
Zones:
Access FormsDate Answered: 01/04/2008 Grade: A Views: 0
I'm trying to use the following code to keep the user from leaving the page/tab until all the conditions are met. It sort of works but it displays my message twice. I think it's because of where ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23060204.ht...
Zones:
Access FormsDate Answered: 01/06/2008 Grade: A Views: 5
What I want is to require the user to enter 1 address(in a sub form) before leaving the main form. All but line 2 of the following code works if the cursor is on the 1st record. However if the c...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23065252.ht...
Zones:
Access FormsDate Answered: 01/08/2008 Grade: A Views: 49
I've created a query and I need to use 'between' but the logic needs to pick between 2 options after the 'and'. Can I do that?
Between ("01/01/" & [Forms]![frmPlacementRpt]![txtYear])
And
(...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_23102080....
