Search results

I made the excel sheet manually, with no code or queries. I need to replicate that in a form for viewing and also as a report for printing in Access, not Excel. I don't need to edit it, just view and print. I would like a form version as I have with the reporting forms. Not sure how to grab...

Hello Guy's I have another challenge to accomplish and could use some help. I attached an excel document that mimics the form and report I need to create. (I made it pretty clear where the data was coming from). The data is coming from a few different places. Points table...

Sweet, looks great, Thanks

It is now opening in "Report View", but full screen. Is it possible to have it show like the other forms?

Hey Guy's, Thanks for all the help with this. I was able to get it to work and I really like it. The only problem is when I push the buttons to pull up the reports, the report comes up as a thin line across the screen. I can maximize it and then hit control P to print, but was hoping it...

I don't think I would want to hide the UI completely in the large database project I have, but I just wanted to give it a try in this little program I made. It's just a simple ledger program. Adding, Editing and printing. Very small, I thought it would be nice to just open the file, hit a few...

I am trying to decipher some of that code and it is very confusing. I was not thinking about using this in the database that you are familiar with, but another one that only has a few forms. The code you provided seems to be for every type of control in the access application. I was just...

I made this database and was hoping I could just open it and only see the forms pop up, no access UI. Is there a quick easy way to do this, or does it take tons of code?

I figured out the issue when I took a break for a bit. I came back and found it before I opened this. Thanks for everything. I do realize that this database is bulky, to say the least. It was my first time working with access and using VBA. I'm sure my next project will be much better. I...

I'm sorry guys about the Pop Out and Modal settings, but if I change them then I don't see the problem with the scroll bar not appearing. There is always a scroll bar in the regular view, so you don't know if it's not showing or not. I need to keep it the way it is meant to function in order...

Never mind, I just figured it out. Works great, thanks so much.

I am not familiar with the "Running Sum" property, or the "Over All" condition. Perhaps give an example or make the changes in the database and attach the updated file.

This is very aggravating. The weekly forms are all the same, with the exception of the data that may change. All the settings and properties are identical. With the user "Brian Kelly", it is only on the Monday form that the scroll bar does not show. All the other days the scroll bar appears...

Just a little confused as to why you think the scroll bar is not showing. The form has enough information. There are points and buttons on the bottom of the form and with that alone, the scroll bar should appear. I gotta take off for a little bit but will be checking back soon. Thanks for...

That's simply a quick change in the properties. Just right-clicking and hitting close does the same thing. My boss didn't want to be able to see any part of the access interface, that's why everything is programmed to close and open by hitting buttons. Making the close visible in the upper...

There is so much code that is used moving from form to form, setting Temporary values, calling queries. I am not sure how to go about cutting this project down to make it easier for everyone else.

That's the problem, at the bottom of that form is a close button. You can't scroll down to the bottom of the page. You can on all the other days, but not Monday on that person and a few others. "Rick Smith" seems to be working the right way, but have no clue as to why one person works and not...

By the way, all the information in the database is made up for testing purposes.

Sorry, I'm attaching another link that is not a zip. The database is designed to open full screen. If you hit "Enter", "Reporting Forms", Select "Brian Kelly", "Week 1", "Monday", "Next". Then "View Reports". You should see Mondays reporting form with no scroll bar...

I am stumped. I have a form "Mon_Reporting_Form" that is not able to scroll because there is no vertical scroll bar. I have remade the form, thinking it has become corrupt, but no change. It seems to work sometimes, but mostly not. Of course, I have checked the properties and the vertical...