Search results for query: *

DELETE/IGNORE THIS THREAD, PLEASE! I GOT WHAT I WAS TRYING TO DO.

Subform (CompanyName)--CompanyName is a subform on the main form. CompanyID is on the main form.

CompanyName is a subform on Company form joined by CompanyID.

The record source for fmainCompany is tblCompanies.

First, it was set up like this: 1. Main form with button to click to sort. 2. Opens frmSort 3. frmSort has: 1) an unbound combo box with Row Source: CompanyID and CompanyName; 2) Option Group with 2 values: Ascending Descending. Below is the code: On Error GoTo ErrorHandler If...

When I try to sort the CompanyName field, it does nothing. All the other fields will sort like it suppose to. Also, CompanyName field is a subform on the main form. Any suggestions on how to get this to work? Below is my table structure: tblCompanies CompanyID dbLong PrimaryKey...

What are you suggesting here? 'Kind of a bad name since it is a primary key value not a bookmark 'Dim lngBookmark As Long

What so wrong with bookmarks?

It looks the same as the last code I posted except for the last line. What difference will this line make or what is it doing different?

So, are you saying the last code I posted is better one to use?

I changed it to: Dim rs As Object Dim lngBookmark As Long If Me.Recordset.RecordCount = 0 Then Forms!frmViewEventHistoryList.Requery Exit Sub Else ' set a variable to the current record lngBookmark = Forms!frmViewEventHistoryList!txtEventID...

When I am on the first record on the list and I open the form to delete that record, when closing the form I get Error Number: 3159--not a valid bookmark. Below is the code I am using: Dim bkMark As String If CurrentProject.AllForms("frmViewEventHistoryList").IsLoaded Then bkMark =...

The combo box works and I have auto drop down set up. I was asked about using 1, 2, 3 and so on. But, at this point, I don't think it's totally necessary.

Thanks everyone but a list box would cause redesigning the form and stuff.

Because I want the text to show even though they are actually choosing # 1, 2, 3, and so on.

Yeah, I did that--not what I wanted. I am going to try to do a text box equaled to the combo box and so on to get it to work. Thanks!

Is there a way to choose a number but display the text? That is, we have over a thousand records to enter; therefore, it would be easier for them to choose 1, 2, 3, 4 and so on instead of having to type the first few letters from a list, hit the down arrow and choose the correct one. The lookup...

Hey genomon, I did: If Not IsNull(Forms!frmViewJobList!ActivityType) Then... in my form on the On Load Event. That did it. Thanks for your help!

Here the example from http://msdn.microsoft.com/en-us/library/aa211471(office.11).aspx The following function returns the number of orders shipped to a specified country after a specified ship date. The domain is an Orders table. Public Function OrdersCount(ByVal strCountry As String, _...

Okay, I redid everything again and I get the same error message for frmViewEventHistoryList, but frmViewJobList works. I don't see anything that's different.