Search results for query: *

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

Tranman, your post was reassuring. I cut and pasted as you advised; changed the criteria as instructed. Got the following error msg when I ran the program: Run Time Error '13': Type Mismatch When I ran the debugger the following code was highlighted: Set rs =...

Tranman, thanks for the input. Looks like I'm biting off more than I can chew. I'm not that good of a programmer to pull off what you just advised. Wouldn't know where to start. However, I really appreciate your time w/this thing. I'll take your code and play w/it, may just get lucky. Again...

I have the following parameter query. SELECT ENLSSN.EP_SSN, ENLSSN.COMPONENT_CD, ENLSSN.PAY_GRADE_ID, ENLSSN.RECSTA_CD, ENLSSN.SEX_CATEGORY_CD, ENLSSN.STRENGTH_CAT_CD, ENLSSN.UIC, ENLSSN.PMOS_CD FROM ENLSSN WHERE (((ENLSSN.EP_SSN)=[ENTER ENLISTED SSN])); Problem is, I need the query to prompt...

Hi folks, just picked-up "Access 2000 Programming by Example" for study. Have to learn the language - fast. Ya'll should be hearing from me soon for heeeeelp. I work for the Army(G1) here at the Pentagon and they keep me super busy w/this automation stuff. So here I am and can't...

1. Gol4 thanks for your input. It led me to the following: TRANSFORM Count([DB2_301].[EP_SSN]) AS CountOfEP_SSN SELECT Left([DB2_301].[PMOS_CD],2) AS PMOS FROM DB2_301 WHERE ((([DB2_301].[PARTITION_ID])=42) And (([DB2_301].[RECSTA_CD])="G") And (([DB2_301].[PAY_GRADE_ID]) In...