Need a good Access Pop-Up date Control for dynamic reports "Matthew David" <mdavid[ at ]matthewdavid.ws> 06.12.2005 14:25:18 I was just contracted for an Access project. The customer has a lot of data that he wants to see in reports. The catch is that he wants to select a date range from a start and end date and then a custom report to view the data. First, are there any good examples of this out there and second which third party date controls should I be looking to buy? Thanks for all and any help, -- Matthew David PH: 920.475.2972 FAX: 775.239.8171 mdavid[ at ]matthewdavid.ws

Re: Need a good Access Pop-Up date Control for dynamic reports "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 06.12.2005 14:29:43 Heaps of freebies out there. This is about as simple as it gets, just an Access form: http://allenbrowne.com/ser-51.html This is a wrapper for the Microsoft Month calendar: http://www.lebans.com/monthcalendar.htm Here's a list of more: http://www.granite.ab.ca/access/calendars.htm -- 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. "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... [Quoted Text] >I was just contracted for an Access project. The customer has a lot of data > that he wants to see in reports. The catch is that he wants to select a > date > range from a start and end date and then a custom report to view the data. > First, are there any good examples of this out there and second which > third > party date controls should I be looking to buy?

Re: Need a good Access Pop-Up date Control for dynamic reports "Matthew David" <mdavid[ at ]matthewdavid.ws> 06.12.2005 14:35:28 Thanks. I will check these out. "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... [Quoted Text] > Heaps of freebies out there. > > This is about as simple as it gets, just an Access form: > http://allenbrowne.com/ser-51.html > > This is a wrapper for the Microsoft Month calendar: > http://www.lebans.com/monthcalendar.htm > > Here's a list of more: > http://www.granite.ab.ca/access/calendars.htm > > -- > 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. > > "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... > >I was just contracted for an Access project. The customer has a lot of data > > that he wants to see in reports. The catch is that he wants to select a > > date > > range from a start and end date and then a custom report to view the data. > > First, are there any good examples of this out there and second which > > third > > party date controls should I be looking to buy? > >

Re: Need a good Access Pop-Up date Control for dynamic reports "Matthew David" <mdavid[ at ]matthewdavid.ws> 06.12.2005 14:47:29 I am new to Access development (I have done a lot of SQL 2000 and ASP.NET development). Is there any good examples of using date controls to format data in a report? Thanks sooo much. Matthew "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... [Quoted Text] > Heaps of freebies out there. > > This is about as simple as it gets, just an Access form: > http://allenbrowne.com/ser-51.html > > This is a wrapper for the Microsoft Month calendar: > http://www.lebans.com/monthcalendar.htm > > Here's a list of more: > http://www.granite.ab.ca/access/calendars.htm > > -- > 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. > > "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... > >I was just contracted for an Access project. The customer has a lot of data > > that he wants to see in reports. The catch is that he wants to select a > > date > > range from a start and end date and then a custom report to view the data. > > First, are there any good examples of this out there and second which > > third > > party date controls should I be looking to buy? > >

Re: Need a good Access Pop-Up date Control for dynamic reports "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 06.12.2005 16:23:15 Not sure I understand the question. You want a report that looks like a clock or something? The Format property of the text box on your report lets you specify how the date should appear. -- 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. "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message news:Oer8bPn%23FHA.1716[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] >I am new to Access development (I have done a lot of SQL 2000 and ASP.NET > development). Is there any good examples of using date controls to format > data in a report? > > Thanks sooo much. > > Matthew > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message > news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... >> Heaps of freebies out there. >> >> This is about as simple as it gets, just an Access form: >> http://allenbrowne.com/ser-51.html >> >> This is a wrapper for the Microsoft Month calendar: >> http://www.lebans.com/monthcalendar.htm >> >> Here's a list of more: >> http://www.granite.ab.ca/access/calendars.htm >> >> -- >> 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. >> >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message >> news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... >> >I was just contracted for an Access project. The customer has a lot of > data >> > that he wants to see in reports. The catch is that he wants to select a >> > date >> > range from a start and end date and then a custom report to view the > data. >> > First, are there any good examples of this out there and second which >> > third >> > party date controls should I be looking to buy? >> >> > >

Re: Need a good Access Pop-Up date Control for dynamic reports "Matthew David" <mdavid[ at ]matthewdavid.ws> 06.12.2005 18:15:29 No, what I need is very simple. The Access database has been created with the reports that I need. Each report is generated across a Start/End date range. What I am looking to do is to create a Form where you can select from the Calendar controls a Start and End date, the report from a drop down and then a button which runs the report. My guess is that this has been done before, but I would like to know where. I have no problem paying. Matthew "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message news:%23cwRhFo%23FHA.2040[ at ]TK2MSFTNGP14.phx.gbl... [Quoted Text] > Not sure I understand the question. > > You want a report that looks like a clock or something? > > The Format property of the text box on your report lets you specify how the > date should appear. > > -- > 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. > > "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > news:Oer8bPn%23FHA.1716[ at ]TK2MSFTNGP10.phx.gbl... > >I am new to Access development (I have done a lot of SQL 2000 and ASP.NET > > development). Is there any good examples of using date controls to format > > data in a report? > > > > Thanks sooo much. > > > > Matthew > > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message > > news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... > >> Heaps of freebies out there. > >> > >> This is about as simple as it gets, just an Access form: > >> http://allenbrowne.com/ser-51.html > >> > >> This is a wrapper for the Microsoft Month calendar: > >> http://www.lebans.com/monthcalendar.htm > >> > >> Here's a list of more: > >> http://www.granite.ab.ca/access/calendars.htm > >> > >> -- > >> 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. > >> > >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > >> news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... > >> >I was just contracted for an Access project. The customer has a lot of > > data > >> > that he wants to see in reports. The catch is that he wants to select a > >> > date > >> > range from a start and end date and then a custom report to view the > > data. > >> > First, are there any good examples of this out there and second which > >> > third > >> > party date controls should I be looking to buy? > >> > >> > > > > > >

Re: Need a good Access Pop-Up date Control for dynamic reports "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 07.12.2005 14:19:29 Okay, David, if you open the Northwind sample database, and the form named Sales Report Dialog, you will see an option group on the left, with command buttons on the right for print or preview. In form design view, you can see that the On Click property of these command buttons is an Event Procedure that calls the routine named PrintReports. That routine does a Select Case to open the right report. The last item (Case3), does the OpenReport with a WhereCondition. That's how you limit the report. For an example of how to limit the report using controls for Start Date and End Date, see: Limiting a Report to a Date Range at: http://allenbrowne.com/casu-08.html It creates the WhereCondition for OpenReport, just like Northwind did. HTH -- 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. "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message news:%23SmOqDp%23FHA.3340[ at ]TK2MSFTNGP12.phx.gbl... [Quoted Text] > No, what I need is very simple. The Access database has been created with > the reports that I need. Each report is generated across a Start/End date > range. What I am looking to do is to create a Form where you can select > from > the Calendar controls a Start and End date, the report from a drop down > and > then a button which runs the report. My guess is that this has been done > before, but I would like to know where. I have no problem paying. > > Matthew > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message > news:%23cwRhFo%23FHA.2040[ at ]TK2MSFTNGP14.phx.gbl... >> Not sure I understand the question. >> >> You want a report that looks like a clock or something? >> >> The Format property of the text box on your report lets you specify how > the >> date should appear. >> >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message >> news:Oer8bPn%23FHA.1716[ at ]TK2MSFTNGP10.phx.gbl... >> >I am new to Access development (I have done a lot of SQL 2000 and >> >ASP.NET >> > development). Is there any good examples of using date controls to > format >> > data in a report? >> > >> > Thanks sooo much. >> > >> > Matthew >> > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message >> > news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... >> >> Heaps of freebies out there. >> >> >> >> This is about as simple as it gets, just an Access form: >> >> http://allenbrowne.com/ser-51.html >> >> >> >> This is a wrapper for the Microsoft Month calendar: >> >> http://www.lebans.com/monthcalendar.htm >> >> >> >> Here's a list of more: >> >> http://www.granite.ab.ca/access/calendars.htm >> >> >> >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message >> >> news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... >> >> >I was just contracted for an Access project. The customer has a lot >> >> >of >> > data >> >> > that he wants to see in reports. The catch is that he wants to >> >> > select > a >> >> > date >> >> > range from a start and end date and then a custom report to view the >> > data. >> >> > First, are there any good examples of this out there and second >> >> > which >> >> > third >> >> > party date controls should I be looking to buy?

Re: Need a good Access Pop-Up date Control for dynamic reports "Matthew David" <mdavid[ at ]matthewdavid.ws> 09.12.2005 19:03:27 You are a life saver. I can not wait to dig through this. "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message news:uqjqClz%23FHA.360[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Okay, David, if you open the Northwind sample database, and the form named > Sales Report Dialog, you will see an option group on the left, with command > buttons on the right for print or preview. > > In form design view, you can see that the On Click property of these command > buttons is an Event Procedure that calls the routine named PrintReports. > That routine does a Select Case to open the right report. > > The last item (Case3), does the OpenReport with a WhereCondition. That's how > you limit the report. > > For an example of how to limit the report using controls for Start Date and > End Date, see: > Limiting a Report to a Date Range > at: > http://allenbrowne.com/casu-08.html > It creates the WhereCondition for OpenReport, just like Northwind did. > > HTH > > -- > 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. > > "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > news:%23SmOqDp%23FHA.3340[ at ]TK2MSFTNGP12.phx.gbl... > > No, what I need is very simple. The Access database has been created with > > the reports that I need. Each report is generated across a Start/End date > > range. What I am looking to do is to create a Form where you can select > > from > > the Calendar controls a Start and End date, the report from a drop down > > and > > then a button which runs the report. My guess is that this has been done > > before, but I would like to know where. I have no problem paying. > > > > Matthew > > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message > > news:%23cwRhFo%23FHA.2040[ at ]TK2MSFTNGP14.phx.gbl... > >> Not sure I understand the question. > >> > >> You want a report that looks like a clock or something? > >> > >> The Format property of the text box on your report lets you specify how > > the > >> date should appear. > >> > >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > >> news:Oer8bPn%23FHA.1716[ at ]TK2MSFTNGP10.phx.gbl... > >> >I am new to Access development (I have done a lot of SQL 2000 and > >> >ASP.NET > >> > development). Is there any good examples of using date controls to > > format > >> > data in a report? > >> > > >> > Thanks sooo much. > >> > > >> > Matthew > >> > "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message > >> > news:e6oCFGn%23FHA.272[ at ]tk2msftngp13.phx.gbl... > >> >> Heaps of freebies out there. > >> >> > >> >> This is about as simple as it gets, just an Access form: > >> >> http://allenbrowne.com/ser-51.html > >> >> > >> >> This is a wrapper for the Microsoft Month calendar: > >> >> http://www.lebans.com/monthcalendar.htm > >> >> > >> >> Here's a list of more: > >> >> http://www.granite.ab.ca/access/calendars.htm > >> >> > >> >> "Matthew David" <mdavid[ at ]matthewdavid.ws> wrote in message > >> >> news:u2YkCDn%23FHA.4004[ at ]TK2MSFTNGP14.phx.gbl... > >> >> >I was just contracted for an Access project. The customer has a lot > >> >> >of > >> > data > >> >> > that he wants to see in reports. The catch is that he wants to > >> >> > select > > a > >> >> > date > >> >> > range from a start and end date and then a custom report to view the > >> > data. > >> >> > First, are there any good examples of this out there and second > >> >> > which > >> >> > third > >> >> > party date controls should I be looking to buy? > >