Search results for query: *

Hi again You're correct: I was using recordsetclone. I've pasted your code, and the debug.print produces this: [PatientID] Like 'c*' was not found: False And, the first matching record is found. So that's great. Thanks! I repeated the txtGoTo.setfocus so it triggers after the record is found...

Thanks, MajP. The first time I tried, it was just resulting in "*". So I modified the code like so: rs.FindFirst "[PatientID] Like '" & txtGoTo.Text & "*'" and now the debug result is: [PatientID] Like 'cn*' but it is still not finding the record on the form. Any ideas?

Hi I am trying to use FindFirst to find a record on a form, by entering the ID into a textbox called txtGoTo. The form is bound to a table containing the record. I have searched this site and found the required syntax but still it wont work. What am I doing wrong? Thanks in advance for any...

Thanks you! Its so obvious once you've pointed it out! I knew it must be something simple - maybe I was too tired to look at it properly yesterday. Thanks again for your help.

Thanks for the quick reply. Good spotting! Sorry, that was me trying to remove confusion in my post by replacing RowerName with AccountName, but now I see I didn't change them all in the post. The real code has RowerName in all instances. More info: I have narrowed it down to something to do...

Hi, its been a long time since I last posted, as I can usually find answers by looking through other people's posts. But this time I have a problem which I just cannot solve, despite all the help there is out there. Using Windows 10, Access 2016 and VBA 7.1, with a database that was designed...

Thanks for your help and patience so far and I'm sorry I didn't make myself more clear to start with - I guess I didn't know what I don't know. I want to set the value of the control through code, but don't know how to. I want to do this because I want the value to alter when I click a...

Hi and thank you for such prompt replies. Here are the results for the three suggestions: "= '" & strNewClient & " is now a member of ' & [txtOldClient] & '`s travelling party.'" results in... = 'Practice Client' is now a member of ' Another Client'`s travelling party. - with unwanted...

I always have trouble with concatentaing strings and text and can never work out whether and/or when to use a single or double apostrophe!!! I know this is simple but I just can't get it right... txtInstructions is a textbox on a form in a MS Access 2003 database. I am trying to change the...

Thanks for your patience. It is working fine now and I have learned something as well. Incidentally, I started trying to make it work with a DLookup in the query but couldn't make it work so had given up on it. In answer to your other observations: 1. the 'hard coded' values for the...

Hi again I have done as suggested and it hasn't made any difference! I must still be missing something. Here's my code now: Dim varItem As Variant Dim txtTemp As String Dim strSQL As String Dim txtAmount As Currency For Each varItem In Me.lstDate.ItemsSelected txtTemp = txtTemp &...

Thanks Gammachaser, Andy and Duane, for your help and teaching with this. That all makes sense. I will have a go and let you know when I succeed! I confess I was being lazy by hard-coding the cost values. I have a lookup table with other cost values - when I had this request to add an...

Hi I have a simple loop which I cannot make work - please tell me what I am doing wrong! I have a list box (lstDate) in which the user selects the dates they want. lstDate is bound to tblDate and has 4 columns; ID, Date, HolidayName, Outing. Outing column is Yes/No. If the user picks a date...

Thanks for sharing that, MaJp. Its a bt clunky but I can see where its going. Cheers

Thanks, Ace. I had read that elsewhere too, but thought there must be a work around. If the AceMan can't do it, it can't be done! Shame, though. It would be good to have the same effect as a hyperlink - showing the user to click on a label for more info. Thanks again.

In Access 2003, have a continuous form with three textboxes: [PaymentDate] [PaymentType] [PaymentAmount] To edit a record, the user clicks on PaymentDate, and a single form pops up showing only the record selected. I want the PaymentDate texbox to change to FontUnderline = True when the user...

YOU'RE KIDDING ME!!!!! No, unfortunately you are not. I'm not going to make you pity me even more than you already do by telling you how long I have been trying to make that work! How did I not see that?! Anyhow - thank you for the time you have spent on that, sorry if you had better things...

Sorry, I should have provided more info. The form opens at a new record, but the ClientTourID is null, so I end up with an error 3101:...cannot find a field in tblClientTour with key matching fields...Its not picking up the ClientTourID from frmEditBooking. I hope that makes sense?

I want a form to go to a new record, and fill in the ID from another form that is open at the same time. There are two forms that this form can take the ID from so I have been trying to use the IsLoaded function to determine which form is open. Here is my code: DoCmd.GoToRecord , ...

...and I can make it change color on hover-over too now. Yay!