How do you use microsoft access to update your inventory for example if i have 10 pencils and 5 is gone updat.
436027
The usual way to do this is to have 2 tables.  One table for your purchases (i.e. the items you are bringing into your inventory) and another table for sales (i.e. the items that are going out of your inventory).  The common link is a part number (i.e. some unique number to identify each item).\n\nYou need to load each item purchased and qty. into the "purchases" table and load each item sold and qty sold into the "sales" table.  If you purchase and sell the same items over and over you can just keep adding rows to your purchases and sales table.\n\nTo see what you have on-hand you make queries that sum up all the purchases by part number and sum up all the sales by part number.  You join these together and include a formula to subtract sales from purchases.  The result is what you have on hand.\n\nDoing it this way gives you a running history of what was purchased and sold.  You never have to change or replace your original data - you just let the system do the math to tell you what's on-hand.
147176
Sure you can.\nYou just need to understand the logic of inventory system. Then you can build it using internet/web programming.
566403
Microsoft Access software can do that.
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
378243
Check the syntax of your Update query\n\nIf you are using Transactions\n\nYou may not have committed a transaction.\n\n\nIf u r editing via Enterprise manager , do necessary edits close and open again
554377
yes either you delete it with right click and then delete or you move the item to a different folder. if you have drag and drop activated just open the folder and drag the item into it. if not there's the option "send to" , or  copy/cut and paste (right click).\nif you hold CTRL you can select many items at once and delete or move the whole bunch with just one mouse click.
291418
just copy everything in the old bulittin...\n\nand paste and post a new buletin....
852680
Well don't know the version of access you are using...\n\nFor Access 2003\nhttp://office.microsoft.com/en-us/access/HP051874901033.aspx
331981
Inventory - well just ask the accountant for a list of all purchases during the last two years, if they ask if you need it tomorrow, tell him or her that if you needed it tomorrow you would of asked for it tomorrow.\n\nThen count all the computers, monitors, and servers, printers, office desks, chairs, give a brief description of each and give them to the accountant to determine a replacement cost, and  a current market value... and again if they ask if you need it tomorrow, tell him or her that if you needed it tomorrow you would of asked for it tomorrow.\n\nIf anything goes wrong - blame it on the accountant...\n\nif you want any more advice on how to climb the ladder your going to have to send me money.
954951
http://www.accesscatalog.com/shop/login.htm?ProgramID=29
238613
How many items? If it's over 1000, you better go with access, or get frustrated trying to use excel (unless your needs are very simple). I think excel has a limit of about 65535 rows, but if your tracking that many, you definitely want to use a database such as MS Access.
133735
you may have forgot to check the "Keep a copy in Sent Items" checkbox
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
244783
This will be difficult because they are updated daily. Hopefully some one can help you\n\nBest of luck
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
785901
Hi,\n\nTry using the Windows Product Key Update Tool, available here:\nhttp://www.microsoft.com/genuine/selfhelp/PKUInstructions.aspx\n\nThis should allow you to put in your now genuine copy's key to overwrite the other one. It should also check the windows system files to make sure they're valid too.\n\nPlus a thumbs up for your q ;)\n\nHTH