Search:

LMAO ... Can I borrow ... $324.00 ??
I promise to repay it next Tuesday ... LOL

RDH

Thanks for the information ...
I always thought that it was one computer one license as you have posted .. but someone tried to tell me different.
I was just curious. I knew that it was legal to...

Is it legal to use a single copy of Windows XP and install on a desktop and a laptop that is for my exclusive use .. as it is with Microsoft Office ??

Try this user defined function:
<pre>Public Function fGetAgeAsOf(dtDOB As Variant, dtAsOf As Variant) As Integer
Dim dtBDay As Date
If Not IsDate(dtDOB) Or Not IsDate(dtAsOf) Then Exit Function...

That's an old FAQ at Tek Tips that I posted a long time ago.

You can also find information on this at the location below.

Animation with Animated GIF's in Access

HTH
RDH

If all you need is the elapsed hours between two Date/Time values ... then all you need is to use is the DateDiff() Function:

DateDiff("h", [YourStartValue], [YourEndValue])

HTH
RDH

The ShiftKey property can be set via a remote database.

Go to the location below and download a Utility that will do what you need.

ByPass Shift Key Utility

HTH
RDH

This user defined function should give you the results you are after.
<pre>Function fGetAgeYMD(DOB As Variant) As String
Dim intYears As Integer, intMonths As Integer, intDays As Integer
Dim...

Here is one way to do this:

First set the "Key Preview" property of the form to Yes (the default is No).

Now place the following in the "On Key Down" event of the form:
<pre>Private Sub...

Mod 2 .... means divide the number by 2 and only return the remainder.

So if you think about it .... any whole number that can be divided by 2 equally with no remainder is an "Even" number. The...

A simpler way would be to use the Update Query. In the "Update To" section of the field you want the "A" or "B" .... use the following example:

IIf([YourNumber] Mod 2=0,"B","A")

"YourNumber"...

If you use a listbox to "multi-select" criteria for your report, you can not simply reference the list box from the query to retrieve the criteria.

You have to use code to "Loop" through the...

Add a Date/Time field to the table. Include the newly added field to the recorset query the form is bound to. Add a new txbox control on your form and set the Control Source of the txbox to the newly...

The code originally posted, at the start of the original thread, works in Access 2000 ... I have not tried it in Access 2002 yet but I suspect it will work in that verson also. It just will not work...

Here is an added note to installing Office XP (2002) on a machine with Office 2000 already installed ......

I also have all 3 versions installed on my development machine.

You do not have to...

I agree with Mark ......

Make sure you choose to install Office 2000 in a different folder (I use C:Program FilesMicrosoft Office2k).
Also make sure you choose to "keep older version" during...

Let me just attach it to the post and save us all the trouble of emails.

I need to add code to the app to detect if the database you want to set the "ShiftKey" property has a password. Currently...

I easiest and simpliest way is not to add the code to the app. Instead use a remote database designed specifically for this pupose. You keep a copy of this application on your development machine and...

You need to extract the Year from your stored Date entry using a "Field Expression".
You then set up a prompt in the Criteria section of this field expression to get the user to enter the Year to...

Hmmmm ........
I just took a look in my Access 2002 help and went right to FileCopy. It is in the VBA help files. To access it you must be in the VBA code window then cilck on help from that window....

Actually you should be using "yyyy" as the "Interval" argument in the DateDiff function ... not "y".
The "y" argument returns the "Day of Year".

Here is an expression I always use:
...

Here is a sample routine that should work for you:

Public Sub BackUp()
On Error GoTo Err_Backup
Dim strMsg As String, strTitle As String
Dim strSource As String, strDest As String
Dim strError...

As long as the backup is performed from the frontend, from an unbound form with no bound forms open, you can use the "FileCopy" statement to copy the backend to another location.

HTH
RDH

Attempting to replace the standard splash screen with a .bmp file on todays faster machines is a totally useless venture. As you have found, it appears and disappears too fast to read ... and Access...

You are very welcome.... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

I was just hoping I understood the question .... LOL

RDH