I started a database for entering ambulance run reports last month. So far, everything is going great with it. As expected, I am always trying to improve upon it as I learn more things.
What I need help on now is auto generating the incident number. Starting the new year, the first incident number will be 20080001. I want to make it where when we create a new record, the default value will see what the last record's incident number...
thebuzzman
Last Activity: Jan 10 '08, 09:37 AM
Joined: Dec 20 '07
Location: Lake Charles, LA
-
increase value of last record by 1 automatically in new record
-
I used this code and it works great. I wanted to thank everyone for their input. It's sites like these that make the internet so valuable.
Mike... -
I will try this code when I get back to work. If things go right, I will not return for another week.
I wouldn't expect that we would run a report on past medical illnesses, so this should be perfect. If we ran a report, it would be off of what the current illness is, and that would be another field (Chief Complaint) with a single entry.
Once again, I appreciate the feedback.
I hope you all have a Merry...Leave a comment:
-
Adding data to a field from combo box
I am creating a database for inputing ambulance run sheets. I have a table that lists different history conditions (HTN, CHF, Asthma....) In my main report form, I have a combo box that gets its' list from that table.
I want to be able to select from the list and then hit a command button next to it that adds the current data to another field, labeled history. I then want to be able to make another selection from the same combo box...
No activity results to display
Leave a comment: