Search results

Hi CJ, Yes, this is based on click of a button, once the user has selected the criteria. This will open the query for viewing and printing. Presently, I have assigned a button to open the query. Basically, after selecting the criteria the user will verify the information and thereafter...

Hi CJ, Sorry for confusing you. Here is what I am looking for : 1) If the user does not select any option - Should be able to get all the data from the table 2) If the user is selecting criteria - Should be able to get the data based only on the selection (and not all the data) In...

Hi CJ, First of all thanks for your reply, it did work, but just for one criteria. For e.g. if i am selecting the name, it is giving me the desired result. However, if I am selecting more than one criteria its giving me the wrong output. My requirement : If there is no selection, I...

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

Can you elaborate want exactly you want. Is it that based on Login ID, it should identify whether the button should be enabled or disabled ?

Hi Paul, I have distributed the FE to multiple users and the BE is located on the network. It was working till last couple of days. :(

I have verified the security settings. I have even replicated the settings of the shared drive database with mine database on laptop. Everything is fine. The users have gone ahead and uploaded many files in last 20-25 days, it was working fine till then. But suddenly couple of days back it...

Yes, the security settings are enabled

Hi Paul, Attached is the database. Once you open the Main Menu form, click on Edit / Reports, this will take you to Find Form, Where I have four combobox, atm id, City, Depots & Vendor. Any of these filter selected and click on edit will open a query. This was working fine. However, once I...

Hi, I have split the database now, but the issue still persits. Can anybody help me out. When I go on the form, the filters are blank. Thanks in advance

Hi, You need to set the access level table first and then give them rights for e.g. "User" "Admin" and based on the same you can provide them access to your various forms. If you want to make the things more simple, just use a login form at the start of your access database. Based on the...

Hi Bob, I haven't split the db with each user nor linked to a back end db. Actually they all are acessing from the same path from one db iteself. If this is the issue, kindly let me know the procedure of splitting the same in detailed as there are around 45-50 multiple users at the same...

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

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

Hi Paul, I have solved the same, using the below logic : I have used a text box (hidden) and done a dlookup with the table to identify whether userid is either User or Admin, based on the same I have enabled the command button. Private Sub Form_Open(Cancel As Integer) strAccess =...

Hi Paul, Below is the code I have used to disable the cmmd button Private Sub Form_Current() Command94.Enabled = (Me.Text72 = "ms185336") Or (Me.Text72 = "pb185101") Or (Me.Text72 = "gm185125") Command99.Enabled = (Me.Text72 = "ms185336") Or (Me.Text72 = "pb185101") Or (Me.Text72 =...

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

Hi, I have found the solution, below is the correct code missed to add "Quote" CurrentDb.Execute "DELETE * FROM SHEET1 " & _ "WHERE DATE = " & Format(Me.Start, "\#dd\/mm\/yyyy\#") & " AND " & _ "CITY = '" & Me.Citycombo & "' AND " &...

Can anyone help me ? Thanks

Sorry, but Its showing nothing in the Immediate window