Search results

Thanks all... you guys are AWESOME!!! The DSN-Less connection worked best for this application. This group is a true godsend. :D

Thanks DB Guy. I have never done that before but it was easy enough. Can you program Access VB to include a file based DSN on load?

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

Thanks CJ... sorry I am not familiar with the dbInconsistent command but I did find by trial and error that if I simply removed the joins, I was able to iterate through the records set. However, I know Pat is right about the join. It was working before I updated the tables... even with the...

Hey Pat... once again, thanks for being a font of knowledge. I know how to iterate through a record set but how can I update all the records in a query with the batchID I crafted. I only know how to walk the record set. Here's what I have. I know this seems arcane but I test to see if I can ping...

I think I figured it out. I don't think you can update a query that has calculated fields or a join from another table. I created a query with just the Upload flag and I can edit the table with that data. It seems count-intuitive to me that I can't edit a record based on a combined table query...

Well, I proved it to myself that looping through a query does not change the record pointer in the table that the query is based on. Why is the query locked for editing? Is it in the SET command???

I am running into a problem with a query recordset being locked for editing and I need some clarity here. I assume this is normal?!? The table Trips is editable but a query I created, "transferquery" is not and I don't know if this is standard. Here is part of the code. All I want to do is...

Done... Question about db.OpenRecordSet. If you set a variable like db = CurrentDb, then set rs = db.OpenrecordSet. Can you work with a second record set? Like rs = db.OpenrecordSet ("Trip", dbOpenDynaset) then rs2 = db.OpenRecordsSet ("SomeQuery", dbOpenDynaset)???

First Pat... thank once again. Adding Option Explicit did help a ton. Turned out it was the PingOK function. When I put a return at the end of the command line, the issue went away. I could not see any hidden chars in there but it stopped erroring out. The explicit option also helped to clean...

I am so close guys... really. And thanks for the help. I am running into a challenge with compile that I can't see why. Getting "Only comments may appear after End, Sub..." error in my module. This was all working before I started to comment my code. Now it's erroring. Not sure if this is the...

Thanks Minty... So the next dumb question from this old novice is how? I was digging into options last night. First, I now have a method of verifying I can ping the SQL server prior to doing any uploading. I looked into an update method and an append method but that does not guarantee the DB's...

Hey Pat... Something just hit me that, to be honest, I should have thought of before but didn't. I have all the master tables located on the SQL server like ,dbo-drivers, dbo-Vehicles, etc.. I also have the off-line version of those tables copied to the local drive. In my entire build of this...

Again, thank you Pat... your input is so very valuable to me and I really do appreciate it... and your time. I think I am finally getting your point. BatchID's are making sense. As I am thinking through this deeper, I think I need to craft a batch ID that is unique to the device the upload is...

You make a great point... it has been one of my concerns. If the driver does not do their part, how will the admin team ever know. OK... I will look to implementing this approach. Though, as I think about it, if the driver is not doing the sync part, how would file transfer be accomplished? It...

Again Pat... thanks for the guidance with this old novice. What I have right now is an Administrative App and a Driver App. The admin side works directly with the SQL ridership tables. The driver version has a stand-alone table set because they will often be disconnected from the network but...

Thanks Pat... you are awesome. Seriously. I did FINALLY find the debug window. I realized I have issues with delimiting the fields... I just couldn't see it. I dropped that approach and followed your suggestions. It working now. I adding some checks and balances now but I used the append query...

OK... I figured out how to turn on the VBA "Locals" window and found what the strSQL string was passing... well, mostly. The window does not show the entire content of the string. There must be a better way to display the actual command and I simply don't know it. Here's what I can copy out of...

Tried to Pat but the Msgbox (which is the only print out I see) does not allow me to highlight and copy text. I totally understand why one would want the actual output. WHERE should I be seeing the debug.print output? I don't see it anywhere. Also, I took your lead on the append query. It came...

I thought that is what the Debug.print strSQL statement did? It right above the MsgBox() statement and that works so not sure why I am not seeing what the CurrentDB.Execute command is getting but it should be this command. BTW... I added #'s around the time fields. They are actually a date/time...