I have a main form (frm_main) which shows activity for each day of the month.
There are therefore 42 subforms on frm_main (one for each day of month).
I have an update form that the user can open to enable them to change the
information on any given day. On confirming the change ...

Is there a way to auto-update front ends on users desktops???
Thanks,
Emma

I have a make table query that creates a null field called ClosedDate. This
is essentially a place holder for an append query that later places data into
this field.
However, when the data gets appended, the field type for this field is

hey all,
i have an expense table like followed:
Name,Date,Amt
-------------------

I am creating a database in Acc03 SP3 and the database keeps crashing.  I
could be putting a button on a from or creating a report or form or query.  
There is no logic to when or why it is crashing it just does.   I am
recreating the database again for probably the 10th time. I ...

Hi, I'm working on what seemed a simple database, but I can't get started.  I
have table with only 3 fields: Account number, account description and
amount.  I want to create a report that list all accounts pertaining to a
specific group (recruitment), another line with all ...

I want to create a database for a pet grooming business.
The preliminary design is 3 tables.
Table 1 is the transaction table consisting of transaction number, date &
time, customer number, service performed and pet name, dollar amount for

I have two tables:
PRICE_LIST
(PK)MetalType
SellPrice

Can anyone help me? I want my users to be able to search for a record in a
table and generate the data of that record on an edit view.  I am used to
having a GRID (Table view), double clicking on the record I need and the
double click open an edit view form with the data for that ...

I have set up a database for my local Credit union.
I have set the member's id number as an integer in a member table. I have
set the format as "fixed" and decimal places as 0 as an added measure.
I am using a combo box in a form bound to the members id in the members

I  have a database the has a Parts Table and a Vendors Table. what needs to
happen is i need a form that will allow someon to view all the information
about that parts itself and the vendors that  supply  the part but  every
part is available by  all 5 vendors for different  cost ...

I have a probelm, that I am hoping someone can answer for me. I am Attempting
to Create a Form that has multiple subforms embedded in tabs.  Access will
not allow me embed more that 3 subforms.  Any Suggestions

So, I cannot do a Sum function when one of the control sources is an
expression (to pull a number from a table?)
Thanks.
You no longer have a Unit Cost field in the form if you have set the Control

I need a little (a lot?) help.   I'm working in a database that someone else
built but I've been maintaining for a while.  Now I want to add a field to a
table in our database.  The tables are linked in relationships.  What is the
best way to unlink these tables, make my changes ...

I am creating a database that will track service calls made in the field. I
want to know how can I create a customer and track all the dates I've
serviced that customer. What i've been doing is having multiple records of
one customer. I just want certain information updated each ...