Hi, I am trying to implement my Database with an enquiry (or quotation) table and I am not sure I am heading in the right direction:
-We use assemblies made of components and the data are held together in the database with a 'Bill of Material' set up.
-A typical assembly is made of 1 or 2 bodies + Fasteners (straps and screws),
-The body price is calculated depending on his weight and an extra costs can be added with extra tooling and machining,
The costumer ask us for a quotation for various number of assemblies and we send back the estimation of the price,
I am really struggling to see if my tables are set right and this is what I came up with (attached rr.zip):
A main Enquiryfile Table is linked to an enquiryDetail Table which would record each individual item information for each Enquiry.
I have also added a Extracost detail table that would record all the Machining and extra pattern making cost for each assembly.
And finally, and that's what I am far to be sure about, a TblChildItemCost where the price of each components would be recorded (for each enquiry detail). The body price is based on his weight but also depend of various market exchange rates, that is the reason why I have created a table for the price of component for each enquiry.
I really hope someone can help me on that one...Thanks in advance.
I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access for the main raw data for my database. This being inventory it changes daily so I am updating this table every day. When I try to append the table it ads all the records. I am wanting an easy way to add only the new records/take out the ones that are no longer there. Basically update the table with what is currently there.The only have I have found to do this is by running non-matching queries and update queries.
I am new to Access and Ive created adatabase to control a spa system. I have several tables: Customers Employees Types Of Haircut - Their prices Types oF massage Their Prices
Now I want To create a form where i am able to choose customer, the employee performing the haircut or massage The price should be displayed and the total AMount
How can I do that? Should I create a Query and based on the query I create the form?
I am still a bit confused about the system.mdw file. I create FE and BE on my local computer and change name of system.mdw to say Jobs.mdw, after backing up system.mdw I then join jobs.mdw with my jobs FE and jobs BE and set secutity settings, etc. I then place FE, BE and Jobs.mdw all in the same folder.
I now email jobs database with jobs.mdw file to client which places FE, BE and jobs.mdw in Jobs folder on server. Shortcut for fe is placed on each local machine.
My question-Does Jobs FE and Jobs BE still access Jobs.mdw even though placed on another computer and possibly another version of Access?
I am creating a database to room allocation in a small hotel. I want the system to check room availability between two dates. What would be the best way to construct this in Access?
My application I develop should retrieve some meta data from Access system tables. It should find: - What tables are stored in database. - What columns have each table in database. - What relationships are between tables in database. I opened systems tables of some .mdb file and took interest in such kind of information. But I got some problems by looking for what exactly I need. Please, could someone help me at these points:
1) I found that in system table MSysObjects I can find names and ids of tables created by user (for example by me). But how to determine that these tables are created by user and they are not let’s say a system tables? 2) I didn’t find any meta data about columns of tables! How to determine what columns has each table?
I created application which uses MS SQL Server to retrieve such a kind of meta information and there where no problems. But I stuck using Access. I was looking for some information in Internet but ineffectively. Please, help me...
Hi, I’ve been having some problems being able to do some things on my database, I was doing ok creating my system but now I’m a bit confused about what to do and I’ve been trying but getting no where. Firstly on my order form I need a total for the products which are in an subform and after the order is complete I need to be able to create an invoice and keep all the order information in the 'invoice' and 'invoice details' tables. I also need it to update the stock levels after the order is complete. Then I had created a tab in 'view customers' and I wanted to have it so that past customer orders could be viewed. Any help is appreciated; here is a link to my system: 'Gamez System' (http://www.savefile.com/files/5877934)
I have a form where I enter student names, and it often happends that I enter the same student a couple times, Is there any way to let the user know that there is allready someone in the system with the same name, like a pop up message.:confused:
Someone, who is no longer working at out organisation, created a system in Access which we are trying to get into, however the creater put on some security which will not let us open the system to alter. Is there a way of getting into this?
I would like to issue a system command from within a VBA function. Specifically, I'd like to start another application using a command-line startup command, but am not sure how to do that.
hi i am trying to make a quiz system using ms access i want to select 30 questions randomly from a questionbak of 100 or more also i need to select 3 answers randomly including the corect answer from answer bank that has 5 possible answers for each question
I'm working on my A2 IT Access project atm, and my aim is to produce a fully functional db for use by a golf course, incorporating membership information and tee-time reservation system.
I've got the membership side pretty much sorted, so now I need to start work on the reservation system. But where to start?
Basically, the user needs to be able to view slot availablity on a specific day, and make/change/delete bookings quickly and easily. The booking also needs to contain the party size. The bookings themselves should relate back to the specific member that made it via the MemberID field. The user should be able to make bookings upto 6months in the future. Block bookings should also be possible, so that the admin can block an entire day out for a tournament therefore preventing member bookings. The first available and last available slots also need to be editable by the system admin to take into account time of year, light conditions etc.
Right, so i know there's quite a lot there, and i'm sure i'll come up with more features that would make it better. But as it stands, that's something to get me started.
I'm not asking for someone to do the project, just to point me in the right direction as to suitable table structure, how to "make" the slots, how to store the bookings in the table, etc.
Is it possible to loop through all forms within a project and look at its controls? I was requested to change some object names to a more generic name, but I would like to find all references of the form within the Access application. Is there an easy way to do this?
I know that the MSysObjects contains the listing of all forms, but I don't know how to generically type cast a local variable to the form name listed in the table.
Does this make sense? There has to be a way to do this, but I haven't found anything in searching this forum.
I have little experience using Microsoft Access, but am attempting to create an order management system.
I have designed a system to store customer details and allow the entry of orders. I now want to develop this so that the system can handle delivery notes.
There are currently two tables for order information, since each order can consist of multiple items. So, general information, like the order date, order number and salesperson are stored in an orders table. A second table, Order Detail lists the items and item specific information along with the order number of which they are a part.
A whole order (i.e. all items assigned to one order number) may be delivered at once, or in smaller consignments. However, every consignment must have a delivery note with a unique number. So, there may be several delivery note numbers associated with each order, relating to different shipments.
I therefore need to create a system which allows the user to select which items from an order are being dispatched and then get Access to do the following:
Create a new record in the delivery notes table. The delivery note number will therefore be created (it's an autonumber). The user should be prompted to enter the delivery date and this should be stored in the date column of the delivery notes table, alongside the delivery note number. Enter the delivery note number in the "Delivery Note Number" field of the Order Details table, for every item that the user selected as dispatching.
Once this is in place, I will then be able to pull all the required details together with a query and then print the delivery note.
Bearing in mind that I'm very new to Access and so don't have any knowledge of scripts/macros etc, can anyone tell me how I can achieve this?
I have the following code for the text field (Before Update)
If IsNull(Me![DyNo]) Then Me![DyNo] = Format(Nz(DMax("[DyNo]", "[tblAllDet]", "[TheYear]='" & Year(Date) & "'"), 0) + 1, "00000") End If Me![DyNo] = Format([DyNo], "00000")
The code starts giving numbers from 00001, 00002, 00003 and so on. The problem was that when I have to search, I have to type the zeros before the number i.e. 00007, 00008 etc. otherwise the search form doesn’t show the relevant record. Ideally, I would like the numbering system to be 1, 2, 3, etc. (without the zeros). I tried changing the code to “0” but with the single “0”, I am unable to insert records beyond No.10. Is there a way to change this code so that I get only 1, 2, 3 etc and not with preceding zeros ? Grateful for help.
I'm not looking to spam anyone or sell their data but need help to test a simple market research system that i have built. I'm looking for about 25-50 people to let me send them an email inviting them to a webform to see if the "process" works correctly from start to finish.
The form asks for limited data about people but nothing that can identify them personally. Just gender, age group and postcode prefix.
Can anyone who is OK with sending me their email address to enable me to test this please send to:
After hard work done, my system become ready. Now I want to deploy it in the clients computers. What is the best installation software my system files from the CD disk into the user computer?
Hello all being my first post i will try and make this as clear as possible...
its a new system my company.
my manager would like if possible the system to work in this way..
firstly a form whcih will book rides so when opened will ask current members to etner their card no which is a 16 digit number always beggining with 5555 1946 and the customer no. added on which is 0000 0001.
If a customer has not registered another link so they can register and enter details and once done this press enter and message generating a new 16 digit card number 1 mroe than the highest number in the system. new members are allocated 2000 points on their card and points are taken off when booking new rides plus a 10 point booking fee.
then a button will be clicked to take back to reserve rides which allows the customer to book a ride using the ride id and ride number on a specific Session of which there are 3 times in the day 11:00, 14:00 and 17:00 and with a maximum of 5 places on each ride during each session being able to book.
once session ID and time,date selected the next box should show the available rides
if member does not have enough points to book an error message is displayed.
I know this all sounds confusing and ive attached my progress so far its very basic being a basic user i hope users out there can help as this has to be done before friday
We have a relational DB that holds information on West Nile Virus. Currently, we have 5 tablet PCs that take a full copy of the DB and updates/edits are done in the field.
Once a month, the tablets come back and someone manually takes the 5 databases and uploads the changes to the central database. I want to find an easier way to do this. Some sort of 'synchronization' type of process.
Can anybody recommend anything? I am not too experienced with Access and this sort of functionality.
I think ideally I would create an application to check data in and out of the central DB, but I'm not really sure where to start.
I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and hopefully display a daily screen with a grid showing who is booked out with who at various time of the day. Can anyone suggest some piece of freeware or example database to get me started?
I have 5 computers in my office. What I want is after networking these computers, I want that the Office note and other work done by one employee should go to another with some pasword and it should also have a log details.
