Search results

` Mostly for working with an SQL Server backend, but also other external sources.

Thank you for this. But it's solved. I hope that you had this function just sitting out in the garage or something, because that's a lot of typing.

GOT IT!! Thanks again for the video. When I looked at it, I thought it's not exactly like mine, but didn't think it would matter. All I did was add: ADOrec.CursorType = adOpenDynamic So, I have: Set ADOrec.ActiveConnection = ADOConn ADOrec.LockType = adLockOptimistic...

Yeah, I edited out a comment before posting, and that was a casualty. The actual code is the same but with ADOrec.open BELOW: Dim ADOConn As New ADODB.Connection Dim ADOrec As New ADODB.Recordset ADOConn.ConnectionString = "Driver={SQL...

Thanks for going to so much trouble. Yeah, it should work. Maybe there's another conflict. Would you be able to copy and paste my code in your system and see what happens? Dim ADOConn As New ADODB.Connection Dim ADOrec As New ADODB.Recordset ADOConn.ConnectionString = XXXX Your...

In my SELECT statement, in the first post, I used the square brackets, but with Yeah, this should be working. Thanks for going through that amount of trouble. Imagine, they don't have jelly bean emoji? Maybe you could paste my code in your system? Public Sub ADOTest() Dim ADOConn As New...

I think I said that it doesn't work with save either. Yeah, not particularly clearly, but that's what I meant up in #10.

Thank you for elaborating. All of this is helping to form a better understanding. And any coding info is always welcome.

Thank you for bringing this all to my attention, I have focused on it, read a chapter in my "bible", and have watched several videos to get a more well-rounded understanding. This will help a great deal.

I tried it. It didn't work. That's up there in post #10 Almost all of these work EXCEPT those with ordinals AND those that use ("field name") That's been my experience. Maybe it's SQL Server 2016. But you can see my code down below, perhaps someone can try running my original code and see if...

I've done a few tens of trials. Made sure that my SQL statement was correct and it works for Save and Update. AND Works with AND without .Fields without ordinals. Works with ADOrec("fieldname"), but not ADOrec("field name")

Yeeh. Thanks. I haven't put a space in a field name in my life, it's not my creation and renaming the fields, and everything they relate to, is beyong the scope of my duties and willingness.

I looked through the help and found that, but it yielded something about an improper accessor, from what I remember.

I've tried out the Index dialog; named the index, selected several fields to represent the unique characteristics of each entity and close the dialog, but the fields in the field properties do not say that they are indexed.

I'm probably misunderstanding; the issue is with the "Job Title" field. If I used "Address", it goes right through. And I would suspect that if I used "JobTitle", it would go right through. "Company" updates no matter what I put in: "Teddy's Company", "Bubby's Company"...all of that kind of...

Hola Muchachos y Muchachas! As you can see it's pretty festive here with the slew of errors that are getting thrown from this one statement. Any ideas why, ONLY WHEN I HAVE a SPACE in the field name, i get this error? Gracias!

Okay. Thanks so much.

I'm sorry, I mean that even the composite keys should be set with little keys next to them, or is it sufficient to just make them indexed?

You mean to set all key fields to primary keys, right? Not leave them as merely indexed.