I am using an ACCESS 2003 .ADP as a frontend for a MS SQL Server 2005
Express Edition
database.
I have a form, which has 4 subforms which all have the same table as

I have a Form that gets infomation from a table via a query. What i need to
do is after i complete a caculation, i need to write the revised value back
to the original table. I need to writ it as these items change a lot and it
keeps my data live.

i have a form that is linked to a table.  all i do is enter data from the
form.  i converted the database from 2000 to 2003 because i want to use with
runtime.  for some reason the form doesnt open up in data entry mode.  i can
scroll through records etc but the * is not ...

I have a form and 2 subforms
Main form [Job Sheet 1]
Sub 1         [Time Table Form]
Sub 2         [Work_hours_sub]

I have tried several Data functions to determine how to count the
total number of "Thursday's" in a given month. For instance:
If I choose to find out how many "Thursday's" are in the month of
September in any given year, how can I find this by not writing a

I have a customer table with a Date of Birth field. I want to be able to
prompt a user to enter a begin and end date to print out birthday letters
based solely on the user entering the begin birth month and day and the end
birth month and day, and not the year. How can this be ...

How can i fixed my unbound text (Concat of Address) with the control
source coming from the same table as what i have in the form that
returns the ID which is number instead of Text?

I need to write a query to link a number of table together so I can build a
form page that the project managers can type in a part number and retrieve
all the specs of the part. Can I use the dlookup to do this?

I would like to use an unbound control on an unbound form to specify
parameters for a query. I would like the user to enter inches and then
fractional inches and then have another text box show the total of those two
entries in decimal form. How can I convert an entry such as 1/8 ...

I am getting no where fast. I have a main form and sub form and what i need
is a message to appear when user moves on to the next record using the record
selector on the bottom of the form. I have tried the beforeupdate on the form
but no results. Can form design prevent a ...

I have a form A with a Y/N field. If the user clicks the box (Y) I want
another form B to open for additional data entry. I'd like to then return to
the main form A and continue. Can someone help me with this?
Thanks,

I must be going insane.  For some reason, vertical scroll bars are missing
from my text and memo fields!  I even created a brand new db file (Access
2003), created a new table with a text field and a memo field.  I typed a
bunch of text into them.  Then I created a new form, plopped ...

I am converting a system for an appliance parts store.  The sales
people hand write sales tickets and I need a form for entering those
sales tickets at the end of the business day.  Some customers pay cash
and some customers just sign the ticket to be billed later.

I have a subform with the following fields:
ScheduledTimeFrame
ActualLoginTime
ActualLogoutTime

Hi I am new to Access and want to be able to do this:
I want to click on a button and enter in a percentage like: 0.458 or 0.455
then have it display on the command button and also use that value to
multiple the amount of miles....