Search results

Hey all, I am beta-testing my bus ridership DB and can see that a touch screen tablet keyboard is not very efficient to enter numbers for things like head-count or odometer entry. I added a 10 key keypad that works but needs some expert eyes. The driver adds the head-count for the trip based...

Hey all, I am testing to see if my app is connected to the SQL server or not. If it is not, I want to hide the upload button on frm_TripsEditOrUpload. The command Set UpLoadButtonVisible = Forms!FrmTripsEditOrUpload!.UploadBtn fails with a debug statement saying it can't find the form...

Hey all, I have a transportation ridership database I have been building for months now. I am getting to the end. The last part is a stand-alone version for trip entry. I test to see if I am on the network before running DSNLess connection code. When I am attached to the network, everything...

Hey all, Preface - I have not worked in Access or SQL is a good many years and I know things have changed so thanks for the help in advance. I have a working database on my PC where I setup links to 5 tables. On my system, the database works fine. I changed the extension to .accdr to try to...

Hey all, I am not sure this is the right place for this so let me know if there is a better location. I have a small ridership database I am crafting for our school district. The tables are now hosted on our MS SQL 2019 server and the system runs. Most of the database is output is for the...

Hey all, Again, thanks to all who reply. This forum is great for nubies like me. I only have a tacit understanding of SQL server operations and I do have a working knowledge of SQL commands. I most likely didn't do this correctly but I do have a backup. I have a fairly simply Access DB I...

Hey all, I have to report the top 3 headcount days to the state for 3 count-periods during the year... FirstCount (Sept 1 to Oct 31), SecondCount (Nov 1 to Jan 31st) and LastCount (Feb 1 to Apr 30th). I have a query that lists all the bus trips between date X to end date Y. All trips have a...

Hey all, Still working on a Ridership database. On my trip entry form, drivers are to put in the start and end times. I have the fields set to 24hr clock which is helpful but I am wondering if there is a way to capture (to help speed up entry) forms of entry and convert them into proper form...

Hello all, I am crafting a ridership database. The database collects data about bus trips and reports totals to the state on a set annual cycle multiple times a year. Those dates change from year to year depending on the dates the calendar committee set for the coming year so I added a...

Hey all, Another beginner question. I have a simple query that pulls trips by bus by day and totals the trips for all buses by the type of ridership... i.e. basic, sped, etc. How can I make the table show totals at the bottom of each column so we know what the totals are for the year? The SQL...

Hey all, I have a cross-tab query (MileageBreakoutByVehicleByCode) that I crafted from a filter query (MileageBreakoutByVehicle includes the Trips and Vehicle tables). The filter is sorted by vehicle ID which puts the data in a nice ordered format as such. VehicleID is from the Vehicle table.

Hey all, I thought I posted this last night but I can't find it here so my apologies up front if this is a dupe. My first foray into Sub-forms so bear with me. I have a form (Frm_BusSelection_Review) tied to the Vehicle table. the subform is Trip Subform (Image attached along with the...

Hey all, Still working on a ridership database and doing entry checking. I have DepartTime and ReturnTIme. The DepartTime must be > zero. When the user puts in Return time, I am checking to see if it is > DepartTime with the following AfterUpdate code entered. The check works but if they do put...

Hey all, Several folks have noted that my table design is incorrect and I now see why but I can't think of a better way to design it. Here is what I have. Vehicle table - ID, VehicleName, CurrentOD Trip Table - ID, Vehicle, Depart-OD, Return-OD I need to track current mileage per bus. I also...

Hey all, Again, relearning Access after many years away. I am building a ridership database. I have the following sort of working. Each record is associated to a specific vehicle so that's a combo box. Selecting the bus ID pulls the current_OD from the table and puts it into the "Odometer at...

Hey all, First post here. Been a long time since I have done any database work so I am on a steep relearning curve here. I am building a database for our school transportation department to track ridership. They have been using spreadsheets. :-( I crafted the following relationships and have...