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

    Persits Referance Library Missing in Access 2003.

    I just upgraded from 2k to 2003 and right away I have a missing reference library for Persits. I tried to look for it in my Referance library but cannot find anything resembling persits. Any ideas?
  2. IamCornholio

    Describe table? works in Oracle, how in Access?

    I would like to write a query, or somehow get the field names and field attributes of a given table in a form that I can export/cut-paste into Excel. Any ideas on how I can do this? I've looked in the System table and I'm not finding attributes.
  3. IamCornholio

    Syntax for Connecting to different Access db.

    I can not seem to find the correct syntax to connect to another db in vba. I want to run a query in another db and instead of: set db = currentdb() HOWEVER!!!! I can't seem to find the syntax for connecting to a different db on my server. any ideas?
  4. IamCornholio

    ODBC Call is failing. No real reason why...

    I'm trying to run a query that pushes to an oracle table. Since Access tends to hold onto its initial connection string, the string for the table I'm pushing to doesn't get refreshed and the permissions reset (changes UID and PWD to give me Update/Insert priveledges). My code is: Dim db As...
  5. IamCornholio

    Modify Shortcut menu?

    I would like to modify the optionis that show up in the short cut menu available while a user is viewing the records in a form's datasheet view. Is this possible? Thanks Corn.
  6. IamCornholio

    Run Time error 3061

    I'm getting the evil error 3061. I typically find that I get this when I run SQL in code. My code is as follows... strSQL = "Select a.Supervisor " strSQL = strSQL & "From tbl_PersonnelInformation a " strSQL = strSQL & "Where Last_Name = " & Me.cboLastName & " " strSQL = strSQL &...

Part and Inventory Search

Back
Top