Search results

  1. T

    Why use a class module in Access?

    Thanks for that link; pretty good explanation. Even better, it included a link to a good MS tutorial on using class modules. I'll study this stuff, and I think I'm starting to grasp the concept, but I'm still struggling with the difference between writing a bunch of code on my form(s) to...
  2. T

    Why use a class module in Access?

    Hi. I used a deliberately (semi-)provocative title for my question. :o I've written tens of thousands of lines of VBA code in many Access databases for my employers over the last several years, but am primarily "self-taught". I have no compsci degree. I've never used a class module in any of my...
  3. T

    Small database grows to 2GB!

    No, the hyperlinks point to files on the local network's shares. What puzzles me when looking at the underlying data in the hyperlink field values is how Access "finds" the file being linked to...when the underlying data sometimes starts with this text...
  4. T

    Small database grows to 2GB!

    Hi. A friend has a small database. The database consists of one table (only 70-80 records)...NO other objects. One or two of the fields in that table are of the Hyperlink type. Anyway, through normal use, this small database file has grown to 2GB! Obviously, it was never compacted, but still...
  5. T

    Can't assign a field's Description property in VBA

    Thanks for the code, but it is similar to some of my other attempts, and didn't do the job. I finally figured it out though. I'm not at my work machine now, but here is the basic sequence of steps my (non-working) code was doing: - open the table - add new field (and set name, type, size at the...
  6. T

    Can't assign a field's Description property in VBA

    Hi. This is driving me nuts. I've written a small routine to update users' tables by adding some new fields to their existing tables. My code iterates through the CurrentDb's tables collection, compares each table, field by field, with a remote table's fields. If the remote table is missing one...
  7. T

    Another MDW file question

    Well, it works, but what I don't understand is why Access lists a different MDW as its current MDW. If you go to Tools | Security | Workgroup Administrator, isn't the MDW file displayed the one Access is currently using? Or is it simply the Registry setting Access has stored showing the...
  8. T

    Another MDW file question

    OK, I'm very familiar with using a shortcut to open a db and "point" Access to a particular MDW (workgroup) file for userids/passwords. I feel that's the _only_ way to set up a networked/multi-user database. Otherwise, a user can get his/her own system.mdw file involved (via "joining" the...
  9. T

    Formatting of a Report from Switchboard

    Hmm...according to my copy of Access, setting AutoResize to No prevents this (what you said) from happening. Not sure what's going on for you now; sorry. Thooom
  10. T

    Printing a report directly from form

    Jared- Use "acViewNormal" rather than "acViewPreview": DoCmd.OpenReport "qry_invoice", acViewNormal, , , acHidden Just write this one single line of code, and your report will quietly print without displaying on screen. Hope this helps. Thooom
  11. T

    Formatting of a Report from Switchboard

    OK, I see what you mean (about "some" users). In the past, I have had to use a form (rather than a report) in place of a proper Access Report, to allow for clickable controls. The biggest downside (in my case) was that this form didn't print quite as "pretty" as a standard report. In other...
  12. T

    Formatting of a Report from Switchboard

    Well, unless I'm missing something, that's the only "normal" thing that should happen. You said you open the report from a switchboard. The report opens (it's just another window on top of the switchboard form). You close the report (you close the window on top of the switchboard form). The...
  13. T

    Formatting of a Report from Switchboard

    Yes and no. ;) Access will let you add a command button to a report, and it'll show up on the page, but you can't really make it do anything useful. Instead, just write a line of VBA code in the OnClose event for the report: DoCmd.OpenForm "MySwitchboardForm" It's not a button, but a user...
  14. T

    Formatting of a Report from Switchboard

    Have you tried setting the report's Auto Resize property to No? I just tried this on a couple of reports (that automatically open up for me resized to fit in the active window....too small to read), and setting Auto Resize to NO allows the report to open up at 100% size. At least on my system...
Back
Top Bottom