Search results

Thanks for everyone's help - I've suggested that my colleague tries the LTrim solution suggested by Brian (Yes, I am working with British postcodes), as I don't fancy trying to talk her through the VBA solution over the phone. Thanks again - I'll let you know if it doesn't work!

Thanks for the replies Bob, you are quite right - in 2000 the Replace function is not included in built-in functions. I hadn't noticed that. However, I can still run the query on a machine that only has Access 2000. RuralGuy, I think that my colleague has already tried bullet point 3 as I had...

I'm trying to help someone with some text functions in Access, and I have used the Replace function to strip out spaces in a postcode. I created a dummy database in Access 2003 but in 2000 format since she is still on Access 2000. However, she is getting the above message. Incidentally, I don't...

Thanks - that seems to have worked!

I have a situation where a form is called from another form using this line of code. DoCmd.OpenForm strName, , , strLinkCriteria, , , Me.fldPartnerID If the form is not open, it works fine, but if the form is already open, I don't get an error but the value in OpenArgs (Me.fldPartnerID) is still...

Thanks for the explanations .... it's all working now!

I've just discovered how to use OpenArgs with OpenForm to pass a value from one form to another, but I noticed while stopping the code at breakpoints that at some point the value in OpenArgs was lost. I wondered when that actually occurs? My code works fine by the way ... for once!

Tried that and it has fixed the error ... the problem now is that the record has it's new value, but the unbound combo box thinks it's still the old one. I did try putting Me.Refresh in the other bound combo, and that seemed OK - what is the difference between Me.Refresh and DoCmd.RunCommand...

The top combo is used for the search - and that is unbound. The bottom one is really meant for changing the Partner name on the record to a different one (since that is bound), and it works fine as long as you remember to move to the next record (and therefore save the change), but if you follow...

I've got a combo box on a form used to select a 'Partner' and jump to the correct record. When the record appears, the Partner name is displayed in a second combo box, along with all other details. The second combo box is bound to the field in the table. The problem is that the following...

Yes, that's what I've done, on the grounds I've now got a more serious problem ... new post to follow!

Just tried it on the laptop and it's exactly the same - fine when it first goes bold, but wraps when you click on the form.

Thanks - that was going to be my next step, but why does it sometimes wrap yet sometimes it's OK (when the text is bold)?

This is probably really obvious ... I have a command button with the word 'Related' on it. I also have some code behind it that turns the text bold and blue if it has been pressed. When I press the button, the word looks fine, but when I click on the form (ie in a blank area of the form), the...

OK, I've just answered my own question - I hadn't realised that the Current event was triggered, but of course it will be triggered when the focus moves to the new record ... and there is code in there that was resetting the PayeeID. Thanks anyway!

Hello, I'm using a combobox to list payee names and then type the name into the combobox with the autocomplete to allow for quick jumping between records. The problem is the AfterUpdate event on the combobox uses a VBA Bookmark to jump to the selected record. This doesn't seem to be working...

That's exactly what I hoped you'd say! The form is not unbound, neither is the recordset based on a combo selection (at least not from that particular combo box). I think I'll try and simplify it. Thanks for your help.

Thanks for that. I should have posted 2 threads, as I had 2 questions really: Why would you put =[refresh] in the OnChange event and not put Me.Refresh in the code for the OnChange event? I have never seen it before (I'm not very experienced though!) Does a standard form need a commit button...

I am testing an Access database, where there is a combo box on the form. The OnChange event for the Combo box is set to =[refresh]. What does this mean? On another note, the form itself has a Commit button, with the following code in the OnClick event: If Me.Dirty = False Then Exit Sub...