Search results

I have a subform that displays filtered information. The subform is based on a form that contains a cmd button that allows the user to add additional records to the subform. The problem is that if there are no records in the subform query, the form in the subform does not show, therefore the cmd...

Rich, Works like a charm. You have helped me so much that I think you are entitled to at least 1/4 of all proceeds from the this project. Unfortunately this, like all of my projects don't generate any money. All kidding aside, thanks a lot to you and everyone else that chooses to help. I am...

Rich, I figured it out. Thanks. Is there a way to open a form or record by entering a click event on an item in a listbox?

I am trying to use the new textbox to read data from a field on the form by using the control source ICAO. Which is the same as the input that the user inputs prior to opening the form. If I type the ICAO in the new textbox the list box updates fine. Is there any way to get the listbox to update...

Rich, I did all of the above and it is almost working. The list box does not update when the new text box updates. I can get the listbox to update if I go into design mode, then back to regular mode.

Rich, I am confused. where do I put the Forms!SomeformName!ControlName Is SomeformName = current form that I am using? With the listbox and the unbound text box. Is ControlName = listbox? Thanks for your time.

I have 2 questions. First, I’m sure there is an easy answer but I have not found it. I would like a list box that is defined by a query, the problem is that the query I want to use is one that the user inputs a value in a dialog box. When the user inputs the value to sort the query, the user has...

Rich, thanks for taking a look, It is getting late here (we must be on opposite ends of the world), so I will check into your suggestions tomorrow. I am going to change my names to get rid of spaces. (Hey I'm learning as I go ) Flying is the easy part, designing the instrument approaches the...

Pat, Thanks for the info. I tried it but I must be doing something wrong. I got the following error message: Syntax error(missing operator0in query expression'{PROCEDURE ID]=193AND'[PTAS Number]'=rkso test 1a'. 193 is the procedure id I want to link with rkso test 1a, so I must be getting close...

Rich, I put the cmd button on the subform footer, but I still can't get to the exact record that the user is viewing on the sub form. If the user is viewing record 3 of 4, I can only go to the first or last record, not the one the user is viewing. I guess I could have the user just cycle through...

Rich, The problem is that the DoCmd.GoToRecord acDataForm, stDocName, acNewRec code brings me to a new record with a procedure ID of 0. My main form is linked to my sub form by procedure ID.If I have a procedure record on my main form with a procedure ID of 193, the PTAS info which is on the...

I posted this in the VBA area but no replies. I wonder if a form expert can help. I have a form that contains airport information. It opens with a query where the user selects the airport to view. Once the form opens, the user can navigate through the instrument procedures at the selected...

The thing is that I can get records that are already in the database on my form to enter new data, but nomatter how I try to enter a new record, all I get is a total new record.( the field from the main menu does not match the field from the subform) So I have the new PTASEnter form opening, but...

No, no filter on the PTASEnter form. Does it look like my code should work? Maybe I should look for a different way to have data entered for PTAS information rather than a pop up form.

Rich, Any chance you can help with another problem? I am trying to get a form to open that opens to the current record on a subform. Private Sub EnterNewPTAS_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "PTASEnter" stLinkCriteria = "[PROCEDURE ID]=" & Me![PROCEDURE...

Rich, the timer event worked for me. Thanks I have been beating my head on my desk for about a week trying to figure this out.

Yes, there is more than one subform on the main form I call up with the query.

Rich, Thanks for the quick response. I put your suggested code in the on open event for the form that loads after the query is ran, but it does not work. I still get a blank form if no records match the search. I'm sure I am missing something simple, I just don't know what yet. Mike

I have a form that contains airport information. It opens with a query where the user selects the airport to view. Once the form opens, the user can navigate through the instrument procedures at the selected airport (on the main form). I have a sub form (on a tab control) linked to the airport...

I am very new to VBA and using Access 97. I have a form that opens and displays filtered data. The query that I am using to filter the data uses an input box to specify the data (from a field) to be displayed. I would like to have a message be displayed when there are no matching records...