I have a form that is generated by a query. The query is populated via table. I want all values in the report that are over 1.99% to show up as red. Those...

Hi everybody, I want to minimize the access windows and have my forms only in modal popup way, with the main forms always on the background. I just found and...

Using Access 2000. I have a form that opens in datasheet view and is bound to a SQL Server 2005 indexed view. The view contains several tables and utilizes...

I'd like to find a case's end date when users enter information into the form. Text Box names denoted within . For Example Start Date = 4/1/06 (Cases start...

Good Morning all, I have been trying to create a sequence number with a unique last three digits. The number has a total of 14 digits. I can concatenate the...

I have tables set up for my questionnaire and responses. I made the questionnaire into a form and it lists all the questions. When I create a subform and...

Hi all, Ive asked this question before a different way but got no resolution. So here's my problem again, please advise on alternative workarounds or...

Using Access 2003, I have a subform in datasheet view which gets data from a query which sorts records in alphabetic order. The subform specifies vertical...

I have a field on a form that requires multiple items to be selected from the List Box. I changed the Properties for Multi Select to Simple and I can select...

I have taken the posted advice and created a union query to use as a control source for my combo box. All is displayed in the list but it produces no results...

I want to find a record by using a text box. The user starts typing the name of the person they are looking for in the box, and the box suggests possible...

I have created a simple form to enter just one piece of data and I need to update a column of a table with this data automatically with a click of a button....

Hello I have an data entry form with a field called tasknumber. What I want to do is that it automatics calculate the tasknumber. It would be something like...

Hello! I am in a situation that I don't to see why it doesn't work. I have: 1 - T_AllData: Name, Date, Value, ... fields 2 - T_MonthYear: MonthYear field,...

If a function obtains two values you want to use, how do you return them to the calling procedure?? In teh following sample code, I have only returned ONE...

I have two objects on a form that I am trying to manipulate. The first is a combo box to select a credit card type (Mastercard, Visa, Discover, Etc.). The...

I am having trouble using a combo box for selecting a field in my table and then having the rest of the fields on the form populate based on the combo box...

I have a query defined that accessses many sql datasets and does some calculations. This query requires 3 inputs (item, lot, whse). How can I set up my...

ACCESS 2000 I have a switchboard that has serveral menus and sub-menus and I am finding it very excessive to keep making a MAIN MENU button. I have made a...

Hi - I am hoping that someone will know how to do this. Is there any way to use the down arrow key to select in a combo box? Currnetly when I use the down...