Fiilters not working for multiple users

[Prashant]

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 filters. I don't know what is the issue all about. Also if i use me.requery, the text filters becomes blank. Below is the code :

Option Compare Database
Option Explicit
Public Function SelRec(shDate As Date, ATMID As String, City As String, Depots As String, Vendor As String) As Boolean
    SelRec = False
    
    If Not IsNull([Forms]![Find]![Start]) Then
        If shDate < [Forms]![Find]![Start] Then Exit Function
    End If
    If Not IsNull([Forms]![Find]![End]) Then
        If shDate > [Forms]![Find]![End] Then Exit Function
    End If
    
    If Not IsNull([Forms]![Find]![ID]) Then
        If ATMID <> [Forms]![Find]![ID] Then Exit Function
    End If
    
    If Not IsNull([Forms]![Find]![Citycombo]) Then
        If City <> [Forms]![Find]![Citycombo] Then Exit Function
    End If
    
    If Not IsNull([Forms]![Find]![Depotscombo]) Then
        If Depots <> [Forms]![Find]![Depotscombo] Then Exit Function
    End If
    
    If Not IsNull([Forms]![Find]![vendorcombo]) Then
        If Vendor <> [Forms]![Find]![vendorcombo] Then Exit Function
    End If
    
    SelRec = True
End Function

Further I have a command button which runs the query with the below code in the query :

Field : SelRec([Date],[ATMID],[City],[Depots],[Vendor])

Criteria : [Forms]![Find]![frmOptions]

Can anybody help me out.

Thanks in Advance.

 

[bob fitz]

You say the db is on a shared drive but have you actually split the db, with each user having a copy of the front end on their own machine linked to a back end db on the shared drive.

 

[Prashant]

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

Thanks.

 

[bob fitz]

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

Thanks.

I can't say that the db not being split is causing your problem. Only that it might. I can't say that crossing the road without looking to see that it free of moving traffic will cause you any harm. Only that it might. Any db that is used by more than one user should be split. There must be thousands of posts and web pages on the subject of splitting. Just try a google search of "why spllit access".
Good luck with your project.

 

[Prashant]

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

 

[pr2-eugin]

I am unable to get the real problem here, could you explain what seems to be the "issue".

 

[CazB]

A problem I had the other day with a new user: they needed to enable macros on their computer before my database would work, as otherwise the code would not run! Have you tried looking at the MS Access security settings on the other computers?

 

[Prashant]

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 uploaded the database on the shared drive and had split it, the multiple users are unable to find the options in the filters i.e. when they click on any of the above combo box, it doesn't pull a list - its blank.

Hope you can help.

Thanks in advance.

 

[Prashant]

Yes, the security settings are enabled

 

[CazB]

Just looked on your database and it worked fine on my pc.... I really think you should be looking at the MS Access security settings / enabling macros on your other pcs.... it's not enough to check it on your own, they'll need to be checked on every pc / for every user that needs to access the database

 

[pr2-eugin]

Affirmative, it works for me too. I split the DB, then copied the Front end file to My Documents, placed the Back end file in my network location. Then it works ! How are you splitting the DB?

 

[Prashant]

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 started with blank filters. I am stuck don't know what the issue is all about. The database is split FE & BE.

 

[Prashant]

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.