Search results

  1. P

    This expression is typed incorrectly, or too complex

    Hi, I am working on a billing database, where I have created a "Find" form where the user can select the criterias for the output of the report. I have used a public function which is as under and used in a query to populate the result : Option Compare Database Option Explicit Public...
  2. P

    Fiilters not working for multiple users

    Hi, I have created a module, where based on various selections (form), the output is thrown in the table for editing various fields. This works fine with single user. But once I have placed the same database on the share drive for multiple users, the users are unable see the data in the text...
  3. P

    Setting the ***** password in a inputbox

    Hi, I want the input box to display the password as "********", below is the code I am using : Private Sub OLEUnbound42_Click() On Error GoTo Err_bDisableBypassKey_Click Key Dim strInput As String Dim strMsg As String Beep strMsg = "Do you want to enable the Bypass Key?"...
  4. P

    Admin to create admin

    Hi, I have been given to build a database which should have a login form with username and password, upon filling up the correct details a new form should open for e.g. main menu. Now if the logged in person is Admin, all the command buttons will be enabled, but if it user there are specific...
  5. P

    Delete records based on Form inputs

    Hi, I have a form Delete which contains four fields i.e. Date, City, Depots and Vendor, which has combobox. I am trying to delete a record from table "Sheet1" based on the combobox, for which i have written the following code, but getting an error at the lines highlighted in red : Private...
  6. P

    Search Query based on form

    Hi, I am unable to get multiple search output using the below code in queries, the search text is based on form : Search form name : Find Query name : Search Table name : Sheet1 [forms]![find]![city] The above works fine if it is only used in one of the fields, but as soon as I have it...
Back
Top Bottom