Search results

It is Number. This is what I did--my first junction table--been reading following examples given: tblCompany CompanyID dbLong PrimaryKey Indexed CompanyDateEntered dbDate CompanyWebsite dbText CompanySize dbText CompanyProduct dbText CompanyYearFounded dbLong...

Thanks vbaInet, That's what I am looking for! But, I have a problem. I posted to ControlSource: =ConcatRelated("CompanyNameTitle","tblCompanyName","CompanyID = " & [CompanyID]) then I get: Error 3061: Too few parameters. Expected 1. Any ideas what I'm doing wrong?

First, let me say I may not be asking the correct question or the correct way. But, I have an unbound field that I want to populate with multiple answers into one. I want all the subsidiaries, aka, and fka to become one in to an unbound field separate by a semicolon. That is: ABC ABC123...

Here is the db. Thanks!

Thanks Boblarson, Got it--works great!! Now, I am getting an error when I do the following: 1. Click the icon to add a company name. 2. Select a name from the list 3. Then I get the following error: Index or primary key cannot contain a Null value. What did I miss? By the way, since...

Oh, I copied that code and was trying to get it to work here. I am just trying to search for a company name and if found go the record.

Thanks lagbolt. What should I do different to get the search to work?

I have an unbound search field on my form that I am using to search for a company name, but I keep getting the following error message: An error was encountered Description: The Microsoft Office Access database engine does not recognize 'CompanyNameTitle' as a valid field name or...

No, the code is doing what I want it to do--that is, keep the data that's there, just go back to TypeofAddress field so I can enter the type. Additionally, I added the Cancel = True and it will not compile. Get: Compile error. Variable not defined. And when I hit the OK button to close the...

Hey boblarson, I see "acSavePrompt" a lot in the examples and books. So, let me get this correct in my head. acSavePrompt will save changes to the design of the form, but will not save changes made to the record; therefore, I should leave it off or use acSaveno. Is that correct?

I did: Private Sub cmdOK_Click() If Trim(cboTypeofAddress.Value & "") = "" Then MsgBox "You must provide data for Type of Address.", _ vbOKOnly, "ETA - Required Field" Me.cboTypeofAddress.SetFocus Else ' User wants to save and close the form...

Nope, it still closes. I had to move the code to the cmdOK button and then it worked. For some reason putting it on the BeforeUpate still closes--meaning, it displays the message and goes to the TypeofAddress fields and automatically closes before you can add a TypeofAddress. Thanks for your...

It still closes. Thanks.

This code will undo my changes after displaying the message and then close the form, but all I want it to do is display the message and set the focus to the empty field. Below is the code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Trim(cboTypeofAddress.Value & "") = "" Then...

Huh? Too complicated--need something simple.

When I am on the first record on the list and I open the form to delete that record, upon 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...

But, I want the text to be displayed not the number.

Okay. Create a txtbox and the number I enter in the text box will equal to the combo box. 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...

Thanks again RuralGuy, this is a good tip. I have since found 4 errors--it went straight to the errors and I was able to figure them out.