Spa System
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?
Please Help!!!
Thanking you all
View Complete Forum Thread with Replies
Related Forum Messages:
System.MDW File
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? Does the shortcut have to reference Jobs.mdw? I need to understand this. Thanks, Jim
View Replies !
Payroll System
Hi All, Need your expert advise. Is it ok to develop a simple payroll system using MS Access or do i need switch to Visual Basic? Also, is there anybody can help what tables do i need to produce a payroll system, i.e. tblEmployee. Thanks, 19Summer95
View Replies !
Reservations System
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? Kev
View Replies !
Set An Equiry System
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.
View Replies !
System Tables
Hello, 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...
View Replies !
Hire System Help
I have two tables, one named Loan and one named DVD Details. On my DVD details table i have a field name, on_loan with a data type yes/no. I have created a form called LoanForm where i want to select a DVD with a combo box, then select a Set loan button that will set the corresponding DVD on_loan field to yes(true), in the dvd form. on the button i have the following code Private Sub HireDVDButton_Click() Update dvd Set car.on_loan = True End Sub But it doesn't seem to set the on_loan field in the DVD table to true, which is what i want to do. Sorry if it's not clear what i want to do. I am just a beginner. Thanks in advance :)
View Replies !
Difficulties With System
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) Thanks, Bob.
View Replies !
Checking If The Same Name Is In The System?
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: thx
View Replies !
Getting Into An Access System
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?
View Replies !
Issue System Commands From VBA?
Hello, 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. Any suggestions? Tom
View Replies !
Missing System Mdw File
:mad: Somehow the system mdw file is missing after I have reinstalled Office XP Professional and every time I try to do anything like make a new file or open a mdb file the dialog box opens saying the workgroup administrator cannot create a new mdw file. I am the only person to use this computer so I must be the administrator. How can I rectify this situation as I cannot use MS Access without a system.mdw file :(
View Replies !
Access Quiz System
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 tblquestionbank QID Question 1 Question1 2 Question2 3 Question3 tblanswerbank AID QID ANSWER CORRECT 1 1 Q1 answer a true 2 1 Q1 answer b false 3 1 Q1 answer c false 4 1 Q1 answer d false 5 1 Q1 answer e false the field correct is for identifying the correct answer yes/no filed so far i have been able to get the questions randomly that is generating a random number in the query and selecting top 30 records ideas and help would be appreciated
View Replies !
Slot Reservation System
Hi there, 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. So, any input and ideas are greatly appreicated. Cheers Gavin W
View Replies !
Data Extrpolation In A BOM System
I am not sure how to deal with the weight of my items in my BOM system. I have got a TblItem Linked to a TblComponent that establish the relationship between each items (Assemblies made of various parts with assemblies and part stored in the same tblItem) I have a field weight in the TblItem, there is no value for the weight of Items that are assemblies as the weight can be calculated after by summing the weight of the components. How can I create a query which could show me each Assembly and each component Weight?
View Replies !
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
Help With Time Tracking System
I have a time tracking system where users can clock in and clock out. I want to have an error message when they clock in and then accidently clock in again. Therefore, they can only clock out after they have clocked in. The data goes into the table called "Timeclock Table". The fields in that table are SSN, Clock-In, Clock-Out, and TimeStamp. The clock in and clock out are check boxes. can you guys help me?????? Im just a beginner.
View Replies !
Maxing System Resources ....
I just found something interesting. I have a small db open. One form, viewing info. I notice in Windows Task Manager that MSACCESS.EXE is taking up between 70 to 97% sometimes 100% of systems resources. How could this be? Cheers! QTNM = )
View Replies !
Is It Possible To Loop Through System Objects?
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. Thanks in advance. CHuck
View Replies !
Order Management System
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? Many thanks in advance, Gary
View Replies !
Serial Numbering System
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.
View Replies !
Help Wanted With System Test...
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: mailconnection@dsl.pipex.com Your help is greatly appreciated. Thanks Vince
View Replies !
|
TRACKER
