Search results

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

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

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

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

Does anyone know why the following code would crash Microsoft Access? In order to rule out issues with the databases themselves (the calling database adn the database being opened via code), I created two new databases both containing a single module and a single function. The code below is...

Reports have never been my strong suit, so I would really appreciate any advise on how to approach this issue. I need to print one report that actually consists of several reports that belong to separate companies meeting a specific criteria. The general format is that it shows company info...

I have what I hope is an interesting problem. I have an unbound form that houses two subforms, which are linked to each other. The first (we'll call SubA) is a continuous form, showing the set of data that my users need quick access to. The second (SubB) is a single form, which shows details...

I have created a form generator for my MS Access application that quickly allows users to create and use form e-mails, letters, and faxes. However, I need to add a hyperlink into the body of my e-mail messages and have not been able to figure out how to do this through VBA. Any help or...

I have dabbled in object oriented programming in the past but not much. My database is getting quite complicated, so I thought I would begin to implement it to keep things from getting too cumbersome when future changes are necessary. I have created a Vendor object, which when initialized...

I am just trying to change the wallpaper through code. The intent is to create a database that will randomly display different wallpapers. I know there are plenty of utilities freely available online that do this, but it is always more fun when you do something yourself. I believe I found...

Someone might have asked this question before, but I couldn't get the right combination of words to make it come up when searching the forum. Is there anyway to make my Access application run in one window on the taskbar like Access 97? My user's have the perception of multiple apps running...

I recently decided to split my database into a front end/back end environment. What I noticed though was a huge slow down in performance. One subform in particular takes 5-8 seconds to load, as opposed to less than a second before the split. I know that splitting the database comes highly...

I came across something I don't understand. I think I could work around it, but I don't understand what is going on. I create a function to round a given number to the nearest fifth: Function RoundToFifth(dblNumber As Double) As Single Dim intNumber As Integer Dim dblRemainder As...

I have multiple forms open that are working in conjunction. A button click on Form1 will either create a new record or update a field in a particular record on Form2 (Form2 is a continuous form). I then reflect these changes by requerying Form2. My problem is that if a user is editing Form2...

I originally began this question under a different thread, but I ended up answering my question and then coming up with a new one that is not necessarily related. I thought it would be best to just start a new thread. I have written code that overtakes the up and down records to move between...

I believe I have ran across a method of doing what I am looking to do before, but I cannot seem to find it anywhere. I want to query for similar words. I thought I had seen an expression that would allow you to retrieve entries that were 80% similar, etc. I may have dreamed it. If anyone...

I set the can grow property for my text box to yes on a continuous form, but nothing is happening (it's not growing when the text is longer than the textbox). I read the help file and the only culprit I saw that should keep this from happening is if the controls are overlapping, but there are...

I know that my biggest problem is that I need to become more familiar with collections, but I wanted to post this here in case I don't get very far in educating myself. Is there an easy way to sort a collection? I was going to try the Shell Sort method, but I am running into a few...