Recent content by VS24

Fixed it...! Thanx VS24! No problem VS24, you're welcome! Yup... talking to myself... :o)

Fixed it... All I had to do was change : Dim rs As Recordset to Dim rs As DAO.Recordset and it sorted it out! That's one form sorted! If I try the same code on another form and change SiteID to [Implementer ID] it gives me this error : Compile Error: Method or Data Member not found...

This is the line with the error tho... Set rs = q.OpenRecordset() I am totally confused with this! What am I not doing...? Thanx again!

Sorry... I mean't that I'm trying to increment SiteID Thanx!

I'm trying to increment RegionID by 1 per region individually whenever a new site is added in that region(There are 32 regions) I'm still new to this... what other connections do I need if any... do I have to link anything etc. I'm also getting this error when I have this code : Private Sub...

Guys... I need to know the procedure/steps/code needed to compare tables in two databases and update/append accordingly in Access 2003. I don't know where to start! (Newbie with Access!) Thanx in advance!

Any other tips/suggestions?

Hi... not sure if this has been asked before! I have an MDB database which has been updated with new records. What's the best & easiest way to compare each record in each table in both databases and check for changes or updates?? I've got two date fields called "FirstEntered" & "LastModified"...

PLUS... ALSO... I have information in a table already and if I want to concatenate two fields and pop them into another field... what would the SQL query for that look like?? Thanx!

I'm kewl! Table called People. Added a new column called AgeCategory. When the user selects from a combo box with options "< 12yrs" or "Between 12 and 18 years" or "18 and older" it should pop in either Class 1, 2 or 3 respectively! Need to know the SQL code! Thanx!

Help on a query. Using a newly created column - would like to pop in data depending on the selection made by the user. eg. New field = AgeCategory (Class 1 are < 13yrs, Class 2 are between 13 and 18 yrs and Class 3 are > 18yrs!) In the combo box when they select < 13yrs, it should pop in...

You guys are gonna kill me! What an idiot I be! Remember I told you guys that the form that works is linked to a table and this form filters on certain types? Well in order to filter on certain types the Record Source isn't a link to a table but rather a query instead! After I created the...

Nope, the other form is almost identical to this and all my combo boxes are named cmb... and textfields are named txt... etc. so there isn't anything that is named the same in the table(s) and form(s). I thought it might be the space in the field "Implementer ID" so I changed it in the table...

No controls on the form with the same name! The control saves a value, but I'm also doing two extra storages after the update on the same control. It works fine on one form but not on this one!

Tried the Me! code and it said that it could not find field "RegImpID" instead of the "|" And "RegImpID" exists & is spelled identical in the table & the code! (Copied & pasted to make certain!) As for the separate tests... both of those tests gave me the same error about not finding the "|"...