Newbie Question! Getting A Cmd Button To Create Data In Table?
Nov 29, 2004
Hey all,
I've never used Access much...i was able to use it OK at one point but ive forgotten all about it now.
I need to create something very simple for the reception at my work...
When a customer phones we want to be able to keep track of how they heard of us - so we want a very simple access/VB program.
The best way would be to have buttons of each of the magazines our company is listed in..then when someone phones and says "ahhh magazine 3" the receptionist can press a button and the button will add 1 to a field in a table?/report? next to that magazine.
Hope that makes sense :s
Any help would be very appreciated! - It seems very simple to do ?
I'm currently working on a project within access which will allow users to select/input information in a form which will then save to the database.
What I need is to create a button on the form which will allow you to convert the data collected from the form to a custom text file template.
(Or maybe the last row added to the database. - although this may cause errors. Example: the form information doesn't save which will in turn create a text file with the data collected from the previous job)
The custom text file template should have a sentence description followed by the value recorded from the form.
Example:
1 configuration type: (data from form)
2 model type: (data from form)
3 Poc: (data from form)
And so on.
So in summary - I would be to use the form to collect the desired information which will save to the database.
Once actioned, a custom text file should be populated with the collected information (with specific data placement as per the example above)....
I am new to MS Access! I have design a database and a form to record the information of customer feedback.
The first thing I want is to search the record from the whole database. Secondly I want to print that searched record. And finally I want to make a Form Reset Button.
I have made a "Clear" button but it is not working correctly and removes the record from the database after saving.
I am currently taking a database design class using Access 2003 and am looking for some help. I am trying to draw a dependency diagram before I create the tables based on the following attributes / fields in one table named Student:
StudentNumber, StudentName, StudentMajor, student's AdvisorNumber, AdvisorName, AdvisorOfficeNumber, AdvisorPhone, student's NumberCredits and student's Class (freshman, sophomore, etc.)
So far I have identified the Primary Keys as StudentNumber and AdvisorNumber and this is what I have:
Table #1 - Student = Student Number functionally determines Student Name, StudentMajor (?) NumberCredits and Class Table #2 - Advisor = Advisor number functionally determines Advisor name, office number and phone
The problem I run into is with the the StudentMajor / Advisor / StudentNumber relationship. Since one student can have many majors and therefore many advisors since there is only one advisor per major, and each advisor has many students I am assuming it is a many-to-many relationship.
The problem I am having is determining the third table (and fourth if there will be one) and the relationship between StudentMajor / Advisor / StudentNumber.
Should StudentMajor be included as functionally dependent on StudentNumber? If it is there would be redundancy due to multiple entries in that field for each row so I guess I can't include it actually. :confused:
Wouldn't there have to be another attribute named AdvisorDept for this to work properly....that way there is a relationship between Advisor and their department they work in so I can link the student's major to the advisor :confused:
Any pointers and suggestions would be greatly appreciated
I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
I'm not sure if I've picked the right forum topic for this... It's not a straightforward table question, and I think the only way I can do what I need is with a query of some sort. Apologies if it should have gone in 'Tables'...
The situation is: I'm creating a database (using Access 2003) in which our secretaries can enter exam marks for students. The difficulty is that there are ten papers (exams), each student's exam is marked by at least two examiners and there are at least 6 examiners per paper. Every examiner also marks more than one paper, but doesn't mark all papers.
So, I've got a table with all of the examiners and the papers they're marking and I've got a table with all the students and the papers they're taking. Because we have to enter the marks in such a way that we know both which mark an examiner gave and (obviously) which mark a student received (e.g. so we can look at statistics for each examiner), I thought the best way to do this would be to run a query that created a new table per paper in which the field names would be: Student_ID, <name of examiner 1 for the paper>, <name of examiner 2 for the paper>, <name of examiner 3 for the paper>, etc until the end of the list of examiners for that paper. The student's number would populate the Student_ID field and then the secretaries would enter each examiner's mark in their named field. Like this:
| Student_ID | A.N. Other | J. Blogs | J.Q. Public | Agreed_Mark | 1234A 72 74 73 2345B 65 68 67 3456C 71 73 72 4567D 52 51 52
Listing the name of every examiner (including those who aren't marking that particular paper) isn't an option (and would have to be hard coded into a table in any case, as far as I'm aware, either in a query or in a table design. This is something I'm loathe to do). Ideally, the secretary would be able to press a button on a form and have all the mark entry tables for all the papers created automagically.
The examiners for the different papers change every year, and not every academic marks exams every year, so this data will not remain static. Hard coding a table with examiner names would make more work for the secretaries. (I want to avoid this as all mark entering for all students is done in a single day. This means over 600 students at 3 marks per student [mark 1, mark 2, and final agreed mark] with time to contact examiners with questions... and only 2 secretaries, each of whom deals with a different section of students).
Because of the nature of the marking, it would also make quite a lot of work for the secretaries if we had to cross reference a generic Examiner_1 field with a different examiner for each paper, so the field name really must be the examiner's actual name.
Can anyone help me? I'm happy to do it with either VB or SQL; I'm not a programmer, but I can usually work out what code does even if I can't write it myself. I should be able to adapt anything presented as long as it's complete and doesn't assume that I know the basics. :) I've also got two reference books to hand: _Microsoft Access 2003 Forms, Reports and Queries_ by Paul McFedries and _How to Do Everything with Microsoft Office Access 2003_ by Virginia Anderson.
How do I create a daily table from monthly data? I have a monthly table and want to split it into a daily table by dividing each monthly value by the number of days in that month. I need this so I can compare the new daily values to other daily values.
I am trying to create a form to enter data into a table that I ultimately will create a report from. I have created a blank table with the columns I need. I created an append query to add the new records and an update query and a macro to run them on click of a button. It all runs but it doesn't append anything to the table. What am I doing wrong?
I want the caption for buttons in my Form to be pulled from a record in a table. Additionally, I want the name of the related form or report opened from the button to be pulled from the same record. I've been looking into this and it seems like using DAO is one option,I've already go the table set up, that was easy enough.
So, I have a form [frmmembers] which will enable the table [tblmembers] to be updated when a button is pressed. When the button is pressed, it will enable the fields "First Name", "Last Name", and "Password" to be updated.
At the moment, the data changes without pressing the button (as soon as it is entered into the text boxes on the form), which means that a password could be accidentally changed and could prevent the user being able to enter the system (which requires their personal MemberID and Password).
Is there a way of making it so that the data inserted into the text boxes on the form will only change the data in the table after the update button is pressed?
I'm looking for someone to help me with a solution to my problem of importing data into a data table. What I'd like to do is have a command button on a form. When this button is clicked the records in a table are cleared out. Then I'd like for a browse window to come up to locate an Excel file. The user would select this file and the data would be imported into the data table that was just cleared. Can this be done without too much trouble?
I have an access table and I want the code that will check two columns in the table "EnvelopeType" and "EnvelopeSize" and create headers in Excelsheet automatically. In the attached workbook, like in sheet1 the headers are already appeared, I want this to be done dynamically using vba code so that if new values get inserted in EnvelopeType and EnvelopeSize then we won't have to change the code to display more headers.
Please see attached workbook named Sample and Access table. E.g.
EnvelopeType EnvelopeSize TNT 2nd Class C5 PP1 2nd Class C5 PPI 1st Class A4 Recorded A4 TNT 2nd Class C5 PP1 2nd Class C5 Recorded A4 PPI 1st Class A4 Recorded C5
With the code it should display following headers in excel sheet:
TNT 2nd Class C5 PP1 2nd Class C5 PPI 1st Class A4 Recorded A4 Recorded C5
What I am trying to do is create a data entry form to an "order table" using 2 cascading combo boxes. I have created a data entry form based on a query. I can't get the cascading combo boxes to work properly.Here is the code:
Private Sub Combo0_AfterUpdate() Combo2.RowSource = "SELECT L2_ID,L4_Element_name,L5_Category FROM qry_ord WHERE L3_ID = Combo0.Value;" Combo2.DefaultValue = [Combo2].[ItemData](0) Command4.SetFocus End Sub
I've been able to navigate a lot on my own, but there is one issue I cannot seem to resolve. I have 1 form and 1 table. I have the form set up so that you can enter data, and then press a button, and it will "save" and refresh the form for a new entry. However, I want to be able to pull that entry back up in the form, and fill out additional fields later on.The form is set to data entry = yes because I do want the form to open up as brand new each time.
To sum up my question. I want a text box and search button at the top of my form. When you type an ID number in the text box, and then press search, I want access to populate my form with the information in my data table associated with that ID number.
If I type in the number 1234 and hit search. I want my form to autopopulate with the data in the row for ID number 1234 (all the fields I have already populated). So by searching 1234, the name, phone, background info, etc that is populated in the row will appear.
Hi, okay completely new to access. I'm trying to create a chart based on a query with 1 record 8 fields. I can not figure out a way to rearrange the data into two fields 8 records.
The background is I have a hundred units, each with 8 wheels. I have a table with the following fields. -Unit part number -Diameter of wheel 1 -Diameter of wheel 2 -Diameter of wheel 3 -Diameter of wheel 4 -Diameter of wheel 5 -Diameter of wheel 6 -Diameter of wheel 7 -Diameter of wheel 8
So, the query tells me how many wheel diameters between a certain range, with the following fields: - Diameter >530 - 530> Diameter >540 - 540> Diameter >550 - 550> Diameter >560 - 560> Diameter >570 - 570> Diameter >580 - 580> Diameter >590 - 590> Diameter >600
Now I want to plot the range on the x axis and # wheels in that range on the y axis of a bar chart.
Any suggestions on how I can achieve this? How do I create the diameter range as a record rather than a field?
Could someone give me a few pointers on how to create a 'Browse' button on a form with the intent to search for an image in an bound-image to record and assign it and store the bmp selected by the user from the user's machine?
I would like to create a button with a macro that will bring up a blank form to create a new record (as opposed to going directly to the datasheet table). There are options to Save a Record, Refresh a Record, Search for A Record, Delete a Record and Show All Records, but I don't see a macro to create a new record.
I am new to the forums, so if i posted this in the wrong section...please accept my apologies...
I am creating a database for recording some information about various customers. There is a date field involved, and if a certain number of days pass from that date, i want to create a button that when it is pressed it will check all the dates to see if this condition is true.
EX
Current Date is 10/21/2006, when i press the button, the database will check to see if 10 days have passed from the date recorded.
User 1 - 10/05/2006 - True User 2 - 10/10/2006 - True User 3 - 10/15/2006 - False
Then it would just display the records which are listed as true only. I was thinking of using a query, but i am not sure how to quite do so...please give your recommendations as to what i can do.
I have a contact list db that displays in datasheet view on startup. I also have an alternate form that displays in datasheet mode that i want to be able to toggle to with a click of a button. I would like the button to appear at the top of the default datasheet form, that will allow a user to toggle to the alternate form when they need to.
I am working on this database where each category contains certain thickness ranges that can be stored in a pack of x amount and finally paneltypes. ie KS1000 only comes in 40mm 50mm 75mm and paneltype MR is the one associated with it.
there are 3 tables tbl_Customer tbl_catergory tbl_product -------------------- tbl_Customer: -CustomerID (autonumber) Primary key -CompName -CompAddr -ContactFName -ContactSName --------------------- tbl_category: -CategoryID (autonumber) Primary key -Category (combo box) this has set values entered i.e.
KS600 KS900 KS1000 KS1000LP KS1000RW ------------------ tbl_Product: -ProductID Primary key (autonumber) -fkeyCategoryID (foreign primary key) -Thickness (combo) this has set values of thickness ie. 40, 50, 55, 60, 70, 80, 100, 150, 180 -NoInPack (set number directly related to the Category and thickness chosen) i.e. Category KS1000 with thicknesses of 55 can be stored in a pack of 17. KS1000 with thickness of 60 can be stored in a pack of 22.
-PanelType: (combo box) set values as follows: MR (this selected item relates to products KS600 KS900 KS1000 ) EB (this selected item relates to product KS1000RW ) CX (this selected item relates to product KS1000 ) MM (this selected item relates to product KS1000 ) WV (this selected item relates to product KS1000 ) --------------- I would like to be able to setup a form that a user uses to provide a quote: It would start with using the Category combo box which lets you select one of the choices (i.e. KS1000) but the combo box would also have multiple column headings ie. Category/Thickness/NoInPack. Once selected then the next several individual field boxes (ie. thickness, NoInPack) are automaticallly populated with the selection just made in the Category combo box.
NOTE: Many categories can be chosen just for one record. I therefore do not want to start setting up fields like Product1 product 2 etc and their associated fields like thickness1, thickness2 etc. I'm failing in the relationships section. Please see attached database. I have tbl_category: CategoryID (1) --------> (many)fkeyCategoryID from tbl_Product I have tbl_Product: ProductID (1) -------->(many) CustomerID from tbl_customer I know that i need a junction table somewhere.... but i'm a newbie when it comes to this stuff. Any help would be appreciated.
Hello, (pls scuse my english, it's not good) I'm a newbie to Access and I'm learning access I'm trying out one scenario to see if I can do it but I'm stuck.. main scenario is that a local company has decided to computerise their wage systems, but the wage system is very confusing.. data modeling has already been done in this example but as I understand the boxes(entities) in ERD becomes tables right? so I have like five tables.. Pay method, Employ type, Employ, Department, Division..
I know what to do with Employ, Department and Division but Pay method and Employ type is confusing for me I don't know how to work out attributes (fields) for these.. I have four different paying methods depending on 7 different types of categories of employees.. how would it work?
Also if you guys have any links that explains sort of similar scenario I would appreciate it very much.. thank you..
Oh and since I'm a newbie I'd appreciate it if you give me a simple answer not complex solutions,
