Search results for query: *

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

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

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

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

I've been building Access 97 programs for my office for years using a split front-end/back-end setup soley using Access. I'm intrigued by ADO and all the discussions regarding it, but am wondering if learning it would be worth my while for programming in Access? I can link to my back end using...

I've been building Access97 programs for my office for about 8 years using a split front-end/back-end setup soley using Access. I'm intrigued by ADO and all the discussions regarding it, but am wondering if learning it would be worth my while? I can link to my back end using the add-in in...