Getting closer-thank you!. I have been able to get the State field update to work from both the AfterUpdate on the VDate(Verified Date) field and the Before Update for the Form, but only if I only put one selection criteria - example:
If (Not [VDate])Then
[State] = 2
MsgBox...
I tried Omega36's suggestion with the IF/Then statement on the Form_BeforeUpdate(). I've got the code entered and no errors are reported, but the [state] field doesn't get updated. I'm not sure how to tell if the code is wrong, or not running at all. I haven't implemented any ELIF statements...
I need to update one field based on the entry in one or more other fields. The scenario is that we have an incident "state" field, which will be a value between 1 and 4. The value for "state" corresponds to a series of date fields on the form. Right now, "state"...
Our database has an autonumber field as a key field. I need to append records into the database and then adjust the autonumber so that the next added record assumes the correct id number. I've tried following the instructions in the help files, which are basically to create a new table with...
I have created a report that prompts the user to enter a starting and ending date so the query can select records in that range. The header of the report includes the date range in the title. If there no records in the range, the report is blank (correct) but the header prints out for the...
Thank you for your response on this thread fields ". I wasn't able to get much accomplished using this approach. I could certainly make the headers, but not get the criteria selected properly. I have had much better success by using subreports. I have one remaining problem. If you have...
I am trying to create a report with several sections. Each section selects the same fields from the main table, but using slightly different criteria based on one or more date fields. After much trial and error, I stumbled on using subreports. After even more trial and error, I now have a...
I am trying to create a report based on some date fields in our database. We have "Fixed", "Verified", "Delivered", and "Closed" (all date fields). Selection for the report needs to be based on if ANY of those fields have a date in them (but at least one...
Thanks for the suggestions. I guess I've left out a few details and/or I'm confused. I have three fields on my form. Each is numeric. The valid choices for each are selected via a combo box pull-down list. When any entry or change is made in any of these three fields, I would like a fourth...
I'm real beginner on creating Access forms. I've fumbled my way through most of it, but am stuck on how to get a calculated value to display onto the screen and also update into a field in the database. Example: Priority, Rank, and Status are all numeric fields entered by user...
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.