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 |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|