Recent content by zashaikh

I regularly copy and paste external data into a memo field in my DB. However, this external data always has carriage returns. How can I make it so that AS SOON AS I paste it into the field, the carriage returns are removed? I'd rather the code run as soon as the text is pasted as opposed to an...

Ridders, I would prefer a button. And Minty, THANK YOU! That typo fixed it!

Thank you for the help everyone. This is the new code: Public Sub GoToSearchFISNumb(FISNumber As Long) With Me.RecordsetClone .FindFirst "[FISNumber] = " & FISNumber If Not .NoMatch Then Me.Bookmark = .Bookmark End With End Sub Private Sub btnSearchFISNum_Click() Call...

Thank you for the assistance. But I tried that method as well, but still no luck

I have a single form with 300 records. One the form I have a textbox called FISNumber where I record an identification number. I also have a textbox field called txtSearchFISNum and a button called btnSearchFISNum. I want to be able to type in a number into txtSearchFISNum and press...

Thank you. I actually had no code at all in the Form_Load event.. However, I added a random comment string use { ' }. And now the form loads without any errors...

I can not. It is confidential

What do you mean by "comment out the code on the load event"? Are you suggesting that in the load event of the form, I click edit code, and enter some rubbish comment as such { 'Random Text }

Hello. Every time I try to open a form in my database I get an error message (see attached image). If I click "OK", my form opens fine and Im able to input data, save, edit, etc. How do I stop this error from happening? The last time I tried to fix it, I was told to...

14 is excluded from the results because “London” is attached to the “Beta” EventType. NOT the “Alpha Event” type. #15 is expected because the MIN(Event Type) = “Beta”. There is no “Alpha” to come alphabetically first before “Beta”

tblMain Event Num, Date, Additional Num 12, Jan1, 999 12, Jan1, 999 13, Sep4, <null> 14, Sep30, 82 14, Sep30, 82 15, Jun4, <null> tblEvent Event Num, Event Type, City1, City2, City3 12, Alpha, London, Beijing, New York 12, Beta, London, <null>, <null> 13, Gamma...

Other image attached

Hello All. I am trying to run a query, but am coming across an anomaly. Before I begin, I would like to ask one thing. I understand that my database may not be designed the best. And I sincerely do appreciate the advice. However, I am not here to make my database fit the proper...