I have some code where I create some SQL and execute it with an ADO
Command object.  Problem is that for some users the table I am updating
is not one they have permission to update (and they cannot have
permission to directly update).

When you have a Text Box & have a Label asscociated with it & then when you
Disbale the Text Box (Enabled=False) it gets greyed out & its Label Font gets
that silvery-etched look.
How can I change other Lablels that are not Associated to Text Boxes to that

I have instances where my checking routines happily move the focus from one
field to another.
But for some particular reason, I can't get this one to work...
A form which is used to select reports (between selected 'Startdate' and

I want 2 combo boxes on a form. When I select an option in the first one, I
want only the linked info available in combo 2. Then comes the tricky part to
me anyway. I then want 4 text boxes to populate based on my combo 2
selection. I can get either to work but when I try and ...

I have a routine which when a user clicks a button on an Access form,
creates an email form with some data already filled in from the record on
display.  The user has the option of reading in the body text from an
external file.    At present I am using a text file, but the ...

I want to make invitations for my son's first communion which is coming up,
on Office 2003?

I have a form with 2 subforms in it. How do I create a command button with VB
or a macro to copy data from 2 seperate fields in one subform to 2 fields in
the other subform simultaneously? Please explain or show me how to or include
examples of coding to do this. Thank You.

I have a form with this calculation in the detail section:
=([cdleva_1]*([cdlevp_1]/100))+([cdleva_2]*([cdlevp_2]/100))
In the form footer I have:
=Sum(([cdleva_1]*([cdlevp_1]/100))+([cdleva_2]*([cdlevp_2]/100)))

Is it possible to use a an unbound field(s) to filter a sub-form. For
example, I would like to enter say a starting date, ending date, and last
name of a student.  Then in the sub form display the results based on the
fields.  I know how to all this stuff in a query with ...

I have an access database on an NT40 server. I need to access files in a
shared folder on a WIN2003 server and copy them to the NT40 server. I have
set up a local account on the WIN2003 server that has access to the shared
folder. How can I have my code issue a logon screen to the ...

I have some code that I want to switch the ControlSouce property based on
what the user selects.
If btnOwners.Caption = "Show Current Owner" Then
   btnOwners.Caption = "Show Owner When Created"

I have the following table structure in a database:
person table:  myuid, some other data about the person
account table: myuid, uid of a person, credit-limit
credit card table: myuid, uid of an account, card number, other details

Hi, if I have focus in subform 1, and I want to programme to filla field in
subform2 on the sameparent, can someone tell me what the coorrect syntax is
to get focus on the second form.
i have tried : Me.parent.subform2name,but that doesnt seem to work

How do I check if a list box has at least one item selected before the record
is saved?
Thanks,
Melanie

   I found this code at some web site for setting security to low when
starting access. My problem being new to programming is where do I put it.
If I put it or behind the Splash screen, teh database is already open so the
first line opens a second copy of Access.