Recent content by ag90fox

o.k. everyone can quit laughing now!! Really, I've been programming in MS Access for 10 years at one amatuer level or another (primarily for various project management positions I've had). I constantly see people talking about connectionsets, recordsets, etc....in relation to Access BUT...

O.k, I'm sorry to ask such a blatant question as this, but the following code will not execute in my access database (2003), and it seems so pitifully simple, yet will not work. Could someone kindly straighten me out. Thanks! Private Sub DateCompleted_AfterUpdate() If Me Is Null Then...

Thanks for the idea Vic. Unfortunately, there appears to be no error as adding that code did not change the execution of the code. It pasted the information into the new record and then stopped executing the code.

I did try that, same result, except the record navigation at the bottom of the form shows the new record, but the data on the screen is that exact same as the old record until I manually navigate one record back, then one forward to the same point at which time the data looks like it should.

I've got a button on a form copies the current record into a new record, using "runcommand" in the the following sequence: 1. select record 2. copy record 3. goto new record 4. paste record That works fine. Next, within the the same sub I want to change a few of the fields on that form, but...

I've got a button on a form copies a record, using "domenuitem" commands in the the following sequence: 1. select record 2. copy record 3. goto new record 4. paste record That works fine. Next, within the the same sub I want to change a few of the fields on that form, but I've found that the...

I'll try to make this brief for those kind souls that will help me! I'm not an elegant programmer, so please forgive the horrible syntax/grammar/etc..... 2. Scenario: I have an order form for a service. If the service isn't completed satisfactorily, the customer can resubmit the order by...

I ported a database from Access 2000 to Access XP. In trying to run a report based upon a query that has the statement ' DateNow: Format(Now(),"mmmm dd" & ", " & "yyyy") ' as one of the fields it is telling me that "format" is an undefined function. This works in Access 2000, but is there a...

SORRY!!!:o) I though html might work and help highlight the specific text there. The "<b>&</b>" stuff was supposed to be 'bold-on' and 'bold-off'.

I am doing a small database for my wife's boss in his two person company. I developed the database using Access 2000 and upon moving the mdb file to his computer which has Access 2002, the "format" function in several of my report queries (ex. <b>EndMonth: Format([EndDate],"mmmm yyyy"</b>) no...

SWAMPBOOGIE....Why do you ask if I'm using access?

I have a &quot;project status&quot; table with multiple records for each project distinguished by date. RecID, ProjID, Date, Status I want to take the most recent record for each project and show it on a form. I've tried to group on ProjID where I take the &quot;max&quot; date, but when...

I'd like to learn ADO for use in Access 2000, and was hoping someone could point out where I could find some example databases using ADO. I see to learn best by picking through examples. Also, I have a Visual Basic 6.0 book (barely used), is the ADO code the same for Vis Basic as for Access...

Laois, I guess I'm still wondering where in your Access program is ADO more useful than using the standard options in Access like linked tables, or the query builder, and the assumed database connection that Access has with linked tables (i.e. not needing a &quot;dim db as...&quot; or whatever...

I've seen that '2000 uses ADO, not DAO, but I've never even really used DAO that I know of. I do my queries in the Access windows, some VBA for form controls, etc... but no recordsets, connections, addnew.....any of that. Am still wondering if using ADO (in '2000) is more efficient that using...