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 |
#21
|
|||
|
|||
Create a folder in your "C:" drive.
Call it "Database" (without the quotes). Copy the database (.mdb) into that folder. Copy the workgroup (.mdw) into that folder. Create a shortcut as follows: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe" "C:\Database\YourDatabaseName.mdb" /WRKGRP "C:\Database\YourWorkgroupName.mdw" Ensure the workgroup file is the one the wizard created and not the original one. Ensure you type the above with the quotes as shown without pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in the directory as per above - if not, modify the path appropriately. If this doesn't work, I am out of ideas. You can make Access look at the workgroup file permanently but then you will have issues with any other databases that may be in use or created later, therefore I won't go there. As far as security is concerned, this is a whole discussion in it's own right. My main concern at this point is that if you are going to have multiple users and the database is not on the server, and anyone makes changes, the others will not be able to see those changes as everyone has their own local copy, which is not shared. Regards, Andreas cel504 wrote: 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 |
#22
|
|||
|
|||
Thanks for that and all your prevous help. The database needs to be local, to
limit the input to just one authorised user at one site. I shall try your latest advice. "Andreas" wrote: Create a folder in your "C:" drive. Call it "Database" (without the quotes). Copy the database (.mdb) into that folder. Copy the workgroup (.mdw) into that folder. Create a shortcut as follows: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe" "C:\Database\YourDatabaseName.mdb" /WRKGRP "C:\Database\YourWorkgroupName.mdw" Ensure the workgroup file is the one the wizard created and not the original one. Ensure you type the above with the quotes as shown without pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in the directory as per above - if not, modify the path appropriately. If this doesn't work, I am out of ideas. You can make Access look at the workgroup file permanently but then you will have issues with any other databases that may be in use or created later, therefore I won't go there. As far as security is concerned, this is a whole discussion in it's own right. My main concern at this point is that if you are going to have multiple users and the database is not on the server, and anyone makes changes, the others will not be able to see those changes as everyone has their own local copy, which is not shared. Regards, Andreas cel504 wrote: 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 |
#23
|
|||
|
|||
Does anybody know how to stop the screen from flickering when switching
between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? "cel504" wrote: Thanks for that and all your prevous help. The database needs to be local, to limit the input to just one authorised user at one site. I shall try your latest advice. "Andreas" wrote: Create a folder in your "C:" drive. Call it "Database" (without the quotes). Copy the database (.mdb) into that folder. Copy the workgroup (.mdw) into that folder. Create a shortcut as follows: "C:\Program Files\Microsoft Office\Office\MSACCESS.exe" "C:\Database\YourDatabaseName.mdb" /WRKGRP "C:\Database\YourWorkgroupName.mdw" Ensure the workgroup file is the one the wizard created and not the original one. Ensure you type the above with the quotes as shown without pressing the "Enter" key inbetween. Ensure the file MSACCESS.exe is in the directory as per above - if not, modify the path appropriately. If this doesn't work, I am out of ideas. You can make Access look at the workgroup file permanently but then you will have issues with any other databases that may be in use or created later, therefore I won't go there. As far as security is concerned, this is a whole discussion in it's own right. My main concern at this point is that if you are going to have multiple users and the database is not on the server, and anyone makes changes, the others will not be able to see those changes as everyone has their own local copy, which is not shared. Regards, Andreas cel504 wrote: 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 |
#24
|
|||
|
|||
cel504 wrote:
Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#25
|
|||
|
|||
Can anyone help with this.
When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#26
|
|||
|
|||
How can I set the work week to be Monday to Sunday, or even Sunday to Saturday?
Can anybody help please? "cel504" wrote: Can anyone help with this. When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#27
|
|||
|
|||
Functions like DatePart and Format (both of which can be used to calculate
week) have two optional arguments that let you specify the first day of the week (use vbMonday, or 2 in your case) and first week of the year. Check the Help file for details. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message news How can I set the work week to be Monday to Sunday, or even Sunday to Saturday? Can anybody help please? "cel504" wrote: Can anyone help with this. When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#28
|
|||
|
|||
That's great and I have mangaged to do that now, one other point, the weeks
are out of sync by one, ie, 200505, should be 200504, any ideas on why. "Douglas J. Steele" wrote: Functions like DatePart and Format (both of which can be used to calculate week) have two optional arguments that let you specify the first day of the week (use vbMonday, or 2 in your case) and first week of the year. Check the Help file for details. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message news How can I set the work week to be Monday to Sunday, or even Sunday to Saturday? Can anybody help please? "cel504" wrote: Can anyone help with this. When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#29
|
|||
|
|||
Not without knowing what date you're passing to get that value and how
you're calculating it... -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message ... That's great and I have mangaged to do that now, one other point, the weeks are out of sync by one, ie, 200505, should be 200504, any ideas on why. "Douglas J. Steele" wrote: Functions like DatePart and Format (both of which can be used to calculate week) have two optional arguments that let you specify the first day of the week (use vbMonday, or 2 in your case) and first week of the year. Check the Help file for details. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message news How can I set the work week to be Monday to Sunday, or even Sunday to Saturday? Can anybody help please? "cel504" wrote: Can anyone help with this. When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#30
|
|||
|
|||
Hi,
The date is entered as say 04/04/2005 and then datepart to give year number and datepart to give weeknumber. These are then merge and the output is 200515 and not 200514 as it should be.If I use the formula on the week to be WK: Format(DatePart("ww",[DATE],2)-1,"00") correct weekdate will be 14. I would appreciate any help you can give me. "Douglas J. Steele" wrote: Not without knowing what date you're passing to get that value and how you're calculating it... -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message ... That's great and I have mangaged to do that now, one other point, the weeks are out of sync by one, ie, 200505, should be 200504, any ideas on why. "Douglas J. Steele" wrote: Functions like DatePart and Format (both of which can be used to calculate week) have two optional arguments that let you specify the first day of the week (use vbMonday, or 2 in your case) and first week of the year. Check the Help file for details. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "cel504" wrote in message news How can I set the work week to be Monday to Sunday, or even Sunday to Saturday? Can anybody help please? "cel504" wrote: Can anyone help with this. When I enter a date onto the database, I need to convert the date to a year and week format. I have two problems. The first is the year and week becomes say 20059, but I need it to be 200509, how can I get the extra nought before the 9. When I enter the date, the data baseconverts it ok, but is currently 1 week out of sync. ie, 07/02/05 convers to week 11 and not week 10......any ideas please. "Rick Brandt" wrote: cel504 wrote: Does anybody know how to stop the screen from flickering when switching between forms. I know in Excel the code is Application.ScreenUpdating.False, I have tried using this in Access without success. Is there a way of closing one form, when another is opened? Application.Echo False (do some stuff) Application.Echo True Make sure you include an error trap that also sets the Echo back to true or your user could get stuck with an app that won't update the screen. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
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 |