Search results

Requery all ComboBoxes & Subforms - Select the only option For anyone who might find it useful. This is the resulting code I created to be used on a ton of my forms. It requeries all ComboBoxes, and subforms. If the combobox only has one choice, it then selects that choice...

Can you give an example?

How do you create dividers in the menu's you create, dividing the menu choices into "Groups"? Most standard menu's have them (lines seperating two different groups). I've searched the VBA help files, and this forum, but can't seem to find any reference to them. I'm probably just searching by...

From Access Help File: Show or hide the Ask a Question box On the Tools menu, click Customize. Click the Options tab. On the menu bar, right-click the Ask a Question box. . Select or deselect Show Ask A Question Box to show or hide it. Note If you are hiding the Ask a Question box, it...

I know this is likely a simple question, I just can't seem to come up with the right search terms to find my answer. I have a custom temporary menu that I am creating in VBA, and suppressing all the traditional menu's. I would like to be able to have a menu choice that will let you go to forms...

Answered my own question I answered my own question with a different thread. This is the code I came up with based upon that thread. Function IsInGroup(grpName As String) As Boolean Dim daGroups As Object Set daGroups = DBEngine.Workspaces(0).Users(CurrentUser).Groups IsInGroup =...

Short Function to Return If CurrentUser is in Group Here's a much simpler adaptation of that code I'm using in conjuction with hide/view toolbar code to display menus based upon if a user is part of a certain group. Function IsInGroup(grpName As String) As Boolean Dim daGroups As Object...

Is there a way to do the example code, but querying the group that the current user is a part of? It'd be much better if I could have the toolbars be hid based upon group, not based upon an individual user. Thanks!

'Checking if table exists, if yes delete table If ObjectExists(acTable, "tblSESSIONAVERAGE") Then DoCmd.DeleteObject acTable, "tblSESSIONAVERAGE" Grabbed from http://www.access-programmers.co.uk/forums/showthread.php?t=46716&highlight=if+table+exists

Thanks! That worked great! Thanks!

Is there an array of all the comboboxes on a form, or any other means to cycle through all the comboboxes on that form without using the names of the comboboxes? I'm trying to create a function that can be used by several different forms that would cycle through all the combo boxes and run a...

Okay, I'm new to this and about to go crazy. Whats wrong with the code below? Function addDays(employID As Long, daType As String, daEXPDATE As Date, daREMARKS As String) Dim daNOW As Date Dim daDAYS As Double Dim daSEARCH As String Dim rst As Recordset...

Clarification Sorry I should have clarified. The part it doesn't like is all the Dlookup entries. daDAYS = DLookup("numberdays", daRECORDS, "TYPE = 'b'")

I've got a table that I've run a query on to get a recordset of. Of these values I want to find values that match a certain criteria, and then return the value in a cell of that record. VBA doesn't seem to like my syntax. Is there an easy way to do this. (Code is below) Thanks for your help...

Thanks! That should work great!

I've been programming in VBA in Excel for awhile, but am new to Access. Is there a way to run a SQL Query and store the values into an array for further manipulation through VBA? (I don't really want the query output to the screen). Thanks!! Query I'd like to run: SELECT accrualofdaysLOG.id...

Try Activate instead of select Try using "Activate" instead of "Select". Activate and Select are almost interchangable, but not quite. As a result, in some instances only one or the other will work. I forget the exact reason why.

I've got two tables employees accrualofdaysLOG I'd like to set it so employees.personal for each employee equals the sum of all entries in accrualofdaysLOG where the accrualofdaysLOG.type = "p" for that employee. Any ideas on how to do this? Thanks! Tables are structured as follows: employees...