Recent content by Garren.Shannon

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...

So in my case, I had a table "Vehicles" with a primary key of VechcleID but was linking to a different field "VehicleUniqID" that was NOT set as the primary which makes is an invalid join?!? And changing the primary key to "VehicleUniqID" validated the query. That makes total sense to me. I did...

BTW... I figured out why I can't edit a query with multiple tables. In one table (Vehicles) instead of using the VehicleID primary key, I created a VehicleUniqID field that was not auto-numbered. I used that field to inner join the two tables but the unique ID was not set as a primary key. If...

Well, counter to what you may believe, I could not have gotten it to the point it is now without your suggestions. I appreciated all your help to date. Sorry, it was not my intention to frustrate you so. Thanks for the advice you did give.

Sorry Pat... I do think there is confusion here and I am not being very clear so my apologies. I have two tables that hold driver and vehicle data (who/what is active and who/what has been added) that the admin team update. The driver needs a local copy of those tables incase they log in when...

Wow... busy week but I am back at this. Pat, thanks for your patience with me. As noted, I created a table in the local DB to store the date of the last check in with the master DB. On app startup, I check the local last update time and if it has been two weeks, the app pulls the updated Drivers...

Great questions Pat. The two weeks test is to download any Bus or staffing record changes from the master LB to the local FB. But your right in that it could be that a driver never syncs. Technically, drivers are required to enter their trips at the end of each day. Often, they come in late and...

Got it Pat... thanks for the pro tip. As you can tell, I don't quite have the ebb and flow of this forums etiquette down yet. I will stick to one thread. Your code worked fine but I could not find a way to shorten the retry time. If done in query, I could set the timeout to be as low as 1...

So you can't change a property of a an object on a form if the form is not open in memory?

Yea... same result.

The UpLoadButtonVisible variable is created at the start of Form_Load(). Option Explicit is included. I will try the .visible... that's one approach I have not tried. But it isn't event getting to that line. It locks up at the SET command.

Oddly, it does compile but blows on run. And the MesgBox() is a wscript wait function I added to test a popup box that auto-closed after 5 seconds. Here's the function. Public Function MesgBox(ByVal msgText As String, Optional ByVal intSeconds As Integer, Optional ByVal intButtons =...

Hey CJ... The form is not open yet at that time and I did not know the forms collection only worked on open forms. In that case, I guess one would simply use the Me. or does that only work on forms that have focus? I wanted to set the button to invisible at the start of the program. Though I...

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...

Got it Pat... I didn't fully read your message. My apologies on that. And your suggestion makes total sense. I originally looked for a try-catch approach but could not find a method. I see this is the method. I replaced the ping code with a GoTo and it is working. The test I put in is to try...