Tbl Population From Fm Problem
Feb 2, 2006
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
ADVERTISEMENT
Nov 23, 2005
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 14 Replies
View Related
May 24, 2005
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 7 Replies
View Related
Sep 15, 2006
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 1 Replies
View Related
Dec 4, 2006
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 1 Replies
View Related
Jan 21, 2008
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 1 Replies
View Related
Nov 23, 2004
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 9 Replies
View Related
Aug 23, 2012
I have a table where names are associated with information. However, we are now not allowed to have any identifying information with the information, so I need to move the names to another table with some kind of indentifier to associate which patient goes with which information. I was thinking about having the auto assigned ID numbers act as the ID numbers for each set of information.
So I need find a way that when someone enters information in the main table, they then enter the name into the "ID table" with the same autoassigned number. The problem now is there is already information in the table, and since data has been deleted, the ID autoassign field has gaps. I also don't know if I can set up an autopopulate field. How to make this easier or how to create the auto-population.
View 3 Replies
View Related
May 6, 2014
I have a form set up so that a supplier code combo box is populated with a simple SQL statement to get values from a lookup table. I have a second combo box that is populated when the supplier code is selected by the user. It works well. For example, if the user selects supplier Dog then the current record value of the Product field is displayed and the combo box shows all Dog products. So that's great.
My problem arises when the form loads. I can't convince Access to fill the Product combo box with the current products. For example, if the first record has Cat as the supplier, I want it to display the Product value for the first record and to show all the Cat products in the drop down. It isn't doing it on load or on record navigation. It does work if the user reselects the supplier.
I have tried various events.
Right now I have the following code in the AfterUpdate event of cboSupplier:
qry = "SELECT SupplierCodeProductCodeEquityTypeQuery.Product.Nam e, SupplierCodeProductCodeEquityTypeQuery.ProductCode ,
SupplierCodeProductCodeEquityTypeQuery.SupplierCod e, "
qry = qry & "SupplierCodeProductCodeEquityTypeQuery.Supplier.N ame, SupplierCodeProductCodeEquityTypeQuery.ProductId FROM SupplierCodeProductCodeEquityTypeQuery "
qry = qry & "WHERE SupplierCodeProductCodeEquityTypeQuery.Supplier.Na me = '" & cboSupplier.SelText & "';"
Me.cboProduct3.RowSource = qry
View 3 Replies
View Related
Dec 30, 2014
use a continuous form to allow users to quickly enter any number of records. One of the fields in this continuous form is an ID (not a foreign key, actually not a key in the database but crucial for other purposes) which is incremental from the last one stored in a table.
I am able to use a combo box and a query to get the ID but I cannot save the value to the text box on the first record, and then requery and get the next id when the user moves onto the next record..and so forth..
View 4 Replies
View Related
Jan 9, 2014
The datasheet is populated in a subform, based upon a table.
Code:
SELECT DEV_List.*
FROM DEV_List;
Within this datasheet, I have several combo boxes.It is easy to give them a query to show all values possible.
Code:
SELECT tbl_PPV_RPM.Createdby
FROM tbl_PPV_RPM
GROUP BY tbl_PPV_RPM.Createdby;
This gives me a list of all possible values in "tbl_PPV_RPM.Createdby".What I want, is to be able to select only the relevant values in this combobox, based upon a materialnumber in the same row. "tbl_PPV_RPM" contains a row named "Material". The datasheet also contains a row named "Material". These need to be linked. When I try to link them through the query builder, I get this:
Code:
SELECT tbl_PPV_RPM.Createdby
FROM tbl_PPV_RPM
WHERE (((tbl_PPV_RPM.Material)=[Forms]![frmSub_TD_List_Edit].[Material]))
GROUP BY tbl_PPV_RPM.Createdby;
But then I get a popup box, requesting for the Material number in "frmSub_TD_List_Edit".So, it does not recognise the Materialnumber in the row I'm trying to select a value.
View 2 Replies
View Related
Mar 20, 2014
I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select.
I have got the the point where I have building name and number in the building name combo box but i'm stuck with the after update code builer part.
I currently have:
Me.Building_NameControl = Me.Building_Number.Column(2)
But doesn't seem to work.I don't really understand syntax!
View 12 Replies
View Related
Aug 3, 2015
I've created a table with a form that includes multiple fields that autopopulate after I enter a certain date into the "reciept date" column. After I hit enter or tab, the autopopulation accures. After I completed the table and form for autopopulation, I was tasked with adding even more autopopulating columns to the tablel that was completed. After adding the additional columns to the table and adding the extra code in it's proper place, doing everything exactly like the night before, the autopopulate does not work for any of the columns.
View 2 Replies
View Related
Aug 1, 2013
how to automatically populate a certain field. To add some context, I have a form which registers the details of a contact with standard information of contact details. There is a subform which shows the different products that the client from the main form is interested in. This is a actually a data sheet which returns the results of a query (selecting from the relevant table the client in question and the products he/she wants).
I have added a button which opens up another form and allows a product (and hence a new record) to be added for that particular client. I would like that the form automatically populates one of the fields in the form that is the client id. Given that the subform is opened from a form which already identifies the client, how do I do this?
View 14 Replies
View Related
Nov 4, 2013
I'm building a test registration form, and I want to populate 2 additional fields based on the TestID ComboBox selection. This same TestID table has a Requirement and Expected result field, that I want to display for the end user, to make sense of the test in question. Multiple fields in the ComboBox does not work since you cannot select a single testID; you can click on the relevant testID, but the table remains in view, rather than displaying only the relevant testID.
View 7 Replies
View Related
Mar 16, 2014
I have a sheet of inventory I am working on creating. The price for storage for an item is determined by 2 things. 1. the type of material and 2. the size of that material. I have created a table with the material types and sizes. Is there a way that I can have the price automatically populate when I select the type of material and then size?
View 3 Replies
View Related
Apr 14, 2007
I need to write a query which populates an empty field in the current record with information from a specific field in the next sequential record. Any ideas?:confused:
View 3 Replies
View Related
