Search results

So I'm just adding a timestamp data type to each table? And name it what I want? Edit: I added it such a field to all tables - no joy.

Thanks - what's strange is I put a breakpoint on any/all code that would run upon data update and the error hits first before the code. And I added a field called "rowversion" that is a TimeStamp in SQL and was still getting the error. Any specific threads you suggest I look at? Thanks again.

Access is connected to SQL Server database on Azure. When changing a record, all of a sudden I'm getting this error. Please help? Tried this idea (see link below) and didn't seem to work...

Never mind - I'm an idiot. I needed to grab the username in the On Delete event first THEN test in the Before Delete event (the names are confusing... Before sounds to me like it comes before anything else!)

I have let's say 2 records in a subform. Record 1 has username A and Record 2 has username B. While I'm focused on Record 1, I want to test that the record can only be deleted if username = B (but it's A of course). So I test in "before delete confirm" what username is. And referring to...

Thanks - unfortunately I've found not all do.

Hi - is there a mostly trouble free way to make sure front-end connect well to SQL server? We share an Access front-end with multiple users and sometimes they have SQL Server driver, and sometimes ODBB Server 17, so getting the right connection string can be tricky. In the past, I've used code...

Thanks all. Current set-up: Access front-end connected to SQL server on Azure server Wondering if DataVerse is as powerful as a front-end (user-friend forms, VBA capability, etc.) - does it work as an Access replacement? or more of a back-end storehouse? For PowerBI, just want to confirm what I...

Has anyone explored using DataVerse? And/or PowerBI? I have questions please.

What's weird is that IsLoaded = false, but it won't let me delete it, even manually!

I did DoEvents still no luck.

I'm actually running that code from a general module. And I've tested that the form is not Loaded before I run this code. Would subforms be a culprit?

Hello. I have a MAIN form that needs to differ depending on the situation. So I have two TEMPLATE forms that I want to use to replace the MAIN form. So roughly the logic is this: Close the MAIN form Delete the MAIN form Copy TEMPLATE_A or TEMPLATE_B and rename them into MAIN form The problem...

Not sure I'm following this item...

Thanks everyone - great insight. If you HAD to give up Access tomorrow... what would you go to. that you think IT would support? Visual Studio? Something else?

There is talk at my company of Microsoft slowly supporting MS Access less and less (not sure I believe that) and/or our IT dept supporting it only through say 2026. What are you hearing? And what alternatives are out there that allows for connecting to SQL server data, user-friendly forms, and...

Thanks all. Need to dig into it more.

Can't open a form whose underlying query contains a user-defined function that attempts to set or get the form's recordsetclone property. Just started seeing this error all of a sudden on Access front-end that accesses Access back-end DB and SQL server. Any suggestions?

Duh?!?!?

How to refer directly to Excel function within Access VBA, please? Thanks! Old database has this coding which is bombing... Abs(Round(Excel.WorksheetFunction.Days360 I get "variable not defined" for the "Excel" word.