Hi Im currently building an Access aplication and Im looking for some advice.
What Id like to do is use a list box which has a list of items in it, once an item is selected and a button clicked for this information to be sent into a text box to then be stored by the database. Each new item should be added to the end of the list.
I was wondering if its actually possible and how you would go about doing it.
Thanks for your help.
Ok guys, im going to be flat out honest, Im new to this whole database thing. I've been doing a lot of studying and Decided that I am going to try my hands at a real simple and straight foward database. It seemed fairly simple but i guess not so im asking for help. I think my problem lies in understanding how the keys work, and what exactly they do for the database itself. And two the relationships, im not really sure of, i understand how to set them, but again i dont know what they do for the database in the end. Ok so heres what i got:
The object of this DB was to collect, store, retrieve, edit and display data for a fictious Print center that deals with Black & White copies and Color Copies.
3 tables:
Company
Customer
Job
these tables contain:
Company Table:
CompanyID Set to AutoNumber *SET AND PRIMARY KEY*
CompanyName Set to Text
Address Set to text
City Set to text
State Set to text with 2 Character limit for input
ZipCode Set to text with 5 characrtr input
Description Set to Memo
Webaddress Set to hyperlink
Customer Table:
CustomerAccountNumber Set to autonumber *SET AND PRIMARY KEY*
CompanyName Set to Text
JobNumber Set to number
FirstName set to text
LastName Set to text
PhoneNumber Set to text with mask set
FaxNumber Set to Text with mask set
Email adddress Set to text
Job Table:
Jobnumber Set to autonumber *SET AND PRIMARY KEY*
Jobname set to text
Jobtype Set to text
JobDescription Set to memo
DueDate Set to Date and time
Ok now hers the relationships I set up:
Company Table: CompanyID ------> Customer table:CompanyName
Customertable:JobNumber ------> JobTable:JobNumber
I tried and thought this would keep things simple but for some reason when i go to create my querys, i get this thing telling me that i have other data from another tabel and cant be edited, i figured out that i had to put the job in first to get a job number and when i go to enter the customers information i have to manually enter the job number in. (Kinda Sucks) I entered some sample data, and tried to make a form, I used the autoform and created a general form but when I flip to the last record in the DataBase it wont let me enter any new information, I thought i was suppose to do that, so i went to the table properties and set the table to Data Enrty Only, and i still couldnt enter new data.
:confused: Ok so theres my problem, I made a boat with duct tape and now im wondering why im sinking to the bottom. Any help would be GREATLY APPRECIATED and if possible a broken down real world explanation on how the keys and relationships work, and what they actually do for the database. I also probably didnt set up the data in the fields correctly, I was trying to normalize everything but im not sure.
Thanks guys! Im really greatful for any help you can offer! ~[MikE]~ :)
Hope nobody minds but I don't really know Access and I have a table that needs sorting pretty desperately.I have a table with 5 columns that I need to filter out so just the remaing records are left over.http://img208.imageshack.us/img208/7328/untitled1wb8.th.jpg (http://img208.imageshack.us/my.php?image=untitled1wb8.jpg)The column 'fax' is the column with the records in it and the following columns need the record removing if the box is ticked.TimFPS, OurFPS, OnFPS, NeedsToBeFPS, however the column 'NumberWeHave' I'm not too sure about so I'll ignore it for now (I may need to take them out later)Sorry to be a complete noob and if anyone can help it will be muchos appreciated.
View 2 Replies View RelatedHi all,
I need to develop a relational database to
track new construction -builders, subdivisions and
employees and additional info about each subdivision.
I want to be able to set it up so that the end user can
click on a drop down list of builders and then have
another drop down list of subdivisions to choose from
when updating or doing data entry.
Any suggestions would be greatly appreciated.
As basic parameters I have around 80 builders with
up to 150 subdivisions. I would also like to be able to use
this in other areas besides mine.
Hi! Let me explain my little problem:confused::
I have in a form two comboxes an a listbox. On the first combobox you can introduce the TAG, on the second one a machine. I need that the listbox show the values of the first and second combobox separated by a comma.
The first combobox= TAG
The second= machine
listbox=TAG machine value together without using the table
If you can help me I will appreciate your information:D
I am a novice user trying to set up a db for small business and am needing a little direction. Most of the company's sales come from the contracted work for remodeling homes; however a small amount of sales are over the counter sales within their showroom.
How do I set up the db to track the following: customer info, contract sales amount & date & payments & balance due, labor costs by employee and sub contractor, materials costs, and net profit from contracted amount vs deductions of costs?
Payments made are directly related to contracted sale and not labor or material costs; with the exception of the over the counter sales. My boss currently tracks the above info in an spreedsheet ... please advise. Any help will be greatly appreciated.
Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.
Help!!!
I am setting up a database with 'open' and 'close' dates of an event for each record/ID. I want to be able to sort/query my results into the next event (i.e. open or close) as it will be happening so that I can plan for each event, but I am not sure how to go about doing this. I have tried various queries but because the information is linked to one ID it does not want to duplicate the information in the record. I can set up separate queries for the 'open' and 'close' dates but I can't seem to be able to tie it together
=>I have 2 queries, but I really need it to be at least in one report in date order each record appearing twice ...once at the open date, once at the closing date.
anyone....please!!!!!!!
:) thank u
Okay my access skills are low at best and I'm trying to build a database for work so hopefully this isn't to stupid of a question.
I'm trying to creat a query that will allow the user to type in a work type and have it generate the all records containing that work type. The way the data is in there to get it to generate just a specific work type without the input I have to use Like "*newacct*" for example. Is there any way to do this since there are more then one work types for some records?
Thank you
Hi, I am trying to create a button that upon click it moves the slelected item in list box one to list box 2 but i am not sure how to go about it, cany anyone help?
Dominic
Hello people,
I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!
For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...
e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...
The relationships are all ok, the fields for Student ID are lookup, etc.
I don't understand. It's driving me insane. I need help with this, I'm struggling so much.
Help much appreciated.
Thanks - Neil.
Im in the process of building a database for a friends business, and im a bit of a newbie with access.
Id like to get some opinions on structure and overall how i should build the Database.
My goal is to have two types of clients ... donors and buyers.
A client can be both a donor, a buyer or both.
When a client is a donor, they get a certain amount of credits added to their account.
When a client is a buyer, they will be purchasing those credits from a donor.
heres an example of what i want to accomplish;
John smith donates 500 credits; I enter John Smiths info and credits into his profile;
Jim Doe buys 100 of John Smiths credits; I want the DB to automatically update Mr. Smiths Credits, and then add 100 credits to Jim Does profile.
Also, I want John Smith to be able to purchase credits from Jane Johnson, and again, have the credits added to John Smith and deducted from Jane Johnson automatically.
Get my meaning here?
The tables will also contain the typical client info ...ie; Name, Address, Phone, SSN etc...
Can i/Should i do a seperate table just for credits and link it to the client tables? Should i create seperate tables for Buyers and Donors?
Also, I have an excel spreadsheet with formulas to do credits already, but when i tried to import it into a table in access, it didnt work so well.
Any opinions on table structure, design etc would be greatly appreciated
Thanks all for lookin in
Hello to all,
i have a non-windows application and i would like to create a vb program to print invoices.
I would like to send to this program a txt file with all the values (qty, vat, customer name etc with vertical & horizontal positions in the form etc..) and then superpose all i need to print with an image (gif or jpg wich is the my customer invoice presentation.
In fact i have 2 layers , one with all the value i print and another with the invoice image background.
I'm a beginer with VB, so i need advices to create this program, maybe someone did this already.
Thx in advance
VINCENT
Hi all,
Im fairly new to access and im having trouble constructing a stock control system that can create sales orders and adjust stock levels accordingly, hold customer details linked to sales orders. Ive spent about 20 hours trying to do this and its just pickled my brain, ive searched everywhere but sometimes im uncertain what exactly it is im looking for. Can anyone give me some pointers?
I have 7 tables at the mo but its 4 of the tables i need for the sales order:
tblcustomerdetails
customerID,first name, last name (general customer details)
tblorder
orderID, customerID, delilvery address fields..., subtotal, total, delivery
tblorderdetails
orderID, productID, productname, description, listprice, quantity, discount, linetotal
tblproducts
productID, catagoryname, productname, description, costprice, listprice, profitmargin, suppliername, instock, reorderlevel, quantityperunit.
what im trying to do at the minute is contruct a subform for a form that would require entering the products into through a combo box selected by productname and then autofill the product description and listprice. Ive ended up deleting all my forms and queries because nothing seemed to work right. I will then add this sub form to a form containing all the customer information and the total price for the subform this then needs to be output to a report for printing, but i can figure that out later. Ive attached my database if anyone wants a look if you dont understand my jibberish.
thanks
Hi all
First post.
I was wondering if this could be done in Access. Let me explain
I work at a candies manufacturer in Puerto Rico. Right now we are not tracking any kind of inventory. Is it possible to efficiently track our kind of inventory ( raw materials, work in process and Finished Goods) in Access?? Maybe using a bar code system??
Is it possible??
Please advice
Thank you
Hi
I would like some advice or opinions from people who have worked with access and mysql.
Currently we run a large database in access which holds around 3500 records. It is actually running quite slow at the moment. What would you suggest to speed it up? ive heard running it on a sql server but i dont have the info to know if this would be correct.
Also i was thinking or changing the access database and getting it fully redone in mysql why would this be more advantageous?
Also i havent any knowledge on MySql is it easy to learn for a beginner? Do you have any information such as websites i could visit to learn or sample databases? Or would it not be worth me learning it? What would you see at the front end and back end?
Sorry to bombard you with questions
I value your opinions
Thanks
Hi,
My client wants me to make fields from different tables on the same form which he wants to use for input. This has made it very difficult for me as my queries have to involve a lot of outer joins and in some cases full joins.
Any suggestion please?
Hi all,
I'm trying to set up a database, which I've done before on different programs, but I'm new to Access. I have a rather elaborate plan but am not sure it's actually possible.
I would like to set up a system that will effectively take input from the user within a record on the database. In simplest terms I'd like to set up a form on which the selection of a value for one field for a record affects the list of options available for a second field. As a basic example, say there are two fields: Input with possible values Red and Blue; Options, with possible values Red1, Red2, Blue1, Blue2. Ideally I would like to set up a form on which if Red is selected in Input, the options Blue1 and Blue2 don't appear in the Options box. Crucially you can also then select Red1 or Red2 as the value for 'Options' for that record (as opposed to just having a text box with the options written in it), as this provides the potential for a string, with the selection of a value for Options affecting another field.
Obviously in reality there will be many potential values for Options, and it won’t be obvious to the user which are compatible with each value for Input.
I wanted to use Program Flow functions with a combo box - say for the Record Source: IIf ( [Input]="red" , "red1;red2" , "blue1;blue2" ), though this would probably need to become a Switch/Case/Break command in the real database - but I don't think you can input equations into the Record Source.
I've also thought about trying to use queries, but can't see how it would work either, (the form for every record is the same, so the combo/list box for Options will always have the same properties. Switching between forms based on the value of Input seems impossible).
Then again perhaps I'm trying to make a database do something it wasn't really designed for, and should go back to basics and just display the possible options in a text box that is dependant on Input (but this way I won't be able to use the value of 'Options' in a further process).
I'd really appreciate any suggestions, especially since I'm pretty clumsy with the system still (first day using it, oh joy) and so could well be missing an obvious solution.
Thanks for your time.
Kate
Hi, I'm still an amateur at using Access and have just recently been introduced to normalization.
I'm looking for some advice on how to proceed with a database I'm trying to create.
I need the database to store vehicle information (name, make, model, color, license plate), along with parking information (date, time, place, who issued the notice)
My biggest question so far, is finding an efficient way to list a vehicle with what would be an undetermined number of parking slips. and then of course being able to retrieve that information on one form.
I tried using a from for VehicleInfo with a subform for ParkingInfo but I'm not getting the relationships right, the parkinginfo form is not displaying all the information connected to the license plate when the main form shows the vehicle information..
if that makes sense, any help or advice on how to proceed (or begin) would be greatly appreciated.
Thanks
Sorry - duplicated post.
View 2 Replies View RelatedI have been developing a catering order system at work. A demo version has been in test and initial issues sorted. The users are very happy with the way it works and though far from perfect it does everything they asked for and then some.
Basically, each order for refreshments/food creates a record and order number. Orders feed through to a daily 'jobs' diary sorted by date/time which the catering staff work from.
However, what they are asking for now is to be able to link some records together for collation/charging purposes. Grouping using the customer ID and the order Date doesn't work as customers could have many orders across many dates , and some of the orders by the same customer won't need to be collated together. My initial thoughts are to add a unique code to each order that needs to be linked , has anyone any ideas on this , is there an easy way to generate a code (perhaps CustID, OrderID , Date, other?) which can be added to other records to 'link' them.
I would be grateful for any suggestions.(other than a complete redesign :eek:)
Thanks
RussG
Greetings,
I was hoping someone could offer some advice on how I would design the following project:
Student Table
- ID
- Name
- Unit (each student belongs to one specific unit)
- License type (each student could have multiple license types)
Unit Table
- Unit Name (string)
License Table
- License Type (string)
I have created a report that dynamically updates information according to what unit the student belongs to via a drop down box, i.e. while the report is open, select a unit from a drop down, press a button to apply the filter and the report automatically updates. I want to add the same kind of functionallity to the report based off of licenses as well. My original design had all license types in the Student Table as a yes/no option. I couldn't get the filter to work properly so I moved license types to its own table (which makes more sense anyways...) But, unlike the Units Table, any One student is allowed to have many licenses so this creates a bit of a problem. If anybody has some insight on this I would much appreciate it. If you're not following, please let me know and I will try to be more specific. Thanks.
j
Hi. I just recently started studying Access independently since my school never taught it to me and I'm trying to design a invoice type of database as a summer project. I'm stumped on queries because the office 2000 guide I have only briefly goes over it.Basically, what i'm trying to do is create an automated value like in excel so that the "Net" column i have will subtract with the "sales" column to automatically enter a value for the "profit" column. I can't find any place for me to enter anything like [profit] = [net] - [sale]. i tried to use the input mask but since my data is in currency, it won't allow me to do it. can anyone please tell me where to start or what i've been doing wrong? thanks.btw, i'm also trying to do the same thing with the y/n feature of access. i'm also trying to find a way so that if i type y/n for a column, it will copy the value from a different colum so say i put yes on "account R" then i want the "AR$" column to copy the value from the "sale" column automatically. if i can solve this problem the same way as the previous problem then please ignore this (i THINK this can all be solved with queries.)
View 10 Replies View RelatedHi everybody !
I have an assigment and have to create a database, i'm just starting to learn how to use access properly.
there's a screen of a form I made, if anyone has some advice to make look better it would be welcomed. As you can see it is very basic.
I also would like to know if it possible to create a search bar, for example typing in "sales" and the list of all the candidates working in sales comes up (I know how to do this in a query, but how do you transpose it into a form).
thanks for your help
Ilan
is there any1 who can give me tips on an exam i have 2moz on databases. its a theory and i'm crap at them. thanx loads, luff me xx
View 2 Replies View RelatedFor now I have 20 comboboxes on my form each bound to a field from my sourcetable. Since ya can only choose 1 value in a combobox, the users want to to choose multiple values in each box. How should I implement this?
I can't use 20 listboxes because I haven't got any free space left on my form.
Can somebody giove me some good advice on this?
thanx in advance,
Johnny