No, please, I have no pride in this regard and I can only hope to make life a little easier for you guys that do know so I can learn and help others! I can't say enough how much I appreciate what you and the rest of the community here do for us "green" members!
So, I had already gotten a pretty lean block of code, and last post helped put the finishing touches. Now my entire sub consists (basically) of:
[code=vb]...
P3Eddie
Last Activity: Mar 27 '08, 11:26 PM
Joined: Aug 2 '07
Location:
-
1. I wasn't sure how to "refresh" the recordset to find the new set of duplicates. So say one entry had 2 duplicates, and two entries had one duplicate each, running the procedure exactly as you had it would result in the entry with two duplicates having only one duplicate. If I looped the procedure, it would be looking at the same recordset query, for which it had already updated the relevant fields. This accomplishes the equivalent of...Leave a comment:
-
Just thought you'd like to see what I came up with to resolve this thread. Any suggestions are appreciated (if you have any)!
[Code=vb]
Private Sub Function4_Click ()
On Error GoTo Err_Function4_C lick
Dim MyDB As DAO.Database, MyRS As DAO.Recordset, MySQL As String, DTotal As Long
Set MyDB = currentdb()
Set MyRS = MyDB.OpenRecord set("qryUniqueD upIDs", dbOpenDynaset)
...Leave a comment:
-
Wow, the thought of doing this in VB never crossed my mind, as a priority of mine of late has been to keep my form code as lean as possible. This worked wonderfully! Now I'll just find a way to automate the function to loop as many times as necessary (in the event of one entry having multiple duplicates, as this works for an entry having one duplicate. ) I expect an if statement in VB ought to do the trick, pointing at an EXISTS select query....Leave a comment:
-
UPDATE qry Specifying Multiple Fields in Nested SELECT subqry
Hello all!
I don't know if this can even be done, but I'm sure you will either help or suggest another avenue to accomplish the same.
My problem may be a simple find duplicates / do something with only one of the duplicates issue, but I got to the point where an update query with a nested select subquery would work wonderfully, if only it would work!
I have several fields in a master Access 2000 table,... -
Specifying Constraints For New Table In SELECT...INTO...
Hello All!
Sorry if this is basic, but I'm having trouble finding a way to specify unique fields (like you would ADD CONSTRAINT in an ALTER TABLE statement) for a new table I'm creating with a SELECT / INTO query.
The table is a list containing, among other fields, names of children (fname and lname), their birthdays and ship addresses. I'd like to pull all the fields from the master table into a new table, retaining... -
Marie:
I'm fairly new at all of this, but I had similar needs on a database of my own. I concocted an elaborate workaround using the DatePart() function, which I know lets you pull out a part of a date (like, d or m or yyyy) to use with/against date values. I don't know enough to find a way to work it into your code, but maybe it's a step in the right direction?
Sorry if I'm way off base here....Leave a comment:
-
Need Help Combining Separate Date Values (M,D,YY) Into A Single Date Field
Hello all!
I am new to Access, SQL and database management, and need help with an SQL statement in Access.
I have 3 fields,
BirthDay
BirthMonth
BirthYear
that I need converted to a single field
Birth_Date
and set as data type DATETIME.
Try as I might, I can't find a way to specify the data type for the new field in this statement...
No activity results to display
Leave a comment: