General :: Filter By User
Oct 15, 2013
I have a database that opens into a continuous form ... which has records and a user name in each, which is taken from a table "ASSIGNED". At the foot of the continuous form I put a filter button to show only the selected user records.That when opening the form, Access asks why I want to filter user (do this only once) ... So each user sees only their records.It is clear that the "Front End" is used in a network and is linked to another database with multiple related tables.
View Replies
ADVERTISEMENT
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Aug 2, 2005
Hi can anyone help me. I need to create a form filter that will allow a user to enter an amount into a text box and then run the filter to match the amount entered. I have tried creating a macro that will execute this but it wont work. any ideas?
Thanks
View 2 Replies
View Related
Jul 23, 2012
I'm trying to create a table that shows only records assigned to the user based on their environ("username"). I tried creating a code that adds the user name to a table, but this won't work as multiple people will be using the database at once.
View 2 Replies
View Related
Sep 23, 2005
Okay, I have a unbound form with three combo boxes the selection of these three & then clicking of a filter button opens the relevant form showing records based on the selection. Great that bit working, no major feat.
Trouble is when I select three criterea in the combo boxes that no record(s)exist for and hit the filter button. A blank form appears not very friendly or appealing.
what I'm after is a simple, thats me all over by the way, of a message box appearing to tell the user no records where found.
Any ideas, starters for ten on this one?
:cool:
View 3 Replies
View Related
Jan 10, 2015
I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then apply the filter on the customer form and allow me to do edits. I have only done the macro that will open the customer form but can't figure out how to do the filter part.
View 2 Replies
View Related
Dec 12, 2011
I have query in MS access which does date filter based on value given by user.
SELECT *
FROM Table1
WHERE ((DateValue([Table1].[Date_col])
Between "#"&[Forms]![Frm1]![Date1]&"#"
and "#"&[Forms]![Frm1]![Date2]&"#"))
But this gives empty output
View 1 Replies
View Related
Oct 23, 2014
I am trying to filter a report based on two user inputted dates, but can't seem to figure it out. I've played around with quotation marks, and # but can't seem to figure the syntax out.
Code:
Me.OrderBy = "Date Submitted"
Me.OrderByOn = True
Dim Date1 As Date
Dim Date2 As Date
Date1 = UserInput
Date2 = UserInput
DoCmd.ApplyFilter WhereCondition:="[Date Submitted] > Date1 and < Date2"
View 11 Replies
View Related
Jun 1, 2012
I use filter Combo boxes in a lot of places so that users can filter records easily. (Not combo boxes for input).I have them labeled as filters but nonetheless users keep trying to input into them for some reason.How would I add a message box to it so that it states that 'this box is not for data entry etc'.
View 2 Replies
View Related
Jul 27, 2012
I have a report that has a link to open a a form "ProjectDetailsActive" to a specific record ID from the report. It works.
I have 3 subsets of users who have restricted access to the form "Project Details Active". By that I mean that when they open this form, it hides and rearranges some tabs, and disables certain controls. If a user from one of these 3 subsets tries to open the link to a specific record in the form, it does not work. The form opens to the first record available instead of the selected record. This is only a problem for these 3 user groups. For users who do not fall into these 3 groups, the filter works.
This is the only code in the form that does the restriction, but I don't know where the process is going wrong.
Code:
Private Sub Form_Current()
LoadBudgetPage
CancelRsn.Enabled = False
'detect number of line items for current project
Me.lblOrderCount.Caption = GetNumRecords & " line items for this project."
[code].....
View 8 Replies
View Related
Jan 19, 2014
I have at present 2 combo box's that filter, now....... the 1st combo box is a drop down value list that will filter the OPOwner (persons name) for example there are 3000 records and 5 OPOwners, I can for now filter my name in cboOPOwner combo box.
The 2nd box (drop down list) is Status which would be "New";"Open";Pipeline";"Lead" ect...
If I filter my name it brings up all records related to my name and the when I want to filter status it will bring up all records relating to say 'Pipeline' however it will bring everyone's ;Pipeline and not just mine.
What I want is to filter my name in the OPOwner combo box and once all records are filtered in my name then in the status combo box filter what ever I want to look at. example what I want to filter - 'Filter Neil' then 'Filter Pipeline, or filter Lead or New'.
This is the code I have in both combo's....
Private Sub cboOPOwner_AfterUpdate()
If Nz(Me.cboOPOwner.Text) = "" Then
Me.Form.Filter = ""
Me.FilterOn = False
ElseIf Me.cboOPOwner.ListIndex <> -1 Then
Me.Form.Filter = "[OPOwner] = '" & _
Replace(Me.cboOPOwner.Text, "'", "''") & "'"
Me.FilterOn = True
[Code] ....
View 14 Replies
View Related
Jun 23, 2014
In access, I have the following: 2 sub forms located in an overall form. I would like when I select a record in the first subform, that the second subform would automatically filter for all records that contain the same ID Value.
View 1 Replies
View Related
Aug 19, 2014
I'm trying to set a filter with a command button. I've tried to do it like the examples I've read on numerous sites, but I can't seem to get the filter set. The code that seems most like the examples to me is:
Me.Filter = "[chkPaid] = 0"
Me.FilterOn = True
When I run this I get a box telling me to enter a parameter value for chkPaid. chkPaid is definitely the correct name for the checkbox control on the form. I've tried many variations with and without the square brackets, but as long as I have [chkPaid] inside of quotes I get the Enter Parameter box. If I leave the quotes off I get no parameter value request, but it doesn't set the filter either.
View 3 Replies
View Related
Apr 10, 2014
So I have a Form with 3 fields. 2 Date fields (Beginning & Ending) as well as a combo box (CName). There is a button (Filter).I want to fill in both dates and select from the dropdown box. Onceeach field has a value then it will send a msgbox saying there were "# of records" between the 2 dates by CName
View 14 Replies
View Related
Sep 12, 2014
I have a query based report Linked to a form. That is, in my form, i have a combo box. Selecting this combo box pulls out a certain field values in list box in the same form. (Cascading Combo/ List Boxes).
So after i select a certain value in combo box, it shows a certain field values in the list box. Now, i want to open a report and view only the records that has the selected combo box and list box values.
Note: I have seen a guy made an access report based on a query. He made a form with a combo box and a list box.
The report is based on the combo box value selected by the user. Once, the user selected a value in the combo box, the list box updates automatically. ( I have done till here successfully). Then he used a toggle button on the same form.
This toggle button opens the report with the combo box value as the criteria but filters the report based on the field value in the list box.
How to place a toggle button with a filter command to open a query based report?
View 1 Replies
View Related
Jun 6, 2014
I have a form that has many fields with the same part number but with a different PO number
Example
part number po number
1 3
1 10
1 15
What I want to do is select the part number and the po number together
Say part number I po number 15
At present my combo box only will select one of these IE THE part number ...
View 2 Replies
View Related
Sep 28, 2012
I need to filter a subform based on the values on the mainform.
Criteria are Multiple. The idea is to show the user the records that are already existing in the table.
First two criteria works, stuck with the third one
I.Criteria - Creative(text type)
Private Sub Creative_AfterUpdate()
Me.frmCommercialWithDetails_subform.Form.Filter = _
"Creative ='" & Creative & "'"
Me.frmCommercialWithDetails_subform.Form.FilterOn = True
End Sub
[Code] ....
Also, how to split the code into two lines
"Creative ='" & Creative & "' And Act_ID = " & Act_ID
when broken into:
"Creative ='" & Creative & "' _
And Act_ID = " & Act_ID
is automatically saved as:
"Creative ='" & Creative & "'" _
And Act_ID = " & Act_ID " and this generates an error on execution.
View 5 Replies
View Related
Jun 27, 2012
I have a function which I want to return the value of a field.
Public Function fieldValue(tblName As String, fldName As String)
Dim drs As Recordset
Set db = CurrentDb
Set drs = db.OpenRecordset(tblName)
fieldValue = drs.Fields(fldName).Value
drs.Close
Set drs = Nothing
End Function
I need to return the value obtained, for a specified User identified with a numeric variable.What is the best way forward? - Some sort of filter or DLookup and how to code this?
View 14 Replies
View Related
Nov 22, 2012
My query is how to restrict a user when he logs in......say for example, if he is a guest user he will not be able to change the setting neither he will be able to see the design mode..i am using access 2003
View 3 Replies
View Related
Feb 10, 2015
This is a database that uses user-level security setup in Access 2003 but it is being run on 2010. An update to the security system is in the cards in the near months, but right now I need to add one more user and I am having an issue with that.
I can add the new user in the user and group accounts form and I can add him to any group except for one. Unfortunately that is the group that he needs to belong to. You can see in the attached image the new user (jschiff) and the group I want to add him to. There already are some other users in that group. What could prevent me from adding this new user to that group?
View 2 Replies
View Related
Jul 29, 2013
So i have a form with 3 fields. (This is just a test form/table):
ID: autonumber
Fullname: text field
Last4: number field
I have the following code:
Code:
DoCmd.OpenForm "test", , , "Id = '" & Me.List14 & "'"
It keeps giving a mismatch error. How do i get it so I can use the autonumber to filter the form?
Code:
DoCmd.OpenForm "test", , , "Fullname = '" & Me.List14 & "'"
When I do this it works just fine.
View 3 Replies
View Related
Mar 26, 2015
I would like to get minimal value from "Ski" column. Need to use recordset instead Dmin function because this value will be changed many times. I work with dao.recordset but I never used recordset filter so I need to do something like this:
Code:
strSQL = "select tblGoraZleceniaNowaWyceny.id_gora_zlecenia, tblGoraZleceniaNowaWyceny.naklad_pracy, tblGoraZleceniaNowaWyceny.nazwa, tblGoraZleceniaNowaWyceny.Ski, tblMontazSzczegoly.iloscuzytkow from tblGoraZleceniaNowaWyceny inner join tblMontazSzczegoly on tblGoraZleceniaNowaWyceny.id_gora_zlecenia = tblMontazSzczegoly.nazwa where tblGoraZleceniaNowaWyceny.id_wycena_pre=" & Forms!frmWycenyObszarRoboczy!ID_wycena_pre & " order by error desc"
Wor = 5
Get the minimum value from strSQL (Ski column)
update this value = Ski+1
wor = wor-1
and loop all procedure until Wor = 0
So the problem is how to requery strSQL to show NEW minimum value at the beginning query - rst.requery doesn't work.
View 4 Replies
View Related
Sep 6, 2012
I am using a combo box to filter a 2nd form upon clicking a button. I posted on this topic the other month and was given some code that works. I am attempting to tweak it for another part of my database.I am receiving a Run-time error "3464': Data type mismatch in criteria expression.
DoCmd.OpenForm "Utilities Contacts", , , "[Utility] = """ & Me.Utility.Column(1) & """"
DoCmd.Close acForm, "Utility Menu"
View 4 Replies
View Related
Jun 11, 2012
I have a database application that i intend to split with the table part on a server and the forms part on each users desktop. It will be used by approx 10 users. While the probability of different users accessing and updating the same form is small, the possibility exists.
Is there a way i can prevent any weird multiple update stuff happening? I'm using Access 2003
View 7 Replies
View Related
May 6, 2014
I have a list of inventory (SR #s) in a excel under column A. And also there are 20 users using ms-access accessing by their user names. If a user completes one item, the next item from the excel should automatically goes to the next available user. After the item allocated to the particular user, under column B the user name should come and in column C there should be a comment saying "Done" Can i have a code for this in SQL or VBA.
View 2 Replies
View Related
May 28, 2014
there are certain txt boxes that once filled out, will filter a subform of a table of 1000's of records to give them a number to use on the form around 200 of the records have a depot in the "depot" field on the table, when they input a depot, it filters to them 200 fine if a depot is there,
what i want is, when they input the depot, if its there, filter it, if its not, to do nothing, as they could still get a unique number if the depot isnt in the list what happens now is, if the depot isnt in the list, it displays no records
Field : Fld_Depot
Table : Tbl_Agreement_Summary
Show : False
Criteria : Like "*" & SearchForText([Forms]![Frm_New_Accounts]![Fld_Depot]) & "*"
Or : Is Null
View 2 Replies
View Related
