Replies

Has anyone managed to get the Verbatim Mediashare Mini working? It looks awesome, but so far I’ve had no joy actually getting it configured and working.

Verbatim’s site is totally lacking in documentation. There’s some that seems to apply to the full-blown Mediashare box, but nothing at all that would help troubleshoot the Mini.

I was looking for something similar, and found this code on Microsoft’s website. I cleaned the code up to my own standards and it worked like a charm: http://support.microsoft.com/kb/210581

Back your database up first.

Next thing to do, open the VBA editor and Clear All Breakpoints (CTRL+SHIFT+F9). Now compile your application(Debug>Compile). Assuming you’ve got Option Explicit set and declared all variables properly, it should compile.

Run a Compact and Repair (depends on the Access version where you find this – use Help if not sure).

If your application is still hinky, then try a decompile. From the command line or from Start Menu, Run use
“C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE” “D:My DocumentsPath To My DatabaseMyDatabase.mdb” /decompile

(Note if there’s a space in either path, you must use quotes. Replace with your actual paths, of course.)

Now do another Compact and Repair, then finally Compile again, and do a final Compact and Repair.

If that hasn’t fixed it, then create a fresh database, and import all your objects into it.

If that hasn’t fixed it, you’ll have to rebuild the report. Save the old version with a new name so you have it for reference.

Good luck.

Try the various other methods of scrolling, or a different mouse. Try creating a query that retrieves the same data as the form and see what it contains. I’d expect that it’s much more likely to have a grungy mouse than on-again-off-again weirdness in the data.

Access will be able to handle this. You use a combination of Grouping and Sorting to organize the data, then use Can Grow, Can Shrink, Force New Page, and Keep Together properties on sections to control how the data displays.

You may not be able to have the data split conveniently at halfway, but you should be able to ensure that you don’t get the widows and orphans.

Now, be warned, you’ll go crazy getting this just right! I’ve been working with Access for fifteen years and I still get into a muddle with getting reports to behave exactly as I want. Every now and then there’ll be a situation where it takes a lot of trial and error and fiddling to get it to work just right.

You may want to try SQL Server Reporting Services too – I don’t have much experience there I’m afraid.