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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Switchboard



 
 
Thread Tools Display Modes
  #1  
Old July 2nd, 2009, 03:10 PM posted to microsoft.public.access.tablesdbdesign
PurpleLady
external usenet poster
 
Posts: 1
Default Switchboard

Hi there - i am such an amateur when it comes to swtichboards. I have
learned that the switchboard wizard is no fun. I like building my own.
Today my concern is using an "unbound" text box to ask for a event date.
When the date is keyed a report is generated for that event.

I have never used an unbound box so i am lost. I looked at a friend's
database and i think i see what to do, but when i try it - goof!

I also want to add a second one that ask for a start date and end date. I've
seen it happen, but not sure how to do it my self.

Any help and encouragement is appreciated.

Thanks - Purple Layd (newbie)

  #2  
Old July 2nd, 2009, 03:25 PM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default Switchboard

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Method 2 in that article explains how to use a form with 2 text boxes (for
entering the starting and ending dates) and a command button to open the
report filtered to the dates (if the user entered some.)

The unbound text boxes are not an issue. Just set their format property to:
General Date
so that Access knows what data type they are supposed to hold, and rejects
things like June 31.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"PurpleLady" u52976@uwe wrote in message news:9879910758a19@uwe...
Hi there - i am such an amateur when it comes to swtichboards. I have
learned that the switchboard wizard is no fun. I like building my own.
Today my concern is using an "unbound" text box to ask for a event date.
When the date is keyed a report is generated for that event.

I have never used an unbound box so i am lost. I looked at a friend's
database and i think i see what to do, but when i try it - goof!

I also want to add a second one that ask for a start date and end date.
I've
seen it happen, but not sure how to do it my self.

Any help and encouragement is appreciated.

Thanks - Purple Layd (newbie)


 




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


All times are GMT +1. The time now is 05:49 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.