Search results

And what event would I trap? I want this to happen after I finish executing some SQL code that either inserts or updates a specific record in an auxilliary table. That does not raise any event that I know of, hence my use of a custom event. Also, the way you describe, even if it is possible...

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

When I substitute things like & # 352 ; to display Š the characters display correctly, so I have a workaround available. I'd rather not use it, because it makes the RibbonML file very difficult to read, and there obviously is some way to make it work, since one of the databases displays all...

That option is set in both databases, and has been all along. Neither announces an error on load, and all controls in all ribbons work correctly. Only the display of some foreign characters is messed up, and only in one of the databases.

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 have, in fact, that was my first thought on making use of the site, but I have not been able to do anything with it. It is a bit outside my areas of expertise, and I don't even know where to start. I've asked around at work, written their help line, looked for web tutorials, but have gotten...

It's a local mapping site for this country, and has better local information than any other site. Since the user of this database is a local zoologist, and the data in it is exclusively local sightings of local fauna, this site is by far the best for his use. A different one would work, of...

I've written them several times in the past about other issues. For technical questions, they're about as helpful as gravel on an ice rink.

You're right, the Google site works properly. Any ideas on how to make the Mapy site work the same way?

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

Try putting a breakpoint on the the line rs.Fields("Cert") = strDocand see what is in the field rs.Fields("Cert"), and in the variable strDoc. Then press F8 once, to execute that statement, and examine those two again. What is on those two storage locations before and after executing the statement?

Oh, good grief - is that how to do it? Submit the parameter to the final query, even though it actually belongs to an earlier one? Seems like that should have occurred to me, somewhere along the way. Just tried it and it works great. I also tried chaining several parameter queries, and I had to...

Are you certain that your comparison is correct? The line:If rs.Fields("Cert") = Me.ListBoxStateLic.Column(3) Then will skip the entire recordset manipulation if there is not an exact match. I just tried your code and it worked fine, updating the table with no problem. My first suspicion would...

Yes, exactly that.

Or maybe I misunderstood your need. Did you want to add information to an existing record, or add a completely new record? If the former, my first answer holds. If the latter, then you should do it this way:rs.AddNew rs.Fields("Cert") = strDoc rs.Update

I'm surprised that doesn't throw an error. Seems to me it should, but I just tried it myself and it doesn't. In any case, the .AddNew is what is throwing you off. You want to use EITHER .Edit, for altering an existing record (which you must first locate), OR .AddNew to start a new record. Then...

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

Yes, these are the ones I was looking for. Thank you.

That just lists indexes, no? Are there not check constraints possible for the table that don't show up in the GUI?

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.