Simple things but getting stuck on.

[StargateFan]

It's been so long since I've used Access that it's been rough going
<g>!

I've been using the Northwinds example and over last few days I've
been modifying it in order to use the db at work. It's going very,
very well. But I've not been able to find answers to these questions:

1) The main report wizard doesn't seem to have a place where we can
set the page type. The page orientation shows up but where could be
choose legal-sized paper, for example, via the wizard? Currently, I
have to go back in and manually modify every aspect of the report so
it will print on legal-sized paper. Since there are many reports, I
will need this feature so that I don't have to do all the post-work
modifications to all the new reports I'll be creating.

2) date entry - how do we tie that field into a pulldown calendar so
the user doesn't have to type anything?

3) how can I add a day to the date? i.e., the date format is
yyyy.mm.dd and we need it to be yyyy.mm.dd.day (2004.05.09.Sun).

Thank you so much! I really appreciate any help. Those are the major
issues though I've forgotten a couple of additional points to ask
about. <sigh> But getting answers to the above will be fantastic.
It would be a real coup for me to show up tomorrow with a working, if
rough db. Input from my supervisor will determine what modifications
to make.

 

[GVaught]

1. The page size is not part of the wizard. Page size is set under File |
Page Setup. Once you assign this to a report and save the report the page
size will be saved. Note: Their is a bug when you use 'Autocorrect' settings
that will sometimes forget your report setup settings. Make sure this is
unchecked. It may be possible to write a class module that will
automatically use predefined printer and printer settings that you can set
on the reports 'On Print' event and bypass the File | Page Setup setting for
every new report. However, you will have to go back to each report and make
sure the code module is applied to each report.

2. There is an Active-X Calendar control that you can use to capture a
selection made by the user to fill in the textbox. Unfortunately, I do not
have any available code to give you to do this. Perhaps if you search Google
for Active-X Calendar Control in Access, you will find this.

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show you the
full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy mm dd
ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

 

[Douglas J. Steele]

Your slashes are the wrong way.

Format([OrderedDate],"yyyy\. mm\. dd ddd") works.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show you the
full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy mm dd
ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

3) how can I add a day to the date? i.e., the date format is
yyyy.mm.dd and we need it to be yyyy.mm.dd.day (2004.05.09.Sun).

Thank you so much! I really appreciate any help. Those are the major
issues though I've forgotten a couple of additional points to ask
about. <sigh> But getting answers to the above will be fantastic.
It would be a real coup for me to show up tomorrow with a working, if
rough db. Input from my supervisor will determine what modifications
to make.

 

[StargateFan]

1. The page size is not part of the wizard. Page size is set under File |
Page Setup. Once you assign this to a report and save the report the page

[snip]

Understood. Thanks!

2. There is an Active-X Calendar control that you can use to capture a
selection made by the user to fill in the textbox. Unfortunately, I do not
have any available code to give you to do this. Perhaps if you search Google
for Active-X Calendar Control in Access, you will find this.

The official link for it is dead
(http://www.microsoft.com/officedev/freestuff/mscaldl.htm). I did
find it here, though: http://www.sunscrip.com/OfficeXP.htm (under
point #3). I'll have a look at this and see if I can figure it out.

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show you the
full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy mm dd
ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

Phew, glad you told me. I didn't realize.

Will use the standard format in the table.

Thank you, I'm really on my way now to creating a great db for my

 

[Larry Daugherty]

I recommend that you avoid the calendar control from MS and use one of the
all code or API and code calendars you can find by poking around. If you
google search for calendar in the Access groups you'll come up with lots of
references. I still use one developed by Ken Getz and delivered in the
Access 2 edition of Access [yourversion] Developer's Handbook by Ken Getz et
alia from Sybex.

Look for calendars at www.lebans.com

Also, look for calendar references at www.mvps.org/access

hth
--
-Larry-
--

1. The page size is not part of the wizard. Page size is set under File |
Page Setup. Once you assign this to a report and save the report the page

[snip]

Understood. Thanks!

2. There is an Active-X Calendar control that you can use to capture a
selection made by the user to fill in the textbox. Unfortunately, I do not
have any available code to give you to do this. Perhaps if you search Google
for Active-X Calendar Control in Access, you will find this.

The official link for it is dead
(http://www.microsoft.com/officedev/freestuff/mscaldl.htm). I did
find it here, though: http://www.sunscrip.com/OfficeXP.htm (under
point #3). I'll have a look at this and see if I can figure it out.

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show you the
full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy mm dd
ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

Phew, glad you told me. I didn't realize.

Will use the standard format in the table.

Thank you, I'm really on my way now to creating a great db for my

 

[StargateFan]

I recommend that you avoid the calendar control from MS and use one of the
all code or API and code calendars you can find by poking around. If you
google search for calendar in the Access groups you'll come up with lots of
references. I still use one developed by Ken Getz and delivered in the
Access 2 edition of Access [yourversion] Developer's Handbook by Ken Getz et
alia from Sybex.

Thank you for the information.

Just out of curiousity, why is one of these better than the MS ones?
or, perhaps question should be, what's wrong with the MS one?

Look for calendars at www.lebans.com

Also, look for calendar references at www.mvps.org/access

Thanks, will do! Hope these are easy to figure out. I'm no expert
<g>.

hth
--
-Larry-
--

1. The page size is not part of the wizard. Page size is set under File |
Page Setup. Once you assign this to a report and save the report the page

[snip]

Understood. Thanks!

2. There is an Active-X Calendar control that you can use to capture a
selection made by the user to fill in the textbox. Unfortunately, I do not
have any available code to give you to do this. Perhaps if you search Google
for Active-X Calendar Control in Access, you will find this.

The official link for it is dead
(http://www.microsoft.com/officedev/freestuff/mscaldl.htm). I did
find it here, though: http://www.sunscrip.com/OfficeXP.htm (under
point #3). I'll have a look at this and see if I can figure it out.

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show you the
full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy mm dd
ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

Phew, glad you told me. I didn't realize.

Will use the standard format in the table.

Thank you, I'm really on my way now to creating a great db for my

It's been so long since I've used Access that it's been rough going
<g>!

I've been using the Northwinds example and over last few days I've
been modifying it in order to use the db at work. It's going very,
very well. But I've not been able to find answers to these questions:

1) The main report wizard doesn't seem to have a place where we can
set the page type. The page orientation shows up but where could be
choose legal-sized paper, for example, via the wizard? Currently, I
have to go back in and manually modify every aspect of the report so
it will print on legal-sized paper. Since there are many reports, I
will need this feature so that I don't have to do all the post-work
modifications to all the new reports I'll be creating.

2) date entry - how do we tie that field into a pulldown calendar so
the user doesn't have to type anything?

3) how can I add a day to the date? i.e., the date format is
yyyy.mm.dd and we need it to be yyyy.mm.dd.day (2004.05.09.Sun).

Thank you so much! I really appreciate any help. Those are the major
issues though I've forgotten a couple of additional points to ask
about. <sigh> But getting answers to the above will be fantastic.
It would be a real coup for me to show up tomorrow with a working, if
rough db. Input from my supervisor will determine what modifications
to make.

 

[Larry Daugherty]

Sorry, I'm getting sloppy in my replies.

The calendar controls supplied by MS are prone to version and OS conflicts
and variations in installations. You can never be sure it will work on the
next (unknown) installation. You can probably fix all problems in time but,
why bother? Using one of the form and code based examples is a little more
complicated to get going but you will never have to worry about the
versioning and other issues.

HTH
--
-Larry-
--

I recommend that you avoid the calendar control from MS and use one of the
all code or API and code calendars you can find by poking around. If you
google search for calendar in the Access groups you'll come up with lots of
references. I still use one developed by Ken Getz and delivered in the
Access 2 edition of Access [yourversion] Developer's Handbook by Ken Getz et
alia from Sybex.

Thank you for the information.

Just out of curiousity, why is one of these better than the MS ones?
or, perhaps question should be, what's wrong with the MS one?

Look for calendars at www.lebans.com

Also, look for calendar references at www.mvps.org/access

Thanks, will do! Hope these are easy to figure out. I'm no expert
<g>.

hth
--
-Larry-
--

On Sun, 9 May 2004 14:04:16 -0600, "GVaught"

1. The page size is not part of the wizard. Page size is set under File |
Page Setup. Once you assign this to a report and save the report the page

[snip]

Understood. Thanks!

2. There is an Active-X Calendar control that you can use to capture a
selection made by the user to fill in the textbox. Unfortunately, I do not
have any available code to give you to do this. Perhaps if you search Google
for Active-X Calendar Control in Access, you will find this.

The official link for it is dead
(http://www.microsoft.com/officedev/freestuff/mscaldl.htm). I did
find it here, though: http://www.sunscrip.com/OfficeXP.htm (under
point #3). I'll have a look at this and see if I can figure it out.

3. You don't want to store that type of date format in the field. At the
table level set the format of the date to Long Date. This will show

you
the

full day with the date. Then in queries, forms, reports use formatting to
display how you wish, such as OrderDate: Format([OrderedDate],"yyyy

mm
dd

ddd"). This is the closest I could come. When I tried to enter /. between
each part it returned the _ (underscore) place holder rather than the
period. This would be a start.

Phew, glad you told me. I didn't realize.

Will use the standard format in the table.

Thank you, I'm really on my way now to creating a great db for my
supervisor. We'll both look good for the boss! <g>

It's been so long since I've used Access that it's been rough going
<g>!

I've been using the Northwinds example and over last few days I've
been modifying it in order to use the db at work. It's going very,
very well. But I've not been able to find answers to these questions:

1) The main report wizard doesn't seem to have a place where we can
set the page type. The page orientation shows up but where could be
choose legal-sized paper, for example, via the wizard? Currently, I
have to go back in and manually modify every aspect of the report so
it will print on legal-sized paper. Since there are many reports, I
will need this feature so that I don't have to do all the post-work
modifications to all the new reports I'll be creating.

2) date entry - how do we tie that field into a pulldown calendar so
the user doesn't have to type anything?

3) how can I add a day to the date? i.e., the date format is
yyyy.mm.dd and we need it to be yyyy.mm.dd.day (2004.05.09.Sun).

Thank you so much! I really appreciate any help. Those are the major
issues though I've forgotten a couple of additional points to ask
about. <sigh> But getting answers to the above will be fantastic.
It would be a real coup for me to show up tomorrow with a working, if
rough db. Input from my supervisor will determine what modifications
to make.

 

[StargateFan]

Sorry, I'm getting sloppy in my replies.

The calendar controls supplied by MS are prone to version and OS conflicts
and variations in installations. You can never be sure it will work on the
next (unknown) installation. You can probably fix all problems in time but,
why bother? Using one of the form and code based examples is a little more
complicated to get going but you will never have to worry about the
versioning and other issues.

HTH

Sure does, Larry, thanks!

Can you recommend one of these, though? I'm so new at this and
wouldn't know where to begin to look for one, googling or not ...
<sigh> <g>

Also, would one of these be easy enough to figure out how to
incorporate into my db?

After years of using Filemaker Pro, the popup calendar issue for it is
one I haven't resolved there either. The freeware calendar plugins
available all require coding into one's solution. I've never been
able to manage it so I'm worried that this will be the same for Access
(which has VB which I don't understand at all. That's why I use FMP.
But we have Access at work so I can't use FMP there.)

Thank you so much!

 

[StargateFan]

Sure does, Larry, thanks!

Can you recommend one of these, though? I'm so new at this and
wouldn't know where to begin to look for one, googling or not ...
<sigh> <g>

Also, would one of these be easy enough to figure out how to
incorporate into my db?

After years of using Filemaker Pro, the popup calendar issue for it is
one I haven't resolved there either. The freeware calendar plugins
available all require coding into one's solution. I've never been
able to manage it so I'm worried that this will be the same for Access
(which has VB which I don't understand at all. That's why I use FMP.
But we have Access at work so I can't use FMP there.)

Thank you so much!

I'm starting a new thread. That might make things easier.

 

[Larry Daugherty]

If you're planning to be developing in Access for the foreseeable future I
recommend getting The Access [yourversion[ Developer's Handbook by Ken Getz
et alia from Sybex. The book typically runs about $50 per volume but well
worth it. I believe, as do many other, that I receive the value of the book
each time I go to it and pull out a solution.. For the later editions there
may be 2 volume sets. You'll probably only need volume 1, the Desktop
volume. On the accompanying CD there will be at least one "form and code
implementation of a calendar with plenty of information on incorporating it
into your db. The one I use has a code module and a form and is simple to
add to any MDB. In most of the date controls in my applications a double
click in the control will bring up the calendar. Navigate the calendar to
the year, month and date you want and doubleclick to have the selected date
appear in the text control.

I don't have the URLs for sites where Ken's stuff is available for perusal
and sampling but you can find links to him at www.mvps.org/access

HTH