How do you get a response for a query type of question.

I posted yesturday regarding having a problem getting my
report to say yes, no and sometimes rather than numbers.  
the advice I was given was to create an unbound text box
with the control source property something like this:  

In vba code, How can I insert recrds into one table from recordset defined
earlier in the code. I want something like this:
Dim rsClient As Recordset
Dim stSQL As String

I have two tables.  Table1 has a one to many relationship with Table2.  I
want to create a query that selects fields from Table1, and one field (a
date field) from Table2, but I want it to select only the newest field (date
field) from Table 2.  Maybe an example would help:

I'm getting message that library with RTrim (Trim, LTrim also) is missing. How to find out what library I have to
reference. In other words which labrary does Rtrim belong to
Thanx

I only need what day it is from a date field.  How do I pull apart the =Date() to just get today's day
Clut
The Access New Guy

Title about says it all. If it does I'm thinking about getting it for home
use. If it doesn't forget it.
Along the same lines, are there any known problems with importing and
changing Access 97 databases to Access 2003?

I am using MS Access 2000 (9.0.6926 SP-3) with MS OS Windows 2000 at work.
The AddItem method is missing?  At home I have MS XP OS and running Access
2000 and AddItem method is available and runs fine.  I transport it to work
and get a run time error.  Is there a missing .dll or ...

Sorry to keep on with these type of questions.
Could anybody give me any ideas on how to get an Insert Into
to work
DoCmd.Run Sql "INSERT INTO ExportUPS ( OrderNo, Company, Contact, Add1,

Can the information or data of a report in access be transfered to a
access database/table or querry. If yes, please help me how.
I am very new to access. I have prepared a report which sums up some
fields from a database. I now wish to store these totals of fields as

I am attempting to  to open an Access 2000 table in Access 2003 and I
keep getting an "Not a vlid bookmark" error.
Is there a way to get around this as the file will not open?
-Bill

Hello.
Don't know if this is the right place, but here we go:
I'm having trouble with this small db I've started to maintain record
of meetings. I have 3 tables (Participants, Meeting and a table wit

Im trying to make a database wich gonna contain some data of my dogs
like the dogs id nr ,sex, parents, offsprings and so on but since im
very new to Access i was just wondering where should i start
could someone give me and hand on this one?

I am supporting an environmental group capturing data on the health of
rivers and streams. Data are collected in various creeks (sometimes in more
than 1 location on a creek), by various people on a daily basis. Previously
data were added to an Excel spreadsheet. With growth in all ...

I'm trying to run Access 97 on a Windows 2000 machine. The
software was installed from a Microsoft Office
Professional Version CD. Word and Excel both work, but
Access won't load, I get an error message saying that