Using Access XP you call the currentproject method and
pick up its name property to return the filename of the
current application file.  I need to to a similar
function in 97 which only picks up the filename directly

I can't seem to get access to work, and this is the error message i get back.

I need to create a summary report of another report, broken down by page,
with a currency total for each page.  Since this seems to be impossible, I'm
hoping I can approach it from a different angle.
There will always be five records on a page, except for possibly the last

Group
I need to trim everything off of the left side of the @ symbol in a list of
e-mail addresses. user@domain.com to *@domain.com.
Thanks

My table has a field called [City].  Data in this field has a City Name and a
State designator.
IE Boston, MA
I have created a new field in the table named [State]

I can open excel.exe using the shell function, but I want to open a excel
file in My Documents at the same time. I want to go directly into the file
and not have to use the file open on the toolbar in excel

I am linking a excel workbook to my database. My problem is that, this linked
file is on the server. My drive letter is z:
If someone else tries to use this database and if the drive letter is
different then the database does not work.

I have an Access 97 Database, about 500K.  I convert it to Access 2002
(compresses to 335K) and run the program.  It "BLOATS" to corruption size at
about 2.097 Gig.  
I have explicitly closed all record sets (rs.close) (to minimize bloating

Is there a way to display the full data field when the mouse curser moves
over the field?   The controltip text property cannot display the actual data.

I have a VBA function that sends emails. I want to automate this process but
when the objoutlook.send method runs i have a message warning me that a
process is trying to send emails on my behalf. How can i supress this message?
Thanks

I have a text box and it has some code on the on_click event. What I need to
do is, after tose code are executed, I would like to automatically click on a
label. There is no code in the on-click event of the label, but it has a
hyperlink, so it opens a file.

Other users of my database.mde, accessing it using Run-
time.
The problem is that even though I set the report paper
size to A3 portrait before I send it out, it keeps

I have a txtfield which I run thru  select case logic and it works with
every possible case except Null.  When the txtField is Null, it skips "Case
Null" and hits "Case Else".  I checked the value in a watch window and it
definitely says Null.  Any suggestions for capturing the ...

   I would like to know if there is a way to gather general networking info
about a workstation?  Something along the lines of the DOS "ipconfig"
command.
machine name

   I want to set a startdir variable = "//public/common/%username%" if the
computer has access to the folder otherwise set it equal to "c:\".  How can
this be done?
Thank you,