Search results

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, 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?

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...

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 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...

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...

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...

This is probably a basic question, but how do you paste other data onto Reports? I'm making a transaction list between two dates and displaying them in a report. The two dates are specified on a form and then used in a query to make the report. I just can't find a way to display the dates on a...

Hey guys, Is it possible to create a drop-down menu Query, as opposed to the basic Parameter Query where the condition is typed in a dialog box? Just thinking it would be easier for the user in that it would eliminate mistakes due to spelling errors. Would it be possible?