Search results

In case anyone finds themselves in a similar situation, I did find it. Go to File/Get External Data/Link Tables and there is a Files of type dropdown towards the bottom left. I didn't see what I needed at first, because you have to scroll. One of the options is ODBC Databases and then it...

I've been spoiled by newer versions of Access, but I'm going back into my past to try to support a client who is still utilizing Access 97. We are going to get them on the newest version, but they have some proprietary software developed in VB that interacts with various Access Databases and an...

I am trying to automate a link to a MySQL table. I can create the link with no problem using the Wizard/DSN.. However, my VBA code to mimic this behavior is failing. The code is as follows: Dim td As TableDef Set td = CurrentDb.CreateTableDef("lnkTest") td.Connect = "ODBC;Driver={MySQL...

Thank you for this thread. I've been having problems with my MySQL based access database for a long time. Isolating the fact that the problem is introduced if you set a data field equal to its original value is huge! Simple conditional statements before I change the value are preventing a lot...

Okay. I feel like an idiot. It is a method not a property, so objWebCtrl.Navigate = txtUpload obviously should become objWebCtrl.Navigate txtUpload. All is working.

Unfortuantely, I'm still getting the same error with Navigate2. Here is the full code and the two form objects I am interacting with is a text box that stores the path (txtUpload) and the activex object itself (objWebCtrl): Private Sub cmdBrowse_Click() Dim cmdlgOpenFile As New...

I am trying to use the Web Browser ActiveX Control to preview PDF files within my application. I did this a long time ago without problems (Access 97) and the examples I have found online are all straightforward: objWebCtrl.Navigate=strPath Unfortunately, Access 2010 does not appear to...

I found it! http://forums.mysql.com/read.php?65,237988,238115#msg-238115 Here is my revised code for creating the link: strConnect = "DRIVER={MySQL ODBC 3.51 Driver};" & _ "Server=MYSERVERPATH;" & _ "Port=3306;" & _ "Option=16384;" & _ "Stmt=;" & _...

The code on the site you provided works; however, it doesn't necessarily solve my problem. I am trying to synchronize data between a Microsoft Access Database and a MySQL database. So I want to create a link to the MySQL table, run Update and Append queries as needed (I use a join between the...

I've done a bit of research into this and I do not like at all some of the posts I am finding regarding unregistered dlls. However, it seems the error can also be produced by an error in the connection string. Can someone look at this and let me know if I am doing something wrong...

Just wanted to say thank you. This post solved my problem on two separate occasions. I was scratching my head about the error on both occasions not thinking that I had transferred the database from one version of Access to another and that the references might be thrown off. This post is a...

Okay. I fixed the problem with the third table using the following: db.Execute "CREATE TABLE tblSessions (SessionID INTEGER CONSTRAINT MyFieldConstraint PRIMARY KEY, YearID long, CampusID long, StartDate date, EndDate date, CreatedBy long, DateCreated date, ModifiedBy long, DateModified...

Thank you. The extra line of code worked perfectly (I am using native Microsoft Access tables) on my first attempt. However, I noticed some oddities. I actually have three tables I am looking to add, so I used the following: db.Execute "CREATE TABLE tblSessions (SessionID INTEGER...

I am looking to create a table via VBA (need to create the table in many different backend databases). I am using the following code, which almost does what I need it to do: db.Execute "CREATE TABLE tblSessions (SessionID Counter CONSTRAINT MyFieldConstraint PRIMARY KEY, YearID long...

Okay. I got this working, but the fix is so idiotic that I would still appreciate any additional insight into what is going on. Maybe it is an error with the way access handles global arrays, but any documentation shedding light on that issue would be welcome. Here was the fix. At the...

That's exactly what I'm doing (using global arrays). I am doing this as these functions are to be used by a query, meaning the functions will be ran many times. I thought it would be better to handle with global arrays and then my main function can simply see if the calculation already exists...

I have simplified the line of code that fails since my other attempts were failing anyway. So now the line of code is simply: curInst = curInst / curTempTotal Here are values on first run (no error): curInst=35 curTempTotal=75 Here are values on second run (when error occurs): curInst=35...

I am trying to use a few global arrays so that I do not duplicate a lot of work (if values have already been looked up, it just pulls it from the array instead of recalculating the values). Everything works except for a very odd error the second time it passes through the array. The line...

Sorry for the delay in response. I got pulled away from this project and am just now getting back to it. I have what I call field databases running for users on their laptops. They do not connect to the office where the central database is stored very often, when they do it is to syncronize...

Sorry, I should have mentioned that. It crashes when I call at this line: appAccess.OpenCurrentDatabase "C:\test.mdb" Your code presents the same problem at the same line. I did figure out an alternate method to do what I need to do after struggling with this for a few hours last night...