I have a continuos form with a subform placed in the footer of the form. The
subform is also a continuos form.
When I update/enter records in a subform. I would like to  requery the
parent form and stay on the same record. In other words I just  want to

Has anyone else noticed that
docmd.hourglass true
docmd.openform "myform"
docmd.hourglass false

I am using the following code to open an existing invoice for a workorder
...
   DoCmd.OpenForm "frmInvoice", , , "WorkOrderID=" & Me.WorkOrderID
and the following code to create a new invoice for a workorder ...

I have a need to split a string with the help of a delimiter. I don't know
the position of the delimiter like  I have file name that could be any number
of characters, I want to find out the file extension, like .doc, .gif how can
I get it?

I have tried everything I can think of to resolve this issue and I really
hoping for some help from the experts out here.
I have a front end database (Front.mdb) and I want my users to be able to
selectively link to different backend files (back1.mdb and back2.mdb) from

Hi, I am a real noob in programing vbscript in Access 2003.
I have got a problem here..
I want to count how many null and 0 values that are in a ROW.
Then I want to have the average of the rest of data in that row without

I have a combo box on a form pulling data from a table. When I click on the
combo box, the first 4 items are blank. The 5th item is where the actual data
from the table starts to be listed. I checked the table and it does not have
blank records. How do I fix this? Why is this ...

I think I read somewhere once that said you should not do this:
whateverSub
If somecondition is false THEN
Exit Sub

I have a text field on my access DB form that i would like to appear if
a user selects a particular item from a combo box. I have completed
this part of the code. However, when user selects another record on the
form where the condition isnt true the combo box still appears.

I have a default form with buttons on the right to open other forms for data
entering working hours. The default form is set to capture the work hours
from the button (forms).
The problem I am having is the button forms do NOT retrieve the [date] and

I have an Access 2003 combo box on a form whose RowSource is a query which
depends on the value of another control on the form.  The other control is
derived from other values - it is not bound.  I can't get the first combo box
to refresh whenever the value of the second control ...

I've seen tons of references to the Shell Command.  I've  been to the
MVPS.org site with the shell command:
http://www.mvps.org/access/api/api0018.htm
I have no clue how to use it.

Is there a way to set the font size for a subform which is in datasheet
format?
Thanks,

I am trying to replace the Access msg (with no runtime error # in the dialog
box):
"The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.

Running A2002.
I'm trying to prevent the user from entering a duplicate value already in my
table.  I'm assuming Dlookup is the best choice for this.
This is what I have: