Search results for query: *

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?

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.

What about if you're trying to execute an action query in another db. For example. Private Sub cmdRUN_click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = OpenDatabase("\\UNC_PATH\2ndAccess.mdb", False, False, "MS Access;PWD=mypassword") now I want to call an action query. In...

It was my UNC path. I had a little tiny typo. I retyped it and it worked. Thanks for the help anyway... I appreciate it as always.

YUP. I thought you could read minds.... It turns out my UNC path is mucked up. Not sure what yet, but deffinitley the UNC path. I tried it with the Northwind db and it worked.

nope. Its deffinitley DAO. I found information in the help topics about the CONNECT method, but can't make it work.

Um..... I need to pass it a password.... syntax is: opendatabase("\\MYUNCPATH",,,[CONNECT]) I'm finding that I should put "Database Type;pwd=mypassword" for [CONNECT] and that connecting to JET type db's is a default and thereby optional leaving me with just the pwd=mypassword. It keeps...

Thanks Remou, I couldn't even find that in the library...I'll give a try. If it works, I'll remember you at Christmas...

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?

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

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.

WOW......!!!!!! I mean WOW, thats wierd, but simple... wonder why its like that? Heres a star for ya CLICK!!!

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

I would just tell it to wait at least a couple minutes.. Could be network congestion? I would have the sleep cycle wait for a couple minutes and call it a day.. :)

Try this on for size... Copy this code: Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) and past it under the first line "Option Compare Database" in your General Declarations section of the module where you're going to run the code. Later you just call it by using...

Can you be a little more descriptive? Your question sounds intreguing...