How do I create a query to display  a certain record with a certain amount of
information?

I'm looking for a sub fuction to test if a table already exist in a
database using VBS, before I execute the function creatobject. Thanks.

Hi!All
I am trying to create a report which tracks faculty progress.So the kind of
data I am reporting at a departmental level is the yearly funding received,
yearly grants generated etc. I am getting this data from a query and using

Does anyone know of a set of coversions to get from dBase
1.1 to ACCESS 2003 ?

Hi,
 I have an interview on tomorrow. Please let me know if you have any idea
about access experts.
Thanks in advance.

Using the lookup wizard, I'm trying to make two fields (in tblGames), named
"Visiting" and "Home", both lookup their values from a table called
"tblTeams".  I'm getting a "could not be saved" error when I try to do this
for the second field.  The first one works ok.  What's the ...

I have an error
==========
MSACCESS.exe has generated errors and will be closed by Windows.  You will
need to restart the program.

As something of a pet project, I'm looking to develop a tool to track
employee holiday (or vacation for those of us in the US) for my company -
good for the company (if I get something usuable working) and good practice
for me.

Our group is accessing several Access 2000 databases (MDB)
files on our network via local MDE files and linked
tables.  On occation, we find we cannot Compact and Repair
our database (MDB) files because there is a file lock

I've spent hours and hours  fixing up the relationships between 6 tables.
I want to delete just one field from one table which actually isn't used as
a join field.
So it says I have to remove the relationship which I did. But it says still

I am a novice at Access: I have an update query that uses two parameters,
which I get the user to supply using a PARAMETERS statement at the start of
the query.  The value from one of these has to be obtained by running another
query (which does a SUM function, so it returns a ...

I am designing forms for Access on my computer,  the information is being
input on another computer.
when we log into Access from the other computer it cuts off the right side
and bottom of our form, Why is this?  How can we fix it.

I am very new to databases and so this is likely a dumb question.  I have a
spreadsheet that I am trying to migrate to a DB.  The problem is that I don't
know how to re-create the calculation that I have in my spreadsheet.
It's pretty simple stuff, I have a "gross", "expense" and ...

I would like the outcome of one combo box to affect the contents of the next
combo box. eg. In the first box I have regions (North West, North East,
Midlands etc.) and when I click on North West, I want the second combo box to
have Lancashire, Cumbria, Cheshire etc. When I click ...

Hello in a field every word of every entry ends with a comma. How can I
delete that comma from every word of the field?
Thanks in advance
Dimitris