Recent content by mbrinser

I created a login screen for users so that reports can all be customized for the individual logging in and I created a custom ribbon with the print functions when a report runs. I've discovered that someone who is running the full version of access can print the reports without problems, but if...

I swear I tried that before and it wouldn't let me...and now it did. Anyway, I am getting a runtime error '13' type mismatch when I try to combine the two conditions below, they worked independantly so what do I need to change now that I am trying to run them together? WhereCondition:="Social...

I appreciate the help thus far. How do I create to where conditions? I have one where condition that searches for similar SS #'s, but in the rare instance where somebody has the same last 4 digits, how do i also include a second where condition to match last 4 and last name?

IT is getting the four digits from an unbound text box I created on the report, and the formula you gave me below got the format that I wanted, i.e. xxx-xx-1234, but now it messed up the WhereCondition, any suggestions on what needs to be fixed for hte wherecondition?

Thank you, that worked perfectly. As a follow up questions, is there any way I can have it display the SS# as follows: xxx-xx-1234 in my report, right now it just shows the last 4 digits without the placeholders.

I have created a report that has a list of individual's names and have written code so that I can click on a person's last name and it will take you to their detailed info, but it brings up all the records who share the same last name so I added a field showing the last 4 of the social security...

I have been trying to create a custom right-click menu and have posted the code below. I set the shortcut menu bar to SimpleShortcutMenu, yet my report tells me it does not recognize the module. Sub CreateSimpleShortcutMenu() Dim cmbShortcutMenu As Office.CommandBar Set...

So I can't do a sort in a report?

Yes the options are on the ribbon, how else can I allow the user to sort the data?

Thank you for all those posts, I'm just about there. I've created a custom ribbon showing the filter and sort options, however, the options to sort are grayed out and I can only filter, what am I missing?

I was able to get get rid of the shortcuts, however somewhere along the way I also got rid of the access options button and now I can't get to some of the functions I would like to touch up a few things. What is the keyboard shortcut to get that back?

I have finished my first database and I would like to create an execute only database in order to disable a lot of the functions. I have a login screen that allows the user to select who they are, however in the execute only database when i select the user and hit "enter" nothing happens, what...

I have finished my first database and I would like to create an execute only database in order to disable a lot of the functions. I have a login screen that allows the user to select who they are, however in the execute only database when i select the user and hit "enter" nothing happens, what...

that worked perfectly, thank you

I have a query that has multiple products listed and when I try to do a total unless there is a value listed for each product then it won't total, so I have to go across and put zero's into the fields. Is there any way around this so that it will total even if not all fields are filled in? Thanks