List/Subform Update
Mar 28, 2006
I have a private sub on a subform called txtsearchstring_change.
The txtsearchstring box is = to the client_id on the main form.
Basically when the user clicks on the next record button (which is on the main form) it should update the txtsearchstring_change on the subform and then display the new results in the list box.
Im not to sure how to do this. I understand im calling a sub from another form, so i did try a public not a private sub. And i have added on the next and previous button - txtsearchstring_change.
Thanks for any help.
View Replies
ADVERTISEMENT
Jun 25, 2007
I have a subform within a main from which switches by entry. The subform is a datasheet. I have two dropdowns in the datasheet and I want to limit one off of the other. I keep getting a prompt. The prompt is Forms!CLTS Subform!Environment. To my understanding it looks like it can't find Environment. Does anyone know the proper format.
This is my code for the second drop down in the subform.
Also special note Environment is what I am referencing to and it also is in the subform.
SELECT PackageName.PackageNameID, PackageName.PackageName, PackageName.EnvironmentID
FROM PackageName
WHERE (((PackageName.EnvironmentID)=[Forms]![CLTS Subform]![Environment]))
ORDER BY PackageName.PackageName;
View 2 Replies
View Related
Oct 5, 2013
i have a main form with three sub forms on it. when i update subform 1 i want subform 2 and 3 to update..currently i have an after update event in a combo box subform 1
Code:
[Forms]![FRMDATESUM]![frmHOURSUMnowork].Requery
[Forms]![FRMDATESUM]![frmHOURSUM].Requery
when the user updates the combobox in subform one nothing happens to the other subforms until close and reopen main form
View 2 Replies
View Related
Oct 31, 2005
Hi
I am creating an input form to assign an engineer to a project for x days.
The form consists of two Text Boxes for the Engineer Code and Project Name. I also have a Multi Select List Box which is linked to a table. The Table contains two fields ID-Autonumber and Date-ShortDate. This table contains all dates for the next three years.
I ideally want the user to select the Engineer Code and Project and the desired dates the engineer is to be assigned and add these to another table.
I have tried the following code but while the two Text Boxes update fine and the number of selected dates are added the dates themselves are not.
Can anyone see where I am going wrong and guide me in the right direction
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
Dim db As ADODB.Connection
Dim r As ADODB.Recordset
Set db = CurrentProject.Connection
Set r = New ADODB.Recordset
Dim var As Variant
r.Open "tblIM", db, adOpenStatic, adLockPessimistic
For Each var In Me.List0.ItemsSelected
r.MoveLast
r.AddNew
r.Fields("Date") = Me.List0.Value
r.Fields("EngineerCode") = Me.EngineerCode.Value
r.Fields("Project") = Me.Project.Value
r.Update
Next var
Exit_Command4_Click:
Exit Sub
Err_Command4_Click:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_Command4_Click
End Sub
Thanks
JC
View 4 Replies
View Related
Jun 6, 2013
How could I write vba in order to get one field in a subform to update another field in a different subform?
View 2 Replies
View Related
Aug 19, 2005
Hi,
I have a list box which is bound to a field in a table - however, when I select a value (which comes from a lookup query) it is not writing the value to the table, which is basically making my database useless!
I've also tried using an update query using the following code (before trying this I made the list box unbound):
UPDATE tblgroup SET tblgroup.Price = [Forms]![frmMain].[lstPrice].[value]
WHERE (((tblgroup.Group)=[forms]![frmMain].[txtGroup].[value]));
Any help would be greatly appreciated, cheers.
View 9 Replies
View Related
Jun 7, 2006
I will try and describe my issues as best I can.
I have a NotOnList Event on a Combo box.
Dim strSQL As String
Dim i As Integer
Dim Msg As String
'Exit this sub if the combo box is cleared
If NewData = "" Then Exit Sub
Msg = "'" & NewData & "' is not currently in the list." & vbCr & vbCr
Msg = Msg & "Do you want to add it?"
i = MsgBox(Msg, vbQuestion + vbYesNo, "Unknown Problem...")
If i = vbYes Then
strSQL = "Insert Into TroubleShootingGuideTBL([Problem]) values ('" & NewData & "')"
CurrentDb.Execute strSQL, dbFailOnError
Response = acDataErrAdded
Else
Response = acDataErrContinue
End If
This worked just fine until I added an AfterUpdate Event used for Cascading Combo Boxes.
On Error Resume Next
Problem.RowSource = "SELECT DISTINCT TroubleShootingGuideTBL.Problem " & _
"FROM TroubleShootingGuideTBL " & _
"WHERE TroubleShootingGuideTBL.SystemGroup = '" & SystemGroup.Value & "' " & _
"ORDER BY TroubleShootingGuideTBL.Problem;"
When I add something that is not current in the recordsource for the combo I still get the msg box:
"is not on the list, Do you want to add it? click yes or no.
I click yes and then I now get this error:
"The text you entered isn't an item in the list. Select an item from the list or enter text that matches one of the listed items"
As I said earlier the NotOnListEvent worked just great until I added the AfterUpdate Event. Any suggestions for me? Thanks in advance
The Source Table is updating but the Table the Form populates is not updating.
Please help. This is driving me crazy. and thanks!
View 2 Replies
View Related
Sep 26, 2006
ok i have three tables..
Booking_Table
Booking_ID
Job_Date
Company_ID
Booker
Passenger
Company_Table
Company_ID
Company_Name
Address
Phone_No
Company_Staff_Table
Company_Staff_ID
Company_ID
Full_Name
Phone_No
each booking will only ever involve one company at a time
company 'A' will have several staff
person 'A' from company 'A' may book a job for themselves
person 'A' from company 'A' may also book a job for person 'B' from company 'A'
i have created a booking form
i have added a combo list displaying all the company names..(control="comp_combo")
i have also added a combo list displaying all staff names from all companies (control="staff_combo")
when the user selects company 'A' from the first combo.. i would like the staff combo to update and only display staff members for that company
how do i do this.
View 1 Replies
View Related
Oct 12, 2007
I have a form in Access 2002 that a field contains a Listbox
of States (US states). If I neglect to click into the listbox
and alter the state name and then leave the form, I will get no
entry. There an item on the list highlighted each time the form is opened. I would like the highlighted list item to act as
it was selected, and then become the value stored in the field.
But, I can't seem to figure out a way to ensure this happens.
eatc7402
View 4 Replies
View Related
Jan 5, 2005
hello all
i have a problem, i have a form bounded to a query
that displays the books infos, in this form i have a list control
that displays the list of authos based on the code of the book
the problem is when i have more than one record in the opened
form ie more than one book and i move to the second record
the list doesnt change and displays the authors of the first book
when the form first opened
anyone has an idea how can the list be updated automatically when
i move between records
thanks a lot
View 6 Replies
View Related
Jun 9, 2005
I have a list box on a continous form that dynamically pulls it's information by why of a query where a field in the query is equal to the value of a field on the form.
The problem is it only does it for the first record and every record after that has values based on the first record. Is it possible for the list box to show different values for each record or is there an alternative method of pulling the information.
View 3 Replies
View Related
Aug 19, 2005
I realize there are several threads already dedicated to this particular topic but my situation is slightly different... First, my tables are set up like so:
tblStudent(studentID,LName,FName,MI,Gender)
tblRack(rackID,roomID,studentID,rackNumber)
tblRooms(roomID,roomNumber)
There are 3 racks to a room and a total of 90 rooms. A room can hold up to 3 students. A list box holds values that I have typed in (the room numbers). I went with typing them in rather than pulling them from a query because of the way my tables are set up. If I pull from a query as the tables stand, room numbers show up 3 times, once for each rack. I want to be able to fill in text boxes with information on students assigned to the room I choose from my list box (FName, LName, etc...) I'm kind of at a loss here on how to go about getting the info that I want. Using the column property to populate text fields is probably going to be much easier but a query is needed (I think) and using a query causes room numbers to show up 3 times in my list box... Anyone want to throw me a bone?? Thanks! :)
View 2 Replies
View Related
Aug 30, 2005
Greeting,
- i have a form, that has a List Box coming from a table ,,
This list box when you click on it, it shows that field in the main form
- and i have a front end and a backend to this database,
- When i add a new entry in my main form, it shows in the List Box just fine, but when i click on that list box, it doesn't show the entry on anyone else on the network - works ok locally
here is an eg: my main table has firstName, LastName, PhoneNumber, Address
Form : main form has firstName, LastName, PhoneNumber, Address
List Box inside my Form has: First Name
so i when i click on the firstName in my list box, it will show me the contact person in my main form
as i mentioned i have couple of people has the database open (split Database) anyone on the network, could see the update on the list box , but when they click on the new created name doesn't show in the main form, unless you close access, and reopen it again
i hope i was clear expaling,
any idea on how to have the List Box update itself without closing and opening Ms Access ??
thanks in advance
View 3 Replies
View Related
Oct 22, 2004
I am an Ms Access newbie and need some help on how to update 2 fields from a drop down list.
The drop down list has 5 columns. The first column is the partname that is bound and updates the table with that partname. I want to take the
listprice which is the 5th column and update a field in the table with the listprice that corresponds to the part name.
Thank you.
View 5 Replies
View Related
Jun 23, 2013
The coding below works fine. It presents a form with a list box of counties. Allows the user to select ALL, one or several counties and returns a query containing the clients from those counties.
The fields showing in the query are First, Last, Add1, FLAGToMap, City, Prov and Sector_Name.
I want to add in there a choice to select only the records that have are TRUE (-1) in the FLAGToMap field - just like the ALL button, this would be an ALL Selected Button let's say.
I would not know where to begin as I copied and adapted the coding below from a sample database and don't understand - at all - how the query is generated. The only coding in the form is the one below.
Private Sub cmdOpenQuery_Click()
On Error GoTo Err_cmdOpenQuery_Click
Dim MyDB As DAO.Database
Dim qdef As DAO.QueryDef
Dim i As Integer
Dim strSQL As String
[code]....
View 6 Replies
View Related
Sep 25, 2014
I have a combo box which gets its values from sql server using a query which is called "get_query_reason", which works fine. Now I want to update combo box values based on a user selection, st string. Have written the code, but does not work:
Dim qDef As QueryDef
Dim Query As String
Dim st As String
Dim rs As Recordset
st = "SOV"
Set qDef = CurrentDb.QueryDefs("get_query_reason")
[Code] ....
View 2 Replies
View Related
Jun 2, 2014
I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing).But for some reason on this one form I get the following error;-
"The expression After Update you entered as the property setting produced the ollowing error; A problem occurred while database was communication with OLE Server or Active X Control".
View 2 Replies
View Related
Jun 16, 2005
I have the folloowing tables in the database
tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table
tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will have, as I see it, 3 types : Composer, Group, Artist.
tblAuthorName - AuthorNameID - autonumber, AuthorName - text, - the name of all authors, composers and artists that u will pick from later
When I select Author which can be a cdgroup which is fine it will display those cd's related to the cdname. Such as Author TypeName Composer, Group. Artist.
tblTrackNumber - -Name of Song TrackNumID - autonumber, TrackNum
I have a subform and I want it to go to the tbktrack number with Name of Song related to that CD after I select an Author from the list box.
I am fairly new to this I need the vb codes for modification
mikevds@optonline.net
I set up these tables so then the relationships will refer back to them.
View 1 Replies
View Related
Jan 8, 2006
I've finally figured out how to populate my list box with radio buttons (3 companys listed on the radio buttons, you click one and employees for that particular company populates the list box). Now I'm trying to figure out how to click on an employee in that box and have their contact information populate the subform that holds that info.
After trying unsuccesfully with VB, I considered using a macro that would open the subform where the Last Name = the Last Name clicked in the list box, but I couldn't figure that out (couldn't figure out what the name would be for the selection in the list box) but I would prefer the subform be there permanantly in "add" mode untill a selection is made in the list box.
I'm code ignorant and rely on google and what books I have for reference / copy-past.....any ideas?
View 3 Replies
View Related
Jan 8, 2006
I've finally figured out how to populate my list box with radio buttons (3 companys listed on the radio buttons, you click one and employees for that particular company populates the list box). Now I'm trying to figure out how to click on an employee in that box and have their contact information populate the subform that holds that info.
After trying unsuccesfully with VB, I considered using a macro that would open the subform where the Last Name = the Last Name clicked in the list box, but I couldn't figure that out (couldn't figure out what the name would be for the selection in the list box) but I would prefer the subform be there permanantly in "add" mode untill a selection is made in the list box.
I'm code ignorant and rely on google and what books I have for reference / copy-past.....any ideas?
View 1 Replies
View Related
Jan 7, 2005
Hi
how do i click on my data in a list box (4 fields unbound)) on my (main form) so that it goes straight to my subform fields (same 4 fields from the list box), this will save me on data entry and i can just enter my quantity and it will calculate a total for me.
i don't want a combo box in my field on the subform.
any solution??
View 6 Replies
View Related
Jun 13, 2005
I am having the same problem as some others.
I have 2 cascade combo boxes
When I select CD Group and CD NAme they display the related values in a list box that's fine.
ex. CD Group Mormon Tabernacle Chior
CD Name displays cdnames with that Group.
NOW After I click cdnames I want it to go to that record on the subform which is cdtracks so it only displays cdtracks with that record.
The other problem is this might have to be straightened out is when I select a cdgroup and or cdname value it displays that value for all the records.
email mikevds@optonline.net so I can send you a attatchment
View 2 Replies
View Related
Jul 23, 2014
I am trying to build a training database, I want to open a form which shows the employees details, when open I want the attached Sub form to show a list of training documents completed to be listed. I have got it so that the sub form shows a list but of all the students, but I just want a list for the the specific person.
View 2 Replies
View Related
Apr 8, 2014
I'm building a customer form using a list box of summary customer info on the left side of the form (CustId and Names) and customer details on the right hand side. I want the details shown on the right to be those for the customer selected in the list box on the left. I'm having problems getting the details to update when a different record in the list box is selected or clicked.
I originally set the data source for the detail records to the base customer table but couldn't work out how to update them when the list box was clicked!
I then tried creating a query with the select clause conditional on the list box (CustId = Me.qryContactDetails) and set the data control source for the detail record to the query (=[qryContactDetails]![FirstName]). The query works as expected but the field in the form just shows '#Name?'.
I tried adding a field requery on the List31_Click() event using Me.[FieldName].ReQuery but that didn't seem to change anything
View 5 Replies
View Related
Jul 8, 2012
I want to have a list box, which is populated with information from a table/query, to 'filter' what it displays based on what i type in a text box, but i need it to search multiple fields. E.g. say I have a field called name and another called address, and say there are 3 johns in the name field of the table, i want the list box to filter all the other names out and just show me the johns and update automatically. but using the same text box i would like to also be able to search addresses and filter them.
code for the 'On Change' event of the text box to reload the query in the list box. I need to put in the 'criteria' section of the query, i have sound this so far but unsure if its right for every field in the query:
LIKE "*" & [Forms]![Form1]![txtSearch] & "*"
View 1 Replies
View Related
Jun 16, 2005
I have the folloowing tables in the database
tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table
tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will have, as I see it, 3 types : Composer, Group, Artist.
tblAuthorName - AuthorNameID - autonumber, AuthorName - text, - the name of all authors, composers and artists that u will pick from later
When I select Author which can be a cdgroup which is fine it will display those cd's related to the cdname. Such as Author TypeName Composer, Group. Artist.
tblTrackNumber - -Name of Song TrackNumID - autonumber, TrackNum
I have a subform and I want it to go to the tbktrack number with Name of Song related to that CD after I select an Author from the list box.
I am fairly new to this I need the vb codes for modification
mikevds@optonline.net
I set up these tables so then the relationships will refer back to them.
View 1 Replies
View Related
