There are some pretty good ideas for securing an Access db to be found here: http://www.granite.ab.ca/access/demo.htm
I realize this isn't exactly what you're trying to do (distribute a demo), but most of these strategies seem like they more or less apply.
In fact you may want to make the...
Well, you can use the docmd methods DoMenuItem, RunCommand, Save, and DeleteObject to save and delete forms or whatever else. However, I don't think any of those (or CreateForm) are going to work in the .mde file either. If the final db will be a .mde, you'll pretty much have to decide what...
You can use the CreateControl method without the CreateForm method, i.e. on an existing form, but the form you're creating controls on **does** need to be in design view, if only momentarily. That is to say, when the running (form view) form needs to add a control, you switch it to design view...
I've had this happen. Very annoying. One thing you can try to "restore" a corrupted form is to use the SaveAsText and LoadFromText functions...
1. Open the database in question. Do not attempt to open the "bad" form.
2. Open the code window. In the Immediate window, type...
If I'm understanding your situation correctly...
Assuming you know where you want the BeforeUpdate event code to execute (e.g. in the OnCurrent event code), you can simply call the BeforeUpdate event sub by name, like any other function or subroutine. Like this:
Private Sub...
First off...hi! New to the board. Looks like a good one.
Secondly, thanks (belatedly) dawnd3 for the answers. This has been driving me crazy -- especially because of the sporadic nature of this problem!
Anyway...I have a question about the ms patch and/or the workaround (i.e. turning off...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.