Search results
-
A
(( FindRecord split form records from combo box ))
Gents, I have a split form with many of a combobox (date, text,numbers and both). How can displayed only the records in the datasheet based on a combo box selection? Can someone explain how to build this mechanism and write a sample code? Thanks & regards -
A
Help: Filtering report by multivalued listbox (vba code issue)
I found a code which is work good with subform table for searching multivalued Listbox but it doesn’t work with open report vba code this is the code is used for filtering the subform and i need it for openreport command If Me.cboDiscipline > "" Then varWhere = varWhere & "[Discipline].value =... -
A
Hellllp: How do I filter a multivalued Listbox field - VBA
The main form has textbox & a Listbox with which I filtered a datasheet inside a sub form. Everything worked fine only the listbox [Discipline] is not working !! it cuase Run-time error: 3831“ The multi-valued field "[Category]" cannot be used in a WHERE or HAVING clause. So how do I filter a... -
A
How do I filter a multivalued Listbox field - VBA
The main form has textbox & a Listbox with which I filtered a datasheet inside a sub form. Everything worked fine only the listbox [Discipline] is not working !! it cuase Run-time error: 3831“ The multi-valued field "[Category]" cannot be used in a WHERE or HAVING clause. So how do I filter a...- alhabkk
- Thread
- Replies: 1
- Forum: Modules & VBA
-
A
please help me on write vba code for a combobox search????
I created Advanced search (Multi- Field) form and its work perfect but I want to add a combo box for search [Date Removed] and the options is ‘Active’ and ‘Inactive’ my table include: [Location] [Date Installed] [Installed by] [EquipmentTag] [Date Removed] ... The users may not enter value in... -
A
*** Advanced search (Multi- Field) - VBA code ***
I created Advanced search (Multi- Field) form and its work perfect but I want to add a combo box for search [Date Removed] and the options is ‘Active’ and ‘Inactive’ my table include: [Location] [Date Installed] [Installed by] [EquipmentTag] [Date Removed] ... The users may not enter... -
A
add a pop-up calendar & time together??
Hi. Does anybody know how to add a pop-up calendar & time (see attachment) to a form so that when I enter a date & a time, I can also click on some icon for a calendar to pop-up? Any help is appreciated. Thanks! -
A
kick out users after a certain time of idle
Hi all, Is there any option to kick out users after a certain time of idle. Say, a user login my ms access and don't logout from database and he don't do anything in ms access. I want automatically logout from ms access after a certain time he is idle. For your information i'm using ms access... -
A
How to create a close/print button for a pivot chart?
How to create a close/print button for a pivot chart? -
A
How to write vba Multi field search form
I have a table name ex. equipment and many fields inside ex. date, equipment name (combo box) and others. I need to make form for all fields and button search once I click on it will open a report depending on a fields i selected. I think that I have to use VBA help me -
A
How to add new record by using vba or sql once click a button?
How to add new record by using vba or sql once click a button? -
A
How to write Sample Code to Retrieve the Current User Name
How to write Sample Code to Retrieve the Current User Name? I have done for short name only and I need it full Help me!! Private Declare Function apiGetUserNameWindows Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As... -
A
----- Hide Password in Input Box -----
This should be an easy one but I am not 100% sure how to do it. I have written the following code on a command button to set up a basic password for deleting current record. What I really want to do is hide the password being typed into the input box with asterix's. Here is the current code...