BeeJayEff, I don't know if this method will work for what I am trying to do. The database is set up so that each user has their own username and password for the database itself and the login is not based on the login for the computer. The reason for this is that the network we are using has...
Hi,
I am creating a database where I want users to be able to store certain information in a folder on the computer and not in the database itself that is unique to them (for example, the folder is titled with their name). The folder would be created after the user's name is entered into the...
pbaldy, What I am saying is that I tried removing the double quotes that you show in red. When I did this, I receive the same message as when they were in the code.
****Correction this now works and I am all set. Thank you for your help. I don't know what mistake I was making before.
Hi pbaldy, thanks for your response. I did try this already and I received a similar if not the same response as explained above. Unless I'm misunderstanding what you're telling me to do.
Hi,
I created a report based on a query for my database. The report creates a sign-in sheet for like a class, training, etc.. The data shown on the report is filtered by VBA code based on the selected option box on the report run form. The issue that I am running into is that for one of the...
I'm sorry but I have not completely ignored what you said. I just noticed what you said about not needing the strCriteria part. I have updated my code to the following and am now getting an Enter Parameter Value error when I hit run.
Private Sub cmdMembers_Click()
'runs report to show member...
Ok, so I ended up redoing the report, making it off the query. I do not include the member type column in the report because this is redundant information and I do not want it to show up in the report. My code is now as follows:
Private Sub cmdMembers_Click()
'runs report to show member...
I'm confused as to why I don't need to call the query in order to tell the report how to filter the data. Also, that example you sent me doesn't work either. I changed everything to the following:
Private Sub cmdMembers_Click()
'runs report to show member information based on option selected...
Thank you Collin for giving me a starting point as to where to go from here. The following is what I have come up with. I'm sure it's far from correct but it's a start.
Private Sub cmdMembers_Click()
'runs report to show member information based on option selected
Dim strCriteria As String...
plog, you did actually post code in your response when you mentioned the DoCmd.OpenReport and that I need to apply filters by coding them in in VBA. I understand the DoCmd.OpenReport part. That is not where I am stuck. I do not understand what to do in order to apply the filters based on what...
Hi ridders, I am confused though as to how to alter the VBA code such that when a particular option box is selected, the filter is applied to only display the data that meets that filter's requirements. Does this make sense?
thanks plog, I appreciate your response about making the query that includes the junior or senior member type. However, I need the report to be run with option buttons and not a drop down combo box. This will be much more efficient and user friendly for the people who would be running the...
Hi,
I am creating a report that will show company contact information and I want to be able to filter it by the person's age. The person's age does not show up on the report but I want to have the user select from three option boxes whether they want to view all "Junior Members" (anyone under...
Hi,
let me see if I can clarify what is going on here. The computer that this will be run on is password protected, however each user of the computer uses the same password to log in regardless of who they are so just telling the database that the user is trustworthy because they logged into...
Hi,
I am creating a form for a database user to have the ability to go in and set up a new user profile for the database. What I mean is that I will have a table that will have a bunch of names as well as a username and password that corresponds to each of those names that a person will go in...