Search results

Micron, the code in autoexec doesn't execute if macros are disabled. There's an 'If' command and an 'OnError' command in macro build. I tried both but get a 'can't find the macro 'errorHandler' in the macro group 'autoexec'. What I want to incorporate in the autoexec is display a message on...

I'm just a neophyte at this so bear with me. From what I see, running any kind of user id/level check in autoexec is useless because if macros are disabled in Trust Center (e.g., database is distributed to new user), or the database has been moved and is not in Trusted Location, the autoexec...

How do you do that outside of using 'autoexec'?

Thanks. I don't want a 'user' level person to see anything except a form that loads when they open the frontend. I've disabled ribbon menus, design shortcuts, navigation pane. Everything I want works except for this hole, which allows any user to stop the autoexec code and bypass user level...

I have an application that has a frontend Access database that contains some forms, and a backend Access database that contains tables which the forms update. In the backend, there is a 'user' table that lists user-ids and their security level, either 'admin' or 'user'. The frontend database...

This works in 'AfterUpdate': Select Case Me.Form_Name Case "Form 1" DoCmd.OpenForm "Form_1" Case "Form 2" DoCmd.OpenForm "Form_2" End Select

Thanks pbaldy. Your suggestion didn't work, at least where I used it in the module.

Thanks Micron. In Autoexec, I want to open a form that has a listbox that lists available forms by their name. I want the user to then select one of the listed forms and then open the selected form. Not sure where the code goes to open the selected form.

I want to restrict users to only a form view when opening a database. There are several forms that the user may use. I can't figure out the VBA I should use to allow the user to choose a form name from the 'Select_Form' form and then open the form they selected. I've tried 'After Update'...

Something like this but I can't get it right? SELECT T1.[F1], Sum(T1.F2) AS SumOfF2 FROM T1 GROUP BY mid(T1.[F1],3,1);

Is it possible to group sums based on the 3rd character within a value? For example, let's say I have a table T1 with fields F1 and F2 with values as this: F1, F2 2A1C, 30 2A2C, 15 2A1D, 20 2A1E, 10 2A2D, 5 Can you create a query that sums by the 3rd character in a field so that the...

Reply erased. Still checking.

The Doc Man, is there a way to calculate the sum of matching pair quantities and then setting the T1 quantity for the associated pair to that summed quantity? I'm worried that if the update query is executed more than once, the aggregate quantities will be wrong. Thanks.

June7, there's too much data for Access to handle on an ad hoc basis. I'm trying to solve a capacity limitation by consolidating key data from multiple databases into more manageable tables that can be queried.

Are you addressing this to me? Do I need the Src field even though #7 seems to be working? Similarly, do I need th 'AS derived' even though #7 seems to be working? Thanks.

I've attached small test database to further explain what I have.

Here's my problem and I need some help, please. Two tables, T1 and T2. Each has three fields, SID, PID and QTY. See my example below with various field values in SID and PID. T1: SID, PID, QTY s1,ps1,0 s1,p2,0 s2,p1,0 s2,p2,0 T2: SID, PID, QTY s1,p1,3 s1,p1,5 s1,p2,3 s1,p2,6 s2,p1,1...

Sorry folks, but I've been away. Like I said, my post #7 seems like it's working. The 6 tables have an F1 and an F2 field. In each of the 6 tables, there are duplicate F1's and duplicate F2's but never a duplicate pairing. I want my result table to have all of the unique pairs from these 6...

These two queries appear to work together to give me what I need: 'Q Union 6 SELECT F1, F2 FROM (SELECT F1, F2 FROM T1 UNION SELECT F1, F2 FROM T2 UNION SELECT F1, F2 FROM T3 UNION SELECT F1, F2 FROM T4 UNION SELECT F1, F2 FROM T5) UNION SELECT F1...

This is what I have: SELECT F1, F2 into myTb FROM (SELECT F1, F2, "T1" FROM T1 UNION SELECT F1, F2, "T2" FROM T2 UNION SELECT F1, F2, "T3" FROM T3 UNION SELECT F1, F2, "T4" FROM T4 UNION SELECT F1, F2, "T5" FROM T5 UNION SELECT F1, F2, "T6" FROM...