Search results

I'm using an SQL statement, and yes, it does contain an ORDER BY clause. I'll just check again, the exact spelling of the field name, ( but I don't think that's the issue ) thanks.

Here's my code ... If Me.cboRefSource.Text = "" Then frm_close Else With Forms!frmAfAISLIVE!sfrmReferrals.Form.Recordset .MoveLast .Edit !Referral_Source_ID = Me.cboRefSource.Value .Update End With End If When it gets to the line...

I've changed the form's name, and now it works ( no special characters ! ) Thank you.

My command line is ... Forms!frmAfAIS(test)!lblTest.Caption I take the point about 'miscellaneous' characters - maybe the brackets are an issue. I'll ltry the SQUARE Brackets technique. Thank you. :o

Create a brand new form ( blank ). Place a new combo box on it, ( where you want the one you're having trouble with i.e. in the header ) - and NOTHING else. Now open the form. Does it stay where you put it ? If yes, select ALL the other controls on your current form in one go, and either copy or...

This link in FAQ http://access.mvps.org/access/forms/frm0031.htm , suggests the following format, to reference a mainform's control's property from another form ... Forms!Mainform!Controlname.property However I continually get, " Cannot find the referenced form (formname )". I've tried several...

Two suggestions :- 1. Move the problematic combo box, to a location of another control in the header section, that does 'stay put' and vice-versa i.e. that control to where the combo box was. Now open form. If the combo box stays put, it looks like its the 'location' that's causing the problem (...

I've postioned a pop-up form over my Subform, using 'Me.Move x, y' ( Where x and y are coordinates for left and top respectively ) at the 'On Load' event. I'd like to parse these values from the subform ( which I have had to get anyway from its On Load event ), using a reference, rather than...

Is there some method/property of individual Datasheet views' cells, to provide the exact coordinates of that particular cell ? :)

Have you checked the properties of said Combo box ? Also look at properties of Header section. I take it, it moves when you open the form in Form view ( rather than design ) ?

The following should reference a subform from another Form. It doesn't recognise the name of the Main form however ( it's definitely correct ) With Forms!frmAfAIS(test)!frmReferrals.Form.Recordset .Edit !Staff_ID = rst.Fields("Staff_ID") .Update...

No. In fact it's no longer writing the new fields. It's stopping during the update i.e '!Referral_ID =' etc. ( Item not found in collection ) when I hover over this line of code, and this field, it shows the value for this field as the existing value for the first record in the recordset ( in...

It's a Public variable used for a field 'Client_ID' accross the project - but as I noticed when sending you, it's a 'vestige' of some experimenting I was doing with the code, and unused here. I'll clear it out when I tidy up the code - post 'functioning properly' ! Many thanks to you.;)

Thanks vbaInet - the code is in my subform. here it is ... Private Sub Referral_Date_AfterUpdate() Dim refid As String Dim dt As Date dt = Me.Referral_Date Me.Parent!txtForename.SetFocus refid = Left(Me.Parent!txtForename.Text, 1) Me.Parent!txtSurname.SetFocus refid = refid &...

Just the subform, ( but it wouldn't hurt if I had to, requery both, as the data is/should be, related ). :)

I have a 'Me.Requery' in an After_Update event proc. for sub form. The reason being, as the field concerned with the 'After_Update' event, is written to my table, I use VBA to add another field to the same record based on this value. However, it does not 'refresh' and show both fields' new...

Your Me.Top = etc. ( and presumably ) Me.Left = etc., produce an error 'Method or Data member not found'. I did wonder when after typing Me. - Intellisense didn't offer these as options ?

I don't see what you got ! What caused the 'Invalid Outside Procedure' error ?

Any ideas - I'm getting constant error messages as quoted, on my Access 2010 project ( I have been editing/changing code recently ? ):confused:

You're just too good, Bob ! Many thanks again. ;)