Search results

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

Thanks, I found the code to execute this function.:)

Hi Banana, Appreciate if you could pass me the full code. I have no clue on how to go about it... Tks

I have a form with combo boxes & textboxes as input selections to generate a report. At the same time, I would like to give User the flexibility to do sorting and grouping on the report by opening a mini form that will use option buttons to indicate which field is being selected by User to do...

I am building a Amend Screen such that Client can change/edit data when they receive new information after the Order record is created. I am using a Edit button to allow changes to the record. If user plans to save the changes, they must use the save button to update the changes. I am using a...

How do I build a form which only requires User to enter the source file pathname (by browsing windows folders & files to get the pathname), display the source file pathname in a textbox. Then when User enter the upload button, it will automatically upload the file from source location to...