Recent content by tony7ana

All, I have been working on a group of sub reports to be combined in one report in Access 2007. I have an issue with the background color of the subreport header. I have changed the background color of the form, the subreport and every section of the subreport. But the blue background color...

Thanks Bob, you are awesome. That worked great!!

Thanks Bob, I created the form and created the combo box in the header section. However, when I select the employee name, the data in the detail section underneath does not change. How do I link the 2 together?

Thanks Guys. I am working on another form where I want employee data to show up once I select an employee name. I already have a table built with the employee data. I want to be able to select the employee name and once their data shows up I can edit it there if I need to without having to go...

Hello All, I am trying to create a form in Access 2007 where employees can submit requests to management. I have a table built with all the data and a form with all the required fields. The problem that I am having is I dont want any existing requests data to show up on the form. Is there a...

Thanks vbaInet. I created my subreport and it providing me the data in the format that I want. However, the report header has a blue back color that I cant remove. I tried changing the background color to transparent and even white and its still shows up blue. I tried copying the background...

Thanks vbaInet, the report is now running but I have one small issue. The report is showing an individual page in the report for each form entry. For example, The report is showing this produced: 50 boxes Next week production type: bags produced:85 boxes Next week production type...

Thanks vbaInet. I have a form created that has a start date and and end date. I have placed the code in your post in my query. I appreciate your input, what are the next steps?

Hi All, I have been trying to figure our how to run a report in Access 2007 for the last 2 days and have not been able to format it to the way that I want. Currently I have a table that looks like this: ...............Date ........... Produced ........NextWeekProductionType Machine A...

I found this calendarr which runs perfectly but I cant get the report function to work. When I run it, I am getting an error in the below code. I only need the calendar report, i dont care about the rest. Any suggestions and thank you for looking at this in advance!! file is attached. Case 3...

Thank you GohDiamond, that worked!!!

I think there might be a problem with the code. It is identifying the correct password, however, i tested it by entering incorrect passwords. It will let me know that I am not authorized, however, it will still open the Form that i am trying to secure automatically after the "not authorized"...

All, I am working on a switch board in Access 2007 which has 2 buttons. Each button allows users to open a different form. One form is for all users, the other form I want to restrict to certain people only to be able to enter. I have created an on click input box that will ask the user for...