Recent content by JenSGT

How do I create the pq (ascending/descending sort) in a subform title bar? (note: subform is display as datasheet) Name Course Start Date Course End Date Amount Paid pq pq pq pq...

How do I use dao to read the group access? any code tips?

I am referring to Access User Level Security.

I know CurrentUser is able to display the current username. How do you display the current User's group in VBA? If a User belongs to at least 2 groups, will VBA be able to detect which is the default group? Thx for any code tips...

How about importing objects after the User-level security wizard is ran? Will the imported objects also be secure without running the User-level security wizard again?

How do I ensure the new objects created after user-level security is run remain secured? If I want to programmatically set the permissions for the groups, how do i do that ? Thkq, any tips is appreciate.

I created 3 Groups, Primary, Secondary & Tertiary with different permissions. The permissions are set at the group level. Everytime, I use the security wizard to add a new user and re-run the security on the new objects, the created groups permissions will be completely remove and the created...

I am working on a treeview control. It has 3 levels. What I would like to display is no checkboxes on level 1 and level 2 but display checkboxes in level 3. How do i code in VBA? Any tips is appreciated.

After applying your tips, my users did not complain. Thanks, Bob.

I have a form with 10 tab pages. On each tab page, I have at least 2 subforms on it. I have a search button on the main form where it will search for the relevants records based on user data input and display the associated tab page. My db is place on the file server. After I hit the search...

Your advise works. Thanks, Bob. :)

Developing a form with filter parameters which will generate a excel spreadsheet when click on the Excel button. At the same time, the form has capability to decide the sort for 2 levels which is then pass to excel using VBA. The sort VBA code works fine whenever I opened the form for the...

Is it possible to code in VBA to retrieve the userid and password of the users in the database?

I have a combo_OrderID button with a OnChange event. In the OnChange event, I would check for a IsFormDirty Flag. If the flag is set, I will proceed to undo the changes on all the controls on the form. I use a "Me.undo" to undo the changes in the control. And all the controls have bound data...

Thanks, I use the form's custom property to pass the data to the report. Another Question: Can we create the sort level (ie. Grouplevel (2) which is third level sort) using VBA? I would like my form to be a bit dynamic in the sense that User can choose to sort by 1 level, 2 levels or 3...