Search results

Good to know!!!

That seems to be it - it was stopping and ACCDE didn't know what to do. Sorry!!!

Hold on... it might be the STOP in the code that I meant to add more logic to...

Can't walk the code in accde file unfortunately. Just accdb where I can't (yet) re-create the error.

Things get as far as "Call subShowMessage("Running report: " + pReportName, "Report")" at least I know that - because that calls a pop-up that does show up just fine.

Thanks. Option Explicit I always add. Compiles fine too. I recompiled accde file and the code ran fine one time. I click on another record and go back to original record, click the button, and it fails again. On event... Private Sub btnCreateReport_Click() Dim sReportName As String...

Hi - getting the above error but only in the accde version (so I don't know where VBA is broken). In full accdb file, no problem. I confirmed all References are good. Suggestions please?

Hi - using this code below which works for me, but only partially works for others on my team (ribbon and system objects are hidden, but navigation pane is still visible). Any suggestions? DoCmd.ShowToolbar "Ribbon", acToolbarNo 'hides ribbon DoCmd.SelectObject acMacro, "AutoExec", True...

Thanks - I had some SQL but commented it out for now... still getting the error. Edit: I rechecked and cleaned out some other SQL and I think that may be it!

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.