Recent content by votegop

Here is what I use: Dim stAppName As String Dim stPathA As String Dim stPathB As String Dim stCombinedPath As String stPathA = SysCmd(acSysCmdAccessDir) stAppName = "WINWORD.EXE " stPathB = "PathToYourWordFile.doc" stCombinedPath = stPathA & stAppName & stPathB Call Shell(stCombinedPath, 1)...

This will get you going... This code checks the link on a linked table to see if it is valid. If it is not, it attempts to refresh all links using the path to the back-end you specify in code. It allows for an alternative search directory also. If it doesn't find it there, it prompts the user...

I don't know if this is a network security/permissions problem or an Access problem, but heregoes: A client had 4 machines, 3 running Win2K & A2K and 1 running WinXP & A2002. The split db worked just fine under that scenario, no version conflicts. Client upgraded the 3 machines to WinXP and...

This code rocks! Note for newbies: works for any type file, not just .pdf's. Thanks pdldavis. Have a star. BTW - this should be an FAQ.

Nothing seemed to help. But I did find a solution, which I thought I'd post just in case it helps someone. I simply made the text boxes on the main form unbound. I populate them with the data from the subform on open via code. No flicker. I also run a requery of the main form After Update...

One tab on my tab control has three subforms on it. They work fine - no flicker. If I add calculated textboxes that perform calculations on the totals of the subforms (the textboxes are below the subforms on the tab control), I get one flicker per text box. ie: if I have four calculated...

I might be off-base, but I think you don't want a sub-form at all. You want a seperate popup form whose recordsource is tied to the current record of the main form. A sub-form is meant to display data related to the record on the main form. I think you are looking to add a "reason for...

Daniel: Your first post above is painfully simple, yet ended my hair-pulling. Thanks. Jay

Pete: Not wrong this time. Spot on! After I added Option Explicit, I had to declare x as string and I as integer. Errors went away & all is joy. Thank you kindly for the help! Jay [roll1]

Small oops. I noticed my reference to "varFilePath" at the top of my post should read "varIconPathandFileName". No difference. Pete: Thanks. I don't have a problem getting the relative file path into a public variable...I use: ----- Public Static Function...

The below code works great, but it relies on a string (in red)holding the absolute path to the icon file. I want to pass a public variable (I've already defined it, and it works elsewhere) that returns the relative application path. This is where the icon file will be. If I have my global...

Glen: It does help, if only to assure me that I'm not the only one out there who has seen this. I'll see if I can get them to show pursuant to your tip. Thanks. Jay

Do relationships defined before splitting a database show up in a back-end relationship window? Mine don't. Hitting "show all" doesn't help. Only relationships that I defined in the back-end post-split show up. Thing is, everything acts normal! Jay

Adi: I recently researched the same problem. My review of related posts lead me to believe the only option is to have an 'undo' button on the subform as well as the main form. This stinks, I know, but I haven't found a better solution. Jay

Every time I see a URL attached to a signature, I know it's usually a professional who knows what he/she is talking about. I invariably click on these links because these people post very useful code and tips on their own websites as well. I usually wind up bookmarking the links so I can check...