Usually everyone has to click enable content and then the login form opens back up and the users have no trouble logging in. It was working great before. I had made some minor changes to some of the forms recently. Now old version of my front ends don't work for my coworkers either but old...
IT fixed activation issue for at least one of my coworkers and they were still not able to open the database. We all have license with government for software.
It is something with my login form also though.
I have Access 2016 installed on my computer, all my coworkers have access 2016. I have multiple people using my database on a network folder. The Front end is split with back end on the shared drive. I have my users copy the front end to their desktop. I don't have any issues using my front end...
If you use a query vs a table in access linked to your pivot table in excel will it be faster? Will it make excel faster? The table in access has several fields I don't need in my pivot table. Eventually the access table is going to get pretty big. Im also using a timeline to filter my pivot...
Like fCboSearch([Forms]![Welcome_Menu]![cboTechnician]) is in my criteria for my query
Then I have the function
Public Function fCboSearch(vCboSearch As Variant)
If vCboSearch = "All Data Technicians" Then
'Prevents data techs from seeing records they worked on
fCboSearch = "Not In ('" &...
that isn't working what do I need to change
fCboSearch = "Not In ('" & Form_Login_frm.cboUser.value & "')"
should it be "Not In ('" & Form.Login_frm.cboUser.value & "')"
So I should be modifying the function to:
Leave the criteria in the query Like fCboSearch([Forms]![Welcome_Menu]![cboTechnician])
Public Function fCboSearch(vCboSearch As Variant)
If vCboSearch = "All Data Technicians" Then
'Prevents data techs from seeing records they worked on
fCboSearch =...
I have query that uses a function and a dropdown box, cboTechnician to get different criteria. When "All Technicians" is selected from my dropdown box I want the criteria/function to show all values for a field except the value in my login textbox, cboUser that is open. I had previously set it...
I got it to work now. I just didnt understand why it was written that way, but now I do. I am still learning with VBA.
Public Function fCboSearch(vCboSearch As Variant)
If vCboSearch = "All Data Technicians" Then
fCboSearch = "*"
Else
fCboSearch = vCboSearch
End If
End Function
criteria in my...
I think I see what I did wrong with the criteria box. I found the function from nifty website. When I saw how it did the criteria i didn't understand why it had the variable and the combobox name. Now I understand why it is written that way.
Like fCboSearch([Forms]![welcome_menu]![cbotecnician])
So should criteria =vCboSearch()
Or should it be. Like vCboSearch()
I will try both tomorrow.
I really have not written any functions before.
I'm trying to assign a criteria value from a drop down box using an if then statement. I can't use an if then statement in a criteria area so I am...
I created a function it is named module 1 fCboSearch(vCboSearch As Variant) IT takes the value from a dropdown box cboTechnician on my main form. I want it to show all records if "All Data Technicians" in my query if it is selected from dropdown list if not I want it just to use filter the...
I did the same thing for another report but instead I wanted top 25 records per person per month. This query keeps causing access to close/crash every time I try to open the query and view the data. It lets me look at the SQL code and the design view of the query but not at the data. I tried...