Search results

No, tried that. A message box works, the question is why. Also checked with various versions of Flash, and various settings of the activex component. Nothing seems give a good result.

Well, I would only like to cheer up my application a bit by adding a flash banner. And the content (text) would be controlled by my database, but that's not the question here. I just want to know what I'm doing wrong, and I hope someone's got a clue.

Well, if you save the entries that came from the barcode reader in a table, a simple query with a count can generate the number of entries. Let's say the value of the barcode is 1234. SELECT Table1.value, Count(Table1.value) AS CountOfvalue FROM Table1 GROUP BY Table1.value HAVING...

I've created a form with a (simple) Flash animation on it, but it runs very choppy. But when a message box is active, it runs perfect. It seems that when the focus is off the form, it works fine, but otherwise, it doesn't. Any ideas? :confused:

mmm, that animated gif does work! Thanks for the tip. An indepth study how to create those gifs is about to follow.....

I can understand your opinion about this. Do it simple. I agree on using the basic Access functionality, the best way to avoid complex work-arounds. But I've created an action menu, with several different kind of functions, on the right of the sub form. If the delete button was on the sub form...

I would like to juice up a form with a little animation (logo). I tried embedding a Flash movie, but it will only run in a seperate window, and that's clearly not what I want. Placing an animated GIF in a form doesn't move a bit. Any ideas?

This might be a good tip, but how do I use it when my button is on form level, and the record to be deleted is on a sub form? If I execute this it will delete a record on form level, not on sub form level. It would really help me, if this would work, the scrolling down after running the query...

Well, I'm running a SQL DELETE statement in VBA, which deletes one record from the sub form. If you don't use a requery, the record will still be visible in that form, though it doesn't exists anymore. Anyway, I tried the recordsetclone, but I get an error running this line: Set rst =...

After a refresh of the sub form, I want to go back to the last record edited. This might be a record not fitting on the top of the screen, let's say record no. 2000. After the refresh the sub form shows the first records, and you need to scroll down. How to solve this?