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.)
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
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?
I'm currently stuck with 2 issues with my database.
1) I have Team (TeamID), Player (PlayerID, CurrentTeamID) & Transfer (TransferID, PlayerID, PrevTeamID, NewTeamID) tables. I got this addTransferRecord form to add transfer records. The Player table has a currentTeamID attribute which is a foreign of TeamID from Team table.
What I'm trying to do is when adding a transfer record via a form and after selecting a particular player from the combobox, I want the prevTeamID combobox.Value to automatically reflect his currentTeamID. Next, after choosing his newTeamID from the combobox, I want the value to be stored in his currentTeamID.
*CurrentTeamID, PrevTeamID & NewTeamID are foreign keys of TeamID
2) I have this LeagueStandings (TeamID, Wins, Losses) table. I've added an expression into the query to calculate the PCT (those basketball fans would know what i mean :) ). The thing is I've been trying to find a way to sort the position and assign rankings to each team where PCT is descending.
First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table.
NAME SALES Bill 2000 Jim 500 Ted 1000
And by some miracle of science, Bill and Jim are able to fuse together to become Jill, combining their sales together. So the new table would look ilke this.
NAME SALES Jill 2500 Ted 1000
My second question is, say I have an extended list of the same table with 30 names and corresponding sales. However, I want to find out Ted's percentage of sales of the TOP 15, not all 30. How can I accomplish this?
Thanks so much in advance for helping out a complete newbie. :)
In the right hand portion of my dialog I use a subform to display key words for the code. Is there a way to turn off the column and row headers for the form? Also is there a way to have a transparent background for the subform?
In order to add key words I need to open up another form, enter the words there, close that form and then select them from this dialog. It would be nice to be able to add keywords from this form. FYI, there is a many to many relationship between the key words and the code.
Is there a way to show just my dialog when the database is opened and not the rest of the Access application space? I have unchecked everything in the startup options already.
The last thing is I would love to be able to format the code section so that certain pieces of text are formatted. I am going to start messing around with the some of the free rich text controls but is there an out of the box solution that can handle this task? I was thinking about formatting the code in html and then displaying the html. Is this possible from within Access?
Hello All, I was wondering when you use a find command, if you can make it so it searches two tables from the form your currently viewing, not just the data from the table that is tied to that current form.
Second question is I am thinking about maybe taking some "1 day" classes on access. My question is how many people have taken these & are they worth the money, or is it easier just to buy a book & if buying a book is better what is a good access book to buy.
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
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:
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?
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.
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 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.
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
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.
I created a form from a query that before loading all the controls asks for the Item ID (parameter). This form has two subforms that depend on another two queries; since I want them to show the info for the same item, all three ask for the Item ID, which can be kind of annnoying and does not look too professional. Is there a way I can get rid of two of the pop-ups and still have the three forms display the info of the same item?
And my second question: After the Item ID is entered 3 times, all the info is displayed on the forms. But, if I click the arrow on the bottom of the form (to supposedly go to the next time...but it should not be possible to do this), a "Enter parameter value" window pops-up (one just like the Item id one), and I have no clue where it came from. I cannot find it in the code; and I really want to get rid of it. I could use all the help I can get.
I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I cannot get them to work in combination with a unique record! I have tried all sorts of combinations to link the cascading boxes to the print but they either don't change at all, or my qry returns 0 records. I must be doing something simple wrong but I'm not very experienced and just don't see the solution. I've spent all evening so far and I think it's time for some help.
I've got these tables (there are more tables and fields, but these are the main ones)
Tbl_prints PrintID PrintTitle
Tbl_Category CategoryID Category
Tbl_SubCat1 SubCatID SubCat1
TblSubCat2 SubCat2ID SubCat2 PrintID
The tables are linked by the printIDs.
Now, when I fill in the details for print #1 and then advance 1 record to print #2, (or #3 etc) the comboboxes don't follow.
Right so I have a database which is split. I have two values which are universal and only change occasionally so I don't want them in a table against every record in the database. I have currently set them up as globals in a module I want to set it up so I can draw the values in from the backend database rather than having to edit every single copy of the front end each time.
Debugging my VBA code. I'm trying to track/display the content/value of a couple of variables to make sure they have the right value at a certain point.
What is the VBA code to say "display content of variable Var1" ? Where exactly will it display the value when instruction is executed?
I know I can just hover the mouse on a variable to see its content but some string varables like SELECT commands are too long and you cannot see the whole string.
On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact.
But to keep the form nice and clear, I only want to make the fields acceseble when the checkbox from [couple] is checkt OK.
How to make the fields and the Box around it Light Gray, so its very clear it issn't clickable.
The main coller is white BG and Green strokes. (see attachment) When the field [paar] 1 (couple in englisch) is OK then the fields in de eclips 2 are available And I want the collors of the stroke 25% black and de fields disabled.
I need to update a table at a client's site to change a couple of fields, and would like to be able to send them something that they can run on their end to perform an insert query.
I cant update the tables via RDP etc. because the database needs to be in Access '97 format, and they all run access 2003.
I also cannot get them to send me the file for updates since it needs to be online basically 24/7.
I would like to enter a couple of alphanumeric groups into a field on an input form. After I enter an alphanumeric group, I hit the enter and the data will add into the field and refresh to empty box ready for next entry. If I continue to enter another group and hit enter, the next group will be added to original field with a comma and a space in between. build the VBA in after update event to accomplish the task.
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.
I have a couple forms with Combo boxes that look up data in queries. I noticed in testing that I could accidently type a "~" (and other characters) in the field and once I do, it causes a runtime error that shuts down the entire app (as opposed to letting the user backspace out of it or resetting the field). Before I put in some "Before Update" code to prevent the system from crashing, I want to make sure I am on the right track. I have already set the combo box to just show the list, not allow edits, limit to list, etc. Is there a way to prevent the user from doing this either by preventing the keyboard from working on combo boxes (not preferred) or by trapping it before the system crashes? I would think I could validate with a recordset, and create my own path out for the user, but I was hoping the combo box would have sort of done that work for me.
