Recent content by paradiso

Dear colleagues, I'm a bit chastened, but very grateful for all your posts, and I hope others will benefit from this thread. I tend to go to my thick books on Access programming when I hit a snag, then I search Tek-Tips. Next time I'll check Help too before I call for assistance. regards, p

Friends, In a form's VB module I populate a list box on the form's open event, based on the ID sent to it in OpenArgs. At certain points in the code I test to see how many items there are in the box. The LstActivities.ListCount property returns the actual count + 1. The list box's RowSource...

Friends, My client's IS person installed a secured .mde file using administrator privileges, then, using a routine I built into the program, linked the tables file which he had placed on a network drive. The dynamic link worked just fine. When he logged off as admin, and had the workstation's...

Perfect. The ADO solution is superior to the DAO one in this instance. Many thanks to EasyIT.

Friends, From one database I need to scan the tables another to pick out a certain one and grab its name into a local variable. To do this, I create a workspace and open the database. When I've got what I want, I close the database and the workspace, and set the variables to nothing. Trouble...

A star for you, Ben. many many thanks, p

Dear friends, I join the people who value this most informative thread. Here's another wrinkle. With the help of the suggestions here I have worked up a nice yearbook-style report of photos of members of a choir. Now the director wants it available as a file (apparently he'll want to e-mail...

Dear friends, It's not that the relationship structure is being overwritten, it's that changes are not being saved. Here is my observation: I am creating a database description document and am creating screenshots of table relationships to explain them. I am using a separate copy of my...

Greetings, I made adjustments to the table relationships in the backend database and printed out the relationship diagram. Next day I opened the frontend and encountered a bug that I suspected was a result of one of my changes. I opened the backend and -- no trace of the work I had done the...

Hi friends, Can an Access 2003 mde file distributed with the runtime version (installed using SageKey's software) operate under Windows 2000 Pro? Or can it only run on XP Home and XP Pro? many thanks, p

Curious. I got the Code Cleaner to run by checking the appropriate box (allow access to VBA project) in the Security window. However, I don't see an effect after the recompile/save. The file size is identical and the phantom control references are still there. In a copy of the doc I deleted...

Installed Code Cleaner but got this msg: Programmatic access to Visual Basic Project is not trusted. I am following the instrutions I'm finding to move the code to a clean document, and will keep my ear open to other suggestions. If I succeed, I'll post the results. p

When I use VBA with MS Access, I can decompile and recompile the code by adding a /decompile command switch to the command line in a shortcut (or I guess you could do it in the Start/Run window as well). This has the effect of cleaning up the code, and often reduces the file size considerably...

Friends, Is it possible to decompile the VBA code behind a Word document? I tried the simple '/decompile' command switch but it did not work. many thanks, p

Hi again, My understanding is that ScreenRefresh is a command to do just that. I don't see a True/False property as I see in ScreenUpdating. How does one turn ScreenRefresh off? best to you, p