Can I assign an active X calander to a query

Whatever you put into the text box's ControlTipText property will do that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"cel504" wrote in message
...
Is it possible to view an message when you hover over a text box, or
label. I
have seen this on other database, can this be done in Access,any help
please.

"cel504" wrote:

Can an activex calander be used in a query to sort out data by a date
range
and how can I extract from a date input say 01/03/2005, that this relates
to
Monday,
ie "dd" =MON

Douglas, thanks very much for your help.


"Douglas J. Steele" wrote:

Whatever you put into the text box's ControlTipText property will do that.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"cel504" wrote in message
...
Is it possible to view an message when you hover over a text box, or
label. I
have seen this on other database, can this be done in Access,any help
please.

"cel504" wrote:

Can an activex calander be used in a query to sort out data by a date
range
and how can I extract from a date input say 01/03/2005, that this relates
to
Monday,
ie "dd" =MON

I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:

Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:
I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:


Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:

If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:
I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:


Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:

Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:

If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:
I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:


Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

Probably the wrong group, there is a group dedicated to security.

If the shortcut can't find the program, then you need to change the part
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" to reflect the
location of MSACCESS.exe. Use Windows Explorer or Start.Find to locate
the file.

Regards,
Andreas


cel504 wrote:
Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:


Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:


If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:

I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:



Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

Andreas,

Sorry to be a pain, but does the rest of the code stay the same, as in
test\supplier, test\ secure or does that have to be substituted by another
code.

What is actuallly happening with the code and sequence.

Thanks again.

"Andreas" wrote:

Probably the wrong group, there is a group dedicated to security.

If the shortcut can't find the program, then you need to change the part
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" to reflect the
location of MSACCESS.exe. Use Windows Explorer or Start.Find to locate
the file.

Regards,
Andreas


cel504 wrote:
Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:


Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:


If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:

I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:



Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

The parts you are specifying a
Program Database /switch Workgroup

So, the first part is the location of the Access program:
Example: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe"

The second part is the location of your database:
Example: "C:\My Documents\Databases\Database.mdb"

The third part is the switch, which allows you to specify your workgroup
file: /WRKGRP

The fourth part is the location of your workgroup file:
Example: "C:\My Documents\Databases\Workgroups\Workgroup.mdw"

You need to supply each example above as written (including quotation
marks), with a space between each argument (for readability anyway),
substituting the directory and file names as appropriate.


Regards,
Andreas


cel504 wrote:
Andreas,

Sorry to be a pain, but does the rest of the code stay the same, as in
test\supplier, test\ secure or does that have to be substituted by another
code.

What is actuallly happening with the code and sequence.

Thanks again.

"Andreas" wrote:


Probably the wrong group, there is a group dedicated to security.

If the shortcut can't find the program, then you need to change the part
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" to reflect the
location of MSACCESS.exe. Use Windows Explorer or Start.Find to locate
the file.

Regards,
Andreas


cel504 wrote:

Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:



Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:



If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:


I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:




Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON

Sorry, Andreas, I have done exactly as you described and it's to no avail. I
even tried to move the file location to another part of my computer to try
it, ie from Desk top to my documents and retype the code on the short cut.
The error is always it can't locate the database. Is this the best way to
secure a database by the way, or am I missing a trick somewhere. I don't want
to put this on a public drive server, but just limit it to a few Desk Top
users.



"Andreas" wrote:

The parts you are specifying a
Program Database /switch Workgroup

So, the first part is the location of the Access program:
Example: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe"

The second part is the location of your database:
Example: "C:\My Documents\Databases\Database.mdb"

The third part is the switch, which allows you to specify your workgroup
file: /WRKGRP

The fourth part is the location of your workgroup file:
Example: "C:\My Documents\Databases\Workgroups\Workgroup.mdw"

You need to supply each example above as written (including quotation
marks), with a space between each argument (for readability anyway),
substituting the directory and file names as appropriate.


Regards,
Andreas


cel504 wrote:
Andreas,

Sorry to be a pain, but does the rest of the code stay the same, as in
test\supplier, test\ secure or does that have to be substituted by another
code.

What is actuallly happening with the code and sequence.

Thanks again.

"Andreas" wrote:


Probably the wrong group, there is a group dedicated to security.

If the shortcut can't find the program, then you need to change the part
"C:\Program Files\Microsoft Office\Office\MSACCESS.exe" to reflect the
location of MSACCESS.exe. Use Windows Explorer or Start.Find to locate
the file.

Regards,
Andreas


cel504 wrote:

Help, required again please.
Having enter the code exactly as discribe, the short cut cannot find the
program, any ideas, where I have gone wrong?


"cel504" wrote:



Andreas, thanks for that, I will give it a go. Standby for help, it will be
needed I am sure!

"Andreas" wrote:



If you want to copy this to another PC in stand alone mode (rather than
having this working over a network in multi user mode) then:
Copy the database and the workgroup file (.mdb and .mdw) onto the new
PC. Then create a shortcut using the format:

"C:\Program Files\Microsoft Office\Office\MSACCESS.exe"
"C:\test\suppliers.mdb" /WRKGRP "C:\test\secure.mdw"

Above is a single line.

Regards,
Andreas


cel504 wrote:


I have designed a database on my computer and set the level securtity using
the Wizard, what is the best method of now copying this database onto another
computer. When I copy it across, there are three parts to the program, a
shortcut, the file and the security file, but the database will not open on
the computer, due to the fact the security file is not in an access format .

Any help please.

"cel504" wrote:




Can an activex calander be used in a query to sort out data by a date range
and how can I extract from a date input say 01/03/2005, that this relates to
Monday,
ie "dd" =MON