Dear reader,
How to print an e-mail address if the address is stored in a datatype
Hyperlink field.
If I use the Hyperlink field in a report than by print the field shows more

Can any one please tell me how do i separate city state and zip. I ask
this question in previous post. But when the city name is in two words
it mess up my values otherwise it works.
CityStateZip

I know that the .ldb file should show the users currently logged into a
database.
However, when a user logs out I cannot detect any change in the file.
I must be missing something as PSPad pops up a message that the file has

Dear reader,
My AddNewRecord procedure looks as follows:
Private Sub AddNewRecord (strFormName As String)
On Error GoTo ErrorHandler:

How can I extract the first name from the full name where each name is
separated by spaces?
Thanks
Regards

hi friends,
i am really surprized the way access behaves in date fields i mean
it's all ok when you have us time zone or us servers but if you have
diffrent timezone like uk then access creates so many problems ....

Hi is there anyone out there that can help me with MS Access???  I am
new to Access and have a project that requires me to create a form with
a list box of entries, and upon double clicking an entry will pull up a
subform (hiding the initial form) that gives you data on the entry ...

What I'm trying to do is set a players division according to their age.
So if age is 8, update division to junior, if age is 9, update division
to medium, if age is 10, update division to pee wee, and etc.
I'm trying to accomplish this in a single query, and be able to run

Do you know how to schedule a weekly export of one table to a text file
from access 2000 on windows xp?
Thanks,
Eyal

i'm sure this is simple to do, but i can't find the answer in the
search engines.
i have an access db with 400,000 records. i produce queries of 5,000
records at a time exported into an excel file. sometimes people will

Can any one please tell me how to i export data thru VBA code as same
when i right click on any table and then it ask me to export data as
comma delimited. Can i do the same thru VBA code. I need it not prompt
me for comma delimited or fixed length as i only need the comma

Is there any way to execute a function by using it's pointer?
The reason I want to do this is:  I have a control on a form that I
have wrapped with a class.  I want to be able to dynamically assign a
function that is in the form's code to an event defined in the wrapper

What is a good way, in VBA, to automate the linking of table links to
excel spreadsheets that reside in the same path as the database file
that would be common to Access97 and Access2000 so that if the
database directory were to change, the links would still be valid at

I need to set up a query that will pick out records for the current winter
season.
I.e., each season runs from October 1 until March 31. The catch is, the year
can't be hard coded. So, if the query is run on September 30 of this year

I am wanting to play a prank on someone. Is there a way to send an
email and make it look like it came from someone else. Thanks for help
or a group sugestiion for the question.