Search results

It's like deja vue all over again. I'm trying to link SQL Server 2005 Developer Edition tables with a MS Access 2003 database (Operating System is Vista Business). I have tried using the File | Get External Data | Link and the Linked Table Manager and neither seems to recognize any ODBC...

Bob, This is a real tricky bit of code. I really want to commit the field but not the record at the time of this code. Moving to the next field is supposed to commit the field but in this particular situation it doesn't. Aside from this issue, have you seen a list of commands that replace...

I got a new computer with Vista. Now the commands using Sendkeys no longer work. I have replaced most already but I'm hung up on SendKeys "{Enter}" I used this after overriding a not in list event and forcing Upper Case to save a value entered that was not in the list. You don't need to...

I use the following code in a function to test if a database is open AppActivate pasDBName, True In ACC2003 and WindowsXP ths worked great, but alas in ACC2003 amd Vista it opens a new Acccess Application that is not shut down when the function is closed. This creates all kinds of issues...

Bob, Thanks for your response. Do your suggestions apply to using an Access Application or to the Shell Function? Or were you referring to the Security Warning and Logon Popup issues? Thanks.

I already tried using an Access Application, but it locks up the current Access Database when the Logon Dialog Box pops up. It is modal and prevents closing the current db or doing anything with it. Had to use Task Manager to shut it down.

OpenDB Function KEYWORDS: Open Database, Open FIle After further reseach I came up with the following function that uses the Shell Command and does work. '------ JW070610(B1) Public Function OpenDB(pasDBPathName As String, pasCloseCurrent As String) As String On Error GoTo Err_Proc '--...

Thanks for your suggestions. Have tried them. THey all seem to work but get hung up on the new MS Access security stuff. THe SendKeys actually does work but I get the message "Permission Denied." The followHyperlink gets locked up. SO I guess the new question is - Is there any way to...

Change is tough. I have some old databases that use the following code: SendKeys "%FO" & strDBPathName & "~", False This is real old code so only old timers will recognize it. But I want to open a new Access database from the current Access database and close the current database. What is...

I hate Vista. Well I have some code the uses the following line of code SendKeys "{HOME}", True I use it to move the curror to the start of the currently active control. This line of code has worked from Acess 2.0 - Access 2003. However, I made the mistake to installing Vista, and...

I recently noticed you can declare a variable as a Parameter. When would you use this? Thanks for your help.

I'm trying to create a Connection String between an MS Access 2003 Database and SQL Server 2005. I want to use OLEDB as the provider. And use SQL Server Authentication. I have added the UserID and Password to the Connection String. When do I need to use "Integrated Security = SSPI" and...

Bob, Thanks for the fast reply. However the issue isn't with the "{F2}" key, it is with the SendKeys. I think it was in Access 2000 that the folks in Redmond introduced the Docmd.RunCommand that was supposed to replace the SendKeys command. At the time I read in some book that they would...

I have a proc that copies all the text from a field on a form. Works great when the Database Option "Behavior entering field" is set to ( ) Select entire field. One of my clients prefers ( ) Go to start of field. When the last option is selected my code BLOWS! The Applicable code is...

All of a sudden I started getting this error message on a form that has worked for years. The code looks something like: Me![Control].SetFocus DoCmd.RunCOmmand acCmdCopy I think something got hosed. I have reloaded MS Access but that didn't help. I can copy the text in the control...

I'm using Access 2002 as a front end to a SQL Server 2000 database. I Update a status field in a SQL Server table using a parameter based stored proc. Works great. Then in the same sub, I open a popup form to view the record I have just updated. If I open the Popup Form automatically in code...

Does SQL Server 2005 Express Edition support multiple users?

I'm creating an MS Access Database as a front-end for a SQL Server 2005 Express Edition Database. I created a View Form (Form with Subform listing each record on a line) showing all records based on a SQL Server View. Then I created a Popup Form to show all fields in a record. I use the Popup...

Send me the code you have so far and I'll take a look at it.

Thanks. I typed in the new Server and it works great.