Hello all, I wonder if you can help me. 1)I have 12 records on a form by use of combo boxes. At any stage, a user might enter data which is not in the...

I am looking for code help to have a not in list event call up a form. What my current code is the following: What I want to be able to do is have it open my...

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...

Okay, I have a Not In List event that allows me to add a new person to a list by asking if we want to add them and it opens a second form that allows the user...

Here is the code I have for my not in list event: It is giving me an error at the If IsNull(DLookup) line. My combo box runs of a query that pulls the...

Two questions follow this NotInList procedure shown he 'Ask the user whether to add a value to the list Dim strMessage As String strMessage = "Are you sure...

I have a form that allows me to add a new person to a list via the not in list event. It opens a seperate form that allows the user to add a person's first and...

Hi everyone, I am using the following code in the event an item isn't in my list: Private Sub Plaintiff_s_Firm_NotInList(NewData As String, Response As...

I know I put this in the validation rule for the date field in the table but I am having a hard time getting the right syntax. The field name is service...

I would like to know which properties I need to call to not load a subform with its parent until all of the on load coding has completed. The reason for this...

I have several databases in 2003 but I'm just not getting anywher in 07. What book or training would you suggest. I'm at the point of switching to File...

Hello. I have a form called Login containing a combo box and a text box linked back to two fields in a table. I have a validation rule for each not to be...

When I am in a subform and enter a product that is not on the list I want to be prompted "Do you want to add to list" and when I say yes it will poplulate...

hi guys, i was wondering if you can help me, i have a form in access the code is kind of big but i am only having a problem when adding a new record so here is...

I have conditional formatting on a form. It changes the text color and background color in certain conditions. Is there a way to NOT show the colors when...

Is there a new setting in A2003 that prevents Access from prompting the user to save after making changes to a form/query/report in design mode? All of the...

This isn't returning the right answer. It's always returning "OLD" no matter what the dates are. If both Start and End date are older than a year then it...

Hi guys, I am having trouble with a DB that is across a network which occasionally does not save files There is no message of any description. When you...

I am generating a pivotchart with smooth lines as an average of items. If it only contains smooth lines I can save the form. When I add a bar chart to the same...

I have put in the following code to filter a quoteid drop down list based on the job # selected in the previous dropdown. There may be 5 quotes for example...