Search results

I have a text field that has preceding zeros, the total LEN is 12, so for instance the field would be 000000561803 or 000001012304 (can have anywhere from 2 to 7 preceding 0's). I am curious if there is a way to add a control to the form field to add X number of 0's to the string to make the...

thanks so much!

I have two tables, one has the autonumber column, sysid, and then in the process of updating the database via forms the sysid from one table is placed in another (text format). I thought I could use that to link the tables for queries, but I am running into a data/type mismatch error. Any...

Thank you! This works perfectly!

I have a query that is set up to join two name fields...for example: [ELIGVENDORS.LSTNAM] & [ELIGVENDORS.FSTNAM] The issue is that this is perfect for names that are entered in the table like this: Lstnam: ABC HOSP Fstnam: ITAL They are entered like that for groups, but when individual...

Thank you so much rural guy!

Any ideas? Thanks in advance.

I have a search form, generally it runs fine...until now. When the record contains a ' in it, I get an error. For example, I can search on last name Smith fine, but unable to search on O'Malley. I get runtime error 3075 Syntax error (missing operator) in query expression 'lstnam LIKE 'O*M*'...

Can't you look at the answer that was provided for your other question, take the code and then customize it for the text box? It should be the same principle, except change = FALSE to NULL

Can you post the db with more than just the subform in it? Hard to figure it out with just the info given.

Do you have a button or something that the user clicks to search for the next record? Do you have a button for the user to check next record, you could change the focus back to the main form onClick and also set the check box properties back to false....I think.

I think I got it. On load of the form: Private Sub Form_Open(Cancel As Integer) If Egetinitiativ = False Then Me!Diagnos.Visible = False End If If Remis = False Then Me!Remittent.Visible = False End If End Sub For the 1st check box: Private Sub Egetinitiativ_Click() If Egetinitiativ = True...

I have something like this in my database. I have a main form, they click on a Search button and a pop up comes up where they can search by last name and first name (first few characters of each) and it brings up a listing of records meeting that criteria, then they click on it and it brings...

I have a list of account numbers for members, they have distinct member numbers. I have it set up for users to search for the member, then the member number will auto-populate. I also need to account for members with no member number. I would like to have the user click on the check box...

Thanks for the help. I finally figured it out. Private Sub Member_Click() ' Select the Main form control. Forms![frmHF_group].SetFocus ' Select the subform control. Forms![frmHF_group]![frmDEMOGRAP].SetFocus ' bring search data over to other form...

thought I'd bump this question. Thanks.

Hi everyone, I'm hoping I can get some help here. I have a form with a search button. Click on search, search for member, then form should close and populate the fields on the form which is already open. I figure I should use setfocus, but I am new to coding and need help. Right now, when the...