I have a db with job related info that opens a form based on a job number.  I
want to put a command button that when clicked will open the server where
pics are located in folders by each job number and I want it to open the
specific job number the form is open to.  Is this ...

how would i program a command button to sort a listbox ascending on the first
click, descending on the second click?  or should I just use a subform?

I have a question.
I have a continous Data Entry form that I have set visibility of several
controls to be turned on and off based on a selection in a combo box. When
condition one is met control set one is turned on. When I move to record two,

Is it possible to have rows alternate between grey and white in a listbox?

Just at completion stage of a project. Looking at the finished article I can
now see that the presentation of the forms is a little dated, particularly
the many buttons on the form. Is there a quick "easy" way to brighten,
modernise my App?.

How can I call a form in a Datasheet View using a Switchboard?

I would like to show the Recordselector but I do want users not to be able
to use copy and paste with its built in function.
Is there any possiblity to deavtivate the copy/past from the recordselector?
(I could only find a property to show or not show the selector. I want to

I asked this question in another window and think it belongs here.
This should be easy for most... It has been a while so I forget this.
What is the address for a subform from the main form? I want to put buttons
on my main form to update data to a field in my subform. I use the ...

I had asked this question before but was unable to get complete.
On my form when I click the Send Email button, the email pops up before
going out. I would like for a certain field (GLNumber) to pre populate in the
email as it shows on that record. Then of course, if you are on a ...

i have a main form on the form has a command button that loads another form
based upon information selected in the combo box beside it.
After this form loads using the data i want the main form to closeto
minimise the amount of forms open at one time.

I have a command button that uses the following command to open the server
where job related pictures are stored in files by job numer.  It opens the
file based on the job number in a field on form.  I want to have a message
box pop up when there is not a file for the related job ...

I have a main form that has a field called "GestioneID" this field is a
primary key and a autonumber.
I have a subform that is in datasheet view that adds items from a dropdown
list to the table "GestioneOrdineMisto"

On a form, I have a button that opens another form only showing records
relating to the record on the previous form. The sub is as follows:
Private Sub ScheduleCB_Click()
On Error GoTo Err_ScheduleCB_Click

I have a process that takes a while to complete.  I want access to display a
MsgBox that says "Please wait while process completes . .  .", and then
automatically close the MsgBox when the process completes, without the user
having to click a button (OK, Cancel, etc).  How can I ...

Update Query has two columns Column A and  Column B.
Column B is a calculation based on the value of Column A.
If columns are 'evaluated' left to right shouldn't I be able to do this in
in one query rather than two.