Question About Autofill Fields From One Individual Field
I have a form with the following Fields: Customer Name, Address, City, State, Postal Code, and Phone Number. I also have a field called License Number. This question is that once the data is entered the first time, is there an easy way so that if an individual that has been entered into the database comes back you can enter there License Number only and the other fields will fill in automatically. If so How. I am assuming so kind of query but i need help. Please Help..thanks
View Complete Forum Thread with Replies
Related Forum Messages:
Autofill Fields Based On Results From Another Field In The Table?
I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other). Field 1Field 2 [facing][DISC_CODE] un3 up1 dn2 Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry. My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?
View Replies !
Autofill Query Field Based Upon Other Fields Within The Same Query?
Hi, Baisically I got this query which controls the selection of Software within a system. i.e. It contains the fields Vender_ID, Application_ID, ApplicationEdition_ID and ApplicationVersion_ID. These auto-filter based upon the users selection (e.g. Vender=Adobe so Application=Acrobat/Photoshop/etc...) Right some from the user software/application selection i want it so that it will automatically assign a License_ID defined within a table tblLicense_Information. Baisically im asking whether i can put this in the 'criteria' box: "SELECT tblSoftwareOverview.License_ID FROM tblSoftwareOverview WHERE ((tblSoftwareOverview.Vender_ID=qryHardwareSoftwar e.Vender_ID) AND (tblSoftwareOverview.Application_ID=qryHardwareSof tware.Application_ID) AND (tblSoftwareOverview.ApplicationEdition_ID=qryHard wareSoftware.ApplicationEdition_ID) AND(tblSoftwareOverview.ApplicationVersion_ID=qryH ardwareSoftware.ApplicationVersion_ID));" I know the sql is not exactly right but you get the idea of what i want to achieve! But im guessing you cant really have an sql statement within an sql statement so any other suggestions on how i can do this would be much appreciated as the INSERT INTO command didnt like inserting into a query and when inserting straight into the table, the query failed... cheers
View Replies !
Autofill Fields
Hello everybody! Im new in Access as well as in this Forum! Glad to be here :) Im currently developping a small application in Access 2003 and here is my problem: I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber" Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox. Note: SupplierName values are from other table: Suppliers Any help is highly appreciated, Thanks in Advance
View Replies !
Autofill Fields
Hi Need some help with a table, or possible more to do with a form design.. I'm looking to autofill in a field depending on data that's in the previous field. E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list. It's probably a simple query or something I need to do.. can anyone help.. Thanks Saifon
View Replies !
Autofill Fields In Form
Hi, I have a form that has a field called scope of work which is a combo box that you have 3 options to select from. I have set up a table called scope of work which has other fields ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date. The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date. I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution.. If anyone has any ideas it would be greatly greatly greatly appreciated!! Thanks a Bunch
View Replies !
Autofill Other Fields In A Form Or Report.
Please help. This might be a simple way to do this, but I'm not really good at coding so here it goes... I want to make a form or report when a person enter a vendor (example) the other fields will atomatically fill-in depending on the data that cooresponds to that vendor. Can you show me how to do this? Example below: Vendor------> (Autofill) address------>(autofill) contract rate-------->(autofill) contract rate---> etc.
View Replies !
Autofill Of 1 Field
I have 2 forms (school and venue) I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome. Martha
View Replies !
Autofill Field With Employee
Hello all! Ok, lets get down straight to the point. What i want to achieve is that when i login that automaticly the name has been filled in on every form. I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked. Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D Greetz. Creegfire
View Replies !
Have Data In 1 Field Autofill Another, Easy?
Here is what I want to do. I have a table called "TblRates" and in the table are two fields called "Description" and "Rate" the description field has data in it like "PC Repair", "Onsite Repair" and the "Rate" field has currency data "$50.00" and "75.00". I have a for called "FrmRates" and I want to be able to select "PC Repair" from the "description" field and have it auto fill "$50.00" into the "Rate" field and the same for "Onsite Repair" and have it bring up"$75.00". That is the best way I can describ it. I would like to either know a macro or somthing easy I can type in VB code which I know nothing about. Please Help
View Replies !
Autofill Field From Selection In Combo Box
Hi all, I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!
View Replies !
Individual Rows
Hi, refer to the (record.jpg) the whole record is identified as " rst.RecordCount " ( red color box). how to identify each individual rows ( blue color box)?
View Replies !
How Do You Sort Individual Columns?
Okay, my first problem is solved...Access now stops me from entering a phone number that is already entered...so I'm a happy camper...thanks again to those who helped :) now I have my next problem, I have 8 columns, each column has phone numbers and I've separated them into what the first digit of the phone number starts with...so columns 2 to 9... now I'd like to sort each individual column so that it puts the phone numbers in numerical order...the only option I find for sort sorts all 9 columns as if they were one column and then everything is out of whack and mixed together...sorting like that works fine in excel...what's the trick to get Access to do the same thing?? Thanks a bunch :) Rosey :confused:
View Replies !
Counting Individual Numbers
Hi everyone. I have a pretty basic database with about 8 tables linked together. The database is going to be used for keeping an electronic record of claims for upto 5000 people. I have been asked though to have box on the menu screen which shows both the number of claims and the number of batches (where the claims are put) All i require really is a way to count each individual number in a coloumn EG abc123 abc123 abc124 abc125 number of batches 3 any ideas? Kev
View Replies !
Individual Controls For Each Record
I have a continuous form based on a query. I would like to have a button or control that performs some command on only one certain record. In other words, the user sees the record he wants, clicks a button and it changes the value or changes the color. When I add a button to the form, it appears next to each record and performs the same command to each record. I have tried different controls, but get similar results with each one. Even a single form seems to do the same thing, but on different pages. Am I missing something? Or maybe I am not following the concept of the form.
View Replies !
Individual Emails And Attachments From Form
I'm sure this is here somewhere but I just can't find it. I have a form where a selection of suppliers are selected, I then want to email each supplier a report attachment - headed up with their particular details - for them to complete and return. I can use the SendObject to send one email with all reports attached, how do I split it up? Can I split it up?
View Replies !
A Record For A Group Being Displayed For An Individual
Hi I'm a teacher and have to set targets for classes, I have created a database which allows me to input targets for the classes. I now need to then display the class target for individual pupils in a new layout. I am sure there is an easy solution and I am looking at the problem from the wrong direction. Thank you for any help graham
View Replies !
Link Resume To Individual Contact
Hello, I'm using the Microsoft Access contact database Template from office online. I've changed it a little to reflect a Resume database. What I would like to do is enter a link to the contacts resume stored on my hard drive. Currently, all fields have the hyperlink icon greyed out. Is this possible? Thanks Ash
View Replies !
Importing .csv Data Each As An Individual Record
Man I thought this would be simple, but it quite clearly isn't! I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record! NO using the import function only seems to allow you to import data as long as each separate piece of data is on field in a record! I understand whent this might be the case, but why the hell can I not import it so each piece of data is a separate record in the table!!!!!!!!!!! Please note I understand some sort of complex query may do it, but I am not that experienced with that yet and so don't know how it's done! Please can anyone offer a simple solution? From where I am sitting, there does not appear to be one!!!! Thanks.
View Replies !
Plz Help! Query For Summing Individual Records On Their Own
Hello Everyone,I am trying to perform a sum of records for the table belowSeatType| Ext rent | |Internal rent | Work Transfer 2 2VendorOther 2 3LOB BRF GTI BRF 2 5Displacement so that when I run the query I get the following followingSeatType| Ext rent| |Internal rent| | Total |Work Transfer 2 2 4VendorOther 2 3 5LOB BRF GTI BRF 2 5 7Displaceme What I mean is that from the first table how is it possible to get the results below. The query would generate a new column and place the sum of the data in the each row(record) in the same row in the total column. I would be really grateful. Have been bashing my head all day over this. PS I dont know any VBA. Is it possible without VBA?Thank you.
View Replies !
Merging 70 Individual Dbs Into One - Without Creating 70 Queries!!!!
Hi all - new here - hope to get some help :) Situation: I have a bunch of individual databases (approx 70) - each holding one table called "Meter" with some GPS reads and additional information about the GPS point. Am looking for solution to create one big database file holding all GPS reads. One idea i have is linking all tables into a new database and run a create table query and then an append query. Is there a way to somehow have the one append query run automatically on all existing linked tables (remember approx 70 tables so i really want to avoid of creating 70 append queries ;) ) To make it more complicated: data sets in the original individual databases could be modified or new data could be added. From what I know linked tables are updated but is there a way of keeping the my big, newly created (appended) database up2date automatically as well? Hope it all makes sense? Thanks a lot in advance Regards from Ireland
View Replies !
Analysis Graphs For Individual Customers
My database records order details for analysis. I have created a form to monitor individual trends in orders placed by my customers. As we supply bespoke items each customer has a list of products which they alone purchase, i.e we do not supply stock items, each item is specifically for one customer (they can then buy the items on a regular basis). The products are assigned to a customer in the products table. The Analysis form I have created displays the customers name and two graphs. The first graph shows total sales each month, this graph updates as I navigate through the records (i.e. a different graph is loaded for each customer). The form also contains another graph, this is where the problem lies! This graph shows orders of the individual products, controlled by a drop down list containing all the products we supply. I need to limit this list to only show those products relevant to the current customer select on the form. (The products are assigned to a customer in my products table). Currently I achieve this by using a query which when the form is opened asks me to enter a customer ID, the drop down list is then limited to the products supplied to that customer. What I would like is for the drop down list to update as I navigate through the records. i.e. when customer A is displayed show all the products assigned to customer A, when customer B is displayed show all the products assigned to customer B. I’ve attached a snapshot of the form to help explain what I mean. Thanks for any suggestions.
View Replies !
Password Protection Of Individual Forms
I have set up a front screen which has linked buttons to other forms. When I open up some of the forms (using the buttons) I would like them to be password protected. I know tihs is probably really easy, but I cant get it sussed!! Any help would be appreciated. thank you Mojaveboy
View Replies !
Locking Individual Controls On A Form
Hi I want to set the On Click Event of a button to unlock the current control a user is on. I know the code to set the property of a named control, but I don't want a button for every control I want to unlock. Is there a 'Me' option for controls? Regards David:)
View Replies !
Print Individual Mailing Label
Hi--I have a contact database, and would like to be able to have a command button on the form for each contact to print one individual mailing label for that particular contact, preferably in a user-specified row/column on a page of Avery 6245 labels. Am realizing that this is a major hassle in Access but would like to do it within Access (why is it so easy to print huge lists of labels but so hard to print just one??). Any help would be appreciated. I'm pretty good at writing queries and reports in Access but a rank newbie at the underlying SQL and VBA so need major handholding if that's involved (and I know it is ). Thanks. tdp
View Replies !
Having Individual Records, In Multiple Groups
i am making a contacts database. I have a table to hold the names and addresses of 700 people. I have another table holding the names of the mailing groups those 700 people can be in. One person can be in multiple mailing groups. i made another table, and i typed in all the people and the multipe groups they were in. For example, a there would be seven records for a person if they belonged to seven groups then i made a query relating that table to the addresses table. I want to be able to open forms to show an individual group, and cycle through the people in that group only. i can do this, but access wont let me edit any of the records. is there somthing wrong with my relationships? how do i tell accesss to allow records be in multiple groups?
View Replies !
How To Organize--By Individual Item Or Classification?
I am not sure what to search for to find an answer for this, so I'm posting a new thread. I would like to make a data-entry form for a couple of my tables. I have already done this with some other tables I have, and it has worked great. These tables are different, however, so I'm not sure how to do it. I have two tables that list our individual subscriptions to journals/magazines/etc. I have a Membership field, where I can indicate which membership, if any, the individual subscription is a part of. When I pay invoices for one of the tables, it would be nice if I could have a form that listed all of the titles for a particular membership, so I can update price information all at once. (There's often a membership price, plus additional costs for the individual journals.) It would be very convenient if this same table also could display information on titles that are NOT part of the membership. Is this possible without splitting the table up? Is there a select query that I can set up and run the form off of that? I just can't think of any way to set this up so that it actually works. Is there a function that will do this that I just don't know about? ETA: I can do something similar to what I want in a report, where it will sort the records by a particular field--but I don't know how to set that up in a form, and to make it show multiple records on one page of the form. Thanks, Siena
View Replies !
|
TRACKER
