Hey guys, bit of a novice here
Say your got a database that has many users & in which quite alot of information is added to it on a regular basis. Basically its getting slower, what could be the problems & how could you fix it???
I am a newbie and just found your forum - hope you can help me.
I built a kindergarten software but seems to have a problem : I have children registered and I keep records of the parents, other relatives etc'.
My question : what w'd be the relations between the tables since parents can have more then 1 child and so does the other relative (each parent has his own table). Should I keep all details in 1 table (personal detail for child + professional details such as positioned in adult class etc/
Hope I'm clear.
Thanks
I am new to databases,, in fact I've never created one before,,
However I started learning today , for this project,,
I'm going to be learning on my own, but if someone feels kind they can give me the basics on how (the following) database would be created.
Fields
Box # (Number)
CBS Code (number)
Shackle Code (Number)
Agent Name
Property Street
Date Out
Date In
Where I can put in a Box # and it will fill in the other information for that box, showing if its currently out (aka no check in date with most current record),
If its not I can input Agent name, property, and Date out (then it will be checked out)? or some way to accomplish this.
Info can also be looked up by Agent name with autofill for the rest of the fields?,
Or Property with autofill
If searched by box Num, I want all previous agents used (check in and check out value) as well as current
If search by Agent, I want all box information from past, check in, and check in/out. with the rest of the records,,
I know this is possible,,
And I'll figure it out,,
But help speeding my learning would be appriciated
Thanks!
Collin
Hi,
New to forum. Beginner/Intermediate Access Experience.
Here is what I am trying to accomplish:
The database i am creating will basically need to have a user check-off a list of Fire Extinguishers that he has checked, on a monthly basis. For example, the user will enter a date, and then a form with a list of all the extinguishers will pop up, and he will place a check mark by each one. When he enters the check mark, that date will be stored so that we have a history of when each extinguisher was checked and by whom (using initials or something)
Currently, my design is simple, something like this:
tblUser
pkUserTableID
fldUserName
fldUserInitial
fldINSPECTIONDATE
tblExtinguisher
pkExtinguisherID
fldExtinguisherNumber
fldExtinguisherManufacturer
fldExtinguisherType
fkUserTableID
My question is this:
-Am I going down the right track with the 2 tables?
-Do I need a third table to Store the Historical Data?
-I am not quite sure how to layout the form so that all the extinguishers are listed.
I know these questions may seem vague, but any help would by highly appreciated.
thank you.
I have designed a few databases for my work. I have been recently assigned a new one that has me a little stumped. I am looking for some suggestions as to how to go about this.
Essentially, we have a training department that does training in the various aspects of the job. In the various classes, the "students" take a midterm exam to gauge the level of retention of the training midpoint in the class. Then at the end of the class, they need to take a final exam.
My department director would like the "students" to be able to take the exams using Access, since 99% of the questions are either multiple choice, yes/no, true/false, or fill in the blank, and Access would be able to "auto-grade" the tests, essentially.
I am at a loss, basically, as to the layout. The "student" information table would be the easy part. I am unsure of how to create the tables that would have the questions, depending on the class and whether it is a midterm or final, with the answer choices attached.
Any suggestions?
Hello everyone, im new here and i have some basic access knowledge, little knowledge about VB. Im looking to create a access database using access 2000 -- I know what I need and how to create most of it, however, I do not know how to do a few things, input for improvement or recommendations are more than welcome... Heres the design
Im doing a fairly simple inventory control database, it will have about 8-10 fields:
FAX# (date)
DATE (date)
NAME (text)
EMP# (number)
UNIT (text)
SIZE (text) (this is static and will be combo box drop down)
GENDER (text) (same as size)
POSITION (text) (same as size)
SENT (date)
AMOUNT (number)
RECEIVED (number)
PO# (text)
I need all of that in a form, which I can do, what i also will need on the form is the current amount which be determined by RECEIVED - AMOUNT, which I need to some how show up on the form (this i dont know how to accomplish) ive been trying to put a formula into a text box like =SUM([RECEIVED]-[AMOUNT]) ... it works okay, unless i copy from excel to the table which the form uses, then it doesnt see the items i copied into the table, only the items that were typed in using the form. I also I need to put like a box below the text boxes which will display a query (which i dont know how to do) -- this box will display a query (ie. if i wanted to filter out all , and only see SIZE = xl GENDER = male and then the box will show up in 'table' form all the people who meet that requirement.)
==============================================
= Gender [M/F] Size [XS/S/M/L/XL] Position [K/C/W] =
= Name [ ] Unit [ ] Emp# [ ] =
= =
= Date [ ] Sent [ ] Fax [ ] =
= =
= PO# [ ] Received [ ] =
= ------------------------------------------------------- =
= Search [ ] Amount Left: X =
= ------------------------------------------------------- =
= || || =
= ||---------------------------------------------------|| =
= || || =
= ||---------------------------------------------------|| =
= || || =
= ||---------------------------------------------------|| =
= ------------------------------------------------------- =
==============================================
Thats the best ascii drawing i can do of what invision...
:) Thanks for any help in advance.
AD
Hello.
I have spent the last couple of hours looking through the forums but have managed to get myself really confused. Lots of questions, sorry - if anyone can point me in the right direction with one or two of them, I would be hugely grateful!
I have a database in a shared folder on the network at work. It is due to start being used by users other than myself in future weeks, and I see here that it's sensible to split things into a FE and a BE.
1. My initial problem is that I have a nagging memory of being told that we're not supposed to save anything on the individual computers hard drives. Can a split leave both the BE and the various copies of the FE on the shared drive, or does this negate the reasons for splitting in the first place?
2. Additionally, with little space left on the shared drive itself, it's possible we'll not have the room to put 10+ copies of the FE on it anyway. If I just split the database into the BE and ONE copy of the FE which everyone accesses, will the BE at least be made more secure by the split, even if the FE is still vulnerable, and performance isn't improved?
3. If no sort of split is possible, are there any alternatives to splitting?
Lastly, some questions for if we ARE able to split and put the FE on each computer:
(I would be keeping the BE and the "master" version of the FE on the shared drive. All tables in the BE and queries, reports and forms for the "user interface" in the FE. Hopefully this is roughly what I'm supposed to do).
4. With a split database, what happens with compacting? Presumably the BE of the database can be compacted as normal, but what happens with all the versions of the FE? Does each user have to be responsible for compacting them individually? Does an FE even need compacting if the design is unchanged?
5. Does splitting affect what happens if two people either open or amend a record at the same time, or is that still just governed by the record locks setting in Tools (which would need to be set before splitting presumably)?
6. If the design of the FE changes (but none of the underlying tables, queries etc. are touched), do I just give each user a copy of the new version, or does something more complicated have to happen (ie. does the whole splitting process have to take place again)? What about if new tables are added to the BE, or if existing tables / queries are amended? Can I just issue amended versions of the FE that interacts with the new tables as needed?
7. I have drop down lists and combo boxs in the forms in the FE that use tables to populate them. Will it cause problems that these tables are in the BE - such as impractical amounts of time before combo boxs show their options? (The table has to be in the BE (I think?) because the user updates the content of these tables / combo boxs through one of the other forms in the FE)
Many, many, many thanks if anyone can help me out with any of these.
Hi all,
I've played a bit with MS Access 2003 the last week. I've made a form wich should contain information about stores (phone numbers, locations e.g.).
I'm trying to imagine myself (what could be a real) scenario, that way it's easier to give myself practice and tasks :)
As I'm new to MS Access, I'd like you to take a look at my forms. I want to know if there's better ways to do what I have done, and if I have done something wrong.
I also got a couple of questions;
Lets say I want to print one post by clicking on a button, is that hard to implement?
Is it possible to make a button, which exports the form to an .xls -file by clicking on it?
I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen :confused:
I think that's all.. Thanks! :)
Here's the access -file (http://www.home.no/f00b/stores.rar) (180kB) (use winrar to extract it)
I've tried to transalate to forms into english, sorry for the bad english :o
Dear Reader
I am a realtivly new user and I do not know alot of things about Access
I have set up a database, and within this database, i have a table with my product details (the products are books, details include: ISBN, Title, Stock Level, and Price), I also have a table with customer's information (Name, Contact details, etc). I have created an order form, from which a user selects the customers name from a drop down list, and then he selects his name, and finally the date. Following this the user then works within a subform.
This subform has the following details, Order ID, Book ID, and Quantity Ordered. After this I want there to be a subtotal. I have no idea as to how to set this up, but I am assuming that I would need a query or something, to look up the price of the books, and then to multiply it by the quantity that the customer wants. Following this ideally I would like a small box on the main form saying the total value of the order.
Would their be anyway, to add the book ISBN number into the subform, where the user could either type in the ISBN number or select from a combo box the book title, but either way, both fields are updated, what ever method is used.
From this subform, I would like to be able to print out an order summary/invoice. This would contain all the books ordered by the customer in the current transaction, as well as the customer’s information, and the total of the order.
And my final question is probably the hardest one. Is their anyway (possibly by pressing a button) to automatically minimize the stock value on the products table, by the quantity chosen by the user in the order form? And if the quantity wanted is greater than the amount in stock, for a message to appear on the Order Summary/Invoice stating "On Order"
Using the above method, would it then be possible through the creation of a query to show what customers have ordered in the past, in a tab on the customer's details form.
Thanking you in advanced
CJM
I started a fairly sucessfull eBay company selling Cellular Phones. Now i am trying to speed up the entire process through the intergration of mutiple programs.
What i have is one program called Blackthorne, i think it is a .net program but i know for sure all of its information is store into a LARGE database with all the sales, listings, and inventory information.
What i would like to do is have access print out the packing slips of all items that are in the payment cleared catagory, and to print them out in accending order.
Is there a way to do this. If so i have aot more little problems to solve, and may need more help but if i can't do that then i will just keep it the way it is.
Thanks alot for your help
Dear Reader
I am a realtivly new user and I do not know alot of things about Access
I have set up a database, and within this database, i have a table with my product details (the products are books, details include: ISBN, Title, Stock Level, and Price), I also have a table with customer's information (Name, Contact details, etc). I have created an order form, from which a user selects the customers name from a drop down list, and then he selects his name, and finally the date. Following this the user then works within a subform.
This subform has the following details, Order ID, Book ID, and Quantity Ordered. After this I want there to be a subtotal. I have no idea as to how to set this up, but I am assuming that I would need a query or something, to look up the price of the books, and then to multiply it by the quantity that the customer wants. Following this ideally I would like a small box on the main form saying the total value of the order.
Would their be anyway, to add the book ISBN number into the subform, where the user could either type in the ISBN number or select from a combo box the book title, but either way, both fields are updated, what ever method is used.
From this subform, I would like to be able to print out an order summary/invoice. This would contain all the books ordered by the customer in the current transaction, as well as the customer’s information, and the total of the order.
And my final question is probably the hardest one. Is their anyway (possibly by pressing a button) to automatically minimize the stock value on the products table, by the quantity chosen by the user in the order form? And if the quantity wanted is greater than the amount in stock, for a message to appear on the Order Summary/Invoice stating "On Order"
Using the above method, would it then be possible through the creation of a query to show what customers have ordered in the past, in a tab on the customer's details form.
I have attached a copy of the relationships, as well as various images, the order form, customers’ details and product details forms.
Thanking you in advanced
CJM
*If more images are needed feel free to ask
Order Form
http://img32.picoodle.com/img/img32/5/11/30/f_Untitled1m_9a2e33a.jpg
Product Form
http://img34.picoodle.com/img/img34/5/11/30/f_Untitled3m_2e1c239.jpg
Customer's Details Form
http://img01.picoodle.com/img/img01/5/11/30/f_Untitled4m_0b196eb.jpg
Relationships
http://img31.picoodle.com/img/img31/5/11/30/f_Untitled2m_cf8ac06.jpg
I'm trying to build up a database for Multiple choice questions quiz in MS access 2010.My requirement are as follows
My quiz consist of 15 questions. Each questions carry some weightage. Suppose a question carries a weightage of 5 and there are two correct options like A & C. If user selects option A then he gets half marks.Multiple users can access the test at the same time.
Hi, I have a survey database file containing the following tables
tblQuestions - contains survey questions
tblResponse - contains responses inputted by user
tblRespondents - contains info on user (e.g. Name, Add...etc)
Is it possible that answer to some questions are dependent on other questions?
for example:
Question 1 -True/false
Question 2 -True/false
Question 3 -True/false
If question1=false or question2=false then question3=false
(the response to question 3 is automatic and dependent on the responses of question1 and question2)
Thanks in advance for those who can give me some suggestions.
1) There are some databases here at work that I can open in BOTH A97 and A2K. I thought A2K won't open in A97, and before you can open an A97 in A2K, you have to convert? At least that's been my experience thus far. Any idea what is happening and how I can determine which version these databases are currently in?
2) With those same databases...assuming some were A97, the option to Convert them under Database Utilities is greyed out. Is this most likely a rights issue? Could it be anything else?
Thanks for the help!
Hi,
Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database.
Is there any method to know which user is opening the database and in which PC (workstation) it is open.
--------------------------------------
Is there any way of adding export fuction to the toolbar using modules or macro
Hi all,
A quick question!
Is it possible to have a table of 10 random questions and an inital form created with those questions in the form of checkboxes. When you chose random questions from that pool of questions a new brand form and table have the option to be created.
Basically, I have many external databases to research and some of the questions are the same in each database. Each database must be saved as individual tables and forms.
~Vanepps
Hello,
I have few questions so please bare with me
1- i want the text box to change automatically according to date so i
tried this:
if date>text14.text then text30.text=sea else text30.text=port
but nothing happens
2-i made a form but not all the data rows in the table are in the form(there`s still some rows)
so if i delete a data that are in the form how i can automatically delete the data that
are in the other row ?
3-this may sound stupid..but is there a way to stop the access logo from apearing when
loading the database?and how to make access directly open a specified form?
Thank you very much all.
I am designing a database and have a couple of questions.
I have designed a form that I have opening at startup. How do I force this to maximize on opening?
I have set up a report based on a query. It works fine. The query requires a parameter to be entered when it is run. The parameter comes from a list (of teachers in my school). How do I set up the query so that the 'Enter Parameter' dialog box provides a drop down list of teachers from which the user selects their name?
PS I have almost no knowledge of Visual Basic!
Thanks for your help.
Steve
Hi all
I am new to Access and have just designed a new database and was wondering if anyone could help with a few questions.
1/ I am setting up a Macro to send an e-mail on the change of a form. When the e-mail is generated by Access I get a message from Outlook stating that "A program is trying to automatically send e-mail..." and asks you to confirm that it is ok to go. Is there any way to bypass this check or alternatively send the e-mail from a specific e-mail address rather than the database user.
2/ I have changed the background colours on a number of my forms but the Record Selector's and Scroll Bar stay the standard Access Grey. Is there anyway to change these?
3/ I have used the User Security Wizard to setup users, groups and access but I can't seem to see a way to limit the number of simulateous logins a person can have i.e. I can log in more than once with the same user when I only want to be able to login once. Any ideas?
Any help would be greatly appreciated.
JC
Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following...
http://img276.imageshack.us/img276/2695/11ch1.png
is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
Hi all, I built a system in access for my a level IT course a few years back but haven't had need to use access since. just been asked to build simple system at work and i'm forgetting some really simple things. trouble is i think i'm overcomplicating the terms and can't find anything in the help file!
basically the system is to keep track of how many hours various people have worked on various jobs.
I've got 3 tables:
Jobs - job id, location etc etc
Staff - staff id, name etc
link - job id, staff id and hours worked.
the job and staff tables have the id as the primary key, and i've set the relationship to link them to the corresponding field in the link table. which is all fine if i remember rightly?!
now what i'm trying to do is set up a form for entring the hours worked etc into the link table. we use job id numbers all the time so i have that as a drop down box. what i want is to have a drop down for employee names, which will insert the employee id into the link table- basically so we can work with names rather than numbers. for the life of me i can't remember how to do it. i know is really simple but i can't find a way to express what i want to do to search for it in the help or online!
if anybody can refresh my memory it would be much appreciated!
I am still learning and I have 2 questions.
First...I have a table called company rates which will be used to calculate time and materials. In the material field, I need to enter .10 for 10 percent. When I enter .10 the field changes back to zero. I have it set to long interger. Is this wrong?
Also, I am working on the form that will calculate all of this. I have a field that needs to look in a flex price field. If there is a number in the flex price than that is the labor, if not, it needs to multiply the estimated time (Text43) times the quantity, times the CurrentLaborRate contained in the CompanyRates subform. I can't seem to get it right...
=IIf([FlexPrice]>1,[FlexPrice],[Text43]*[Quantity]*[frmCompanyRates.CurrentLaborRate])
I know it is probably something simple but I can't figure it out. Can anyone help?
THANKS SO MUCH!
Allrighty, some questions about replication. I have gotten the Replication Manager from the helpful IT folks here, have made the database, and it works well to synchronise between different files locally on this computer. However, ideally the other people in the department would be able to carry replicas around on their laptops, while ideally the design master and overall database tidying should sit on mine. The setup is typical intranet here - computers are invisible to one another directly, and so are their virtual My Documents drives, while shared network folders are visible to all.
Questions;
1. Since I can't see any of the other laptop drives, and the database would have to be accessible offline, I assume indirect synchronisation is the only choice, correct?
2. Does the Replication Manager need to be installed on each of the laptops that will use the database offline?
3. If yes, what's the process? Do I install RM on each laptop, then use the Create Replica function to create one locally on each? No hidden pitfalls here?
4. If yes, is it sufficient to keep RM shut all the time unless specifically wanting to synchronise? Would happen at least once a week.
5. If Replication Manager doesn't need to be installed on other laptops, how do I move replicas there? I tried moving one through copy/paste, but that broke the link to the Replication Manager.
6. (Optionally - I've seen some references to 'replica farms' - what is that?)
Very much appreciated if anyone is able to answer..
I am trying to build a db for the office I work at. And I have a few questions about how I should design it.
1. My vendor number should be an autonumber, but it has a relationship to the vendor name on a report. I cant create a relationship btwn text and autonumber.
2. Right now I have 3 main tables. Vendor, builder, and job. All of this is for the marketing aspect of the business. But I want to include other aspects, like collections and payroll. Should I add columns to the jobs table, or create a new table? For example, on the jobs table, I already have job info like details on the job and who referred it to us. Should I add invoiced amount, amount collected, etc., or create a table called collections to store all of this info? Im really confused about this.
Hi I'm new to the forum, and i have a question (don't we all)
I need the following, i tried some turorials but couldn't find it..
I'm creating a form, that has 2 fields that I want to relate,
let me explain a little:
the database if for a Church I work for. The church has 3 sites (3 different buildings in 3 different parts of the city)
Each site has it's own schedule of day and time.
I need to create a field that asks for the site, and depending on the site that is selected, it should display in another drop down menu the possible days and time of only that site.
I have no idea how to do this. I have created a table with the sites, days and time
How do i make one field depend on the other.
The other question is regarding a field that I want to add for the Cities of States. I want the field to remember the new ones, and add them to a drop down menu, so that if it is there it can be selected without not having to write it again, and if it isn't there yet, it can be written and then it would be added to the list....
thanks
I want to thank you in advance.
hope i can be of help soon enough:cool:
Hi there...
I've run into a problem with my db :( When I'm trying to create users for it, apparently Access won't accept them when they try to log in from different computers.
Is it a general problem with Access, or is it just me who's a noob with this?