Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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