Using Access 97
I am trying to create a form that allows for user entry of search terms
and displays a table of results. I thought I could accomplish this using
a subform but it isn't quite doing what I want it to do.

I currently have a solution that requires 2 sub queries, where each of
them is convereted into a crosstab query and then I join the crosstab
queries to a result.    I would like to make this more dynamic and
allow for users to filter, and to do so I would like to be able to

I have an Access 2003 database with a table for customers and a table
for orders - linked by the cutomer number (a unique field in the
customer table).
Sometimes the staff set up a new customer when there already is the

I don't seem to be able to get opening a report and sortin the rcords right.
I an open the report, limited to a range of my choosing.  So, for example
the code below opens my report and limits it to the dates required.
DoCmd.OpenReport stDocName, acPreview, "[NegBehave].[NegDate] ...

I plan to use the following code behind an Access form button:
Dim Wordobj as Word.Application
Set Wordobj = CreateObject("Word.Application")
Wordobj.Documents.Open Mdocument

 I have a report with the NoData event and i need to use the OutputTO
command
to create a .snp file, this is possible???

How do I get the Len function to count a space at the end of a string? For
example, if I enter AB(space), how do I get Len to return 3 instead of 2?
Thanks,
Steve

Hi i have a table with data like this
f1    f2      f3
1    8        0
2    8        8

Table:  address
address_id (PK, autonumber)
add_off_id (FK, Long, has duplicates)
add_start_date (date, ver likely to have duplicates)

I need help for sort date("Table"). How can I sort a month, then year?
Thanks in advance,
Catherine

I want to add a number (for example 7.5) to a date. I've been using
365.2425*7.5 and then adding this to the date. This gives an answer
that is close and in most cases the error is unnoticeable. However if
the number to be added is an integer this error looks awful (eg

I want to auto fill a feild from a previous record. Pressing f8 does
the trick but I want to automate it?

Anyone out there successfully deployed Data Access Pages, on a server
they do not control, using RDS in a 3-tier environment?  If so I would
like to hear about your success.
From my reading, RDS is not widely available on commercial servers due

I've been developing Access databases for some time now and would like
to take the next step - web based systems.
What technology should I start exploring?
What software would I need?  Instead of building a physical web server

Hi.  I want to execute a routine, at database startup time, to relink
the backend tables.  I have the code for the function, but I don't know
where to invoke it.  I tried putting a call to the function in the Open
Event of the MainMenu (which gets displayed at Startup).  That seems ...