Search results

Hello, I have created a database to record, categorise and assign responses to correspondence received by my organisation. I'll outline what the database needs to do and how I arranged it. I would then really appreciate some tips on how I might design it better in the future. Please keep in...

Good on ya CJ, that's working exactly as I hoped it would! Thank you so much for all your help on this!! :) Had to make a couple of changes, first I needed to add an rst.edit before the first replace to avoid a runtime error. I also had to return that space infront of the " ** ". ;). Don't...

Wow! Thank you so much!!! I had no idea how to step through code like that, and view the results! So very useful! :D I think we're almost there on this. Because I attached that button to a form that showed each record in the table individually, and I have a bit of code in the form that loads...

Thank you very much CJ, that looks like exactly what I'm looking for. However I keep getting the null error. I inserted that line of code but I'm not sure what it did for me? I ran a query: SELECT Register.Response_to_Submission, Register.ID FROM Register WHERE...

The database contains loads of personal and confidential information so I really can't post a copy unfortunately. Confidential information about our processes could be determined just from the database itself, even without data.

Hi John, I copied and pasted that text exactly and received the same error. Debugger highlights that entire line.

The latest code returned the following error: Run-time error '94': Invalid use of Null. Something to do with the asterixs being confused with wildcards?

Certainly: Private Sub Command182_Click() Me.Response_to_Submission = Replace(Me.Response_to_Submission, , "**", vbCrLf & vbCrLf & vbCrLf) End Sub

Thanks for your help John. I'm not very good with code... so far I've only played around with it for on click and on event procedures. Therefore in order to run this code I made a new command button on a form that is related to the table, and used your code with an on click event. It...

RESOLVED - I need to remove characters from a memo field, and enter new lines Hello, I'm not sure if this is best place to ask this question but I figured it will probably be an update query. I have a database (Access 2003) with a memo field that is concanated from multiple other fields...

Hi folks! I'm not a database person, but I do have the need to use them in my work. I've joined up so that I can get some help from time to time on issues that I'm having and who knows, maybe I will be able to help others at some point? All the best, U