Search results

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

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.

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.

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.

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

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

I have a form that displays a list of records. The user cannot edit these records but can select one and click the EDIT button that I provide. This will take him to another window that allows edits to be made to the selected record. This new window has a CONTINUE button and a CANCEL button. The...

If all the records in Table2 are in Table1, is there an easy way to tell WHICH records in Table1 are not in Table2?

I have a form that I have created with a Tabstrip and a large Unbound subform control. Depending on which button on which tab is selected, different forms are bound to the Unbound control using VBA. No problems there. A series of other buttons (not part of the Tabstrip) appear / disappear based...

How complex can you get with the SQL ORDER BY clause? In the QBE, you can only put Ascending or Descending in the Sort cell for a field. But my query is too large for QBE and I have to use SQL. It's working fine, but now I want to add an ORDER BY clause. It needs to be conditional based on a...

Can a SWITCH command return two or more values from a single comparison? Ex: Switch([Field]=Val1, 1, [Field]=Val2, 2 or 3) If I use QBE, I can put 1 or (2 OR 3) on the CriteriaLine depending on the value of Field and it will work fine. But how do I implement this using a Switch command. I...

Can WITH statements be nested? example dim rst as Recordset dim btn as CommandButton dim i as integer With rst If .RecordCount > 0 Then .MoveFirst Do Until .EOF for i = 1 to 4 With btn .Name =...

I have two tables, a Master table and a Details table. In the Master is one record per employee. In the Details table are multiple records for each employee. Each Details record is time and date stamped. If I query the tables, I get all the records from both tables. How do I query the tables so...