Search results

I apologize for that. I went and took a look at what I had pasted into the report and that was not at all was I was looking for. I have attached a spreadsheet that should make more sense. Again, just to clarify what I'm looking for: Query should contain only one row for each student. Each row...

Are the tables and queries not showing up in the accdb or are you saying the query cannot produce those results?

plog, I have attached a sanitized version of what I am working with. I put a screen shot in the report of what I would like to see as the end result and have 2 queries with the information I need. I just can't figure out how to join them in a manner that makes this work. Your help is really...

I have a database that tracks students and their test scores. I am trying to figure out a way to where it will pull the student's latest test score and compare it to see if they fall within standards. So far I have 3 tables. tblStudents studentID studentName studentEmail tblResults resultID...

Alright, so the user data that the code is supposed to grab from on start up is in the back end. Is this a reason why? and if so is there a workaround?

Yes, it does use the AutoExec Macro to perform the start VBA and there is no interaction from the user to perform the code. I have also tried distributing the accdb file to a few others to see if that would work but they get the same error. I can get both to work from my machine but the people I...

I have always compiled the code and the db if that helps.

There is no default form to be displayed like you see in the access settings. What happens is i have the code check who is logged on to the computer and then look up their permissions then based on that it will open up a particular form. As for the other users, the have it in a trusted location...

The accde file is my front end with some VBA to check users permission etc. I can open up the file from my machine in particular but others will open the file click the "Open" button on the window to grant access to the code and it goes to the welcome screen with all the templates. All machines...

When I distributed my accde file to the people in my office it went straight to the MS Access welcome screen instead of opening the database. Anyone have any ideas?

For some reason even when I set it I still get the main ribbon. I can see the ribbon in the form properties and have it set but it still shows the default ribbon. Any ideas?

I know there is VBA to load a ribbon in to the database but is there actual code to set the ribbon or code that corresponds to Access Options --> Current Database --->Ribbon and Toolbar Options --> Ribbon Name?

That's where I'm at right now just have to get these ribbons made up. The ribbon will be dependent on the permissions ID.

More or less I just wanted to take out all tabs but the Home tab

I have. I really don't like the way it's set up and odds are that I will end up converting to 2007 by the end of the year.

Does anyone know where I can find the XML for the default ribbon bar on Access? I think it would be be easier to take away certain buttons than to start from scratch.

I would have 3 different ribbons depending on the permissions of the user and a different form would open up with certain filters depending on the user.

@vbaInet I have 4 different user permissions. Eventually I want to be able to call my custom ribbons and adjust specific splash screens for each permission level.

I have a table with the fields userName and dbPermissions. the username in the database is the same one that is displayed when calling the Environ$("username") function. I want to build a script that will find record where the function matches the userName in the table and then looks up that...

I am trying to use conditional formatting on a report and fill color only changes if I click in the field on the report. Nothing happens in preview mode. It works if I change the condition to change font color only but I want the field to fill. This field is date format if that makes a...