Search results

OK... the Insert Into command is simply not working. I can't see what I am missing. I print the strSQL string out in a message box and it shows accurate data so it is pulling from the local query correctly. I have 16 fields and 16 sets of matching data. I am getting a syntax error in "INSERT...

BTW... not sure why but Debug.Print strSQL does not output anything. I must not understand how to use that function.

Thanks Isaac, I am following your lead. You are the natives in this Access world, I am (currently) the immigrant. I spent a few hours last night trying to get this to work. With such a long Insert command, I have something in there that isn't coming across right. I don't thing brackets would...

Thanks Isaac... so very helpful. If I have a date field, do I have to format the value or can I just do rs.fields("T-Date").value this is hard to read but I crafted the insert string. Looks like this and I get the output below. Just learning to crawl here so I am not taking any actual actions...

Thanks again Isaac... and thank you for the Recordset primer here in the Info Sharing Center. VERY helpful. Question... I have a transferquery that filters only records with the archive field not set to yes. I am opening that record set and will do while <> eof. I am also opening the linked...

Hey Isaac, Thanks for the direction on this. I copied the original DB (prior to migrating it to our SQL server), then removed all forms except the one the drivers will use. This leaves the core of the data individualized as it were. Then I added a dbo link to the SQL trips table. The drivers...

Pat... I think I understand what your asking so let me clarify. The master DB resides on our SQL server. Each driver will have a Surface Go with Access on it. They will have a stripped down version of the program with all the DB's and just a form for entry. On occasion with they are at the...

Hey all, Circling back to this. I decided to create a sub-DB with just the trip database but linked with a dbo to the SQL stored master DB. I added an archive flag (Boolean y/n) field to the local trip DB. MY thoughts now are to add a button to the start page to allow the drivers to copy/append...

Thanks The_Doc_Man... that's what I was leaning to as well. Decades ago, this would be done via transaction tracking. In access, I am assuming this is an SQL command and I have to look for a True or False response from VB code to see if the command completed successfully or not. Am I guessing...

Sorry for the delay in responding. I have been distracted by a $1million dollar grant I landed to build a fixed wireless network in our area... but I am back at this for right now. As I noted, it has been many years since I worked with data and things have both changed and stayed the same... I...

GPGeorge, Back in the day (1990), I use to support AT&T 3B2 sub-stations for data lift to Data General mainframes when I was in the USAF. It seems maybe a stand-alone app that can "upload" trips to the main DB would not be a bad idea. Since the buses are often outside network service ranges...

Thanks Pat... I got 365 and Power Apps mixed. I heard that Power Apps can be tied to a SQL BE though after looking deeper into it, it seems like a heavy lift on my end... one I am not ready for. I will go the FE route and get just the trip form working as a stand-alone app tied to out SQL for...

:LOL:

Thanks The_Doc_Man and GPGeorge. I am very familiar with both RDP and Citrix. I will review the video links so thank you. A follow-on question here. If I extract the form and supportive queries and linked tables, is it possible to deploy just those feathers of this database on the Surface Go's...

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

Thanks Minty... you are a quick witted wizard. :D

Got it... Thanks Minty... but I am getting the following when trying to modify the tables.

Hey all, So my next hurdle... after migrating the tables to SQL, I note that the primary keys no longer auto-increment. Of course, in Access, one sets the field to auto-increment. When running the DB now, I get "cannot insert null..." which I am sure reflects the lack of auto numbering. I don't...

OK... so I ran into not-sure-what issue. When testing adding a new record, the action complains that my primary key will not accept nulls. I am guessing it's because the metadata of setting the key field to auto-increment did not transfer. How does one now go into SQL and tell it to...

I didn't even know you were thinking reverse. :D So no problem at all.