I would like to lock the data from the form view. So that when some scrolls
up and down they do not see the other data that was input into the database
thought the forms.

I currently have a combo box on a form.  The combo contains a list of parts.  
When a part is selected it stores the value on my form.  At the same time it
displays the full part description/info on a subform.
What I would like to do....

I wish to create a date which takes "Date()" and returns just the two digit
year portion converted to fiscal year starting in October.
I have tried several variations, but nothing seems to work.

I have a macro set to open another form (Edit Form) to edit data found on a
Multiple Item Form.   The problem is the (Edit Form) always opens to the very
first record.  I would like the form to open the record I click on.  Would
someone give me some suggestions as to what I am ...

I have a form based on a table, with a set of values that are calculated in
VBA (many thanks to the guys yesterday for their input on that), however, i
cannot seem to adjust the number of decimal places for the calculated values.
I have something approaching 10 digits after the ...

Hi, and thank you for all your help.
I've created a command button that opens EXCEL (that's simple) but how can I
modify the VBA as to exactly which file to open?
Here is the VBA that was created when I created the CMD button;

Our technicians installed Adobe 7.0 and now I can't use the 1400+ hyperlinks
in my drawing database (Access XP PRofessional). When I click on the
hyperlink in the form, the Adobe window flashes, then disapears. I can open
the files by going to their respective folders, so the ...

What do I have to do and will this become a full time job.  I just want to
make sure this is all legal and on the up in up and not get into anything
that will cause trouble.  I will be recieving checks correct and they will
be mailed to me in my name I cash them take out my fee ...

I understand this will seem confusing, but I am quite certain someone will
know how to help me.
I am an electronic engineer, and as such I use different value resistors a
lot.

I have created a function (code below) however I want to change the "Like"
part to "not like" however this does not work. Can someone please advise what
the statement should be i.e the opposite of "Like". Thanks (from someone who
has been experimenting with VBA for 1 week)

This is what I am trying to achieve, I have a form with the following:
Received Date:
Received Time:
Sent Date:

Deligent as I am ,I want to look for friends as many as possible.
Especially from the Occident.

I need to see the current month written out.  When I use the formula below I
get the previous Month to the current one.
=Format(DateSerial(Year(Date()),Month(Date())-1,2),"mmmm")
When I take out the minus sign, it doesn't work.  I have also tried the

Is it possible to set a database up for data entry only? I want to set up a
front end that allows the user to access the created forms and reports but
not have access to the design wizards. I need a GUI interface that allows the
user to enter data and print reports, nothing else.

Can lookup look at two values (in separate columns) and return the value in
the third column.  e.g. I want a spreadsheet where i can input the product
type in column 1 (e.g. coke) and the size in column 2 (e.g. 1.5L) and
automatically fill the third column with the price.  I'm ...