I went to the Microsoft Templates page to see if there is a database
template for tracking and reporting on personal finances, but there is
nothing good, does anyone have one, or know where I can download a good
database for this?

Hi.  I'm creating a business advertising directory website for all 50
states using FrontPage and Access.  I am really not understanding how
to mesh the two together.  Some entries in the directory will just be
company name, address, phone number.  Some will have a basic ad, some

I'm having trouble figuring out what I need to do here.  Basically, I
want to pull data from several different tables and send them to a form
using open args.  However, the form that is being fed need to have
certain columns of data concatenated.  Here is the code I have so far.

I have an A2K database that has links to 3 of my other databases
(external links) to run some reports.  The coding in any of the 4 is
pretty simple.
Recently when we make a new .mde for the "main" database, the first

I've been distributing a fairly mature, very specific MS Access
application to end users in small offices of colleges for several years
now. This is a part-time venture and low volume operation- this is
somewhat of a hobby for me. Many of my end users are computer phobic

When my report load i want to ask from user:
Enter Starting Date: Date1
Enter Ending Date: Date2
and on the basis of these two dates i want to run my report (rptsmry)

I am having trouble designing the tables and establishing relationships
for a survey database for the purpose of evaluating speakers for a
variety of events.  After every event, the attendants are asked to fill
out an anonymous survey assessing the overall effectiveness of the

hi ppl
how would i get the value stored in TEXT1 from FORM1 to display in
TEXT2 in FORM2 when form2 is opened.
thx..

Evening,
I have a form that uses 5 pages (it's an electronic copy of the paper
version) we are going to use for manufacturing non conformances and
product deviations.  In case your wondering, it's 5 pages to get the

I'm currently "paper design" stage of building a database to track
employee information.  The main goal for this database is tracking
training records however in the future I will be expanding it to track
other information also.  I've got a couple ideas about how to set it up

How do I link tables in Access XP to a Lotus Notes Database or View? I
read an article on MS KB, but it only stated that you can link after
exporting data out of Lotus.
Thanks!

Is it possible that in a continous form i create a listbox which is not
a part of a table and disply some values. For eg: TableA has a field
FieldA. I run a query on TableA when it loads it match values in FieldB
of TableB and display values from FieldB in a listbox or any other

In tbl_EquipmentChronology there are three variables Equipment1,
Equipment2, Equipment3. My query worsk fine but on the basis of
[tbl_EquipmentChronology].[Equipment1] as i have to check if Equipment2
has a value then instead of Equipment1 i have to grab Equipment2 value

This is the query which i run when the form load. In
tbl_EquipmentChronology there are three variables Equipment1,
Equipment2, Equipment3. If Equipment1 and 2 are not empty then the
query copy equipment2 value in txt of table tbl_Event. Is it possible i

I have a table like this:
Numbers
10
20