Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ag90fox

    Can't quite make the connection between Access & ADO...help!!

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

    If Then statement not working....how simple can it be?

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

    ac

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

    ac

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

    ac

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

    Pasted record automatically exits sub. How continue code?

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

    UGH! Frustrating field update "crash" after record copy

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

    "Format" function in Access XP vs. Access 2000

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

    "Format" function in query in Access2000 not working in Access2002

    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'.
  10. ag90fox

    &quot;Format&quot; function in query in Access2000 not working in Access2002

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

    Easy query question......

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

    Easy query question......

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

    Access ADO Example Databases

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

    Clueless: Why use ADO in 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...
  15. ag90fox

    Clueless: Why use ADO in MS Access?

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

    Clueless: Why use ADO in 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...
  17. ag90fox

    Clueless: Why use ADO in MS Access?

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

Part and Inventory Search

Back
Top