Hi Velle,
Did you ever resolve this? I have the same exact problem. The select query pulls up the right records, changing it to an update query and nothing happens. (zero records will be updated) What's wierd is that in the select query, I pull up the records based on a checked off checkbox...
Hello,
Paul, when I type in your code into the criteria line, access interprets it into to separate criteria, the between clause stays with the date field, and the or is null clause moves to the right in the design grid under two new fields: [Enter Start Date] and [Enter End Date], seems wierd...
Tranman,
I apologize for being unclear, my bad. In the case you have suggested, I believe I'll get the records where the date is null all of the time. I actually only want to pick up these records in cases where the user has not specified a date range criteria (in which case I use the code to...
Hello,
Sorry to sneak in here. I'm doing the exact same thing and the suggestion above worked great in all cases except where the value for the date field in the database can be blank (is not required) in which case the stmt:
Between IIf(IsNull([LowDate]),#01/01/1900#,[LowDate]) And...
Hi,
This may or may not help. I have an existing question in thread thread181-586685 where I conditionally lock a form (similar to locking a field) may help you out. Keep an eye out for an resolution to my problem as you may need to watch out for it as well.
Good luck!
Hello,
I have a simple database for tracking customer complaints with 30 users. The database is split and both front-end and back-end sit on the server. There is functionality in one of the forms which sets the parameter of several fields to locked (no edit) if the value of another field...
Well, apparently after a day of frustration, my computer felt bad for me and decided to fix itself. I have no explanation but it is working finally. Please disregard.
Thanks.
Hello,
I am new to this so please forgive me. I have created a database where 2 tables are linked. (Header and Items for example) The relationship is setup as follows:
Header is autonumbered, and that field is the primary key.
Items is autonumbered, and that field is its primary key.
Items also...
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.