A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I assign an active X calander to a query



 
 
Thread Tools Display Modes
  #21  
Old March 21st, 2005, 06:39 AM
Andreas
external usenet poster
 
Posts: n/a
Default

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  
Old March 23rd, 2005, 04:45 PM
cel504
external usenet poster
 
Posts: n/a
Default

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  
Old March 27th, 2005, 06:29 PM
cel504
external usenet poster
 
Posts: n/a
Default

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  
Old March 27th, 2005, 06:41 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

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  
Old April 2nd, 2005, 03:01 PM
cel504
external usenet poster
 
Posts: n/a
Default

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  
Old April 3rd, 2005, 10:17 AM
cel504
external usenet poster
 
Posts: n/a
Default

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  
Old April 3rd, 2005, 01:25 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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  
Old April 3rd, 2005, 01:53 PM
cel504
external usenet poster
 
Posts: n/a
Default

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  
Old April 3rd, 2005, 02:55 PM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default

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  
Old April 3rd, 2005, 03:43 PM
cel504
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to assign passthrough query into listbox rowsource Sunny New Users 1 January 10th, 2005 10: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


All times are GMT +1. The time now is 06:12 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.