Hi I'm tried to get a field in a subform to automatically show if the status of record is open or closed based on the closed date. I have something like...

Does anyone know of an addin that can create navigation bars in an Access database that are similar to the one used in Outlook. As I'm a bit of novice one that...

Hello all, I have a field (User Modified) in my table to record the user who modified that particular record. The users will be doing all the transactions...

I would like to have a field in my form where people can type in their ID number (which is the primary key) and then their entire record comes up. Any advice...

I have a drop down box on a form that has three columns. I need to have the field bound to the first 2 columns because none of these fields are unique. Please...

Hi, I have a continuous form with the following fields from one table: Name (text) Grade (text) CkMailingLabel (check box) The form also has a combo box...

Okay, this is one of the stranger things I have seen. I have a simple form with 2 combos and a listbox. The 2nd combo references the 1st in its Row Source and...

Hi, I don't know what happened. Lately, whether I create a subform or command button in a form, the wizard does not come up anymore. In the past, the wizard...

Any idea why Access adds a colon to a field name? I have a field in a table called "No" (for number) and when I added that field to a form, a colon showed up:...

When I set the Allow Addition property to No on a subform and try to open main form causes Access 2003 to crash. Anyone heard of this before? Change back to...

i am maintaining my data in excel. can i use an "Access" form to feed data in excel. and same way i want to generate a report in access which is based upon the...

Below is the code I have attached to the after update event of a combo box- basically filling in fields when a quoteid is selected- however the field may be...

I would like to have the user be in a read only mode when they enter the form. then give them the ability to switch into an edit mode when they need to make...

rather than using LIKE in all the criteria that you MAY have .... consider having the subform show all the records and just building the Filter property from...

How can I enter a condition for two fields? I want a lt green background with red text if the following conditions are met: HotJob = Yes (redtxt) and...

Please help....Tired of trying diffferent ways nothing working. Using sample of NW.DB Orders. It looks up the rate in Products In my Service table (Which...

I have a pop-up form where I would like to hide the form title bar; right now the form looks good except at the top it says "frmDesignation: Form". Ugly!! Is...

I have a pretty elaborate form I created based on several different tables. I deleted two fields in one table after I had created the form, then deleted those...

Hi All One of the fields in my query "Total: ()+()" displays the correct numerical value when run. Is it possible to get it to display a Zero if it after...

I'm trying to create my first database. I'm working on a form right now that will display data from several fields, all of which now have seemingly...