I have a quantity per field set up in my SQL Server file (adp project)
as precision 11 scale 5.  This means the largest number I can store is
999999.99999 .  I have a subform that this field is entered on
(datasheet view) and if a user keys in a number that is 7 digits long

This probably sounds fairly simple, but I can't get all aspects of this to
work. I have 4 text boxes.
1. Part Cost - in Dollars
2. Part Quantitiy - Number

Can I make a calender on drop down menu?. So instead of enter the date, just
click the date on the menu. Thank you....
KF

have a form that allows users to search a Read Only database. I have a make
table query that pulls data from this databae and puts it into a table in
access.
When a new record shows up in the linked database, the user will be able to

My combo box displays case-sensitive entries for which I need a notinlist
event to occur if the user changes the case of a letter. Any suggestions on
how to do this?
Thanks.

I am writing an Access app to interface with Excel.
I am trying to write a function in VBA which will convert a number
between 1 and 200 into the equivalent column letter in Excel i.e. A to
GR. The idea is to pass the number as a Long Int variable to the

I am creating a tabular form for all employees of my firm with the
fields:  Dept, Employee Name, Current Salary, Projected Raise, New
Salary and Month of Raise.  It's one line item of data per employee so
I really don't want to have the person entering the data to have 1

Thanks to anyone who can help.
I have a calulated control which is based on 3 other alterable controls on
a(continuous) form. I force display of the calculation by 'if me.dirty then
me.dirty=false' in the afterupdate of the 3 alterable controls. There is also

I have a form which I want to insert the ActiveX control Microsoft
WebBrowser.  When I have added to the form and then view the form the only
thing I get is a white box the size of the object.  I then went to the
properties of the form and on the eveht "ON Open" I added

If manipulating by code, and both methods are possible, is it generally
better practice to change the form's RecordSource, or add filters?
I generally have been changing RecordSource, but I think this is because I
started doing so to "filter" ComboBox's RecordSources. I know all ...

Can someone tell me the code I need to do this on a form? I need to update
the date to the current date after any change in the record.

I have an ODBC report that has been created in Microsoft Access 2002
(10.6771.6825) Service Pack 3
This report Uses 5 Tables (Of which the size of data amounts to over 60
meg). The report works fine no problems at all.

Please Help.
I have a form that opens on click of a option group button.  When the form
opens I require fields to be completed before the form can be closed.
Private Sub Form_Close()

I have an option button where I want the default value to be "Active".  In
the Option Group Frame I have the default value set as "1".  When a user
clicks on the "Active" button  I want the backcolor of my form to remain the
same, when a user clicks on the "Inactive" button I ...

I have validation rules built into my existing form.
For instance, a facility may only be built inside a SFR or MFR zoning area.  
What's the best way to build a function into the form that will let the user
(maybe with password or other warning screen) override the validation ...