Recent content by mredmond

I am not quite clear on the difference between Max() and DMax(). Any clarity would be appreciated. Also, all the examples show Max() and DMax() being run against tables? Can you apply them to a recordset in VBA? What would be the proper syntax? It is not working for me, so either it cannot be...

I have a database in which I keep track of audit projects, the sites visted during each project and the staff members assigned to each project. Each of the three entities are indexed on their Project ID, Site ID and Staff ID, numbered consecutively. So I could have a ProjectID #4, a SiteID #4...

Picture, if you will, an Internal Audit department of a community college system. Each audit project can cover one or multiple campuses. A project can have one report for the overall project or multiple reports, one for each campus. On the master record for the project, I have a check box...

Yep! I've tried it every way you can. I've even tried it with my tongue sticking out. Nothing is working. Is there anything I can run in VBA that would do it?

Restore Menus Nope. That was the first thing I tried. Didn't work. Thanks for playing though. Somebody spin the wheel again.

I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu. How do...

I recently had MS Access 2003 installed on my PC. When I open it up, I get the iconic menu bar, but not the text menu bar. Can anyone tell me how to make the menu come back.

No the tables do not have indices and Yes the tables have identical structures. Of course 1500 records is not large in the realm of databases, but in fact, my problem does not involve simply tables A & B; it involves A, B, C, D ... AA, AB, AC, etc. So to iterate through all the records one by...

I have two tables or recordsets : A and B Both are fairly large, with up to 1500 records in each. Has anyone every written a procedure to determine if A = B or if A is a subset of B? I'd appreciate your thoughts on how to approach this. Thanks in advance.

Thanks for your response. This does work for procedure to procedure, even module to module. But, I should have been more specific. I was looking for a way to know which procedure had issued the OpenForm call. Actually, I solved my problem using the OpenArgs parameter of the OpenForm call. I...

Is there a way to know, from within module C, whether it was called from module A or module B? In the VBA editor, there is a button for viewing the Call Stack. Can this stack be read from within VBA code? Thanks.

This is actually a simpler solution than I had in mind. It works great. Thanks.

Setting Subform's RecordSource I have a form with a large unbound subform area. Depending on which button is pushed on the Main form, I load various subforms into the unbound area. Some of these dynamically loaded subforms themselves have subforms. I want to programatically add a record to the...

Never thought to try that, but it worked like a charm. The print dialog box came up, just like I wanted. Thanks so much!

In my application, I have hidden all toolbars. This also disables the right-click capabilities. This is what I want. I don't want users accidently (or purposely) fiddling with underlying tables, etc. At some point, the user will request a report and the report is displayed in Preview mode...