Good morning all.
I have created a subform and would like one of the fields on the datasheet
to be invisible.  Is that possible?  (The purpose for the invisible field to
enable subtotalling it in the footer with that calculation to be carried to

I have a database of student records. On the form for the Student table, I
have an image control for a picture, and a text control for the image path.
It is supposed to display a picture of the student if there is one in a sub-
folder called Images. By default it displays a blank ...

I hope some one can help i have a form thatis used for sales and i have a
total field that has the total of the sales. What i need now is a field where
i can enter the amount the customer gave me and it gives me the change amount
i need to give to the customer. But i want it to ...

I have a form with a combo box. I want the combo box to contain years
between 2000 and 2020, and its default value to be the current year. I don't
know how to do this...
Can any body please help?

My autonumber field is the first field in my form.Thus, it is empty until I
go to another field and begin entering data.  I had the same issue a few
years ago and remember solving it with a few lines of code that placed then
deleted a value in a field using the the onload event but ...

I've several related tables and I want a form that has aspects of all the
tables.  I cannot get Access to work with a form based on a Query that
relates the tables.  It just refuses to recognises the key presses, I assume
because of referential integrity being enforced and it ...

I have Access 2002 Office XP Professional and no matter what I do I cannot
get my wizards to work in forms, query or table.  The icon is there but when
you double click the icon nothing happens but if you click new with the
wizard icon highlighted it goes directly to design view. ...

In a form I have a Combo1 field which provides Agent_Id and Agent_Name from
Table1.
Then I have Date_In and Date_Out fields which are chosen from a calendar.
I would like a command button to execute the following SQL statement:

I have created an application that keeps track of people who have been to
classes.  I want to create a section called Build a Roster.  We have about
500 people who are registered for class.  I want them to all appear in a
collumn on the left with a scroll bar.  I then want both ...

I do alot of work at home, some of my co workers send me documents, I have
microsoft works It would be nice if i could open .xls documents with it, is
there a way to do this.
----------------

Does this work in A2003?
AfterUpdate of combo
'Move to the record selected in the control Me.RecordsetClone.Findfirst
"[ID] = " & Me![ComboOrListboxName] Me.Bookmark =

I am a relatively new learner in Access 2000. I need to put field lists (both
label and text boxes) on a form, detached eventually. I used auto wizard to
quickly do that. But the two are attached. Rather than cut and paste the
label to un-attached the pair, is there a way to ...

Can someone tell me how to set up a field in Access that will do the type
ahead feature so as I'm entering in information in starts to fill in likely
selections?
Also, if I'm entering data into a form how do I set it up to enter, for

Is it possible to change the value of the Record Number Box (Withing th
Navigation Button). If so how?
Thanks
Sridha

I am usually quite competent working with Access and the basic programming of
it.  But, for some reason, I can't get it to produce the result I want.  
Currently I have:
=Iif([Data Costs]=1,"Data Service","Phone Service")