hey, is there anyone who wil be of help to me by creating me a quick and simple database. It needs to keep track how many spare parts I have. Therefore it needs to show how many of each spare part i have, and be able to update the stock levels with a submit request page that when the submit button is pressed the stock levels automatically update. the information required for each spare part is article (what the product is from), article number ( the unique article number of the product), colour (the colour which its from), spare part (what it actually is) and quantity.
I am trying to calculate the stock level for my spareparts. I am aware of that I am not to update the stock level in my table but calculate the total from the transactions.
I need some assitant in building a simple check reconciliation database. I was wondering if anyone can guide me in doing so? Or if anyone has some kind of sample i can use that would be great. thanks
Hi all, i'm new here and I have a query about a database i'm building with which any help would be appreciated.
I'm designing a form and I need to be able to have an option to save to a temporary table for retrieval by users so that they can continue their saved record at a later time. Does anyone have any ideas on the best way to do this as I am relatively inexperienced and I have to have the whole database complete before Wednesday:confused:
Hi i have a assignment in which i have to build a database with documentation (attached file has details about the assignment) I have no prior database experience, and have no idea where to start.I want to build the database for a computer store which sells computer products. I don't want to make it very complex, since my database skills at this stage are very poor. I will appreciate if someone gives me a run down or steps in building this database. I have no clue where to start, since this is probably the first database i have ever built.
I want to build a database stored on a server which can be used by our employees as basis for their Excel pivot reporting
The idea is as follows:
I make a query that will get selected data (via odbc) from several Progress database tables of our ERP system and write them to one MS access table
The idea is to run each night at midnight a query (append or make table) via a schedule and gradually build a huge database table holding sales details
This table will be used as basis for the Excel pivot reporting .These reports are currently run directly on the ERP system's database which slows things down
Question:
1. Is it possible to automate the queries (perhaps via scheduler or 3rd party program ?
2. what would be better to use an append query that adds data or a maketable query which constantly replaces the data ?
3. How many ODBC connections on a MS Access database can I have at the same time ?
I have offered to help a local school ICT Dept with their A level projects. the first database they send me and I can't get further than the sub menus. I would appreciate any assistance as I don't know wether it is something I am doing wrong or something within the structure. I've opened it using the Shift key to look at the code and can't see anything wrong. Any help will be very much appreciated. Regards. Bernard
I am going to put my access database on a network drive so that four different computers can have access it. However will user-level security work if I implement it? For example, from one of the computers I implement 2 different usernames and passwords. If one of the other computers tries to access the database will they also be presented with the logon screen?
I am creating a database which keeps control of stock. Each item is scanned in with a barcode scanner and given a unique stock number. The Manufacturer, System, Subsystem, Location and Classification is then added.
When a customer phones, and orders a product i.e. a camera, a customer order number can be added to the item in stock. The problem with this is that if the customer is ordering a number of items, and other items are not in stock yet, this item needs to be seen as unavailable. Due to large amounts of stock, i do not want to allocate the customer a specific item with stock number, but just allocate one of the many items of that sort. I do not want to allocate a specific item as when you go to collect the item from the stock room, every item of this type would have to be checked to find the specific stock number, which would be timely and difficult.
I tried using a make table query, which copies the information from the stock table, except the stock number, and so with this list, i will have a list of every item. I can then produce a table which shows me how many of each type of item is available. The problem is, this needs to update every time more stock is added, but i also need to be able to allocate a number of the items, and this becomes unavailable stock. At the moment, each time the query is run, the information is overwritten.
Please can someone help me if they can think of a better idea of how to do this! Im not that hot on programming, and so a in depth description of what to do would be great!
I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?
In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.
I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?
In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.
I have a database whereby users already have to sign in with a username and password, using a form which them allows them to view a front page. The front page allows them to access data and add/amend it.
I now have to adjust this setup as we have directors who want to view the system, but we don't want them to amend it.
Is there anyway to change the current setup that I already have or do I have to scrap it and start again?
I have created a database and made the steps to the user-level security and VBA protected the project but i lost the passwords and the MDW file.
is there any way to reset the VBA pass then reset the security level?
this is very important for my business it's a school database with lots of info and it's critical for me to update or at least export some reports and forms to a new project
I am a beginner with making databases, so am looking for a bit of advice so I can know where to start. What I'm trying to do is make a stock control database for our drugs dispensary as there are constantly drugs going in and out and they need to be able to keep track of where drugs have gone and what quantity levels they have.
I also have a 2D barcode scanner which scans and reads the drugs barcodes in the following format:
Product Code [Enter] Product Descripition [Enter] Batch Number [Enter] Expiry Date [Enter]
So I would have thought the best thing would be to have a form with these fields in so the user could scan a barcode in filling in these fields. and that would then input the drugs into stock (Obviously there would be a quantity field too)
But where Im getting stuck is how could I then produce a form much like the one above with a search button. So the user could blip in the barcode filling in the relavant fields and then search for that product based on the products batch number?
I have started making a stock control database, i have spent about a week on it, And i am struggling! There are obviously lots of different ways to actually build them efficiently. My problem is that i want to add stock and take stock out, changing the stock quantity and obviously keeping track of stock. I only want to ammend the stock quantity, in the stock table if the item is not a new item. The stock is added via a log sheet which could also have a new item. My head is beginning to hurt, but with a bit of help from you guys i might be able to crack it.
The Tables I have are:
tblStock
tblCategories
tblSuppliers
tblInventory transaction
tblStock_in
tblStock_Out
tblEmployees
Is this sufficient? Can i add stock and take stock out with one transaction table? Or would i need to add another table? I believe the code would be through a query but again am a little unsure as never done anything like this!
I am quite new to access and i can grasp things quite easily.
Basically i am make a stock control data base for a food company. I am making it so theres an order table and a stock table. Basically i want to know how to change the Quantity avalible in the stock table fom the orders table.
I dont know if i have explained that very well. But basically i have related the product name in the stock table to the product name in the order table. So i can add a number so that that the quantity of the product will change on the stock table.
If there are any easier ways of doing this rather than having 2 tables it would be useful
Ive tried all types of things and i cant get it to work. Any help would be very much appriceated.
I'm in over my head with something I've been asked to do at work as my access skills are pretty basic.
I need a sample database containing PRODUCTS and SUPPLIERS, that lets you book IN stock received from the supplier (and adds to the stock level) and lets you book OUT stock issued to staff (and reduces the stock level)
I'll have a go at reorder levels, form design, stuff like that myself, but I'm having trouble with these very basic requirements.
Does anyone know of a sample database that I can download to learn some of this from?
I need a basic Product database that allows you to have a drop down menu to select a product from a table. In turn this puts the unit price in for you, you then put the quantity in and it calculates the total.
I also have a stock control. When one is bought it takes the quantity down. Very simple I know but I can’t get it to work….
If there are any good basic database templates i could use let me know
I am a realtivly new user and I do not know alot of things about Access
I have set up a database, and within this database, i have a table with my product details (the products are books, details include: ISBN, Title, Stock Level, and Price), I also have a table with customer's information (Name, Contact details, etc). I have created an order form, from which a user selects the customers name from a drop down list, and then he selects his name, and finally the date. Following this the user then works within a subform.
This subform has the following details, Order ID, Book ID, and Quantity Ordered. After this I want there to be a subtotal. I have no idea as to how to set this up, but I am assuming that I would need a query or something, to look up the price of the books, and then to multiply it by the quantity that the customer wants. Following this ideally I would like a small box on the main form saying the total value of the order.
Would their be anyway, to add the book ISBN number into the subform, where the user could either type in the ISBN number or select from a combo box the book title, but either way, both fields are updated, what ever method is used.
From this subform, I would like to be able to print out an order summary/invoice. This would contain all the books ordered by the customer in the current transaction, as well as the customer’s information, and the total of the order.
And my final question is probably the hardest one. Is their anyway (possibly by pressing a button) to automatically minimize the stock value on the products table, by the quantity chosen by the user in the order form? And if the quantity wanted is greater than the amount in stock, for a message to appear on the Order Summary/Invoice stating "On Order"
Using the above method, would it then be possible through the creation of a query to show what customers have ordered in the past, in a tab on the customer's details form.
I am a realtivly new user and I do not know alot of things about Access
I have set up a database, and within this database, i have a table with my product details (the products are books, details include: ISBN, Title, Stock Level, and Price), I also have a table with customer's information (Name, Contact details, etc). I have created an order form, from which a user selects the customers name from a drop down list, and then he selects his name, and finally the date. Following this the user then works within a subform.
This subform has the following details, Order ID, Book ID, and Quantity Ordered. After this I want there to be a subtotal. I have no idea as to how to set this up, but I am assuming that I would need a query or something, to look up the price of the books, and then to multiply it by the quantity that the customer wants. Following this ideally I would like a small box on the main form saying the total value of the order.
Would their be anyway, to add the book ISBN number into the subform, where the user could either type in the ISBN number or select from a combo box the book title, but either way, both fields are updated, what ever method is used.
From this subform, I would like to be able to print out an order summary/invoice. This would contain all the books ordered by the customer in the current transaction, as well as the customer’s information, and the total of the order.
And my final question is probably the hardest one. Is their anyway (possibly by pressing a button) to automatically minimize the stock value on the products table, by the quantity chosen by the user in the order form? And if the quantity wanted is greater than the amount in stock, for a message to appear on the Order Summary/Invoice stating "On Order"
Using the above method, would it then be possible through the creation of a query to show what customers have ordered in the past, in a tab on the customer's details form.
I have attached a copy of the relationships, as well as various images, the order form, customers’ details and product details forms.
Thanking you in advanced CJM
*If more images are needed feel free to ask
Order Form http://img32.picoodle.com/img/img32/5/11/30/f_Untitled1m_9a2e33a.jpg
Product Form http://img34.picoodle.com/img/img34/5/11/30/f_Untitled3m_2e1c239.jpg
Customer's Details Form http://img01.picoodle.com/img/img01/5/11/30/f_Untitled4m_0b196eb.jpg
I have been working on a stock database for my company. It needs to hold stock data, Any adjustments in the storesperson may do (QtyIn or Out). And allow Customer PO's to be raised (just to show prices and quantites sold to customers)
I then want to create a query to work out the total stock.
At the moment i have two queries, one to Sum the adjustments and one to sum the PO's. (The stock is not removed from the Customer PO until invidual line is shipped)
I then need to combine both these queries to work out the total stock value.
There will always be a value in the Sum of Adjustments but not in the Customer PO. So when i run the query to =SumofAdjustments - SumofCustomerPO's, if there is no record in the SumOfCustomerPo's, no value will appear.
I am student, in high school, and I have to make a stock database, for ITGS, so as to receive my IB diploma.
I have created forms so as to enter stock information, and customer information, but I have no idea, as to how to connect them, so as to create an order summery and invoice. I started by creating 2 tables, one for the books, and one for the customers. I then made 2 other tables, one being an order table, and the other the linking table between the order and the books (see relation.jpg). I created a form so as to input information, but I can’t seem to get it to work, (see form.jpg)
Ideally, I would like the end-user, to select the customer's name, from a drop down list, and then for the rest of the customer information to update automatically, then, for the end-user to select a date, and finally the end-user to select books from the stock. Once the end-user has finalized the selection, they would ideally press a button, which would automatically print out an order summary/invoice (Maybe a report?)And that would also automatically reduce the quantity of the books in stock by one.
I have no idea as to how to do this and I would really need someone’s help, seeing as I have less than a week to hand this in by (The deadline is Monday 16th November 2007)
Here are the images form.jpg - http://img30.picoodle.com/img/img30/5/11/18/f_formm_78d6ea7.jpg relation.jpg - http://img03.picoodle.com/img/img03/5/11/18/f_relationm_6280f62.jpg
I am trying without any success to build a small stock control database.
very simply put I am the main site and I have many other sites. each site has a unique code. I have 4 products only. I want to have the total stock that I hold in my site and as I send stock to other sites I want the number to decrease from my site and be added to the other specified site.
