(Msg. 9) Posted: Sun Aug 23, 2009 11:05 pm
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: microsoft>public>access>gettingstarted (more info?)
Hi John,
I don't have a button, but I have read up on the VBA behind setting it up...
let's just say that it didn't take. But still trying.
John Spencer wrote:
>No forms do not become read-only just because they are based on a query.
> As long as you update records in the query, you can update records
>displayed on a form using that query.
>
>And you apply the criteria against your date field.
>
>I am not clear on whether or not you have a button or other method to
>initiate a requery based on your entries in the two unbound controls.
>
>'====================================================
> John Spencer
> Access MVP 2002-2005, 2007-2009
> The Hilltop Institute
> University of Maryland Baltimore County
>'====================================================
>
>> And remember that the fields BeginDate and EndDate are unbound and therefore
>> not part of my original table.
>[quoted text clipped - 10 lines]
>>> [quoted text clipped - 8 lines]
>>>>>> Chris
(Msg. 10) Posted: Mon Aug 24, 2009 1:38 am
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Chris75 via AccessMonster.com" <u54211@uwe> wrote in message
news:9b0a3a454d728@uwe...
> Hi Arvin,
>
> If I based the form on a query instead of the table, would my form not
> become
> read-only? I want to be able to enter schedules as well.
>
>
> Thanks.
>
> Arvin Meyer [MVP] wrote:
>>Sorry, that was wrong, it will prompt a second time. Instead use:
>>
>>Select * from tblSchedule Where DateField Between
>>Forms!Schedule![BeginDate]
>>And Forms!Schedule![EndDate];
>>
>>and make sure you change the names of the table and date field to match
>>yours.
>>> Base your form on a query, instead of a table. The query should look
>>> like:
>>>
>>[quoted text clipped - 20 lines]
>>>>
>>>> Chris
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200908/1 >
(Msg. 11) Posted: Mon Aug 24, 2009 6:05 am
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks. One thing. I inputed your criteria and I get an invalid syntax
error.
Select * from tblSchedule Where DateField Between Forms!Schedule![BeginDate]
And Forms!Schedule![EndDate];
What is missing from the above? The fields and table names are the same.
Arvin Meyer [MVP] wrote:
>As long as you can edit the query, you will be able to edit the form.
>> Hi Arvin,
>>
>[quoted text clipped - 18 lines]
>>>>>
>>>>> Chris
(Msg. 12) Posted: Mon Aug 24, 2009 7:44 am
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Chris75 via AccessMonster.com" <u54211@uwe> wrote in message
news:9b1172be6ffad@uwe...
> Thanks. One thing. I inputed your criteria and I get an invalid syntax
> error.
>
> Select * from tblSchedule Where DateField Between
> Forms!Schedule![BeginDate]
> And Forms!Schedule![EndDate];
>
> What is missing from the above? The fields and table names are the same.
>
> Arvin Meyer [MVP] wrote:
>>As long as you can edit the query, you will be able to edit the form.
>>> Hi Arvin,
>>>
>>[quoted text clipped - 18 lines]
>>>>>>
>>>>>> Chris
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200908/1 >
(Msg. 13) Posted: Mon Aug 24, 2009 2:05 pm
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The table name is jsut Schedule. The date field is just Date.
Arvin Meyer [MVP] wrote:
>Is the Schedule table name tblSchedule? How about the date field in the
>table, is it named DateField?
>> Thanks. One thing. I inputed your criteria and I get an invalid syntax
>> error.
>[quoted text clipped - 11 lines]
>>>>>>>
>>>>>>> Chris
(Msg. 14) Posted: Mon Aug 24, 2009 2:05 pm
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Consider renaming your field. Date is a reserved word, and should never be
used as a field name.
For a comprehensive list of names to avoid (as well as a link to a free
utility to check your application for compliance), see what Allen Browne has
at http://www.allenbrowne.com/AppIssueBadWord.html
"Chris75 via AccessMonster.com" <u54211@uwe> wrote in message
news:9b1597b3da583@uwe...
> The table name is jsut Schedule. The date field is just Date.
>
> Arvin Meyer [MVP] wrote:
>>Is the Schedule table name tblSchedule? How about the date field in the
>>table, is it named DateField?
>>> Thanks. One thing. I inputed your criteria and I get an invalid syntax
>>> error.
>>[quoted text clipped - 11 lines]
>>>>>>>>
>>>>>>>> Chris
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200908/1 >
(Msg. 15) Posted: Mon Aug 24, 2009 3:05 pm
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Douglas,
I had just finished reading one of your other posts regarding this. I will
change the field name and seet what it gives me.
Question:
Would it work best if you could actually see what I was talking about rather
than me describing it?
Douglas J. Steele wrote:
>Consider renaming your field. Date is a reserved word, and should never be
>used as a field name.
>
>For a comprehensive list of names to avoid (as well as a link to a free
>utility to check your application for compliance), see what Allen Browne has
>at http://www.allenbrowne.com/AppIssueBadWord.html >
>> The table name is jsut Schedule. The date field is just Date.
>>
>[quoted text clipped - 5 lines]
>>>>>>>>>
>>>>>>>>> Chris
(Msg. 16) Posted: Mon Aug 24, 2009 3:05 pm
Post subject: Re: Date filter [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If by "see what I was talking about" you mean you want to post a copy of
your database, the answer is no. Binary attachments are not desirable.
"Chris75 via AccessMonster.com" <u54211@uwe> wrote in message
news:9b160d65268ce@uwe...
> Hi Douglas,
>
> I had just finished reading one of your other posts regarding this. I
> will
> change the field name and seet what it gives me.
>
> Question:
>
> Would it work best if you could actually see what I was talking about
> rather
> than me describing it?
>
> Douglas J. Steele wrote:
>>Consider renaming your field. Date is a reserved word, and should never be
>>used as a field name.
>>
>>For a comprehensive list of names to avoid (as well as a link to a free
>>utility to check your application for compliance), see what Allen Browne
>>has
>>at http://www.allenbrowne.com/AppIssueBadWord.html >>
>>> The table name is jsut Schedule. The date field is just Date.
>>>
>>[quoted text clipped - 5 lines]
>>>>>>>>>>
>>>>>>>>>> Chris
>
> --
> Message posted via http://www.accessmonster.com >
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2, 3, 4
Page 2 of 4
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other