I have set up shortcut menus on many form successfully.
However, for the first time, I am trying to set one up on a subform.
In the 'On Action:' when customising the menu item I have:
=Forms![OrderDetails].showAvailability()

For clueing me in to regular expressions for use in VBA.  I still have the
original problem I posted about on my back burner, but I've already been
able to use regular expressions to solve problems that would have been much
more complicated without them.

My problem is: My union query is made up of two cross-reference
querys.
The cross-reference querys has number fields formated as standard. So
far so good.

I have an A97 MDB that I converted to A2003 yesterday.  My MainMenu
calls ARInfoForm.  I hit the Exit button in ARInfoForm and it closes and
displays/activates the MainMenu just fine.
The ARInfoForm has a complicated recordsource that makes reference to a

I have a linked table (two primary keys: one coming from Me.txtRMA#
and the other is an Autonumber) that I am writing to from an unbound
form. Please review my code and tell me what is wrong with it. I don't
get any errors and no data is written to the table. It doesn't do

I'm creating a new table in code  (dataBaseObject.TableDefs.Append
MyNewTable)  but it doesn't show up in the navigation pane until I close the
database and open it back up again.  Is there some VB command to force the
table to appear in the pane?

Hi, I got a pass-through query (that takes about 15 mins to process)
I would like to integrate variables to it.
IE: something simple:
Select EmplID from empl_Lst

I am using the following vba code to calculate the median of a table
in MS Access:
Public Function MedianOfRst(RstName As String, fldName As String) As
Double

Can anyone tell me:
'Is Access 97 Bible' available in pdf format, & if so, where can I aquire it
?
TIA,

i have a application database written in A2K3 that i have converted to
A2K7 and i am looking to create an application ribbon that i can ship
with the runtime. It would be fair to say that i am having trouble
getting my head round the new technology and not making any progress.

I would like to create a button that opens Outlook and puts some text
in the body of the email.  I don't need any attachments, just some
text in the body.  I've accomplished the ability to create an email
using a macro, but the text I want to add to the body generates an

How do I set the Criteria in a query for my City field to return those
records that have nothing/no value/null value that is, no city name
entered.
City field used Text data type.

I wish to control which users can and cannot alter the toolbars.  The
opening popup window invites them to login.  Immediately after this, I
have the code:
CurrentDb.Properties("AllowToolbarChanges") = isManager

I dont know why only else part of if statement is effected when using
below
Private Sub Form_Current()
If Me.NewRecord Then

I am trying to connect my backend whih is stored on a public server as
accdb file. This connects well on a local network but when I store the
BE on my ISPs server I get following error in Access 07 "Not a valid
file name"