Search results

Silly me! I added the lines and it's perfect. Thanks. Solved :)

Sorry to be a noob. Where do I add these? I don't currently have an error handler for this. It seems like you might've posted something before this post that didn't come through?

I tried this If KeyAscii = 27 then KeyAscii = 0 Me.txtSearch.SetFocus KeyAscii = 27 End If Same problem :|

What I understood was that I should set vbKeyEscape to 0 in the Form_KeyDown event, or something of the like. But how would that help? Why should I disable the ESC key when I want something to happen when it is pressed (i.e. the focus moves to the searchbox)?

Sorry, I don't know what you mean.

I don't think it was me that asked about concatenating haha. Anyway, I set the KeyPreview to False before the function and it produces the same error, except this time, the whole form (apart from one record) goes blank when the error message is displayed.

I use code that traps it and moves focus to the searchbox.

How do I disable the ESC key? What to you mean by 'interrupt key'. Does it interrupt all instances of code when pressed. In that case, shouldn't I have it permanently disabled?

It's a continuous form, which displays limited details of individuals. You can click on an individual's record to be directed to another form which displays more details about just that individual. I'm going to simplify. The form is based on a query with the fields, IndividualID and...

I'm using Allen Browne's Concatenate Function to concatenate the many phone number records of one person into one field of a record. i.e. John Smith | 02038483956 John Smith | 07593999493 Jim Jones | 07540029938 James Williams | 02079348395 James Williams |...

One thing about the blank database. Was it created in a 32-bit or 64-bit Access? And does it matter? Can a database made in Access 64-bit be distributed to Access 32-bit users? Can a database made in Access 32-bit be distributed to Access 64-bit users?

Will keep that in mind next time.

Thanks! I didn't compile and yes, I have backups, but I've done a lot before the last one.

Thanks for that vbaInet. I think it should work. I implemented it, but before I could test it, the database has become corrupted :banghead: Also, I've eliminated the chances of there being a blank record. I'll need to fix the DB now. If you so happen to use Access 2010, could you be kind to...

Exactly. The arrow key selection is what I meant. If the only solution means having to detect (arrow) key presses, I'd rather not carry on with this feature, as I've heard its unreliable.

Wow, I checked this thread a few times after you posted this, not realising there was a second page. Nevertheless, thanks for your suggestion. I tried the code, but it doesn't account for a record that is already selected, as in, the user must click on the record twice, whether it's already in...

I'm still trying to figure out a way, but I always come back to the same issue; the GotFocus event happens before the Click event. It would be easy if it was the opposite. Dim b as Boolean Private Sub Form_Current() b = False End Sub Private Sub cmdSelectRecord_Click() If b = True...

How to do that is what I've been trying to figure out. How would I check this? Something like: If ButtonOfCurrentSelectedRecord = ButtonOfPreviousSelectedRecord Then ... EDIT: I just understood what you're saying, after I realised the current event happens every time you switch focus to a...

A double click isn't my desired effect. The reason for this is, the user should be able to select a record and see its ID number in the footer. The main reason, however, is that I plan to add another feature after implementing this feature, which depends on it.

I feel I haven't explained it well enough; I tried to simplify it for ease of understanding, but here's the exact scenario: See the attached image. The button is transparent and overlays the width of the individual records, as seen selected on the form (dotted box) Currently, when you click...