Search results

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.

I received a very strange error this morning. I was going to create a new query with the simple query wizard, but as soon as selected a data source I got a message saying "The expression on Got Focus you entered as the event property setting produced the following error: The text you entered...

Thanks, I think I got the message box thing figured out. What about the first question....How can you use a delete-query to delete records from 2 tables? Just reading the help-files makes this look like a touchy subject as they mention relationships and other things. Is this a viable way to go...

Hey guys, I got two questions about delete queries, Question 1: Is it possible to use the delete query to delete records from two different tables? What I'm looking at is deleting a customer from a customer list, and customer records from a distribution list, which are in two different tables...

Cool....My database is at 3MB already and I hadn't even put any data into it, other than some test data, so I was starting to get a little concerned. I'm not anticipating multi-users, but the stockpiling of data could add up, though it sounds like it should be ok. Thanks for the tip on the...

Hey guys, Was wondering, what is the recommended maximum size for Access databases? I've heard that for very large databases that oracle is preferred. Would Access be appropriate for something on the scope of 5000 records of roughly 6 text and 2 number fields? Do people ever notice performance...