Search results
-
F
Undefined function 'replace' in expression
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... -
F
OpenForm when form is already open?
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... -
F
Using OpenArgs with OpenForm - general question
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! -
F
Run-time error 3020 - combo boxes
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... -
F
Text wrapping on a Command Button
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... -
F
Bookmark not finding correct record in Combo Box
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... -
F
What does =[refresh] do?
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...