Search results

I've crashed repeatedly on the following: when I issue an SQL command to empty a table, the command CurrentDB.TableDefs("tbl").RecordCount continues to show the count BEFORE the records were deleted. And they ARE deleted. Opening the table shows it empty, and functions like DCount give the...

Tried this a while back in AccessForums.net (https://www.accessforums.net/showthread.php?t=84803). Got several suggestions, but no solution or explanation, and the problem continues. ======================== I believe this has started since I switched to 365 - I don't recall it happening in...

I'm trying to use custom events more, and running into some rather odd problems. Main form has a subform with some associated records. In the main form's OnCurrent event, I call a public routine in the main form's code that does some display housekeeping around the subform's contents. All has...

I have two Access databases, both with custom ribbons. In both ribbon declaration files, the first line is: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="LitrRibbonLoad"> Both ribbon files are full of Czech characters, with diacritical marks over some of the...

I tried putting an Internet control on a form, both the ActiveX version and the native Microsoft one. Both open the website okay, but neither one allows something I need. The site is a mapping portal: https://mapy.cz/ When the site is open in a browser, I can press and hold the mouse to move...

I call parameter queries from VBA fairly often, and they work fine - set a reference to the query, load the parameter and the query can then be used as a recordsource: Set qdf = CurrentDb.QueryDefs("HypsoSouhrn") With qdf .Parameters("ID Druhu") = 2669 End With Set rst = qdf.OpenRecordset...

I have a constraint on a table, which I created in Jet SQL, using Add Constraint. I don't know what it says now. How do I read the text of the constraint? The ADOX library seemed the most promising for this, but I have looked at the ADOX object, and see nothing.

I have an Access application that was originally built in Access 2000. Several textboxes and comboboxes use custom right-click menus to call filter routines. The RC menus are built in code, and some are quite extensive - hundreds of items, nested up to four levels deep.When data in a field...

It's been a long time since Access has managed to thoroughly stump me, but ... I have a form called in dialog mode. It has numerous comboboxes, some of which have a huge number of records in their row source. I'm trying to use the technique of having a blank row source, then populating it only...