If I give someone a runtime app,
they can open the database
window by pressing the F-11
key. How to prevent???

I consider myself an Excel PT wizard of sorts, but now I have a
situation with so much infromationthat I need to categorize and
summarize, that I will use access to manage it.
Interestingly, though, the pivot tables in excel 2003 do not resemble

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/ac
fctNZ_HV05186465.asp
"If the value of the variant argument is Null, the Nz function returns
the number zero or a zero-length string (always returns a zero-length
string when used in a query expression)"

I have this code in my query and I'm getting the message
"undefined function Left (or Right) in Expression"
AcctJulian: Left([Account],3)
I have looked on posts, and it seems this is the correct syntax.  I

using ADODB recordset.  trying to use the .open method
SQL uses data from a form [Forms]![Form1]![txtQuantity]
If I replace directly with a number then no problem.
As is, I get error -2147217904 which I gather is likely to be something

Is it acceptable to run Nz this way...
Forms!MyForm!CaseFileNum = Nz(DLookup("[CaseNum]", "tblCourtCases",
"[CaseID]=30"), Null)
What I'm curious about is the use of the keyword Null as an Nz

Have asked before elsewhere but think I will have to rephrase the question.
Using MS Access, what's the best way of tackling dates if I want to list all
say; birthdays/birthdates in a date field?
Many thanks as I'm totally lost on this.

I have a query, like the following:
(Assumption: an ID will not have an entry in both "Meal" and "Daily" on
the same date; it can only have an entry in either "meal" or "Daily"
per date)

Has anyone ever done this?  How difficult would it be?  Is there anything
written about how to do it?
Merry Christmas from Down Under
dixie

Hello again..
   I have a table with a text field named "Requisition" (Indexed, no
dupes).  It is not the key field. This field is the first text box on a
form. I would like to check to make sure the Requisition string is not

I have a combo with a list of names. On the basis of a particular name
selected, I want a few hidden fields to become visible.
Like, when "James" is selected, show CheckBox1, CheckBox2, CheckBox3
Could someone please help with this?

I need help with this. How do I call an external Avaya CMS Supervisor
auto-script from Access?
Please advise
Regards

Do you know about UserForms in Access?
UserForms seems to me to be just like VB Forms, or Excel UserForms.
They are not Access objects and have little or nothing to do with
Access forms. In the Project Explorer that appear in a Forms folder,

I have managed to secure a split database. Both frontend and backend
share a common workgroup, common security groups and common users and
permissions, but as in all good stories there is a catch.
All works well for the newAdmin user, but not so for the newUser. In

I am having trouble with hyperlinks in Access. They dont work! Any tips? I
am trying to use them on a network drive.
Karl