Recent content by Kayo

I have a basic parameter query that asks the user to enter a social security number. Currently, if no record is found, the system shows a blank record. I need the system to prompt the user that "No Records Found" via msgbox.

Leslie, thanks for getting back so quickly on this. I tried to respond to you immediately yesterday but the system was experiencing problems. In answer to your questions of yesterday: 1. The fields are in different tables. 2. The fields are both text fields. 3. UIC2 will always be a single...

I have two fields: UIC1 = W12345 UIC2 = 12345 How do select all the records in UIC1 That match the five characters in UIC2? V/r

Ooch1, to easly get rid of "dups" simply create a new table. 1) Make a copy of current table's structure only 2) Do a make table query 3) In the new table design view, make the MPA ID field the "Primary field." This will prevent any duplicate MPA data from...

[b]Sorry, it has taken me so long to get back w/you folks. Thanks for all the help. I tried all the examples. Klaz2002, your code produced exactly what I was looking for. Again, thanks to you all. V/r, Kayo{/b}

Alpha/Numeric The UIC value identifies Army units in the field. Each Army unit has its own unique UIC e.g., W1234, W4889, W9876 all UICs begin with a "W" and are 5 characters long.

1. I want the frequency of a field with broken values: Field = UIC(Unit Identification Code) Value = W1234 Lentth = 5 Rep = Alpha 2. I need to print all UICs that are not correct format or missing characters e.g., _1234, W12_4, W_ _34 etc. Thanks in advance.

1. I hear so much about arrays. What are they and when should you use them? V/r,

1. Folks, I've answered my own question. Check the following code out. SELECT A2SF_UHGTU301ENL_INV.* FROM A2SF_UHGTU301ENL_INV WHERE (((A2SF_UHGTU301ENL_INV.PARTITION_ID)=54) AND ((A2SF_UHGTU301ENL_INV.EP_SSN)=[Enter SSN1])) OR (((A2SF_UHGTU301ENL_INV.PARTITION_ID)=54) AND...

1. I've built a basic parameter query that finds one social security number at a time. When found, the resulting data set displays: SSN, FNAME, LNAME, GRADE. 2. I need to be able to input multiple SSNs and if SSN is found then display the above or if SSN is not found display "record...

Paul, I forgot. your last post was a two star. We here at the pentagon (Army) really appreciate your help. As you know our computer help resources are extremely limited during these times and when we get into a programming fix, it's good to know you good folks are out there willing and able...

Paul, it worked. However, I still have a problem. After the msg box displays "no record found" and I click on the "ok" button, a blank form still appears. This is the same blank form that I wanted the msg box to get rid of. Any suggestions. Gregg

Paul, It all got to me and I took some time off. Below is the program. I have tried all the fixes you've advise me. Don't know where to go from here. Don't want to sound like a damp cloth, but is this thing I'm trying to do with Access 2000 doable? Public Function enlFound(strSSN As...

Paul, yes, the 1st line of code is highlighted in yellow: Public Function enlfound(strSSN As String) As String And the 3rd line of code is highlighted in blue: rs.Open "Select EP_SSN from ENLSSN where EP_SSN = '" & strSSN & '";", Pls call me Gregg

Tranman, did what you advised and was prompted the following error msg after I ran the program: Compile error: Sub or Function not defined The following code was highlighted in the debugger: Public Function enlFound(strSSN As String) As String Tranman, is there anything else that I...