Search results

It works!! Thanks guys. The only side-effect seems to be that the front-end accesses the linked tables about 25% slower, for some reason. I'm not sure that the users will really notice this though.

Cheers guys. This is yet another one of those scenarios in VBA where, to me as reasonably-competent programmer (no expert by any means, but I can get by), VBA doesn't quite do what I expect and I end up thinking ""so how come Microsoft never thought of that?". 'TransferDatabase' so obviously...

Thanks for that. I've been having a play around but I still can't get it to work. I think the problem is that the last field of the TransferDatabase method is expecting either True or False rather than the password preceeded with the "PWD=" identifier. You'd think that there *should* be a...

Yeah I did see that, but it stops short of telling you where or how to pass-on the password, and that's where I'm stuck.

Hi Guys... Long time, no post...sorry, sadly I only tend to post on here when I get stuck :o I'm trying to link tables in two databases (ie a front end and a back-end holding the data) using VBA. I've already had success with this using in my front end: DoCmd.TransferDatabase acLink...

I guess that's a no then.

Hi there gurus... I have made a form with various text-boxes, radio-buttons and other controls on it. The form is not bound to a table or query: I'm just using the form as a data-gathering device for my VBA code. After the user has entered the data I want to use a button to reset the boxes...

Nope, all the references are fine. I think I've found the answer by trawling the 'net a bit. It seems that if you set a form's ControlSource property from it's OnOpen event using an SQL SELECT query, and if a control on your form is bound to a field which doesn't exist prior to you setting the...

I'm trying to compile my modules in an Access 97 database using Debug/Compile All Modules, but it's coming back with the error "Method or Data Member Not Found" wherever I've used the .OldValue property. The code works fine, so what's the issue with compiling it? The reason I'm trying to...

Thanks The_Doc_Man. I am already using your first method on another database, but I was hoping for a better solution because the problem I've had is that if people quit Access with the X button, my D-I-Y locking file doesn't get deleted: it only gets deleted through using my "Quit" option...

Hi folks I've got a DB on a LAN which doesn't need to be p/wd protected or anything, but I want to restrict access to it to only ONE USER at a time. The users are using Access 97 on Win 95B I've tried going into Tools/Options/Advanced and selecting "Exclusive" as the Default Open Mode, but...

Cheers, never though of that. Sorry for the delay in offering thanks: been away on business. Will try what you say. John

Hi folks, me again. I'm building a form for the client which will allow the results of a query to be exported to Excel using a button on the form. No problem exporting: sussed how to do that. What I want to know now is how can I tell using Access 97 VBA if the client has Excel installed on...

Thanks for that! The reason I didn't think of that is because when I hit the full-stop after entering .Controls("Maintenance") the Controls property was never listed in the popup menu, so I assumed you couldn't use it again. Something I've learned, then: the list of commands which pop up after...

Hi folks I’m a newbie here so treat me gently :) I’m trying to build an application in Access 97 with a customized toolbar. I have created the toolbar through View/Toolbars/Customize… and the options on the various menus I have created invoke macros which in turn open up forms and/or run VB...