Recent content by neideb

I wish I could read records in two tables (two DBase but same fields) and update missing records. I already have a module but I am having intermitent errors. I would appreciate your help. Thanks a lot

Re: Add multiple records on one form by selecting items on other form. Hi all, I have a similar problem. In subform i would like to have a list box and checkboxes so that i could select the products i want to be saved in detail table. Although this thread is already 11 years old hope someone...

Hi Sparks80, ALso this function is very good. To make it work better for me I added to it the following sentence: Option Explicit Dim strReplaceArray as Variant Set the table to Plain Text Also it it very important not forget to do the folowing: In the VBA Editor you will need to go to Tools...

Hi all, i am having a huge difficult trying to replace some characters that appeared in a table I have imported from another program. I need to replace <div>, </div>, <br>, unnecessary white spaces double lines, and others. I have already a code that spark80 created and it is supposed to do...

Hi all, I want to thank very much all help Sparks80 gave to me writing the code to replace those characters that appeared in my database after converting fields to rich text. It is really a very good code and hope it can help other people in need. Tks Sparks80:cool::cool:

Tks so much Sparks80. I will backup my db and test your function. I will let you know soon. Have a nice day. Tks:D:D

Hi Sparks80 and Splkepl, tks for yr attention. I want to delete <div> that is at the begining of sentence and replace </div> or <br> at the end of sentence for next line and return character. Splkepl, The field is set to rich text. I have already copied the records to a new field set as plain...

I have placed this question in another post but maybe it was in the wrong place. I imported some fields from another database and my memo field displays some caracters like <div>_____</div>. Also there are some strings ending by <br> and others. I know that chr(13) and chr(10) means carriage...

Hi Accessfever, hope this still helps you. I am attaching a sample of what I am using based on code that John Big Booty provided us. Maybe you will have problems to populate ExamID and Examname after double click the ExamName list. Hope this helps. Feel free to post back.

Hi, accessfever, I will prepare a sample to post in forum.

Hello, I solved the problem to let user type PW in both caps and small caracter as follows: ... For K = 1 To Len(Me!PW) strPW1 = strPW1 & Asc(Mid$(Me!PW, K, 0)) 'where there was 1 put 0 strPW2 = strsPW2 & Asc(Mid$(.Column(2), K, 0)) 'where there was 1 put 0 Next K If strPW1 = strPW2 Then ...

Tks to all. I have already found the solution to my problem. I created a pop-up list form that I call from my form. I search for name I want then double click and the result is saved in the form. If anyone needs help feel free to send me email or post here.

Hi Bob, happy birthday to you. Tks for helping. Tks to John Big Booty and the Net 2.0. I will read article and let´s see I can fix my code. Latter I will let you know. Tks again

Hi all, Here is a piece of code I have to check if PW is OK. I do not know why it says that PW is not OK when I use Capital Letters. Can anyone help? I believe my problem is here but not sure.:confused: ... For K = 1 To Len(Me!PW) strPW1 = strPW1 & Asc(Mid$(Me!PW, K, 1)) strPW2 = strsPW2...

Tks Brighton, yes I have already seen that code. What I need is to search in the same form two different sources to populate another form all at once. The reason of trying to use the code is to see the names all together. Also to use de (*) to find any part of field that I could not do in...