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?
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)
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 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.
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:
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.
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.
I have been asked to create a database that creates orders, debits stock etc for my company. Now I have been asked to put in some kind of discount table with percentages for each individual item for each individual customer. What would the best way of doing this?
I figured in the Customer Table I would have a code such as 'CustomerADiscount' and 'CustomerBDiscount' etc. and then in my table maybe
Product A - CustomerADiscount - 10% Product A - CustomerBDiscount - 20%
Product B - CustomerADiscount - 5% Product B - CustomerBDiscount - 7%
This link these values up within a query? Would this be the best way of doing it?
Is Access able to determine a percentage in "10%" or "5%" or do I need some type of formula for it instead?
My question is simple: I've got a database of my book collection. If i view it in a style sheet, it is something like
Author Title etc.
A 0 C 1 B 3 F 2 D 5 D 4 A 8 F 9
I would like to order the Author and Title columns (permanently). Particularly, I would like to order in alphabetical order all the authors and, if I've got the same author, order his/her book alphabetically, something like:
Is it possible to direct the placement/order new of fields when modifying an Ms Access database in code?
I need to modify the schema of an MS Access database via code - but I want to be able to direct the order or placement of the fields within the tables.
For example - if TableOne has 3 fields - Field10, Field20 and Field30.
I would like to be able to add say Field15 between Field10 and Field20 - not just append it to the end of existing fields.
I believe it is possible as you can do it within Ms Access itself. I can use ADO, DAO, ADOX or SQL for that matter - but it seems all of these offer no placement of the field within the table.
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?
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?
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?
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.
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.
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
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?
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?
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.
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?
I have a report based on main database that list all "Sites" by Manager, when i open the report it gives me all the details that I want, what I would now like to do is page break at the end of each manager, in addition the each record as a "completed" and "active" field I only want to show on the report the "Active" Records. ie:- After it reports all the Active marked sites for 1 manager is starts the second manager on a new page, can this be done? and how do I do it?
I'm in the process of recreating a contact manager for a group of salespeople at an office I work for... What I want to do is be able to consolidate all of the contacts in a single contact database on the back end. Then the records will have specific users specified to each record, and what I want to happen is that the users will open up their own database, and they will only see the records pertaining to them, and they can't change who gets the records.
Here's where it starts getting tricky. I want the manager to have access to all of the records, and I want him to select which user's contact list he wants, and it brings up those contacts. I want him to have a combo list on the screen where he can select who gets which contacts, and he can change them throughout the different users.
Related to each of these contacts is a subform, called CALLS... When this button is clicked, any information regarding past calls is brought up, and the user can add information about a call that is made. This checks the previous form that is open to find out the ContactID so that it can open up the corresponding CALLS entries in the CALLS table.
Here's what I did: I created a new contacts form for each salesperson (there are 5 salespeople). Then I had to create a new subform for each salesperson for the CALLS, and then the information will be gathered from the proper subform to the users contact form.
I can do all of the above, but it seems kind of redundant to do this for all of the users, and I'm wondering if there is an easier way to do this. Also, in the future if more salespeople are added and I'm not here for the company to set up the new users, I would like to see if there is an easy way for them to set it up (like adding a new value to a few different spots)...
BTW: One difficulty is that they are already using a previous contact manager (not designed by me) that has hundreds of contacts, but each user has their own separate copy of the contact manager which is just copied and pasted onto their local drive when a new salesperson arrives. I will also need to import all of their previous contacts, and I would like to maintain as much of the original structure as possible to avoid dealing with user compatibility problems.
If you need to see the contact managers, please let me know. Any questions, i will be glad to discuss. Thanks.
I have tentatively gotten an indirectly synchronised database system to work on a testing basis, in the following way:
1. Design Master - resides on network. 2. Replica Master - replica of master, resides on network 3. Local replica on the windows desktop of my laptop (as one of few folders with write authority). These three are managed by a synchroniser running on my laptop. 4. Other people (3-6) also have synchronisers running - managing the Replica Master, and a local copy on their desktop only.
This appears to work. It was done as we did not have access to get a synchroniser process running on a server, just folder access (I am amazed IT accepted this without oversight, anyway..). I would be happy to describe the procedure.
However, does anyone have any advice on potential things that could go wrong and how to avoid them? What problems could crop up? I don't believe database size would be one of them. How about backups? I know that the network is backed up daily and can be restored to any day - but would this method of backup create any problems if restoring? How rare are collisions/conflicts?
Also, is there any limitations to using the Compact utility in Access on either the replica master on the design master? Would this cause changes to get lost?
Would be grateful for advice.
Edit: Addition, just as I was submitting this, my synchroniser appears to have gone into a loop... From the log file:
Time = 2007-01-22 01:23:55 PM Log Type = Close exchange Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3} Result = Failure
Time = 2007-01-22 01:23:56 PM Log Type = Cancel exchange Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3} Reason = More than one synchronizer is managing the replica
This looks to be a problem... Is it caused by having multiple synchronisers managing the same replica? Does it work to set them to manage the local one only? Advice GREATLY appreciated. :P