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
|
|||
|
|||
Allen Browne Calendar
I am using Allen Browne's calendar, and it is working great. I have used it
in my current database 4 times, and need it for one more set of parameters. However, when I use one particular query as a record source, nothing is visible on the form in form view, except the grey background. I can use the basic "Between [Start] And [End]" criteria in the date field of the query, and it works fine. I can also change between other queries as a record source on the calendar control form, and the controls are all visible. What could it be about this one query that is making all of the form controls invisible. |
#2
|
|||
|
|||
Allen Browne Calendar
As is too often the case, not being able to see the actual query to which
you refer makes it very hard to diagnose the issue, so we'll start with some general questions. The most obvious of those is to ask whether you are able to open the query directly and get records back. You seem to be saying that you do, and that there is a parameter in this query which restricts records by date. However, there is also an implication in your statement about using "the basic "Between [Start] And [End]" criteria", which is that you are trying to substitute in a different criteria in place of that "basic" version. So the issue here is whether you are passing the appropriate criteria into this query when it is being used in the calendar. How are you doing that? "Jim L." wrote in message ... I am using Allen Browne's calendar, and it is working great. I have used it in my current database 4 times, and need it for one more set of parameters. However, when I use one particular query as a record source, nothing is visible on the form in form view, except the grey background. I can use the basic "Between [Start] And [End]" criteria in the date field of the query, and it works fine. I can also change between other queries as a record source on the calendar control form, and the controls are all visible. What could it be about this one query that is making all of the form controls invisible. |
#3
|
|||
|
|||
Allen Browne Calendar
George,
I am able to open the query/report whether I have "Between [Enter Start Date] And [Enter End Date]", or with no criteria set for the date range at all. What I have entered in the Date criteria now is "Between ([Forms]![CalendarControlFrm]![txtStart]) And ([Forms]![CalendarControlFrm]![txtEnd])", which are the names of the unbound text boxes on the calendar control form. This works well for the other applications I have used it for in this db. I have checked all the properties against the ones that are working good, and all is the same. Checked all spelling as well. The wierd part is, if I use one of the other queries as a record source, all on the form is visible again. Both the form text boxes and the query Date field are set to Short Date. "George" wrote: As is too often the case, not being able to see the actual query to which you refer makes it very hard to diagnose the issue, so we'll start with some general questions. The most obvious of those is to ask whether you are able to open the query directly and get records back. You seem to be saying that you do, and that there is a parameter in this query which restricts records by date. However, there is also an implication in your statement about using "the basic "Between [Start] And [End]" criteria", which is that you are trying to substitute in a different criteria in place of that "basic" version. So the issue here is whether you are passing the appropriate criteria into this query when it is being used in the calendar. How are you doing that? "Jim L." wrote in message ... I am using Allen Browne's calendar, and it is working great. I have used it in my current database 4 times, and need it for one more set of parameters. However, when I use one particular query as a record source, nothing is visible on the form in form view, except the grey background. I can use the basic "Between [Start] And [End]" criteria in the date field of the query, and it works fine. I can also change between other queries as a record source on the calendar control form, and the controls are all visible. What could it be about this one query that is making all of the form controls invisible. |
#4
|
|||
|
|||
Allen Browne Calendar
See:
Why does my form go completely blank? at: http://allenbrowne.com/casu-20.html The article explains why the Detail section of a form blanks out when there are no records to display and the form does not allow new records to be added. -- 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. "Jim L." wrote in message ... I am using Allen Browne's calendar, and it is working great. I have used it in my current database 4 times, and need it for one more set of parameters. However, when I use one particular query as a record source, nothing is visible on the form in form view, except the grey background. I can use the basic "Between [Start] And [End]" criteria in the date field of the query, and it works fine. I can also change between other queries as a record source on the calendar control form, and the controls are all visible. What could it be about this one query that is making all of the form controls invisible. |
#5
|
|||
|
|||
Allen Browne Calendar
Mr. Browne, you are a genious!
I read through your link, and found no problems until right at the end. I had one field in the query that was linked to another database written in an earlier version of Access, so the query was unwriteable. I have since broken the links and created append queries for these tables, and everything is working perfectly. Thanks so much for all of your help (and the calendar). I am just a beginner, and have been working on this database for several months. I hope to have it in use by the end of this month, which will make my job much easier. Couldn't have done it without you guys! "Allen Browne" wrote: See: Why does my form go completely blank? at: http://allenbrowne.com/casu-20.html The article explains why the Detail section of a form blanks out when there are no records to display and the form does not allow new records to be added. -- 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. "Jim L." wrote in message ... I am using Allen Browne's calendar, and it is working great. I have used it in my current database 4 times, and need it for one more set of parameters. However, when I use one particular query as a record source, nothing is visible on the form in form view, except the grey background. I can use the basic "Between [Start] And [End]" criteria in the date field of the query, and it works fine. I can also change between other queries as a record source on the calendar control form, and the controls are all visible. What could it be about this one query that is making all of the form controls invisible. |
#6
|
|||
|
|||
Allen Browne Calendar
Great news. All the best for your project.
-- 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. "Jim L." wrote in message ... Mr. Browne, you are a genious! I read through your link, and found no problems until right at the end. I had one field in the query that was linked to another database written in an earlier version of Access, so the query was unwriteable. I have since broken the links and created append queries for these tables, and everything is working perfectly. Thanks so much for all of your help (and the calendar). I am just a beginner, and have been working on this database for several months. I hope to have it in use by the end of this month, which will make my job much easier. Couldn't have done it without you guys! \ |
Thread Tools | |
Display Modes | |
|
|