Search:

This was resolved.

DBMS_LOB package was missing in SYS database for unknown reason. Had DBA reinstall it and it worked fine.

Hi Guys,

Hoping someone would be able to help me on this. The below code is running perfectly fine on other regions of our application but not in dev.

I had someone checked on this and he told...

Well that did the trick. It was very informative on my end as I have no idea with such variables. Thank you again westconn.

Life saver!

westconn, the idea of Chr(160) resolved the issue.

I did not change any codes on the one you have provided to remove duplicates. Instead, I added one more line above the code.
to remove that...

There's just 1 line. In a cell, I used alt+enter to go to the next line on the same cell that's why it's like that.

Attached is a sample workbook. thanks

146899

Using vbtab just pushes the text to the right while vblf does nothing.

I'm not sure why the textbox detects it like that.

Thanks, westconn. Tried that one and here goes the code:


Private Sub CommandButton4_Click()
Dim col As Collection
Set col = New Collection
s = Text1
a = Split(s, vbLf)
On Error Resume Next...

Below is a sample string of text. I already managed to removed that quotation marks. It is displayed like that becasue the test is wrapped but literally, it's just one straight line.

"Mango Pie...

I figured that out too. The data is from the sharepoint site.

It's actually like this: apple shake mango shake chocolate cake

and I just wrapped the text to make it more readable by putting...

The picture below shows where I get the data. It's actually a straight text and was just wrapped to display it separately on the next line of the cell.

If the data are manually written on the...

Thanks, Arnoutdv! The code works fine if data is manually inputted on textbox but does not work if data is copied from a cell.




Thanks, Phil and apologies as I'm still trying to learn this...

Thanks, westconn! I can say that it's working fine but ONLY if the text is manually written on the textbox. Yes it removes the duplicate text and spaces before the line but if the data is copied over...

Sorry but I'm not that good in VB especially on arrays and I don't know where to start based on the instructions you provided. Thanks for your time.



It's from another source and just pasted...

Hi Guys and mods,

Sorry for asking another help.

Been trying to code how to remove the extra line on the first part of text to no avail.

I tried the one below but it also removes the space...

Thanks, westconn! Problem solved by updating the code to the one you've provided.

I can't forget you because you've been a great help to me way back then during my thesis days. :)

Thanks a...

hi westconn,

Thanks for providing me an answer to my question. However, it's not functioning as expected.

I'm guessing that I made a wrong title by indicating "word" where it should have been...

Hi Mods and Members,

Just want to ask for a little help.

So I created a textbox on excel and created a command button to remove the quotation marks on the text that will be pasted on the...

Thank you very much sir! that's what I need! I just had to find out how to include the second onwards line of the texbox during the search process

Thank you for your time, Sir.

I've updated the data sheet and added multiple applications in one server but when I do a search via server,

only the first line is displayed. other entries are...

Thank you, Sir! The code worked but is it possible to display multiple entries? I mean example, server sample000 has multiple applications, is it possible to list all applications in the result?
...

Here you go sir. no code yet I'm very sorry and thank you.

thank you, Sir.

I'm not excel expert either sorry.

There's a system manager, App, Server, etc on the table and the data is on the other sheet.

I just don't know how to write vb codes to...

Hi Everyone,

I've been off coding for vb 10 years I guess and I'm in the position now that I don't know what to do or to write codes.

I have this simple CMDB tool that I need to create in...

Bump... hello :wave:

:(

Hi everyone,

I'm newbie to excel. I'm trying to create a simple time tracker that can track how many minutes/hours a transaction has been complete. It's easy as subtracting cells *1440 but I...

Hi All,

Is there a way to convert MS excel codes to open office? Please see below codes. I did not experience this one before.


Private Sub CommandButton1_Click()
Dim lngRowNum As Long
Dim...

thank you sir! I get your point but I don't know how to apply it. Can you please give me a sample code? I have no idea where to put the if then statement. I'm sorry for being a noob. -_-

I think I got it... correct me if I'm wrong.


=sum(A2-A1)*1440-1020

How can I exactly do that sir? =sum(A2-A1)-1020 isn't working. sorry, i'm really a newbie on this one

Hi,

I would like to seek for some help. This is just simple for some of you but I can't figure out how to do it.

I need to get how many minutes a work has been done. It is easy as

...

Thank you very much to both of you...


SOLVED!

it works great! thank you very much!

one last question, is it possible to press tab to proceed in each of the textbox?

HI - I just want to ask some help how to transfer the data from data entry sheet to data datasheet using textbox and command button. is it possible that all the data from the text box will be...

thank you very much for your help koolsid. I'll try that one later. thanks much.

look. I'm not looking for a fight here. I'm seeking for help, you know people need discipline. I'm not that strict, but they're abusing, 15 mins overbreak is fine with me, but 1 hour? come on. And I...

thanks koolsid... but I need a program which I indicated above that will run a timer when the pc is locked. I need that so I can monitor my associates if they're on overbreak or not. lol.

Thanks westconn1. But can you give me a sample?

Hi everyone... I just want to ask if it is possible to run a timer in excel when you suddenly lock your pc (I mean lock, win+L or ctrl+alt+delete lock pc.) It is possible to run a macro when that...

actually, instead of doing it on a form on VBA, what I did is just put the textbox, command buttons and other stuffs directly to the excel spreadsheet.. sorry for the confusion...

sorry for posting in the wrong section...

thanks to all of you..

[RESOLVED]