Search results

Just wondering if there should be a Me. (or Me! ?)in front of the cboRowField etc..

Sorry Rich, I didn't mean to rub it in by posting twice. I actually meant to edit my post but I stuffed up somehow. :p

Me.Parent!frmContactSelect.ContactList.Requery is wrong syntax. Use Me.Parent!frmContactSelect.Form!ContactList.Requery

Me.Parent!Subform1.ComboList1.Requery is wrong syntax. Use Me.Parent!Subform1.Form!ComboList1.Requery

You could try: Forms!Form1.Form!EuipmentID = Me.EquiupmentID. This would be in the On Click event of a button. alternatively, you could also just use a combo box in form1 based on your query for form2.

Dim Db As DAO.Database Dim rs As DAO.Recordset 'opens Log table and adds a new record Set Db = CurrentDb Set rs = Db.OpenRecordset("tblLog") rs.AddNew rs("Elevator_ID").Value = Me.Elevator_ID 'etc. rs.Update set db = nothing set rs = nothing This may not be what you are looking for but I use...

Thanks Jeff and Ian. All I had to do was add .Text and it all works fine now. How bloody annoying. I had used your hitlimit function Ian, but I didn't see the .Text so I wasn't getting a 'live' count. Anyway, I appreciate your help.

I think it's because you didn't refer to the subform correctly somewhere. You need to refer to it's parent form as well as the subform: Forms!ClientData!ClientServices

Yeah, the thing is I need to be able to warn the user, when they reach the limit, while they are typing. When I use the Len function it won't tell me the length of the string that has just been typed while the text box still has focus, so I can't warn the user in a timely fashion i.e. before...

One way is to catch the character (number or letter) as it is typed in. You can use the On Key Press event of the text box, like this: Private Sub Text1_KeyPress(KeyAscii As Integer) If (KeyAscii < 48) Or (KeyAscii > 57) Then MsgBox "Please enter numbers only" End If *This could get...

to break it down a bit: I need to be able to know the lengths of the strings from various text boxes and comboboxes (which I can do) as well as the main 'Details' text box. The number of characters, across all controls, should not exceed 160 characters so I want to be able to count the number...

I have a form which allows the user to enter info into various controls and then send all that data, as a text message, to a cell phone. I need to limit the number of characters to be sent. I want to be able to change the colour of the text to red, in whatever control is being used at the time...

You don't actually refer to the tab control, just the page when you want affect a change to the properties of a page. The tab control is to affect changes to all pages. Try Me.ExtraInfo.Visible = False

just wondering if the master/child link is wrong for Broker Details subform i.e. the Main form doesn't seem to have the link field (brokerID) from what you have said. Also, in your code you have: Forms!BrokerList!BrokerID I'm not sure what the normal way to do it is but I would normally write...

in the on close event of your customer form you enter this: Forms!<nameofform>.Form!<nameofcombobox>.requery

I normally refer to an item on a form as Forms!MainForm.Form!TextBox. I am not sure if that is the best syntax but it works.

Try chkbox OnClick event if chkbox.value = true then form_customer!page1!Controls!date.setfocus else othertxtbox.setfocus endif Glen.

I have a list box with three columns. I want to change the data in the third column by double clicking on a row then choosing 'yes' in a message box that pops up. It's a yes/no field. So far I have: If MsgBox("Do you wish to change Technician Status for " + Me.List19.Column(1), vbYesNo) =...

Try the OnGotFocus property of the control. Add code which will change the backcolour such as: Me.Combo5.BackColour = 255 Then use the onLostFocus property to return it to its normal colour.

I was looking at the code I had written and realised I didn't have an 'end with' at the end of the with statement- before the 'end if'. Probably doesn't help now. And I still don't see why you need an 'Else'. Glen.