How can I through DAO (VB) find out if a specific user has access to open a
particular database ?
Paul

How do I write code to Recalc a subform on an unbound dialog form?
I see two methods:
   Forms![Mainfrm]![Subfrm].Form.Recalc
   Forms("Mainfrm").Subfrm.Form.Recalc

I need to call a sub routine on a subform from a main form. How would I code
that? Thanks!

I often insert If MsgBox into the BeforeUpdate of various controls to ask for
a user decision about whether to continue or cancel. In one case, I need to
pop up a report so that the user can make his decision based on the content
of the report. I got this far:

Can u please let me know is there such a thing as an organiser withing
microsoft office?

I wrote some code (OK, I admit I copied the code from "Beginning Access 2000
VBA").  It works great, but I want to take it one step further and so far no
luck.  Here's what I've got:
I've got a form called frmReportList with a list box called lstReports and 2

Is there a way in Access 2003 to identify the first time a newly installed
database is run? I want to add a module that is invoked on the first start up.

I seem to be having a "brain freeze"; I have the following VBA and would
like for the frm to open to the last record:
Dim stDocName As String
   Dim stLinkCriteria As String

I can change the application title with:
dbs.Properties("AppTitle") = "New title"
but it doesnt show until I shut down and open the database
again. How do I make it update immediately?

I have the following code that resutls in a compile
error.  It's purpose is to run some append queries to
create new records so the user can enter additional data.  
The user chooses a grant and their name from drop-downs

For example (in a module of an Access project):
Global xx as String
versus using
Public xx as String

I have three  nested loops.  I get in error on inner while loop:
While Not rscount.EOF
The error states "Wend without While".  The code is below.  
I'm not sure what I'm doing wrong... Does anyone see anything?

In a couple of critical places, I use a filtered Row Source where I would
really like to tell the user WHY the item is not on the list. That is, is it
missing because it does not exist or because it is filtered out.
How can I trap the value the user typed In Control_NotInList for ...

I have front end in many computers, so I didn’t like to go one by one to
change the level security to Low.
So, how can turn off this message programmatically? Is it possible?
Thanks

I have created a MDE. In this MDE I have some important functions, methods,
which I don't want, that another user, developer can see and use them, when
they make a reference to this MDE. How can I do this?
In VB we can use a dialog to do this? How is it in Access?