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!

  • Congratulations SkipVought 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: *

  • Users: fredl
  • Order by date
  1. fredl

    Access 2002 -- Will it convert db to ADO ok?

    Ok here is what I know. ADO is part of Access 2000 and up, if you have calls to DAO you can open the database and go to design view of a module choose tools and references, scroll down to Microsoft DAO 3.51 Object Library. Check it....click ok...reopen the references, now move it all the way up...
  2. fredl

    Access Printing

    A dot matrix has two modes of printing graphic and normal. If the report is made using a windows font or has a graphic the printer tries to paint it. Not only slow but noisy and uses a lot of ink. Make sure that the native fonts for that printer are installed and the report that you are...
  3. fredl

    A button to open a report on a specific record.

    try this one Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "[RefID]=" & Me![RefID] stDocName = "rptprintsingle" DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria Make a command button on your form. Put this code in the onclick event...
  4. fredl

    Autonumber reset

    Access keeps tabs on the records you delete that way there can never be a duplicate number. Did you try and delete the autonumber field? then save the database and make a new field that is a autonumber? that might do the trick.
  5. fredl

    Filemake Pro...

    Try it and see if it works. Can't hurt cause you have a back up right. Can you do a dump in filemaker? Access can pull in just about anything fl
  6. fredl

    sendobject problem

    I had problems with the whole sendobject thing, I too received the "The action SendObject isn't available now." I checked all my references. Turns out the access installation was out of wack.(office 2000) I ran detect and repair....and presto!. You might want to keep an eye on the...
  7. fredl

    Select Case statement within a DLookup on a form

    Dlookup() expects you to give it three things inside the brackets. Look up the_____field, from the_____table, where the record is______ Each of these must be in quotes, seperated by commas. =Dlookup("CompanyName","Company","CompanyID = 200") or...
  8. fredl

    Help creating complex string - how??

    I thought the way to put two strings together was [field1]&""&[field2] or ="String"&""&[field2] if you want a space between the field and string seperate the quotation marks with a space hope that helps
  9. fredl

    sendobject problem

    Can you tell me how Access is configured, I'm working with sendobject also receiving an error message. thanks
  10. fredl

    Linking Oracle tables to Microsoft Access 2000 --Better way?

    The problem is looking at all those records, if you want to filter the records, let oracle do the work not access. There are two ways that I know of create a SQL statement (query) and connect to that, or create a view and connect to that, I do not know which one is faster. But I know from...
  11. fredl

    ODBC connection for Views

    Joey, We have a Oracle here at our shop. The answer is yes, you can obdc to a view. We do it here to create reports using access. This is the best way I know to connect to a oracle table that has lots of indexes, or to large for Access. Create a view and connect to that. fred
  12. fredl

    Sending a Single Record from Access to Word.

    I have not been able to find much on the subject myself. Type automation in the help section (access) Microsoft Knowledge base has an article that you might find handy http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209882 this should give you enough information to get you going...

Part and Inventory Search

Back
Top