Search results

Hi, How do i requery a listbox that is contained inside a subform? Listfacility is a listbox in main form while the listlender is a listbox in subform. This is my current code: [Forms]! [ListFacility].[Form]! [ListLender].Requery

Hi Janr, So far its looking good but how do you modify the code so that the cascading listbox would refer to another listbox in a subform? Is it FormName.ListName.Requery ???

Hi i have tried this and it has worked to some extent. I am only able to get the resize columns working however they do not expand fully while the autoresize method does not work for me at all. Would it trouble you to take a look at my database with the code again?? Essentially what i did was...

Oh yea i missed out the cancel. Thanks it worked

Hey i have tried using this code: Private Sub listDrawdown_AfterUpdate() With Me![ListLender] If IsNull(Me!listDrawdown) Then .RowSource = "" Else .RowSource = "SELECT [FacilityName],[TypeFacility] " & _ "FROM tblFacilitySub " & _...

Thx i will try and see if it works

Hi, Is there anyway i can set a code in order to allow users to expand columns in a listbox?

Sorry john what i meant was these two listboxes are on the same form. THe second listbox will be empty at first but once the user selects a value in listbox1 then listbox2 will be populated with the related child records

Sure. Its the AddCommitmentDetails form. Also, do you happen to know a method to expand columns in a listbox. I have a field,borrowertitle, that can get really long sometimes and the listbox doesnt have an option to expand. Help on that would be appreciated

Hi, Currently i have a listbox that has 9 columns. I want to cut it down so im intending to have two listboxes. First list box displays BorrowerID and then after making a selection the second listbox will display the child records that borrower has, which are the contact parties. Borrower...

Thanks your code solved the error part. However, it did not work the way as i thought i would. The code only cleared the last number of the year if it was earlier that the start date but i want to clear everything in the field. Also, subsequent times that i entered an earlier date on purpose...

Ok, so here is my code for the validation of my form : Private Sub AvailablePeriodEnd_BeforeUpdate(Cancel As Integer) If [AvailablePeriodStart] > [AvailablePeriodEnd] Then MsgBox ("You have entered a date wrongly") Me!AvailablePeriodEnd = "" End If End Sub However the code in red gives me an...

Hi, I currently have a select form where users select a record based on BorrowerTitle, FacilityName,CommitmentID using a single listbox and then clicking a button to open the selected record in edit mode. This has caused a problem as BorrowerTitle and TitleAgreement can have many...

Hi i tried doing the [tablename.fieldname] method but access said invalid bracketing 3126

Hi, I have a edit section in my database that has a listbox that displays records by clicking on a button. I use the following code to excecute the command: DoCmd.OpenForm "Formname", , , _ "[tblname].[fieldname]=" & "'" & Me.typelistnamehere.Column(0) & "'" 'Close the dialog box DoCmd.Close...

Thx it worked

Hi, So my form has three combo boxes named TypeSecurity,Location,ProjectType. I want to disable projectype in the form unless the user selects two specific values in the other combo boxes which are "Property" in TypeSecurity and "Local" in Location. Only if they select these options then the...

Hi, How do i put a PrimaryKey Value i selected in a listbox(Listbox contains records in form 1) in form 2 and put it in a field in a form 2? I have two tables : addnewborrower(One) and documents(Many) and they have a one to many relationship. I arldy established the relationship in the...

1. My event is ShowRecord_Click 2.no theere are subforms which are based on other table. But tblborrowerdetails contain borrowerserialno which links everthing tgt. 3. 3 column 4.BorrowerSerialNo is autonumber

Hmm now the errors are both 2465 Error 2465 is microsoft cant find the field "|" in your expression ( i dont even have that in my code o_0) 2nd Error 2465 is microsoft cant find the field "searchborrower.Column(0) in your expression.