Order Manager Database
Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites.
Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have the database generate the ecommerce sites automatically as static html, which can be uploaded. As the orders come in they will be stored online, and then periodically downloaded into the database.
The reason is we currently have 3 sites running and managing inventory and stock control is the hardest, as currently there are 3 databases controling stock! Also when a customer telephones its difficult to know which site they have ordered from which is unprofessional, and we have to log into every site just to find their order.
Future ideas:- Meaning we are going to setup more sites which will obivously make the situation worse. We also want to branch out in into eBay using the eBay API to download transactions and sales, and will therefore need a place to store the data.
Can anyone foresee any problems with such a system? Any ideas or examples?
Thanks for your time.
View Complete Forum Thread with Replies
Related Forum Messages:
Switchboard Manager Disabled In An Access Database Project (ADP)
I recently converted an Access front-end application (that used ODBC to a SQL 2000 database) to an Access Database Project (ADP). I imported all the forms, macros, code modes, etc, including the Switchboard Items table. With minor tweaking to table references here and there (such as in rowsource, controlsource, and vba code) everything is working great--with one exception. The Switchboard Manager command (Tool-->Database Utilities-->Switchboard Manager) is disabled, and as a result, there is no easy interface available to change the switchboard items. I've been through the support.microsoft.com articles, but haven't found anything that solves the problem. I'd rather not have to re-create all the switchboard screens if I can avoid it. Anyone know why the Manager would be disabled in ADP? (And yes, it is installed, it's available in all my MDBs, just not the ADPs). Mark
View Replies !
Help With A Word Order Database
I am a modular housing sales consultant and I am trying to setup a work order database in access. This database would allow me to spec out a modular home for a prospective customer/client as they provide me with all of their home options (floors, exterior, doors & windows, interior, appliances, bathrooms, kitchen, etc.) and then print out an invoice with an estimated total. I am currently using an excel spreadsheet and it is very cumbersome to use. I use it as an invoice and the invoice contains the following information on it. Bill to: Dealer Name Dealer Rep Phone, Fax, Cell Ship to: Customer Name Customer Address Phone, Fax, Cell Home Options: Floors: Joist: (Structure Wood 2X8 Joist, Structure Wood 2X10 Joist, Plywood 2X10 Joist) Carpet: (Cappuchinno, Biscuit, Pebble, Summer Straw, Praline, Herringbone, Cashew, Buckskin, Shale, Botanical, Cordovan, Stone, Cascade, Black Ice) Vinyl Flooring: (Woodgrain #05296, Square Tile #57296, Mosaic #55296, Tan Stone #08296, Large Square Tile #07296) Interior: Interior Doors: (install, ship loose, 6 panel, flat) Hardware: (Brass, Brushed Nickle, Round Knob, Level Handle) Crown Molding: (4", 5") Base Molding: (4", 5") Appliances: Color: (White, Black, Bisque, Stainless) Dishwasher: (Standard, Power Scrub) Microwave: (Over Range, Free Standing) There are other options but this is just a brief listing of options as an example. Each option would have a price attached, and selected price would be added to the invoice, and once work order is completed, the invoice would have options totalled. Ready for the customer and dealer to confirm and approve. Can someone start me in the right direction on getting the tables setup for this - the one that I seem to be having the most difficulty with is how to setup the options for this invoice. I pretty well have a grasp on the others. I might also need help in relating the tables to one another. I hope this all makes sense. Any help would be greatly appreciated. Donm
View Replies !
Help With Clothing Order Management Database
Hi, I am trying to design and build an orders management database for a clothing wholesaler. Has anyone got any ideas on what entities i should have. I thought: Clients (Customer Details) Orders (Inc. order date, ship via etc) Order Details (sizes, quantity of orders per size) Product Details (Product Code, colour, size, stock numbers per size) Catergories (Shorts, Jackets, Jeans etc) Suppliers (Supplier Information) Delivery (Delivery Method etc) However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes And when i do the order details table, i need to enter order quantities for each different size for one clothing unit. Any ideas? I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc. Hope you understand and can help me!!! Thanks for your time J
View Replies !
Calculate Payroll In Order Database
I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... :confused: Any advise be greatly appreciated.:confused:
View Replies !
Order Entry Database Problem With Pop-Up Subform
I have taken the Order Entry database sample from Microsoft and have added a "Wizard" type interface. Question) I'm having trouble understanding how to get more than one Feature applied to a single new service. - For example, If I add a new SERVICE to an ORDER, and I need to add all available FEATURES to that SERVICE, how do I do that? *see my attached database & relationships. The form of FEATURES is also attached. I just want to be able to check off the ones that apply. (is this many to many? I tried a junction table but can't make it work) I would really appreciate some advice on my Forms, and definitely advice on my Table / Relationship structure. ps: My tblServices use to be called tblProducts. I then added the tblCategories, tblPaid, tblTeleServ, tblLongDistRate, tbl800Serv & tblFeatures. Thanks in advance for your help, jlig
View Replies !
Multiple Lines In Order Form From Single Database
I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost. 2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total. I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected. Can anyone hsuggest how best to do this.
View Replies !
Add-in Manager
Why does Access Add-in Manager not have any available add-ins listed? Do I have to install each one and if I have several users, do they have to install it individually on there machines or can it be done globally. If it can be done globally, how would I go about it?
View Replies !
Switchboard Manager??
I was wondering if there is a way to have a certain option in my switchboard only display if the user has administrative permissions to the database?
View Replies !
SQL Enterprise Manager For 6.5
Hello everyone, I have MS SQL 6.5 for NT installed on an NT server and I have the SQL Enterprise Manager installed. I'm new to Access and this is my first try at understanding SQL 6.5. Where can I find the Relationship window within SQL Enterprise Manger? Is it called something else or am I missing it? :eek: Any help will be greatly appreciated. René
View Replies !
Switchboard Manager
Hi, Wondering if anyone can help me with a problem I'm having with the switchboard manager. What I want to do is open a form in pivotchart view from a switchboard. I've set it as the default view to see if this makes a difference. I've not allowed any other view, no difference. Exhausted all basic property solutions and can't think what else to try. Thinking of either adding a control to the switchboards form in design view and bypassing the switchboard manager or would it be better to put some code into the form that says when open, open in pivot chart view?? Anyone have any other ideas?
View Replies !
No Link Table Manager
I am working on a new system. Have been given Full MS Access but Link Table Manager fails it gives a standard security warning that this new system enforces it says Opening: CProg..FilesMSOfficeOffice11ACWZTOOL.MDE however on selecting OPEN nothing happens. If Cancel is hit then long critical message saying in short " Can't find wizard , syntax error in delerations in VB. Likewise I cannot link to a spreadsheet without using the manager. Question is there anything I can do or is it the fact that these are options were not installed and it is an administrators job?
View Replies !
Need Example Of Multiuser Contact Manager
I've got a contact manager application that will be split and the backend will run on a server. I would like to take it to the next step where users can download their current appointments and upload any changes. It would be nice if they could do all of this from the field by logging into our Microsoft Server. However, it would be acceptable if they had to be in the office to do this. This is new territory for me and I would greatly appreciate any feedback, help and espcially an example. Thanks in advance!
View Replies !
Task Manager Problems
There are a few procedures that run when my Access database closes (backing up data, etc.). Since this can take a minute or two to finish (running over a network), one of the users here has started to use Task Manager to shut down the application. This is not ideal, as the same user has also deleted the backend on more than one occasion. Should both happen on one day, we'd lose that day's updates. Asking them not to do it doesn't work. Explaining why doesn't work. Telling them not to do it doesn't work. If I ask their supervisor to tell them not to do it, they just deny it. It's starting to look like the backup scripts aren't running, when they work fine for everyone else. Is there any way of either (a) Preventing them from doing this (unlikely, I'd have thought) or (b) Recording the fact that this has happened. It doesn't necessarily have to be recorded in Access itself - although that would be ideal - if there's some other file I can access to get the info? Any suggestions are gratefully received.
View Replies !
Table Link Manager
I searched the internet and different forums, but could not find the solution for my problem. In Access 2003 I splitted the database and made a mde file of the frontend. When I copy the front and backend to another computer it cannot find the backend due to the original path is included. To solve this I would like the database to link the backend that is available in the directory of the frontend. No more and no less. Is this possible? I find a lot of questions in this direction, but could not destilate a solution.
View Replies !
VBA Linked Table Manager
I have successfully automated the refresh of my linked tables using VBA (thanks to a post on this forum -- Cool). Anyway, what I would like to know now is this: If my table collection does not have any linked tables, using VBA, how can I get that list of available tables to show? Assume that I will be connecting to the same database (Oracle) through an ODBC connection. I dont wish to change the connection - just want that window with all tables to shouw up. Thanks guys/gals for the help.
View Replies !
Help Accessing Task Manager
this has been "bugging" me for a while. everytime i access task manager it opens for couple of seconds and then disappears. i heard that this was some type of virus and/or spyware related. norton, spyware, and adaware haven't seemed to solve this problem. please help
View Replies !
Linked Table Manager
Hello, Does anyone know how to use a Macro or Module to refresh/update linked excel worksheets in an access DB. I used to delete all the tables then re-add them. There must be a better more correct way. Any ideas?
View Replies !
Switchboard Manager Problem
I am trying to display forms to the user in datasheet view. The properties are set to datasheet as default and Form View to No. They work fine using the database window but are displayed in Form View when using the Switchboard. If the switchboard setting is Open in Add Mode no data is displayed. If it is Open in Edit Mode the data is there but in both cases they are in Form View. I am using Access 2000 and Access 2002. Can anyone help?
View Replies !
Records Switchboard Manager,
I have made a database in access 2003 I have forms, reports etc, which all worked great! then I did a switchboard manager,which took me to two more switchboards and one of them was forms it works great but when I open a form I can not use the find comand, and it does not show all my records but it does up date the table and everything else works great.It is just the find and records on all the forms and only when opened in switchboard when I open them from the database window they work fine.
View Replies !
Line-manager / Staff Relationship?
Hi all, I'm a bit stuck with a db relationship design. I need to hold information in a staff table about a person's Line-manager. My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their staff. I then came across a problem. I need to be able to select all the staff under a Line-manager. For example a head of department may have 3 team leaders who each manage 10 staff. I need to know all of them, not just the 3 team leaders who are directly managed by the HoD but their staff as well. As it happens there is no rigidgly defined managment structure per se for this organisation which makes things even more difficult. I assume there is a reasonably standard way of doing this as all organisations have some form of line-manager/staff relationship. Anyone care to enlighten me? Cheers TS
View Replies !
Help Cant Access Linked Table Manager
I cant access the linked table manager each time I try to run this I get this error 'Microsoft Office Access cant find the wizerd, or the wizard has not been installed, or there is a syntax error in the Declarations section of Visual Basic module" then it says "the wizard you need may be missing from the libraries key of the microsot office access section of the windows registry, or the wizards have been disabled. To make sure that the wizard is in the windows registry, run setup to reinstall microsoft office access and then compile all visual basic modules in the database.To reenable the wizard click about microsoft office on the help menu, and then click the disabled items to view a list of addins which you can enable" Now Access 2003 is installed as part of office pro, nothing is disabled, the additional wizards are installed. I have removed access and resintalled access same issue, I cant run a detect and repair as it asks for a cab file that is not on the CD, upon research I have found this is common and the cab file is no where, the only solution they suggested was complete reinstall of office, this does not work for me as I have stacks of terminal service clients using Outlook and I cant remove Office and have to setup each user up again. Now even if I did remove this and reinstall I am not 100% sure it will fix the access problem, can someone help me please, I have also noticed I cannot open add in manager or swicth board manager, the same error comes up. This is Office 2003 Pro on server 2003 standard. cheers all
View Replies !
|
TRACKER
