Search results

Well noted

Realized that this is a live database, If we load a run, you will get it LOL

Realizing that as the monster grows. Trying to have a naming convention, but I rushed to get things done in between work.

tblRuns are the calls we run on, to include, type of call, actions taken, mutual aid, apparatus used, responders and the Incident Commander or "Fall Guy".

The main start of the database came from when I worked for Arkansas Forestry, I needed to report local fire departments and Forestry equipment in use. tblPer and "43 Fire Dept" were the main two tables. the database sat for years when I left forestry and became a paramedic and volunteering on...

Will this work? I had this file under Users/Alan Falcone/Desktop/Fire/2 Database. Reports went to folder /2.1 Web in same folder. This is a copy, patient and responder info removed. https://drive.google.com/file/d/1cDGLrY2Mj6xgSN_44u5Yy-tQAFzc9CQ_/view?usp=sharing

Scared to delete items since I was in a pinch to catch up with needed info. So I bulldozed a pile and and moved to the next disaster, creating organized chaos of piles. I am not currently chasing the next disaster so I can take a breath and see the damage I have done. So now, IT WORKS-DON"T...

So I created a database. Looking for insight to whether or not I am on the right track and where to go next. The need rose from gather fire call data in a rural volunteer fire dept. Most medical calls are responded to personnely, no fire apparatus. An incident is recorded with Google Forms that...

I use a form to select my dates for my reports. It's an unbound form that uses first of or last of dates. Mine is formatted to year or quarter for the past year

I implemented the use of google forms with our Volunteer FD to input run information. That in turn is auto downloaded to Access and parsed, queried. No longer worried who did the run paperwork or if it was turned in, Now trying to upload it to ESO solutions for the National Fire Information...

I'm guessing no backup. May have to recreate it. I backup my DB after major changes and have about 20 backups with my original starting DB on the web (Dropbox, google drive ....) Then when I screw it all up, I open a previous version and rename the malfunctioned object and copy over the backed...

Would a Select Case work?

Just having FUN! Making a DB for my local volunteer Fire Dept

It crashed my program:banghead:

This is what I came up with, As I input a new year in the date field, the new seq num starts Private Sub Form_Current() Dim strThisYear As String Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() strYearNow = Format(Now, "yy") strrnums = DMax("RNum2", "TblRuns") strThisYear...

Trying to do this in MS Access VB. Had it working in test runs then messed it all up LOL. So starting over with: Me.ProjectID = ThisYear & Format(Nz(DMax(Right("ProjectID", 3), "tblProject", "Left(ProjectID,2) = '" & ThisYear & "'"), 0) + 1, "000") Can't make it sequence to record 002 " + 1...

Make an Append query and then view the query in "SQL". Then execute it with your cmd button. The query should only show those not already in "Customer_List" table or you may duplicate entries. May need an "If" statement to enable the cmd button based on your query results, that may clue you

If you had not asked I would not know how to fix my DB, Thanks