Search results

Dude!! You Rule. Thanks for the code, it works great.

Jim, I am interested in your method of "re-setting" the table links in a front end database through code. Much like you, I will be releasing a project for use outside of my own building. I do expect, however, to have to make revisions after the initial rollout. For this reason, I would like to...

Don't worry about the hyperlink text field if its a static address. Instead put this code behind the onclick event of the .bmp image. Me.TopPic.HyperlinkAddress = "C:\myDir\myPDF.pdf" Me.TopPic.Hyperlink.Follow Make sure to set the hyperlink address to your desired address. Or, if you...

ps.. There are dozens of other fully qualified members of this forum that could help you also. I could "Name Drop" until I was blue in the face, but you get the picture.

Read through the posts on this site daily. There is always something to be learned. If you are into theory and description search by posts from The_Doc_Man If you are into application/code search for posts by JackCrowley If you want the whole package (any guesses from the "regular" crowd...

That's funny Tim.. As I was shocking my brain early this morning in the shower, I thought of that exact same thing (speaking of loading all forms and hiding them). It's good to hear someone else suggesting it. That makes me feel a little better about the idea. Why does it take a long time to...

Thanks Tim, I'll take a look.. I've split my db and it is working. However, it is now going VERY, VERY SLOW. It takes forever to load forms especially. Once the forms are loaded its not bad. Any Remedies??

I think we are both right... Everything is still available, except dbOpenTable type Recordsets. I was using the .AddNew method to add records all over the place in my code. This has forced me to use Append Queries instead. Append queries are much more efficient anyways. I'm almost done, so I...

I'll be working on splitting this thing all day today. Unfortunately, I'm already getting a bunch of funny errors that look like they will keep me busy for a while. Are there any Methods or procedures that are not allowed over a split db. From what I can see so far, dbOpenTable type Recordsets...

All the references are full intact on each machine. I have not split the db yet because I have not been able to test and debug to my satisfaction. Would splitting the db help to solve this problem? If so, how? I can implement compact on close, but I'm fairly sure this won't do anything for my...

Half of my development was spent using a Win2k machine and the other half was spent using WinXP. However, both had the exact same version of MS Access. My db works perfectly with 1 and even 2 users, but when a third user starts parusing around I get a 3343 error: "Unrecognized Database Format"...

Cascade Combo example

I'm still having problems with this... I don't think my rollback is working properly. I have successfully trapped the error. I am also able to re-create the error. If I simply run the following Procedure from 2 machines at the same time, the Database .mdb is corrupted and no longer works. Here...

I'm still having problems with this... I don't think my rollback is working properly. I have successfully trapped the error. I am also able to re-create the error. If I simply run the following Procedure from 2 machines at the same time, the Database .mdb is corrupted and no longer works. Here...

See above.. The blue line is the same thing isn't it? I am beginning to see the light with this. I can tell that the benefit will be immense. I stepped through my code and have found a problem. In my second Function Call (addIncrement) I am using Dlookup to get the Primary Key Value (autonum)...

DOH!! I think I opened an entire can of worms here. Unfortunately, I'll have to address a number of things if I'm going to implement this method. My actual psuedocode goes like this... On_Event On Error GoTo UpdateError Dim wrkDefault As Workspace, bolUpdatePending As Boolean...

DOH!! I think I opened an entire can of worms here. Unfortunately, I'll have to address a number of things if I'm going to implement this method. My actual psuedocode goes like this... On_Event On Error GoTo UpdateError Dim wrkDefault As Workspace, bolUpdatePending As Boolean...

I found a good post here... Will using this method keep the .mdb from being corrupted? In other words, hasn't the damage already been done regardless if the transmission commits or not?

I'm intrigued by your answer, unfortunately, my Access Help Reference has failed for about half of the function calls and DAO objects. So I can't search for help. I tried repairing it about 10 times, but to no avail. Do you have any application specific suggestions on how I would get started in...

Wayne, Could you please expand a little more as to the symptoms of these missing References Problems.. What type of errors do they produce (numbers)? Is it imperative that all users have the same Access Version as was used to develop the database? Is it imperative that all users have the same...