Search results

Yes, it's still 4.03 MB

Is there any service or site you do trust? The database is over 4MB zipped. I agree I need to take the bulk out of it and would love to approach this more professionally, but I can't risk deleting anything without replacing it and testing its functionality.

Tried using this DLookup and getting the value for week 1 instead of week 3. Any advice. I think I need a "&" somewhere or missing quotes. =DLookUp("[TotActAcntPts]","[PointsQuery]","UserID = [TmpUserID]" And "WeekNumber =3")

This isn't the first time I have had criticism on the design of my database. This is my first time doing anything like this and although the design is not traditional, it is working well. I appreciate all the constructive criticism and would love to sit down with a few of you and redesign the...

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.