Search results

Can I use the rs.Findfirst ( where 'rs' is a recordset ) method to locate a record, one field of which, has a 'Long' data type value, which is the biggest number ( because this is an Auto Number Primary key, it SHOULD be the most recently created record - which is what I actually want to ensure...

The following is the problematic section of code, in a form opened from another. The form which opens it, is a main Client form. On the form which is opened from a click on the Client form, it updates a field ( Disability_Type_IDS ) in the main table used by the first/calling form. How can I...

A MouseMove event, triggers when I hover over a control. i've checked this. Does anyone know if I can change the cursor type, from an 'I_Beam' ( not very helpful to indicate to a user they can click on this control ) to a hand ( or whatever ) as it's a control which is clickable to do something...

Thank you for your inquiries and help. It's now working. My fault for not checking my code and program thoroughly. I had not included in the problematic subform's recordsource/recordset, the most important field 'Client_ID', which is used as the link Master/Child field ( in both sub forms )...

Thank you and sorry Galaxiom, as I don't really understand the distinction you stress in your last posting ( between the subfrom object and control )It's half working now, but still a glitch. Here's the S.P. I have a tabbed control with two tabs, each of which has a subform in - sfrmReferrals...

I want it to set the recordsource of this subfrom, to the String 'refSQL' used in my command line, and display the recordset created in the said subform ( the next line is Me.sfrmreferraslClosed.Form.Requery - but tyhe syntax for thsi would be the same as the line causing the error, once that is...

The following line of code is producing an error - Me!sfrmReferrals.Form!sfrmReferralsClosed.Form.RecordSource = refSQL Microsoft Access can't find the field 'sfrmReferralsClosed' referred to in your expression. I have followed the syntax on the link in Access FAQ, and treated the recordsource...

Thank you boblarson. Yet again your knowledge and expertise has proved invaluable. You're a very important and competent contributor to this forum, and helped me on many occasions. It works perfectly.

Thank you Mr. Larson. I will inform you of the outcome of your suggestion tomorrow, when I try this.

Certainly. here's the sub : Private Sub cmdClientsOpen_Click() DoCmd.OpenForm "frmClients", acNormal DoCmd.GoToRecord , , acNewRec End Sub this GoToRecord was working and opening on a new record, but now it's saying 'Run tim error 2105: You can't go to the specified record' ( on the...

I posted earlier, that unless I was at Record No.1 in a form's recordset, and clicked on the 'AddNew' button, I could not go to a blank/new record. Now it's only if I am at the last record in the recordset ??? It's clearly allowing additions, and this works well, so it's to do with where the...

I've just noticed, the navigation buttons i.e FindFirst, FindPrevious, FindNext, FindLast and AddNew - in that order left to right, will only allow me to 'AddNew' from the first record. So, unless I navigate using FindFirst or FindPrevious to the FIRST record, every time I click on the 'AddNew'...

Your suggestion works perfectly ypma. Many thanks.

No bob fitz - but I will, and if not, ypma's suggestion. I take his point. ypma - it's not continuous form, it's Single Form is the Form view. Thank you both - will update you anon.

I have a mainform based on a simple query ( qryAllClients ) SQL statement i.e.SELECT tblClients.Client_ID, * FROM tblClients ORDER BY tblClients.Surname, tblClients.Forename; However, it doesn't open the form in alphabetical name order a la telephone directory style. When I 'run' the query...

A continuous form I have, sets the back colour of each 'row' depending on the value in one of the text boxes. It was working perfectly well, but now isn't. Quite honestly I can't see why not, as I have not altered the 'rules' set in the Conditional Formatting dialog box.:confused:

Many thanks boblarson. It's works perfectly. You're expertise has been invaluable.

Could this work for me. My post is on Forms forum, and exactly the same issue - although my SQL/Query is on another form which updates just one field in the current record on the subform, on it's Form_Unload event.. ?

When I change a date field in a subform it opens a Form ( as it should ) and I select an item from a combo box. On closing this Form, it references the record on the opening subform ( works correctly ) and updates a field in it ( not shown on subform/recordset). However, on closing the Form...

many thanks trevor G. I've solved it. It was to do with setting the BoundColumn property to '0' - deleting this, it now works fine.