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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
Update Field Based On Other Form
I have two tables: Table1 - show details of customer payment (full payment / with credit terms up to a maximum of six (6) months) ColID - (PK/Autonumber) Col1 Col2 Col3 Col4 Col5 Col6 Table2 - shows insurance agent's prorata commission (based on cleared payment). ComID - (PK/Autonumber) ColID Com1 Com2 Com3 Com4 Com5 Com6 Scenario: If a customer was given 6-month-credit term to pay for his insurance premium, then the insurance agent's commission will also be given in six monthly terms. Example Computation: Amount of premium is 12,000 (payable in 6 months = 2,000/monthly) Agents Commission is 10% of Premium (1,200 = 200/monthly) What i need is a code to automatically update Table2 if Table1 is updated. If the dbase user updates Col2 based on the amount the customer pays, the field Com2 must also be updated. I hope this is feasible. Thanks! Sheila
View Replies !
Update Form Based On Multiple Tables
My db has several tables tb1, tb2 tb3 tb4 ..... I have link tb1 to tb2 (tb1Id to tb2)and linked tb2 to tb3 and tb4 (tb2Id to tb3 and tb4) I have created a form with several field from tb1 and tb2 and a single field for tb3 and tb4. All of the fields except one for tb1 are use to make a decision based on what they display. The only field that is updated on the form is a date conversion field from tb1. once you update this field it will auto populate a date field on tb1 with current date. you then have a choice of 4 commands to activate based on what is displayed form the rest of the form. my problem none of the fields can be updated. can any one help qry the form is based on tb1 [Name] tb1 [ID] tb1 [date conversion] 'this is the only field that is manualy updated tb1 [date] 'updated base on date conversion field being updated tb2 [field] tb3 [Yes/no] tb4 [yes/no] based on what is displayed on the form you have 4 choices of cmd buttons.
View Replies !
Combo Box Based On Other Fields On Form
I have a table that list a set of numbers in one field, the organization in a field and the position title in a field. The numbers are specific to the organization and the position title. Number OrgPosition 89087Company AClerk 52145Company AMgr 32154Company BClerk 12545Company CClerk And so forth – This is a list of numbers that is about 400+ I have created a form that displays the personal information about the employee – Name, Organization, Position title. I have also added a drop down to chose the number. I have created a dropdown to display the number based on a query that will only display numbers not used. I need to narrow this down to display only the unused numbers based on the company and position title of the individual so I do not have to search for the available Company A, Clerk numbers through the whole list. How do I write the code to open the form, look at the Organization and Position titles fields and determine the correct set of numbers to display in the list?
View Replies !
Beginners Question - Auto Update Fields Based On Fields In Another Table
I don't have any database experience whatsoever so please go easy. I'm guessing this kind of this is extremely simple for all of you. I'm constructing a database of network resources and devices and I'd like to automatically update the values in one field based on the values of a field in another table. The first table is called "IP" and the fields are called "Address", "IP Type" and "Device". The second table is called "Devices" and contains the fields "Name", "Description", "Asset Number" and "IP". Here's an example of the tables: (ignore the "code" tag. i've only used it to align my columns properly) DEVICES: NameDescriptionAssetIP XserveFile Server107203.30.144.75 ProliantXDHCP119203.30.144.15 IP: AddressIP TypeDevice 203.30.144.75Static 203.30.144.15Static What I want is for the Device field in the IP table to automatically update it's values based on the values found in the Devices table. In this case, the values that should appear in the Device field in the IP table are "Xserve" and "ProliantX". I've searched through but haven't found a complete solution, just little pieces which I'm too inexperienced to put together myself. thank you -Tim
View Replies !
Update Form Objects Based On Subform Values
Hi there, I have a form that contains customer details. A search can also be performed - and if the customer exists the details show up in a subform (based on a query). I then have buttons to either select the customer from the query, or create a new customer. Is it possible, that when the button to select the customer is clicked, the details from the subform are used to populate the text boxes on the mainform? The form is 'frmEnquiry', subform 'subfrmCus' and example field is 'Customer_No' with textbox 'txtCusNo' on mainform. I am using Access 2003. Cheers Rob
View Replies !
Subform Update Based On Query In Main Form
I based a subform called frmPatientLookupResults on a Query and placed it in a main Form called frmPatientLookup a command button on the Main form called cmdFind with the following code Private Sub cmdFind_Click() DoCmd.OpenForm "frmPatientLookupResults" Me!frmPatientLookupResults.Form.Requery End Sub I know the query works because DoCmd.OpenForm "frmPatientLookupResults" return the correct results in a separte window. But the same form as a subform only shows first patient of the table. Any ideas what went wrong?
View Replies !
Change Query Based On Form Fields
I am trying to come up with a simple way for users to query the database and pull back entries relating to the (potentially vague) data they input. I know how to run a query based upon data input in a form ("=[Forms]![FormName]![FieldName]"), and I know I can do this several times in one query. However, if one of the fields is blank, the query doesn't return anything. Is there a way to use only one query, but still allow the user to leave search criteria blank? The only thing I can think of is by using a very convoluted VB script and creating a query for each possible combination of criteria. It's not an error-checking issue, either, as entering info into all of the fields isn't required. For reference, the searchable fields are: Agent Name, Beginning Date, Ending Date (intended for a date range), Request Type, and District Name. A user could then search for any requests made by an Agent; any requests by an agent within a date range; any requests made by anyone in a date range; ad nauseum. There are quite a few combinations, there, and I'd rather not create a query for each one (or code the VB conditionals to choose the right one). I hope I'm clear in what I'm trying to accomplish :o Thanks in advance!
View Replies !
Form Fields Do Not Update
Hey guys.. the fields in my form don't update for some odd reason. i tried making another form and it works fine there. But i want these fields to be enabled on the current form because it will be the main menu and i want it to be there already. the record source is fine, all the properties are fine... but it does not update.. there is a combo box which updates perfectly.. any idea ??
View Replies !
Unable To Update Fields On Form
I created a form with a query as it's source. I am able to open the tables themselves and update them, but when I go to a field on the form I'm unable to update. What could be wrong since I have full update rights to these tables? I've checked the properties and they appear to be set correctly.
View Replies !
Establish Criteria In Query Based On Form Text Box Value
I sure am having difficulty with this. I'm trying to have the criteria in my form refer to a text box within one of my forms which is the text as I would write it myself within the query design view. Query's [DEST_ZIP5] criteria = [Forms]![Mainswitchboard]![QueryWizard].[form]![calcDestZip5] [calcDestZip5]'s value in QueryWizard form = "55422" OR "55343" Basically, I just want to be able to enter the text string within a form instead of within the query. Sure this can be done! Oh, and for what it's worth... If, [calcDestZip5]'s value in QueryWizard form = "55422" Then the query runs just fine. It's as if the query doesn't want to accept multiple criteria from another source. TIA
View Replies !
Conditional Formatting - Form Based On Text Box Entry
Hello, Could some kind person out there help me out please? I have been 'dabbling in' the area of conditional formatting, particularly in the area of changing the colour of my active form based on the result of what’s output on a text box. I have had some success in this area but where I am getting confused is getting the colour of my form to change on the basis of what is entered into a text box control that does not match exactly. My forms background changes to the required colour when its value is ‘set exactly’ but what I am trying to achieve is to change it according to the first letter of entry regardless of what follows? It always starts with a letter, either a ‘D’ or ‘V’ to indicate whether its ‘Vital’ or ‘Desirable’ and is subsequently followed by no more than 6 numbers and finally a letter. Basically I need my form to change colour based on the whether it is either a ‘V’ or a ‘D’ irrespective of what follows??? What I have been using so far is: Private Sub Model_Number_AfterUpdate() If Me.Part_Number = "V111145K" Then Me.Section(acDetail).BackColor = 12632256 'Light Red Else Me.Section(acDetail).BackColor = 8421631 'Blah Gray End If End Sub Private Sub Form_Current() If Me.Part_Number = "V111145K" Then Me.Section(acDetail).BackColor = 12632256 'Light Red Else Me.Section(acDetail).BackColor = 8421631 'Blah Gray End If End Sub Can anyone help me out of a ' sticky situation'.. Ta Very much Carol
View Replies !
Conditional Format Form Based On Text In Txtfield
Hi All, I'd lile to show/hide selected subforms based on the the text in a txtfield. The text in the selection field (txtSelect) I'd like to use for that may be either one of the following: book-01, book-02, book-03 etc OR, folder-01, folder-02, folder-03 etc OR, record-01, record-02 record-03 etc. OR it can be just a 4 digit number. If the txtSelect contains "book" I'd like the subfrmBookdetails to be visible. If the txtSelect contains "folder" obviously the subfrmFolderdetails etc. What I'm struggling with is the If-Then statement for selecting the partial text in txtselect. I've tried things like this: On current me.txtSelect.setfocus if me.txtSelect.text="book*" then me.subfrmBookdetails.visible=true etc etc. No joy. I know how to get this to work in a query with a like-statement but I have not been able to find anything on this in relation to conditional formatting of a form. Any one and good ideas? Thanks, Walter
View Replies !
Use Calculated Fields In Form To Update Table
I have a form created from a table and I had to use calculations in some of the fields to automate certain processes. Now, if I pull a report based on the fields in the table - I am getting all except for the fields with the calculations. Is there any way to update the main table - since most of the calculations were done with text boxes?
View Replies !
Copy Text Fields On Form
Hi I new to VBA and having a few problems with a database I'm working on. I have a form that contains customer details. The are two sections one for the Registered Office Address and one for the Trading Office Address. I want to be able to allow the user to auto fill the Trading Office Address fields if the Trading Office is the same as the Registered Office. I'm not sure how the event code should look. I was just going to add a button that will copy the text from the Registered Office Address fields and add them to the Trading Office Address fields. I've tried a couple of other groups but the replies just contain use this code.... TOName = ROName TOAddress = ROAddress etc... for all your fields. I need a little bit more info on how the event code should look. Any suggestions on the best code to use would be greatly appreciated. Kind Regards David
View Replies !
Form Display Cutting Off Text In Some Fields
I have tried everything I can think of- I have a tabular form in Access 2003 that is cutting off the text disply in some text fields. I am doing some comparisons so the fields are repeated three times. All three fields are larger than the data. Two fields display correctly and the third field, identical to the other two, is chopped off on the right side and just shows empty space after the first few letters instead of all the data. Fields are all the same size in the underlying table. Changing the format between left, center, right has no effect. Text size is the same in all three. All the data is from a single query on a single form. There is no subform. All properties for the three are the same. If I increase the field WAY beyond the required size all the data shows, but I haven't any extra room to do this on the form. Any ideas would be much appreciated :)
View Replies !
Unbound Text Field In Continuous Form: Update One Record, They All Get The Same Value
Hi, I want to show some text from another table based on the values of the bound fields in each record of a continuous form. I thought it would be easy, but I can't get it to work. I step through the records in the bound recordset and use some of the values to query another table. Then I use the value from the query to populate the unbound text field. It works fine for each record. But every time the unbound field is updated, all the records in the continuous form are updated. I'm stuck on this one. It's probably something simple to fix - if you know what to do! Do you have any suggestions? Thanks! -Daniel
View Replies !
Search Multiple Text Fields In A Table From A Form
Please bare with me as I am an Absolute Access VB code novice . I have a Form in my Access DB and I found the Following code on this site and placed it behind my search button : Private Sub SearchButton_Click() DoCmd.OpenReport "All users", acViewPreview, , "[AUP].[First Name] = '" & Me.[Text34] & "'" End Sub The Search works great but only searches on the 1 Field "First Name" . How would I expand the VB code to include another 2 fields within my table . ( the other 2 fields I want to serach appear on the Form ) .
View Replies !
Update Field Based On Other Other Fields
drvRegion either contains "EUROPE", "AMERICA" , "ASIA" or is NULL. if drvOrderSource="Whatever" THEN update drvRegion with "EUROPE", "AMERICA" , "ASIA" Right now I'm getting a circular reference error :/ please advise. Thank you.
View Replies !
Dynamically Create Text Fields In Form And Fill Data
I want a help on this complicated issue: On running a select query with "a*" of names in a table: Results are : America, Argentina Now I want this to dynamically create 2 text fileds in a form and fill America &".snp" in first and Argentina &".snp" in 2nd filed. It is not regarding subform to display data of query result. This I am going to use to add attchment for outlook email session as being discussed in my Email from access with attachment thread.
View Replies !
|
TRACKER
