I was wondering if anyone has an example of a system documentation that could be shared. I'm about to start writing one myself and I'm not sure what to include in the documentation. Thanks in advance!
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
Is there a web site that has examples of databases to search through to give planning ideas? I've offered to help a friend out :eek: , designing a database which will record all the customers/sales for her small online business. It would be a real help for me to see if there is a 'template' if you like, how this type of database should be set out
Have the situation where a database backend is on a number of sites and if changes have to be made to the design structure of the backend database I would like to run a VB generated report to check that all indexes are correct. While this is not an issue with single field indexes, I have issues with multi field indexes.
Does anyone know where I can find Invoice Database Examples.
I am creating a Invoice Database at present and am having difficulties trying to work out how to do the final total.
I have many records for each inoice all linked by invoice number. I need to do a query of this table to show me all the invoice items for a particular invoice number then add all the individual item totals together to get a final total.
I have been wondering about how I'm going to keep track of revisions for one of my databases.
Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the FE. All table data in stored in the BE and linked to the FE.
I have recently got my act together and started documenting all the revisions I make to the BE and FE of the database. To do so, I created two tables with the following fields:
RevID (PK Auto increment), RevDate RevNumber RevisionNotes TimeDateStamp
I called them tblRevisions_FE, tblRevisions_BE. I placed both tables in the BE.
Whenever I make changes to BE / FE, I record it in the appropriate table.
However, because I often work on the FE of the database off site, I don't have access to the BE table (tblRevisions_FE) to record the new changes for the FE.
One alternative I thought of was just recording the revisions in a text document, and asking the client to manually record these in the tblRevisions_FE (via a FE form).
I did have tblRevisions_FE located in the FE, but when each db user got a copy of the FE, there would also be 4 copies of the table floating around.
Does anyone have any suggestions about how to manage documentation of FE revisions in this situation?
Hi I need to create a documentation - help system in my Access database. Can you give some guide lines and tips? General of course... like how to link a help file or something like that... thanx for the helping hand
I spent a great deal of time trying to load up a picturebox with an image stored in an Access data base.
The thing that was most troubling was the complete lack of documentation.
Every feature that exists in VB or Access had many, many man days spent in development. Which means that someone has extensive documentation on it.
Yet, when I went to Microsoft web site to look it up, I was told my product (access) was not supported in the us, but rather I had to pay $99 to speak with someone.
It is a shame that the Microsoft monopoly is able to steal from the consumers and the little developers. Not to get to political but i think it is unfortuante that the bust up of microsoft was averted. It is really a drag to the little developer the lack of documentation and proper development of so many features of their products.
Perhaps I am missing something but is there a place to find proper documentation on the various components - with examples of use?
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.
Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new.
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?
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.
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.