If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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 |
#15
|
|||
|
|||
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 |
#16
|
|||
|
|||
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 |
#17
|
|||
|
|||
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 |
#18
|
|||
|
|||
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 |
#19
|
|||
|
|||
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 |
#20
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to assign passthrough query into listbox rowsource | Sunny | New Users | 1 | January 10th, 2005 09:09 PM |
Inactive delete feature | frepaci | Using Forms | 7 | October 27th, 2004 08:11 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |