Automatic Population Of Fields On A Form
Hello, we are creating an input form to update a file in access. We would like to enter an order number and use that number to retrieve extra data from, a non access database. The extra data would be used to populate the
fields in the access file.
View Complete Forum Thread with Replies
Related Forum Messages:
Automatic Values Based On Other Fields
I've put together a database for my company to track our archived files. When the files are archived, there are three important values pertaining to their location: a list number, a box number, and a barcode number. Each box has a barcode on it, so what I'd like to do is make it so that when any record has both a list and box number entered (since it is dependent on the list number to know which, for example, "Box 1" I'm entering information for), it would automatically insert the appropriate barcode number in the field. It would obviously need a seed for each barcode number to be entered before it would know which one to use, but that could either be based on the first unique entry, or entered another way. If anyone can help me do this, I'd really appreciate it. Also, if my description was insufficient or confusing, just let me know and I'll try to clear it up. Thanks! Example: If I entered: List # Box # Barcode # 77 4 It might not know what the barcode is the first time. But once I had entered List # Box # Barcode # 77 4 366582 It would know what I was entering. Keeping in mind that I'm not showing the rest of the record, but just this end part, my next entry would look like: List # Box # Barcode # 77 4 366582 77 4 366582 ...the red representing that it would automatically fill that in, because it knows that if I'm talking about Box 4 in List 77, that must be the barcode.
View Replies !
Automatic Field Entry Based On Several Fields
Hi I am an amature with databases and a bit rusty too. Can anyone help me with this problem? basically I want to automatically enter a unique asset code for one table that is based on product and manuafacturer's codes from other tables e.g. for audio visual eqipment The first table would be a manufacturers table with the manufacturers code as the primary key e.g. JVC, HTC (hitachi), SHP (sharp) etc The second table would be a product table with the product code as the primary key e.g. AMP, DVD, LCD (lcd tv) etc. ( i would also have a customer table and an asset repair table) In my asset table I would like to enter an asset code as the primary key of the type JVC-DVD-001, JVC-DVD-002, HTC-LCD-001 etc by looking up codes from the other tables and then adding the last number. (Ideally once the manufacturer's code has been selected only the product codes for products made by that manufacturer would be displayed). (Also it would be ideal if referential integrity could be set up so that the asset code components can only contain valid manufacturer and product keys.) The asset code cannot be a compound key as I want to have a repair records table in which the asset code is entered as a single field with referential integrity to the asset field in the asset table. When entering repairs I would like the lookup field to display only the assets belonging to a particular customer.
View Replies !
Automatic Update Of Information In Relevant Fields
Morning everyone I have made up a database to record generations of birds; along with others I have the following fields: Ring number (primary key) Sex Year Colour Data entry via a form view. For new entries I pick up from a combo box the parents, what I need to do now is create a relationship between 1, 3&4 and 2, 5&6 so that the data will automatically slot in the relevant fields. 1Parent Cock 2Parent Hen 3Grand Parent Cock C/S 4Grand Parent Hen C/S 5Grand Parent Cock H/S 6Grand Parent Hen H/S would I do it via a query.’ And would one cover relevant generations Thanks for any help Norma
View Replies !
Automatic Entries On A Form
I'm trying to build a Form that will allow one field to be automatically populated when data is entered in another field. I have a table that contains two Fields: Course Name and Course Code. When I enter the Course Name in a Form, I would like the corresponding Course Code to appear in the relevant box on the Form. Can anybody point me in the right direction as to how this can be achieved Thanks DD
View Replies !
Trying To Create An Automatic Payroll Form
Hello, I am basically doing FORM to automatically figure out my stylists commission pay, based on 5 levels of sales and 3 different pay levels, that I will cut and paste in a table from my POS system. 3 Total Tables. tbl_Employees, with the headers ID, Name, Payroll ID, Comm_Level. tbl-Current Year with the headers ID, Payroll ID, Name, Service Sales. tbl_Comm with the headers ID, CommLow, CommHigh, Level1, Level2, Level3 In a query, Qry_Years, I have Payroll ID, linked between the tbl_Employees and tbl-Current Year. I am close in a FORM to getting this to work, unless DLookup is the wrong why to go about this. This is not correct, but gives you an idea of what I am trying to do. In a FORM text box (called framePayrollIDLookup) I have =DLookUp("Level1","tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"). This pulls up the correct pay percent for level1 employees, but i need to change out Level1 to something variable. This also doesn't work, but gives you an idea of my though process. =DLookUp(" " = framePayrollIDLookup,"tbl_Comm",[tbl - Current Year.Service Sales] & " between [CommLow] and [CommHigh]"), but this doesn't work. I might be way off base on how to do this, but I am trying. Thanks for any help. Chris
View Replies !
Field Population
Hi all, could help me with a problem. I have a form that displays only the records for a specific field. in my table I have many records so I have narrowed the records I want to display by displaying only the records with the same pin number. So if Pin number 2550 has 10 records then on my form there will be 10 records. Now I would like to add a record to make it 11 so I would like to have my fields populated from the information that I already narrowed. so the user doesnt have to enter it again. IE. my phone number, my name, and the current date doesnt change so I would like to be able to have that data appear when the button is clicked. any help would be great. So Any code Ideas would be great!:) Thanks
View Replies !
Listbox Population
Hi, I was wondering if someone could look at this code and see where I am going wrong. I open form 2 from form 1 and Form 2 has date fields populated by a calendar. When I click the search button on Form 2 I am trying to populate the listbox on form1 with records between the selected dates on form2. I think the listbox is requering as if flickers. Hope this makes sense! Here is the code so far: Private Sub cmdSearch_Click() On Error Resume Next Dim sSql As String Dim sCriteria As String sCriteria = "WHERE 1=1 " If Me![StartDate] <> "" And EndDate <> "" Then sCriteria = sCriteria & " AND tblWO.Created between #" & Format(StartDate, "dd-mmm-yyyy") & "# and #" & Format(EndDate, "dd-mmm-yyyy") & "#" End If sSql = "SELECT DISTINCT [work_priority], [UDF1],[WOnumber],[Status],[Property],[Description],[Requested],[RequestedBy],[Service],[Created],[Phone],[Asset] from tblWO " & sCriteria [Forms]![FrmFilter]![Listbox1].Form.RowSource = sSql [Forms]![FrmFilter]![Listbox1].Form.Requery End Sub
View Replies !
Tbl Population From Fm Problem
Hi All, I am having trouble getting a form to populate a table with certain information. Sergeant was good enough to help me out with getting two combo boxes to work together in the form but now the information from the two boxes are the only info from the form that will not populate the tbl. The fm is Sightings and the tbl is sightings too, the two conbo boxes in fm sightings sorce is, tbl BBList. The two combo boxes are called CommonName & Species. I have attached the DB in a zip file, it only very small and really only a trial run, so if anyone could put me out of my misery and tell me how to do it I would be most grateful. I have tried relationships and queries but to no avail, I am as you will be able to tell very new to DBing. I am using Access 2002 in Office XP
View Replies !
Combo Box Population Help
Hello: I am hoping someone can point me to a direction to help me achieve what I am trying to do. I have a form (shown below) I have 2 combo boxes, type and state What I to do is when some one chooses the type, it automatically populates the state that the type coresponds to. For example if I choose Type 1, it will populate, IL. WI, MI, NY into the State combox box and then the user can select the state they want. If they choose Type 2, it will populate NV, CA, CO, TX into the State combo box. I know how to populate a single value, but to populate all relating to a type, I am not sure. Here are the screens: http://static.flickr.com/84/244052119_404aaf8c26_o.jpg http://static.flickr.com/87/244052121_52859f3f9f_o.jpg http://static.flickr.com/95/244052123_b274f51b97_o.jpg Here's the table that the data has: http://static.flickr.com/83/244052125_0f5ca3ec82_o.jpg I appreciate any help anyone can provide.
View Replies !
List Box Population?
hi Guys I have a request from a customer to create an form to view images in a table. The idea is this.... a really quick scanner scans 100's of images to a folder. But because they're all different, we dont want to use expensive OCR software....here's the thing: I can view the images if I import their location (from a CSV file) but I wanna be able to view them directly out of their folder. So the user scrolls through each image, renames the filename and then moves the image to another folder.... The part that confuses me is this: How do you populate a list box with a list of files in a folder? And then, how do you move the images???? Sorry to lay this on ya's but its driving me mad right now. I've never worked with the DIR() functionality :(
View Replies !
Refreshing The Form And Automatic Saving Question
Dear all My inquiries is 2 fold 1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form. In more elaborate terms, I have a Main Client Form, and a Fee tracking subform. Each Client can have more than one account, so in the Fee tracking subform, I have a account combo box that provides the value that correspond to the client on the main form based on a query i generated. >> My question is everytime i scroll through the clients, I still get the same drop down values for the previous client. I installed a refresh command button and upon clicking that, it gives me the new account numbers that correspond to the current client upon. What I would like to ask is if there is any simpler or automatic way of refreshing? 2) I am not that familiar with how Access records the data in the underlying tables, but right now, all the changes I make is recorded. Is there anyway to do so such that changes will be saved only upon the user confirmation and not automatically? Thanks a lot in advance on any advice Regards TK
View Replies !
Text Field Population
Hi guys....I m facing problem with Text field population that comes from query. I successfully get the value on comboX.Rowsource from one query. Like comboX.Rowsource =" Select count[field1] FROM Table". But how can I do the same result with Text field. My email address saif009972@gmail.com
View Replies !
Limiting The Population Of A Combo Box...
This is a little complex, I will try to explain as best I can... I have several tables, storing businesses, business types, and categories... now, each business has between 3-7 categories, the categories are determined by the business type. here is how my tables are setup: tblBusiness -BusID -BusTypeID -BusInfo (several fields) tblBusType -BusTypeID -BusType -BusTypeInfo tblCat -CatID -CatName tblBusCat -BusID -CatID -Value tblBusTypeCat -BusTypeID -CatID On the form I have the all of the Business info, then a subform with the BusCat info to fill the values of the Categories that relate to the businesses. The purpose of the final table (at least I was hoping) was to populate the Available Business Categories in this form and on my reports, basically limiting the categories available to a business via it's business type. Currently I had created a second subform within the original form and set it as uneditable in order to Display the categories associated with the business type, however my system will be SO much more functional if I can find a way to limit the options as previously stated. Thanks so much for your help, I hope I haven’t confused everyone.
View Replies !
Auto Data Population
Hi I am new to the use of Access so please try to be pateint with me. I have a need to track and record lots of small components that come into and out of the warehouse. Each new item is entered into a table called newitems. The product code is the PK and is indexed, information about the supplier cost etc is added along with an opening balance. The newitems table has a one to many relationship with the movements table, the movements table tracks receipts and issues of the items. In order to speed things up it would help loads if the form for entering data into teh movements table could pick up things like the description etc from the newitems table. Currently this is being entered manually ! Thanks in anticipation. Skelly
View Replies !
How To Make Automatic Refresh / Realtime Form Datasheet
fyi : database use SQL Server 2000 ,frond end use Ms.Access 2000 and allready use with multi user the problem is : I want to automatic refresh / realtime form datasheet, if the data allready changed, deleted or add new. I try to solve it with 1. timer event + requery but i thing it's not a good idea because if data not changes, the form will be allways requery. 2.I use winsock so every user change the data, the will be send an event and i use arrived event to refresh form datasheet. And it's not solve the problem again because prosedure save/add data is more slow than event send data with winsock. so guys , plx help me to solve the problem. thx Esugiawan
View Replies !
Data Population To Frontpage 2000
Hello, I have a quick and mabye simple question. I have created a form and database using the DRW provided by frontpage. I am creating an invoice and want to set up the web page to autopopulate the next available number for invoicing. I went back into the database and set up the field to autonumber. I just want to know how to insert this into my webpage. I have tried many different result query's using the DRW but just cannot seem to get it. Any help would be appreciated. Jack
View Replies !
Data Access Pages, Date Population
i have a few data access pages and there is this field Date Created but this date created does not auto populate on my Laptop, however on the other laptop, i've tried using it and the date does auto populate, i've check the regional settings and it's the same.. any other solutions?
View Replies !
Creating New Table From Form Data Fields/clreaing Datat Fields.
I created a form in Access that retrieves data from a table. Inside the form, I am able to access/populate data fields with data from the table. I also have data fields, inside the form, that requires key-in data. I have some how lost the ability send all data field information to a second table and clear existing data fields for new entry. Questions: What settings, code or buttons can I use to send/store data field information to a new table? What settings, code or buttons can I use to automatically clear all data fields from my form once data has been sent to the new table?
View Replies !
Updating SubForm Fields From Main Form Fields
Hey Everyone, I am stuck trying to figure out this problem. I have a main form "frm_tirelog_600" which has 4 combo boxes "cboleg", "cbocar", "cbopos", "cboserial" on it. The first 3 combo boxes are used as criteria on 1 of 3 subforms that I have. The fourth combo box "cboserial" is used for the criteria in a query on another subform that I have called "frm_mount_600_subform", which is independant from the main form, I hope I have explained that clearly enough. What I need to be able to do is have the subform fill in 3 of the fields on it "leg", "car", "pos" with the value from the 3 combo boxes on my main form. I can get it to show in the fields but not write to the table. I have searched the forum and have not been able to locate anything that would work and really need any assistance with this. Im not real strong in the coding department which is where I beleive this could be done. I have attached a copy of my DB which I hope will better explain it. Any help would be greatly appreciated
View Replies !
New At Access: Update Simlar Text Fields In One Form Based On Another Form
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View Replies !
Open Form Command Button Fills In Text And Date Fields From Previous Form
I currently have two forms: frmE_SAFind and frmE_SAOrder frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05 frmE_SAOrder shows order details including [txtIDPO] and [dtmDate] I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command? Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details. Hopefully I made myself clear enough to understand. Thanks for your help!
View Replies !
Hide Fields In Main Form By Clicking Sub Form
I have one main form with 3 tabulated sub forms. My main form consists of two fields. When the user clicks tab 2 (subform 2) or tab 3 (subform 3) the main fields should hide I tried to achieve this by using the on click event at the tabbed forms. I referenced the two main fields and used the visible property followed by a form requery. It didn't work. thanks in advance
View Replies !
Problem With Total Of Sub-form Fields On Main Form
I'm trying to sum up the hours of a sub-form on the main form. I've followed the instructions in Access Help so far. I've created a text box in the footer of the sub form with the following control source: =Sum([Mon]) which should sum up all the hours in HoursMon fileds. Then I've created a text box on the main form with the following code in the Control Source =[frmTshtProj Subform]!SumMon But it doesn't work. I get a #Name? appear in the box instead of a total. Any ideas? Thanks in advance S
View Replies !
Copy Button In A Form To Copy Fields To Other Fields In The Same Record
Hi there, Can someone help me on this issue? I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment. I want to copy 4 fields to 4 other fields within the same Record. This the current code I use for the Copy-button: --- Private Sub cmdCopyFields_Click() Dim v1 As Variant Dim v2 As Variant Dim v3 As Variant Dim v4 As Variant v1 = Me!Field_a.Value v2 = Me!Field_b.Value v3 = Me!Field_c.Value v4 = Me!Field_d.Value RunCommand acCmdRecordsGoToNew Me!Field_e = v1 Me!Field_f = v2 Me!Field_g = v3 Me!Field_h = v4 End Sub --- The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same. -Is there someone that can help me with this problem, to make the copy-button in the Form run properly? -Are there other options to achieve te same? I have put in a attachment, to give you guys a visual example of what I mean. Thanks in advance, Quinten
View Replies !
Form & Sub Form Clear Fields
Hi all, I am currently trying to program a video hire form for HNC Project. The form loads from two querries: the main form from 'Customers' table; the subform from 'Rental records 'table. The form loads fine with the main menu scroll bars running through the records.....but I need the form to load with blank datafields, and only load the record when it is entered into the 'customer_membership_number'. 1. How do I clear the previous data from the form when It is loaded? 2. How do I relate the Customer_membership_Number entry text box(42) to the find button so it runs the database querry? Many thanks Sean
View Replies !
More Fields In Form
Hi I'm quite a biginner at this and I'm making a support form based on a query because I made a search function. Now I would like to add some fields in the same form, but these are made in a nother table. How do I get these fields in the field list? //Mikael
View Replies !
Form Fields
Hi, I have a combo box which has the follwoing options: Column 1 Column 2 1 Wedding 2 Funeral Now you can select via the combo box and the field will be populated with that choice. Now I have a additional field that needs to display the following. If the combo field shows Wedding, then the addiditional field needs to show £200.00 If the combo field shows Funeral, then the addiditional field needs to show £100.00 :)
View Replies !
|
TRACKER
