Recent content by chris990

Nevermind, I got it... Was overcomplicating things.... < MinLevel right under the Quantity thing worked just fine.

Hi guys, I have a newbie question here. I have a sum in my query, which sums the # of particular units, and want to compare it to a MinimumLevel field. I can get the query to display the Sum and the MinLevel fields, but I can't get them to compare each other and only display the correct...

Hi guys, Just want to give people one more look at this. I am still stuck with this! I need to somehow group similar products, and add their quantities to compare to another value. Can this be specified in the criteria section? Thanks

Hi Matt, I believe their is some functionality to embed queries/forms into an existing form. Maybe that would apply better to your needs, but unfortunately I am beginning to get out of my element. Good luck!

I know, Access won't automatically regenerate the query. You have to close the query and reselect an option.

The other option is to create a form with a combo-box. Then have the query called when the option is selected (change the event properties of the combo-box). Pretty much my whole database works on this structure.

Hi, I'm trying to produce a subtotal in a query to compare it to another field to determine whether to include the record or not. For example, in my table I'd have, ProductA 3(units) Lot1 ProductA 4(units) Lot2 ProductB 2(units) Lot3 ProductA would also have a...

How come when I secured my database, it made it smaller?

I appreciate your responses. I think I've kind of figured it out but I'm left with one problem. I can open my database with a shortcut using this as my shorcut target, "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "z:\samples\Sample Database\Sample Database New.mdb" /wrkgrp...

This is my 2nd thread on the topic...I've searched the forums.... I have a database. It is on the shared folder on the server. I ran the security wizard and created a shortcut. On my machine it works perfectly...asks for a login, has a couple user groups etc... When I run it off the server...

works on my machine, but it didn't work on another machine? am I missing something?

forgive me, but you can save me a lot of time. How do you create a .mdw file and apply it to the database?

I see Access has security features, such as creating group accounts with varying levels of permissions....This all works great for my computer, as I want an administrator and read-only user accounts. The problem is that these setting seem only to apply to my machine and are not present when the...

Hey, can someone help me out here, I want to make my database so it is read-only for all other people who use it, besides me, as I'm the only one who really is making changes to it. Would there be a way to do this, perhaps in a multi-user environment? Also does Access have a tool to...

I don't have a timer unless Microsoft put one in there. It appears to be ok now though.....as I was about to show the problem to my boss, it somehow mysteriously, although not unpredictably, fixed itself....I looked like an idiot there, and here, so I think my work is done for now. Thanks.