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

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

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

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

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

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