Search results

Thank you! What you sent worked and I appreciate the help. Thanks Again!!

I have a query that returns all the records sequentially some what. It will list the records like 1, 10 1000, 1001 It will jump like 1200, 12, 1201, 1202 instead of 1,2,3,4,5,6,7,8,9,10 It will list 1, 10, 1000 Any ideas? Here is the query to list all records. I have gon intot he report...

I have another question for you. Are you pretty go with queires/reports? I have a query that returns all the records sequentially some what. It will list the records like 1, 10 1000, 1001 It will jump like 1200, 12, 1201, 1202 instead of 1,2,3,4,5,6,7,8,9,10 It will list 1, 10, 1000 Any...

Thank You Charity It works like it should. I really appreciate your help!!

What you sent works but when you scroll back or forward between records the dialog box with duplicate id pops up. it comes up all the time instead of just when a new record is to be added.

CS_NUM is a text field!

Here is what I put as you suggested. Private Sub txtCS_NUM_LostFocus() Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("Select * from dbo_INV_INFSVC where CS_NUM=" & txtCS_NUM) If rst.EOF = False Then MsgBox "Duplicate ID!" End If End Sub DB is...

I have a query that finds duplicate records and the number of each duplicate there is, listed below SELECT dbo_INV_INFSVC.CS_NUM, Count(*) AS Expr1 FROM dbo_INV_INFSVC GROUP BY dbo_INV_INFSVC.CS_NUM HAVING (((Count(*))>1)); What I need is to let the user know if there is a record in the table...

It should not have taken me this long. Do you know enough to look at what I have so far and fine tune it to make it work?

Yes the name are drwn from the queires you mentied sine in those queries they are joined to the People Table that contains the names. Di you see my last post that said I have almost got this to work?

I tell you waht! I have almost got this to work. Here is what I have: (Query 1) I have one query the uses tblPeople and tblApplicant to bring back the People_Code_ID, First_Name, Last_Name, Senate_ID, House_ID. (Query 2) I have another query that uses tblPeople and tblLegislator to bring back...

What you sent is what I want returned. The thing is that the first name and last name are in the People table not in the legislator or applicant table.

EMP: Your query worked like it should, the only problem is that the First_Name and Last_Name are located in a separate table( tblPeople). In the tblApplicant you have People_Code_ID, Senate_ID, House_ID. IN tblLegislator you have People_Code_ID, Legislator_ID, Legislator_Title. So in order to...

The tble People is large enough and I do not want to add more fields to it like you have shown. The query should be able to get done either through using tables or by combining queries.

I currently have a query between tblPeople and tblApplicant that works just fine. Also a query between tbl People and tbl Legislator and it works just fine. My problem is being able to llist the Legislators and all the applicants under them based on the House_ID or Senate_ID in the tble...

Three tables: tblPeople, tblApplicants and tblLegislator. tblPeople PeopleCodeId LastName FirstName 1000 Smith Harry 2000 Sooner Amber 3000 Fillpot...

Got it solved I got it solved and works like a charm. I have the delete query pointing to the wrong query.

Yes you are confused I am only deleting the record that is currently on the form. My problem now is that when I hit the button it appends the record and jumps directly inot the table that it is appended to. I need to fix this mess.

Just deleting 1 record This query only deletes 1 record.

Criteria info and sql SQL: DELETE NMPHY.ACQ_DATE, NMPHY.ACQ_YYYY, NMPHY.BUILDING_NUM, NMPHY.BUILDING, NMPHY.COST, NMPHY.NMMI_NUM, NMPHY.DEPARTMENT, NMPHY.DEPARTMENT_NUM, NMPHY.FDN_PURCHASE, NMPHY.ITEM_DESC, NMPHY.NON_TECH_DES, NMPHY.PO_NUM, NMPHY.SERIAL_NUM, NMPHY.DELETEREASON FROM NMPHY WHERE...