Search results for query: *

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

I must echo Pete's observation. I haven't seen any solicitation in here at all. This forum is very well monitored and I find most of the "consultants" to be pretty darn selfless.

ddelport: Your answer is in your question...you're just in denial! The commandline switch IS the way to go. It's the ONLY way to go. The only other alternative I know of is to have all your users "join" the same workgroup, which means any and all Access databases they open will be...

Bill Power has developed code to automate checking and setting of references. See his website at http://www.wpower.fsbusiness.co.uk/ Be careful of setting this to execute everytime the database opens, as you may cause opening to be very slow in a networked environment. Jay

Good feedback guys. Thank you. A couple of points... 1) I dont' know if I'd ever get to where I can demand Jeremy's car, but my code is to ensure that I don't ever find out. Just in testing, my autonumber field values (which is not the number of records, because the records get deleted prior...

Leover- You'll need to make sure all users have the correct references set, or else you'll have problems. I ditched my plans to use flash on a form because of this. Also, I found the flash object ran differently on different machines (slow on some, although the machines were comparable). For...