This is very interesting, and I am really surprised that it works (I've checked). OpenRecordset is DAO library function, so I cannot understand how can this method work without an explicit DAO reference.
Maybe one of the other experts can explain this.
dima69
Last Activity: Nov 12 '09, 07:14 PM
Joined: Sep 27 '06
Location: Israel
-
This is not that I don't want to use DBEngine.SetOpt ion method (actually, I do use it), The issue is that I want to set an options other than DBEngine options, and I was wondering if this can be done by user profile.Leave a comment:
-
Yes, this is correct as applied to DBEngine options. But this is quite a different case with Application.Set Option method, as this method is actually changes registry settings for Access.Leave a comment:
-
Chip, how do you use late binding on DAO ? Clearly, changing declarations to objects is not enough, since you have to create an object as well, am I right ?
As for your question, Package and Deployment Wizard must take care of DAO installation.
Maybe this article can be relevant to this, too :Microsoft Access Flaws - Errors using multiple versions of Microsoft Access under Windows VistaLeave a comment:
-
Yes, that's what I'm looking for - to set options so that this will affect my application only.Leave a comment:
-
Thanks for your reply. The problems here are:
1. DEngine options can be set at runtime using DBengine.SetOpt ion method, you don't need a user profile for that.
2. Application.Set Option method really takes care of the settings in question, but it affects ALL Access applications on the client computer, and this is what I'm trying to avoid.Leave a comment:
-
MSAccess Profile options
I'm looking for complete list of options that could be set using Access user profile. All I could found till now are some rather "harmless" options like TitleBar, Icon, StartupScreen and AppHelpFile. Also workgroup file reference and DBEngine settings could be overwritten. IS THAT ALL ? What about all the other settings, like "Behavior Entering Field", "Arrow Key Behavior" ect. ? -
Thanks for the reply.
Could you please be more specific about the Shell you mentioned ?...Leave a comment:
-
Creating file duplicate on server
Hi everybody.
I wonder if it's possible to create a duplicate of the file on the network location, without having it travel over the network (i.e, making it much faster, like on local disk) ? -
Without getting too deep into your code, I can tell you that your attemtpt to use DCount in a wrong way. What you need is probably Count in Select ... Group By query....Leave a comment:
-
In order to prevent form closing you have to use Form_Unload event (it has Cancel argument). For instance:
[CODE=vb]Private Sub Form_BeforeUpda te(Cancel as integer)
If MsgBox("Do you want to save ...") = vbYes then
NoCloseFlag = FALSE
Else
NoCloseFlag = TRUE
End If
End Sub
Private Sub Form_Unload(Can cel as integer)
Cancel = NoCloseFlag
End Sub[/CODE...Leave a comment:
-
Program Files as a default installation folder
Hi everybody.
I develop a commercial MSAccess application. Until now, the default folder for my installation was "Program Files" - because this is the "convention al" way. However, I discovered that Vista makes the life hard while installing to Program Files. The application must be "run as administrator" to run at all, while in any other folder it works OK without the administrator permission. So I ask myself... -
Re
My concern is (as usual :-)) how robust this solution is. Personally, I don't like using OCX, as they often make trouble with installation because of the version compatibility.
Can this WshShell object be used via late binding ? (i.e., by CreateObject) ?Leave a comment:
-
What do you mean by "under each amount" ? Now I start to suspect that something's wrong with the report/subreport structure. What is the connection between your Main report and it’s Subreport ? What are the underlying tables ?...Leave a comment:
-
And another thing, the subreport should never be empty (i.e., contain no data), otherwise you get an error.Leave a comment:
-
Sorry, I think I gave an incorrect answer - got confused with another related problem.
So I think that you CAN use the reference to the subreport calculated total, but the referencing control should be placed in the Detail section (as the subreport itself) of the main report to get the correct result....Leave a comment:
-
As far as I can remember, the thing you are trying to do (referencing calculated controls on Subreport) is not working with reports, only with forms.
My advice here is to create a separate query calculating the totals you need, and base the main report on that query....Leave a comment:
-
I know that in Kaspersky AV there is an option that can be changed to enable Scripting. Don't remember about the others....Leave a comment:
-
Just one drawback from using Scripting. There are some antivirus programs (like Kaspersky AV) that have an ability to block scripting in Access. In such case, Access application just stops running. So if you intend to distribute your application, you would rather consider not using Scripting, as powerful as it is, unless there is no other option.Leave a comment:
-
Licensing application on Terminal Server
Hi.
My application (Access 2K) license is based on system drive ID number. It works fine on PC, but on terminal server each user gets the same drive ID (i.e, that of the server), thus the same license code.
Any suggestions of how to work this around.
No activity results to display
Leave a comment: