Search results

Thanks a lot to all who helped me in the past few months, I now feel somewhat comfortable with this program, and I owe it all to members of this message board. Thanks again! Mike St. Louis MO

I have a simple question that could make or break my database, Is it possible to have auto calculations in a table? And if so, how do I do it? Just like in excel: Unit Cost Current In stock Total Value $12 4 =(Unit...

I am new to access this year. I am finishing up an Access 97 db that I need one more feature out of. 3 Fields in my table are the following. Current, UnitCost, TotalValue. (Current being the current number of an item in stock) I have to be able to make the database autocalculate the Total...

I have a dB that I designed last June. It is a program that holds product information in a storeroom. My users have requested a way to search the ENTIRE dB, with only one search string. I have one main table that contains my parts data, and I have select queries that control all my searches...

Hello again, one more issue. All of my reports are based on queries. I sort the datasheet that my query produces, and then run my report. How come I sort the query and sort the report by the same fields, but they do not match? Any Ideas?? Mike Fischer

I have finished up my db except for this one report I HAVE to find a way to create. What I have is: -ONE Table, with all my information (I know this is usually frowned upon) -I have 9 classifications of parts that my user breaks data up into. eg.. Administrative, Electrical, Mechanical...

I have a db that keeps track of storeroom inventory. I have one table that includes all of my data, and I have searches, controlled by select queries that allow my users to search through and find parts by a certain classification. (Eg... Search by Vendor, Search by location, etc....) These...

I know this is very simple, but I am new to the program. I have an Access 97 database with three four reports that will be used on a regular basis. One of these reports is named "Count Sheets" It is a item by item listing of all the items in the storeroom. My problem is, at the beginning of...

I have user level question for Access 97. My database contains information about a specific item, and also the Vendor information for the supplier. In quite a few instances, my user would like to be able to add new parts to the database, but keep the same Vendor. How can he copy the Vendor...

Hello, I recently wrote a database that keeps track of storeroom inventory in a chemical plant in St. Louis, MO. My user has a couple questions that I hoped someone would be able to help me with. 1. Is it possible, in datasheet view, to enter a new record ANYWHERE in the datasheet, not just...

I have a part inventory database that I am working on. I have to create all the reports that the store room's old program had in it. One of these was a Total Value report. This report has all of my part classifications on it, the total value of each of those classifications, and the number of...

Is it possible to search through all fields of my table with a query? I have several searches by certain fields, but my user wants to be able to search through ALL of the available fields, is this possible? thanks Mike camaroltd82@msn.com

I have a store room part inventory database I just implemented. My users have requested a search query that will search for anything in a string of words (Their part descriptions) I use the following criteria in all my other queries, but this only works if they type the first few letters of...

Hello again, I need a final bit of help in my dB. Two fields in my table are "unitcost" and "totalvalue". In the previous MS Works 3.0 program that I am updating from, any time the user updated the unitcost value, the totalvalue number updated automatically, as if there was a formula embedded...

Also, I have a field in my database that I need to enter a formula in, like Excel. One field is cost per unit, and the other is total cost... pretty simple, but I can't figure out for the life of me how to do it.

Hello, I am designing a db that keeps track of store room inventory. I am at the point of importing the data from the old program into Access 97. I have imported it several times, but I keeps getting blank fields in SOME records. Others come up just fine. I saved my Works 3.0 file as a text...

Hello Again. I need one last peice of advice. (I hope) My storeroom database has 10 tables in it that all have different classifications of parts. I need to have my users search for all of the parts supplied by one single vendor. Since vendors may supply several different types of parts, I...

I am designing a database where ONE or TWO users must be able to input data about a vendor, (Address, city/state, etc) I need to know how to make my form that they will use, open up blank, ready for them to enter in a new record. Every time I create a new form, it always opens on the FIRST...

Hello, I posted a message a week ago about building User input queries for my storeroom database. I need to know how I can translate that query result to a form. Not just a table view. Thanks for the help on the first topic, and any help here would be greatly appreciated. Mike

I know this may be a little bit of a simple request, but I really need some help. I am a network intern at a Chemical plant in Sauget IL. I am working on an Access database for our Storeroom. I am doing okay on forms, and navigation through my pages, but I can't figure out my queries. I need...