i have insert a calendar, and made a textbox having it as control sourse.. the problem is the calender(MicroSoft date and time picker) returns hour as well. i...

Hi I have a table that is indexed on the tel# field (no duplicates). My input form lets you fill in a tel# while automatically filling in the number as you...

Thanks in advance for any assistance you can provide. I'm using the control on an Access 2003 form where I would like it to update an existing date field which...

I have Subform1 (datasheet view). Subform1 has also a subform (subform2)... so I have the "+" symbol next to each record on Subform1. I need to find out if...

I have a form with a input mask, the format in the input mask is !\(000")"000\-0000;0;_. I also have the format in the table set to the same. Unfortunately,...

I have a form to enter invoices. The form is similar to the Service Call Management sample db "Work Orders" form (included with ACC2000). My invoice form has...

When a user creates a new record in the main form, at least one record is required in the subform. How can I enforce this? For example, if my main form is an...

I have an A2000 form with a 3- page tab control named Personal Data, Contacts & History. When users click the History page tab I'd like a messagebox to fire...

Hi Everyone, I have a form that I want to show all the records. Usually I have a 1 of 3333 and can scroll through the list of patients using the record...

Hello there, I need to create a comboBox named cboStatus as follow: 1) If the user is a manager, display only one status in the comboBox as "CLOSED" and the...

I am looking for a way to be able to have a user be able to take multiple pictures, save them onto their computer in a directory and then have the form I am...

Hi, I have a form where there are few blank fileds (shown in design view). However, this form is being used as a data entry screen. I have no way to know which...

I have several questions, but first the setup Mainform = frmEmployees On the frmEmployees I have a tab control = TabCtl36. On the tab control I have...

I would like the database my teachers use, that has not be used in the last 10 minutes, to close by itself. I have teachers who will let the database run all...

Hello, I have a combo box with data from a chart of accounts. The first (bound) column is the account number. The second column is the description. I want...

Okay, I figured out how to make certain controls/fields visible on my form depending on what is entered in one of the controls (it's always visible). The...

I have 2 date fields in my table/form to capture 2 possible expiration dates. If either of those dates is current date I want to set an unbound text field to...

I asked this question earlier and received a suggestion. I had some questions, but the thread died out. Here is the situation again. I have a table...

Hi All! I have an option group with three options. What I need to do is when the user clicks on "Reset", the default option is selected. Thanks to all for...

I am a newbie and have a crazy question. On a form, I have a combo box that is designed to pull up certain diagnoses. My original Diagnosis table is set to...