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 Complete Forum Thread with Replies
Related Forum Messages:
Hire System - Append Query
Hi, I am trying to creat a booking system for cars which has a specification of being able to be hired by the 'week'. I am thinking of creating a table with every week date (every monday) from Feb 28 2005. Just wondering how I would create a table do to this with an append query? I was thinking something like looping from Feb 28 2005 (monday) and dateadd + 7 a few hundred times then having an HireID field in the same table and once a car is booked for a one week period its start date hireID (or CarID) are entered into the database so nothing can be double booked.. I am just not so sure how I would reuse each date for all the different cars? Any ideas on this are much welcomed. Thanks in advance, Scott.
View Replies !
Looking To Hire Someone To Make Changes
Hi, I'm looking to hire a capable person to make some changes to a simple Access 2000 database. Changes would be relatively easy, and shouldn't take someone in the know more than a few hours. Looking for a quick turnaround, please. Scope is modifying form to show a command button based on the status of a check box, modifying a db value, then sending a simple email notification. I can provide the db and scope of work on request. Please PM me if interested or email me rbrong (at) gmail.com Experienced people, only please... Thanks in advance, Bob
View Replies !
Where Do I Hire Access 2000 Database Help?
Can anyone direct me to someone that does work with Office 2000 Developer to complete a database runtime version. I paid Microsoft for help that was expensive and all i got was suggestions to but more software. I own Office 2000 Developer 2000 version 1.5. Its a small job so I dont know where to start looking for someone to hire. Thanks
View Replies !
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 Replies !
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 !
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 !
|
TRACKER
