I have a customer database that includes the customer and his/her significant other and their birthdays. Field names are fname1, lname1, birthday1, fname2, lname2, and birthday2. (yeah I know it's not very original ;-} )
Would someone help me write a query that would output a single list of...
No locks on the records in the query.
I cannot update any of the fields in the query
Whoops...Yes,when I am in a field of the query, the status bar says the recordset is not updateable...how can I change that?
Regards, Samm
There is no code running that I know of that would lock the records.
The properties are all set to allow the fields/records to be edited....it is a continuous form so that the customer can see that he has multiple calls to make....
I have several fields collected into a form by a query. I want to change the data in one of the fields but when the field (a check box in this case) is clicked, the check box will not change state...merely a ding and nothing happens. Can anyone tell me how I can change the data in a field when...
Thanks for replying, I certainly appreciate it...The check box in the table works fine and when I do the query I use the contents to determine whether or not the record appears in the query...That works fine also..What I want to do is...after the records appear in the form I built for the query...
I have a query which uses a y/n field (check box) in my data base. I've written a form to support the query and want to include the check box. When the check box is not clicked, the record will appear in the query but if the check box is (no) then the record will not appear. The idea is that...
Jane in MA,
Thanks for the simple and elegant solution. I have put a star on your post because it was such a simple answer to a question many others had foundered upon. Yours is the only star I issued.
[wavey]
Thanks again for all the help everyone....
Samm
Thanks, but...Well, if all the people in the table were going to be born in the time period that is specified that would work, but all of them were born in the 40s, 50s, 60s, 70s and 80s. The year is the stumbling block here. It is also a problem on the year end/beginning time period also...
I need a query that will produce a list of people from my table that have a birthday within a two week window that starts one week from the day I run The query. ie; if I run the query today, Oct 9th, the query should list everyone with a birthday beetween the 16th and 30th of October.
Can anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.