Hi all,
I am a fairly new User to Access and have been charged at work with making some spreadsheets useful. I have 5 workbooks, with approx. 5-9 wkshts per wkbk, each with anywhere from 200-1200 rows. (CT Scanner Protocol information).
My Idea was to link all of the sheets to a reference excel spreadsheet and then to import that as a linked file to access. The problem is that I cannot change a linked fields property, among other things, and have trouble with some blank fields. i have been working on this for a while, searching the net and am still clueless.
Anybody have any Ideas on what I can do? I can email copies of the "sample" sheet I am using (a condensed version that way I don't goof up the main one, plus it is smaller and easier to work with) to anyone who might be able to help. Or any inout here would be appreciated.
Currently trying to build a database for customer management and order placement/tracking. Want to set a couple of rules so that if I for instance click yes of billing and shipping address the same that the database will automatically fill the shipping address with the data I inputted for the billing address in the same table.
The other issue I can see I'll run into is, I want to be able to select one of the company ID's (made up of a three letter abbreviation of the full company name) in the product ordering table and it will automatically fill in the rest of the customer data (phone, email, address etc) data into that form.
I am doing a project where we are collecting home owner data and information on all the dogs in the household. The data for homeowner has an autonumber primary key because no field is unique or has been consistently collected. I am struggling to link the data for the dogs to the owners because an autonumber primary key will not work since not all homes have dogs. I need to have this set up so that people who are not tech savvy can look up each homeowner (or dog) and get the dog (or home owner) information. And to make things even more fun we need up to 15 potential dogs per household each of whom will have 18 different pieces of data collected.
It looks a little like this (and you can see my not matching ID issue):
Homeowner table ID First Name Last Name...........Total Dogs 1 Max Maximus 5 2 Min Minimus 0 3 Mus Musculus 1
Dogs 1-5 table ID Date Dog 1 Name Dog 2 Name .......Dog 5 Name 1 (Max's) 4/11/14 Bobby Billy Betty 2 (Mus's) 4/11/14 Jojo
Min will have no dog records at all, just home information.how to link the dog's to the homeowners .
I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.
I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.
Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.
My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?
I will be splitting the database once completed and then making a ACCDE file for my techs to use.
I recently imported an excel file into access. Let's say it contained data for both domestic and international customers. With different things needed from each type of customer, once in Access, it became needed and easier to create separate tables- one for international and one for domestic. However, each customer needs their own unique id - and I need a way to link or relate the tables in a manner that it will not allow duplicate customer numbers between the two tables.
I have two tables called Hardware and Desk. They both have two fields called ChangeID and Priority.
What I would like to do is set it so that if we change the Priority in a record existing/created in 'Hardware', the Priority of the related record in 'Desk', also changes.
First off, thanks to all who have helped me with my other posts :)
I have yet another question that y'all might be able to assist me with... I'm looking to create a report and am having trouble figuring out how exactly to format the stupid thing... And, like my other posts, this could be a little confusing... I'll do my best ;)
I've modified this a bit to figure one thing out at a time. If you have a solution to my original post (below) feel free to help out, but for now I am just trying to figure out how to get the variables in the report to go across the page instead of down. I would like my quantity field to be listed across the page with the price for the part below it:
1-9 10-24 ... 50K+ $$ $$ $$
instead of:
1-9 $$
10-24 $$
...
50000+ $$
Thanks!
------ Here's my original post------ Ok, I've already got a query with all the data and computations needed. Basically I'm just trying to create a price sheet for our products here, but it's not quite that simple... I have 72 different part sizes, 12 for each of 6 voltages (3KV, 5KV...20KV), and a price for 13 different qty ranges (1-9, 10-24...50000+). I would like it to look something like this:
Qty1-9 Qty10-24 ... 50K+ Part 1 $$ $$ $$ $$ Part 2 $$ $$ $$ $$ Part 3 $$ $$ $$ $$ Part 4 $$ $$ $$ $$ Part 5 $$ $$ $$ $$ Part 6 $$ $$ $$ $$ Part 7 $$ $$ $$ $$ Part 8 $$ $$ $$ $$ Part 9 $$ $$ $$ $$ Part 10 $$ $$ $$ $$ Part 11 $$ $$ $$ $$ Part 12 $$ $$ $$ $$ ... Part 72 $$ $$ $$ $$
Parts 1-12 will be grouped by Voltage 1, Parts 13-24 by Voltage 2, and so on... Have I lost you yet? :confused: :confused: :confused:
Grouping by voltage can be left out for now if it add too much confusion...
Hi, this is my first message on this forum ;)! I have a little problem with my Access 2000 (with 2003 too on another compuer), in fact when I put an icon on a page of my Tab Control, the background of that icon is white and not transparent (the file I use is an "ico" file and so it HAS a transparent background, anyway I treid all the possible file types); the strange thing is that when I put an icon on a button, the icon is shown properly. Here is an image of my problem:
i have 1-to-many relationships set up as follows; tblManufacturers --> tblAssets, tblManufacturers --> tblModels, tblModels --> tblAssets, tblSites --> tblAssets.
what i would like to happen is if i add a new site in tblAssets it will add the site in tblSites as well. if i have "enforce referential integrity" checked then it will only let me insert sites that are on the tblSites table, and if i uncheck the box then it will allow me to put in a site that's not on the table, but it doesn't add it to the table.
i only have 1 form and it's just linked to the tblAssets table. please forgive my noobness, i've been having a rough time trying to understand relationships even though i've read about everything i could find on them, so could someone please point me in the right direction?
I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant figure it out. Anyone?? Im not very good with code but if thats what it takes thats what it takes.
I have hit a brick wall with my A-Level Access Project. Basically, I have a form for ordering where a user can select items from a combo box linked to a table that contains products. They then select the quantity and a subtotal is calculated for that particular item(s). By that I mean the subtotal generated is only for one selection from the combo box. Any subsequent selections have their own subtotals generated afterwards (I hope I'm not being too vague). This is the form I am talking about: http://img.photobucket.com/albums/v318/GOAT2G/FrmMakeOrder1.jpg
The thing I am having trouble with is the final box; "Order Total". I have no idea how to set it to sum all of the above Subtotals to equal an overall total. I will send anyone willing to help a copy of the database via email or something if they need it.
I would be immensely grateful for any help you can give.
Im currently making my first database for a company i work for. As expected im having some troubles hehe im not sure im going about everything the right way. At the moment im trying to create a form which will get product information from one table, display the details in a few combo boxes and based on a selection will store the selections in a separate table. Ive done everything up till that last bit, i cant seem to be able to record the selections in a separate table.
i would appreciate some help as my bosses have to be kept up to speed on my progress and as you can imagine it doesnt look so good when you tell them you havent made any progress hehe.
I have a form that I'm trying to make a sub-form for. I create the sub-form and link the two forms by a text field, but for some reason instead of being the contents of the field that links them being the same, it's the name of the Form, and thus any time I refresh the page the subform data gets lost in the table and is unassociated with any records I have on the main form...
I've done subforms before without a problem, so why are they messing up for me now?
Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing. Thanks
I have a table with job info like: job #, job name, job addy. I would like my end query to look like this: job #, job name, job notes. I want the query to list all jobs, job names, and job notes for a particular week(we have a weekly meeting on the status of our jobs), so if I were to query the jobs for 6/26, i would get: job #, job name, and job notes for that date as fields in my query. I am not sure how to accomplish this. Should I make a seperate table that contains job notes? If so, how would I accomplish this and create a relationship between the job info table and the job notes table?
:confused: How can I link a table to one specific item in another table in order to avoid repeating information? (ex: school name that would be narrowed down to its different departments)
Excuse me for sounding extremely dumb, but I have a question that is really bugging me. I have created a database using two tables. The two tables are called User and Assets. In both tables I have set the primary key to be the field Username. I have also linked these two fields.
I have created a form that is my interface for the database and can add and delete from the table (User). I now want to insert a sub form into my form, that displays the contents of my second table (Assets) and reference's the field Username. Hopefully this will enable me to display my table (User) in the Form, whilst only displaying the relevent data in the subform (Assets) for the particular user.
I'm sorry if this sounds confusing, but I would really appreciate your help ...
I have a question which I think is probably very straight foward for those who know about these things. I have just created a new database, but there are obviously some problems with the design, because when I enter information into a form, I don't seem to be able to access the information through queries or reports.
I have 11 tables, and one single form (I created the tables, and then used the wizard to create the form). The main table is called 'Client Information,' and the key in that table is the CaseNumber. They key in every other table is called something along the lines of 'ClientDetailID,' 'IncidentDetailID,' etc. When I look at the relationships between the tables, the 'ID' field in each table is linked to the 'CaseNumber' field in the Client Information table. However, I don't have any fields actually duplicated between the tables. Do I need to do this? (ie, should I have the 'CaseNumber' field appear in each table, and then the 'ID' field from every other table appear in the 'ClientInformation' table?)
thanks so much, this is probably a really simple problem but I don't think I really understand the whole relationships and linking tables thing.
I have tables in MS Access and the same tables in SQL Server. I want to link the appropriate tables up so that when i update the table in MS Access, it will automatically update the table in SQL Server. I want to do this using an ODBC link.
Anyone with any suggestions of how to go about this?
Hi I need some help linking some tables... Does anyone knoe how i would go about taking several years of contact information and compine it all into one table
I have 5 or 6 questionnaires and each of these is linked together by a person Identifier number. How can I do it so that all the questionnaires recognise that these tables are all linked by the same number.
Secondly, if I wanted to say, do a search on a particular number, is there a way to do that if i say, searched for that number in a query, i'd get all 5 questionnaires come up rather than have to do a search for each table (ie. one search brings all the results from all the tables up or at least a link to them
What would be great is if you could do it so that you could do a search on say, all who were a nationality and it brings you up all the results for all the different questionnaires.
I have a 'main' database named(A), and I have 2 tables that I have linked from two other databases(B and C). NOTE: I kept all this 3 databases(A,B,C) in one folder named 'Joe' on my workstation.
Here is the issue, every so often when I open my 'main' database, and I need to query the tables in B or C(which I have already linked to in my main database), I get an error message saying something like "path to c:...B is not found." To fix this issue, I have to use the "Linked Tables Manager" tool to relink all the tables again. As you can this, this is causing me a lot of unnecessary wasted time. What will i have to do to have these tables linked permantely so that I don't have to relink everything?
Each person can only be either a Host, Sponsor, or Organizer. I have established the proper relationships in Access, but my problem is if i make a form to create Hosts say, it will create a person of type host, but it will not make an entry into the Hosts table linking the person's id. I presume this is because it doesn't know that the type field specifys which subclass the person is.
My question is how to get around this problem, can I somehow tell it that type indicates what other table to use, or can I manually insert them? (Since I have an individual form for each subclass)
