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
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
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.
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?
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.
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?
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
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
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 :(
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.
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.
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
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..
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.
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.
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:
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
Here is what I am trying to do. I have a query with 2 fields. "Time In" & "Time Out". What I would like to happen is this. Whenever a character, let's say a "t", is entered into that field I would like the current time to populate that field. Right now we are actually typing in the time. I have the fields set up as DateTime fields currently.
I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.
Currently in filling a form we physically enter: Apples 2.2 red apple 2.4 red apple cut 2.45 Oranges 5.6 Cucumbers 8.5
Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?
FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs
Within my table if Field 1 has an answer of Self (from drop down), then, I would like Fields 6-12 to auto populate; however, if Field 1 does not have an answer of Self, then leave Fields 6-12 blank.
I am not quite sure how to lay this out. I am using Access 2010.
I am currently stuck on set focus property. I have a main from with nested subform. I am trying to move the focus from last field of the subform to another field on the main form.
Now I have a field name [Securedesign] in frmOrderdetails and I want the tab order to navigate to field [CustomerID] in frmAddresses which is a subform to frmCustomers.
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)
Tables: * Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player) * Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box) * Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box * Venue - similar to Competition table * Opponent - Similar to above two tables * Match - MatchID, Competition, Venue, etc (form corresponding to table attached)
Forms: * Player form * Match form
Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).