I am trying to add a Browse-button to a database, and I believe an
ActiveX-control is the way to go (correct me if I'm wrong). Get an error
that says something like "You don't have the licence required to use
this ActiveX Control", have tried to register the comdlg32.dll, but it

Hello...
I have two tables, first is Location
ID    location
-------------------------------

I want to build a database which has  an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front

No objections have been made to an encore of the
expose of a certain individual and his cronies
who frequent this ng.  
Having received no objections at all, public or private,

I have a form [Formulas] with a continuous subform [Formulas - Raws].
subform has a combo box called [lot#}
I have a separate form called [COA - Quick Information].
The following code is opening up the [COA - Quick Information] form,

I need to return the field (or column) names as the first row in a
select query.  Any way to do this without resorting to vba?
Thanks,
TD

I am given a sales forecast every month for certain products which
usually extend a year.  I enter each forecast into a "tblForecast"
which contains the sales forecast information and the date the forecast
was entered.

My ColorSet building form/subform now works beautifully, thanks to the
help that I've gotten from people in this group.
The working form displays the parent ColorSet record with the
child records displayed in the subform below it.

I am trying to create a query that can be loaded as a querydef object
but not having to assign values to the parameters if I don't want to.
Normally when using a parameter query in VBA my code would go something
like this:

I have a two tables, Breeding and Mouse. The Breeding table contains
information of the parent mice. The Mouse table contains information of
the pups. Each table contains a field called DateOfBirth (of the pups).
The relationship between the two tables is a one-to-many. They are

I have the following code.
i m wondering how you pass the actual value of a variable to an insert
query
I want to input the value os jobnumber and finalstring

This should be really simple but I just can't get it to work right.
I'm trying to create a report (no code involved on my part) that prints
details about different schools each on a different page.  I'm working
with 7 schools and 6 of them show up on their own page just fine.  I

team
so i have a nice little list in sharepoint.. about 15k items
i've got the simplest little join statement in access; and im trying to
UPDATE the sharepoint list via an access query.

I have this code and does not see to work it gives me all the time the
dbseeChanges error
 strSqlTeam = "Select id, firstname, surname from [dbo_users]"
 Set teamrst = CurrentDb().OpenRecordset(strSqlTeam)

Hi all, is it possible to only protect a certain switchboard e.g. Admin,
with a pasword and not the whole data base ?
Les Stout