I have some sample code written for VBA which accesses the database
using db.this = currentDB
I would like to combine the code with another example that is written
in  VB6 and uses ADO. This code accesses the database using a path to

i have a DB file with 3 forms and couple of tables and queries.
i want users to be able to open one of two forms, without seeing the
database window and the other tables & queries.
but i still want to be able to access the rest of the DB myself.

how do i position a textbox where i want it at runtime.
tried .left = but no go.
tia,
mcnewsxp

I am trying to change a protected document which I created with Word 2003.  
When I open it in Word 2007 it is showing unprotected, yet I cannot make any
changes to the document.  What do I need to do to so that I may be able to
alter my document?

print a simple list of all the tables. I used the documenter but I only need
a list of the names of the tables - can this be done? can I print the list
continuously (not each table on a seperate page)? (PS I cant download
anything - work network restrictions.)

I have a database that is linked to a backend database.  The "front end"
application is installed on a number of computers at a school.  The back end
is installed on a server.  Typically, when the front end is copied onto a
computer, we get the message "The database DynamicMinds ...

then I'm trying to calculate the maximum value for a field and add 1 to it
and display this in a field on a form, when it is opened.

I am having a really hard time trying to get my DSum update query to
work.  What I'm trying to accomplish is a running total of claims
across time for claimants.  The fields I'm using in my update query
are [CCC] a text field that identifies a claimant, [SumOfPAID_BY_US] a

Is there a way to go to a specific switchboard page and item (SwitchboardID
and ItemNumber) from code?  If so, can you help me with some sample code?
Thanks,
Mike from Moriches

I've created a database to monitor machine downtime and production levels.  
The database is split into a front end and back end.  The front end is on 10
computers.  I was led to beleive that it would be a good idea to save the
front end as an MDE file.  When I go into database ...

I have =count("*") in a report and want it inside text in a text box, ie
="On this page there are "&[Count]& " clients listed"
when I put text after the count function it is fine, but when I embed the
count function in the middle it won't work, what am I doing wrong ?

My question involves the following:
Table:   Sales_Leads
Form:   Sales_Leads_enter
Report: Sales_Leads_result

please tell me what is the general code for access 2003 because i can not
open a store database will is ask me a access code

I would like to get means and other summary values from the  "table" produced
as a result of a parameter query. But everytime I try to open the parameter
query it ask for the input paramters. Is there any way to save the results of
a parameter query as a table so I can use that ...

I'm a novice user here.  So please keep that in mind.  :)  I've developed a
database in Access 2000.  It's not a running program like one would be used
for inventory, sales, etc.  We use the program to enter address/site
information, then enter data related to items collected or ...