I have a combobox whos row source is: SELECT ., & " - " & & " " & AS Name, .First, .Last, ., .Phone, ., .Company, .Address, ., .City, .State, .,...

Hello,All I am quite new with Access and stuck with two questions. 1.I use a combo box in a form to input or edit BASEID. I set the Limittolist to true and...

When the user Clicks new Record, I would like the current date to be filled in on the OpenDate field Annelie

I originally posted this question in the Forms Programming goup, and got no response. I am really hoping that someone here can give me some direction. Kind...

I have two forms and one master table. The forms were created for data entry convenience. In the first form there is a command button to direct to the 2nd...

I would like to filter a form when it opens. In doing this I would like to be able to choose from one of 12 different filters and have them listed for the user...

I want to have a running clock in a form. I currently have a lbl with the control source being =Now(). But this appears to be static while entering data in...

Hi I have a column of text boxes on my form that have been creted using the table list drag and drop method. When i enter data into one of the text boxes it...

Is there a way to do a lookup for this, rather than the complex expression I've written? It used to work fine, until I added one more Iif to...

I have a problem when trying to print or print preview an access form. All data is visible, apart from numbers. I can see the numeric characters in the form...

How do you create a report from a Word form? I want to fill in the blanks on the Word form with the information that would be supplied by Access database that...

I have a database in which users are beginning to input old data. However included with each record to be inputted are attatched a a word document(s). How...

I have two forms, let's say: frmMain frmSubform frmSubform is a sub form in frmMain. The subform is viewd in continous form format. In addition, I also have...

I have a sub form where you click on a field in the sub form to display detail information about the record. The mouse changes to 'I' when it is moved over...

Switchboards are essentially forms, is there any way that I can have a user push a button to go somewhere but before they go they are prompted for a...

I need 2 fields from a combo box. 1 field, ID is the bound column, and opens 1 subform. I need another field, student, to open a different subform. How do I...

I have a form that is displayed as a Pivot Chart. The pivot chart has its own title and I would like to be able to change it on FORM_OPEN to equal a value on...

Hi, I have two tables .. 1.tblPhys (fields are SSN, Sal) 2.tblTransTemp (fields are SSN, Sum,....) the SSN field type is Text (not number) I designed a...

Does anyone know a way to emulate the behavior of a multi-select list box in a continuous form (datasheet view)? E.g. I'd like to be able to hold the ctrl key...

Is there any way in which i can automatically change poeples screen resolution to a set size when a user opens up my access file? - and then change it back to...