I have a form based on a Dynaset query. The query is based on two tables linked one-to-many in the relationship window and linked via a left join from the...

The records in my form seem to be sorted alphanumerically by ExpID(pk). I want them to be sorted oldest record to most recent because folks make use of Ctrl/'...

I'm having a problem with the ItemsSelected.Count. I have two list boxes on a form. The first list box contains a list of tasks. The second list box I want to...

I would like to have a text box's visibility tied in with a check box. In other words, if the check box is unchecked the text box field would be grayed out...

I have a form with a subform. I would like the subform to open in add only mode is that possible. I want to allow multiple additions but no changes once the...

hi, is it possible to use a function call as event replacement with the form itself (Me) as parameter? In a module i have defined the following: Public...

I have a list box with a list of first and last names in it and I just used the wizard to create it. It created it so that when you click on one of the...

Hello I would like someone to be able to help with the updating of data in a lookup list in a subform. In short, is their a VB instruction that is...

I have a form for Production Procedures, and a subform for the parts that are covered by the procedure. The subform works by selecting a part number from a...

I am using Access XP. I would like to simplifiy the data entry on my form. I have a field for City, County, State, and Zip Code. The State will default to...

All of a sudden when I add a subform to a form (any form or any database), but when I draw the subform using the wizard the list of tables or other forms that...

Hi, I've programmed a rather robust program to use in our business on an Office Intranet. If I attempt to edit a form and make even the slightest...

How do I set the global property of a textfield on a form so that if an Email address is added when I click it takes me direct to Outlook. I have tried...

Hi In a form I put an Excel OLE windows for the user to put some info in it. I've create a button to save the work but i'm not quiet sur how to put what the...

Is it possible to have a subform that changes its source table based on a selection in the main form? For example: if I am using this form to look through...

I'd like to simulate the sort of drag and drop action you get when dragging a query into a macro; it appears as the OpenQuery action. All I'd like to capture...

Hi All, This must be simple but... Can't get it to work. My problem: I have a form with data. As a specific field in the form is filled with data the related...

I am trying to find get my database to display data that i type in a combo box...what coding do i use to clear the combo box after it has displayed the...

I am putting a subform on a tab control (Access 2003), and want to match the color exactly. Does anyone know the rgb codes for the tab control? I've tried to...

Hi, Heres a good one :) Ive got a form in Access97 and am using a Tab control. To make it look a bit nicer, I have put a Box around it and coloured the...