:confused: I recently added a find button, using the wizard in access, i am searching three feilds ( Id, Last name & first name) when i type in these feilds and want other info to populate on the same form. now i need to update the code, so that when i hit the find button it does populate.
can anyone help
Thanks
PS the form is based on a table and not a query, I saw some info in the forum about using a combo :confused: box, but i don't want to do that.
I am new to database and hope this is a simple problem.
I have a few thousand products each with their own code and description.
I would like to create a form that when I type in the code the description self populates in an adjoining box. I would like to enter at least fifteen codes and their descriptions per form.
Have tried related tables using forms and sub forms with child/parent link but any editing of code changes the information back on the table.
Tried parameter query but how can I get more than one code on a form at a time?
Any suggestions greatly appreciated.:confused:
Hi everyone. I'm new to database design and hoping htis is a simple question.
I have nine thousand products each with their own code and description. I want a form that allows me to enter a product code and will then self populate an adjoining box with the corresponding description. I would like to enter at least fifteen codes per form.
I tried a linked form and sub form with a child/parent link but the tables info can be changed if the form user edits/deletes etc a code.
I tried a parameter query but don't know how to do more than one and the format isn't really suitable.
Any suggestions would be very much appreciated.
Thanks
:confused:Sunstar :confused:
Good day,
I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.
Can someone assist?
Thanks
I’m fairly new to Access so I hope I can get the terminology correct. I’ve been working on creating a database which has a one to many relationship. With the help of the people in the table forum, I do have that working correctly, and even have a form and sub form where the data can be successfully input.
In short, I have a main item table to track my widgets. I have a reference or look up table of colors. Third, I have a relationship table that manages the one to many relationship. My main input form has all the fields that need to be plugged into the primary table. The Sub-Form is setup for continuous forms which allow me to input as many colors as I need. Again, this all works great.
Now, to go to the next level. There are times when I want to select many (lets say 8) different colors to my widgets (kept in the primary database and form). To select each all 8 colors each time is somewhat of a pain. It is my hope and intent to create a button on my sub form that would populate my subform with the static 8 colors that I want, thus bringing me down to a single click instead of 16. (1 for the drop down, 1 to select the color).
Is this at all possible? If so, can someone give me a shove in the right direction?
Structure as follows:
TblWidgets
•Widget – Text
•Value – Numeric
•Description – Memo
•Type – Text
TblColors
•Color - Text
•Description – Text
TblWidgetColorRelationship (one to many relationship)
•Widget – points to primary key in TblWidgets
•Color – points to primary key in TblColors
Thanks,
Joiry
I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table.
I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose it would populate that data to my Carriers table.
Any help and suggestions will be appreciated.
Thanks.
Gary
Hello out there,
I am looking for some really smart people to help me with a problem.
I have a library forms database full of names of tapes and CDs, like a library. I also have an order form database. I would like to toggle between the library and order form pulling information from the library directly into the order form. I need help
I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.
View 8 Replies View RelatedThe pop-up will show the content of the parent form field or a literal if it is blank.
But it doesn't work. The syntax is invalid but my meaning is clear to everyone but the compile.
Private Sub Form_Open(Cancel As Integer)
If [Forms]![MeetingStatus]![List2].[Column](3) = "" Then
Set [Forms]![Comment]![Text2] = "No comments"
Else
Set [Forms]![Comment]![Text2] = [Forms]![MeetingStatus]![List2].[Column](3)
End If
End Sub
Help!
Hi,
I have a form with various list boxes that display options based on a query. When options are selected the text relating to them is populated in a seperate text box at the side.
The problem im having is when I select options from the list box I want it to store the selected options in the table that holds each record when the form has been filled out and submitted. At the minute it populates everything into the table apart from the options selected from the list boxes.
Does anyone know how to do this?
Thanks in advance
Edit: I have got the control souurce of the list boxes set to the correct field in the table.
I hope you can help - I have two simple problems and one slightly more complicated problem (bearing in mind I'm quite an Access Novice!)
Problem 1.
I have set up a simple form for a Timehsheet where the user can select a project and then enter hours worked in 7 text boxes for Mon-Sun. Then I have create a Total Text box at the end of the row. I need the Total box to Sum up the hours from the 7 boxes dynamically. How does one do this?
Problem 2.
How do I then ensure this calculated field populated the field hoursID in tblHours? (I am able to do this with a normal field, but with a calculated field, doesn't the formula go into the Controlsource field??)
Problem 3.
I plan to put this form as a sub-form into a main form 4-5 times so that a user can select 4-5 projects to enter hours against. I would like to have a SUBMIT button on the main form, so that all the calculated hours and selected projects populate the respective tables ONLY after this button is pressed.
Can this be done?
Thanks in advance!
Sunil
If any one can make a suggestion it would be great. I have a list of names with phone numbers, addresses and emails. I thought I could use a combo box to select the name and and have the other date associated with it come up in the appropriate boxes set. I can't get it to work. Does any one have any suggestions on how to make it work or another method that can be used. The out come I want is to allow someone to pic name from a list which will then set the phone number, address and email correct. Ideas would be great.
Thanks Tracey
I am trying to create a main form that selects a series of values allowing the user to enter new data or edit current data (using other forms). I have a series of cascading combo boxes that populate accordingly and become visible after update. I can successfully create the series and add new data and edit data as in my code.
How to populate the junction table from the forms so for example when editing or adding a new site it not only populates the tblSites and the tblSitesContacts it also populates the tblClientSitesJunction with values from the frmSites and also cmbClients. If I use the wizard and try and add values from all 3 tables to form it doesn't work and I am not sure how to add the ClientID and SiteID manually to frmSites.
I have attached a copy of my database :
Attachment 4334
I have a form with several controls. Among them are 3 in particular:
Vendor Price - Unit cost with no tax
Unit Price - Vendor Price w/tax
Old Price
What I am trying to accomplish is a way to track what previous costs were by having the Old Cost control populate with the Unit Price controls value when there is a change to either VP or UP either due to new cost or new tax rates.I found a bit of code online but was not able to get it to work for me...probably because I haven't a clue of how to structure it for my needs.
Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek:
I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table for that field. What am I doing wrong or missing here?
Sorry for posting into another thread about this, but here's my problem:
Hello All. Finally getting my pride out of the way and asking this. I've searched and this is the closest question pertaining to the problem I'm having. I have created a form to populate a table in Access. I've created Lookup fields for parts of the table that will get data from another table/tables. I want a certain part of the form to auto-populate data based off of the last name I put in the initial Drop-down box. Say, I have a person with a last name (and there are several with the same last names), I want the remainder of that line in the form/report to populate with his/her data needed for the form letter. Unfortunately right now, I have it where we have to select each from a drop down menu, for both last names, first names and other data needed. I've tore my brain up trying to figure out how to link the data in each one of the combo boxes to the first combo box. Any help would be appreciated. These are driving me nuts as I should be able to figure this out and it's just escaping my vision I guess. Thanks in advance for the help.
http://forums.aspfree.com/microsoft-access-help-18/menu-list-values-won-t-pass-to-db-20951.html
Here's a page that shows almost what I am trying to do, but my question is how do I make selecting an item in my listbox pupulate date in multiple field on my form?
For instance, I want to click on a line in a textbox and have the fields "City" "State" and "Zip" all changed on my form, not just "City"
I actually have two questions.
1. I was reviewing the Access 10 commandments and I wonder why using "lookup" is evil?
2. I am working on a db which contains approximately 14 tables. One is tblMaterialslist which contains the following fields:
ID - Autonumber
PartDescription - ShortText
PartCost - Currency
Size - ShortText
Additionally, I have a form in which I would like the "PartCost" field to auto populate when the "PartDescription" field is entered.
I am displaying records from a table on a form line after line like a spreadsheet/data sheet.
I want to do 2 things.
When the user clicks anywhere on a new row to add data I want to populate that row with some data from the row above.
I also want to protect certain fields on each line (but not all lines!)
So basically if the user is presented with
old model number.....new model number..Added by.....date
123456...................77777777................. Fred..........15/10/2014 10:11:12
77777777..................8888.................... .John..........16/10/2014 12:12:12
8888..........................6767................ .....Jack..........16/10/2014 14:11:12
6767..........................4321................ ......Joe..........17/10/2014 10:11:12
I want to protect all of the 1st 3 rows and the old model number in the last row.
When they tab or click into the new row I want the old model number populated with the new model number.
I have a Form in a datasheet view and i would like to be able to double click on a record (ideally any part of the record but if not, on the name at least) and have it open up a form to that record details.
Picture 1 is the table with the records in.
Picture 2 is the form i want it to open and populate.
I have created two tables. One table list of 100 Categories that I monitor each month. The Categories are never changing month-to month, however, each might be associated with a different client month-to-month. Presently, I am manually typing in the Client information month-to-month with information pulled from the Client's table. The Client's table has a Category Field which is populated when a Client has purchased space to use it.
In essence, I have the Category Table (Fields: Record Number; CategoryName; Client Name; beginning date the client will use the Category and Ending Date the client will stop using it). The Client's Table has a lot more fields/information but it still has the same fields as the Category Table. I am trying to be able to use the Category Table and have it automatically populate with the client who is using the Category at that time. Any Category not being used by a Client then the Query should write "Open" in the Client's name field. I have tried many different scenarios but can't seem to get it to work. I must see all 100 Categories each time I run a report. It doesn't have to say "Open" but where ever a client did not use the Category it should be left blank.
I have a form and I am not sure of the best way to populate the multiple fields on it.
The form consists of a textbox to select a date (txtDate) and then once this date is selected I want the multiple textboxes on the form to be populated from data I have in a table.
The name of each textbox is a concatenation of "txt" the number of the person which is a number from 1 to 4 and then a time eg for 12 Noon it would be 1200 so the textboxes are from txt10800 to txt42000 i.e. each person has textboxes from 8.00am to 8.00pm in half hour intervals.
I need to use two tables to populate these textboxes as in the main table there are codes that have a relationship to fields within another table that holds attributes for that code. (eg code 123 could equal Service A in the second Table but 123 is what is held on the main table) Also in the main table I have a calculated field that creates the name of the relevant textboxes on the form.
If there is a textbox that will not be populated as there is nothing in that time period then I would like this to be left blank or Null.
Am I best creating a query and binding the form to this query or to leave it unbounded and use a recordset within VBA
Also what is the best way of using either
I am using Access 2013...
I am trying to create a form from questions listed in a table, add a yes/no column to it and then have it auto populate a data sheet with the question and the answer. how I can have the datasheet autopopulated?
View 1 Replies View RelatedI am creating a db for my work place that records incidents that take place. I am a novice at Access but I have made different tables, queries, forms and reports and they all work.
I was wondering if there was a way to extract data that a user enters into a form and then use that to populate a word template *without* coding using VBA? I am really a beginner and not confident with VBA at all. I have read the forum and that seems to be an option (but would rather something else if possible!)
I'm building my first Access DB for a while, so am a little rusty, but I can't seem to work out this problem.
I've bound my form, and all of the other fields are saving and populating the correct table, but I have two combo boxes, both of which populate a series of other text boxes based on the selection (eg. I select Joe Bloggs in one box, and it automatically puts Joe Bloggs' phone number and email address in two following boxes).
This all works, however when I save the record, or move to the next one, the data entered in the combo boxes and the related populated fields doesn't save - they just show up as blank in the record created in my table.
As an aside, how do I get the combo boxes & related text fields to show a default blank value until a value is selected.
Hi all,
I have a query which populates a form called EditPatientFrm, which asks the user to enter the patient UniqueID in order to pull up the record they want to edit from the TblPatient. However, I want the user to now be able to input just one of three criteria in order to pull up the record to be edited:
UniqueID
ChartNumber
PatientLastName and PatientFirstName (two fields)
since they may not have the UniqueID readily available to them.
Can anyone show me how to do this? I have tried to find answer to this one under queries and forms- no avail. Sure it's a simple thing...
thanks!
vrpres