How do I find out if a verbal is Negative in VBA

Get me started in the right direction.  In my report I have a page header
with certain information.  But on the 2 page I want to keep some page header
info but not other information.
Using VB can I somehow have certain information show on 1st page but not in

I have a column which has values like 00-H15-81366, 03-A02-81570 etc. I need
to make another column which will show the aphabet only e.g. H, A etc. I
would like to know if there is any function that would allow me to do so.
Thanks in advance.

The new Access Visual Basic example files use a text that is very tiny, and I
have been unable to find options to increase example font size.  Microsoft
needs to include a fix for this in their next Office Update!

I am using the code below on [Event Procedure]of the option Buttons.  This
opens my form correctly BUT it also opens a blank form when No job number
matches the criteria.  Is there a way I can create a message box to show
there is know match.

Ref: office xp sp3
Would like to put up on the screen a window with several check box's or ...
. The user would then mark the boxes appropriate to his request & then click
on next or ... . Then the vba program could process the request(s).

I'm using Access 2000 and I'm trying to use the natural logarithm function
( ln ) in one of my modules but one doesn't exist.
Does anyone know or have a function that uses the existing Math.log/exp
functions to get the equivalent ln function?

Good morning,
I am using this Access module to control Excel as well. I am using an object
variable named OBJ declared as an Excel Application. I use this object
variable to call certain Excel macros, but I need to know if there is a way

Can someone please tell me how to use the vbTab character?  I am trying to
format a label using tabs.  When I add the vbTab to the string it prints a
squares instead of tabbing the text over.  
This is what I am doing:

 I was just wondering how it would be possible to obtain a field called
'week ending' which would give me a list of all the sunday's dates for the
coming year.

I've written code to copy files from an FTP (intranet) to a networked
destination.  it then verifies the transfer & sends me an email stating that
it was a success or failure.
however, the missing piece to this code is gaining access to the FTP site.  

Hi group,
i am trying to execute the code below, but i get the following error (3061)
I think that it is erroring on this line:
Set rsPT = dbCurrent.OpenRecordset("qryQtrRptAge")

I'm using a treeview control and i'm building a search routine. The problem
is that, if the string i'm searching doesn't exists on the Tree, all the
nodes of the tree stay expanded. Is there any method to collapse all the
nodes?

I have a database with two tables:
Table (table name:Data) contains 183 fields. (Field names: Name, 1, 2, 3, 4
..... 182) . These 182 fields will contain number of troubleshooting done on
each day by a technician from 1st September 2004 till date. Name field

I have created some code to create and save a word doc to a specfic location
on my server. Is there  an easy way to check to see if the document already
exists before the  "AppWord.ActiveDocument.SaveAs" code is run. Have copied
sections of the code which outline the folder ...