adamdaban
Last Activity: Feb 12 '20, 10:11 PM
Joined: Sep 4 '17
Location:
-
Thanks so much for carrying about my issue, actually I have no VBA script! -
thanks again for your advice, I'll try to do your wayLeave a comment:
-
thanks for your advice, but I have one problem is: I upload excel file into my DB some times I forget to upload again, so the best way is when I upload excel file then after append data into my table vb will delete duplicated data, hope someone can help me to solve my problemLeave a comment:
-
Vba delete duplicated value in table
Dear All,
I need your help to solve my problem to remove the duplicated value in my table by using VBA if you check my image here is some times I may add again record but once I click on the button will remove duplicate data.
thanks for help
[IMGnothumb]https://bytes.com/attachment.php? attachmentid=99 94[/IMGnothumb]... -
amazing resource thanksLeave a comment:
-
Thanks for every thingsLeave a comment:
-
I trying to learn more I'm not so good at VBALeave a comment:
-
I don't understand why you are thinking like this way and judged me! This website for exchange idea and if you don't like I am there just talk with admin and withdraw me!Leave a comment:
-
Ade, I don't know what I should do? Also, i need it, if you have any advice, please let me knowLeave a comment:
-
always this blood test machine give us this result, this machine name is MedonicLeave a comment:
-
yes ADezii I want to like this if you check my picture
about Date is not important because I use the default date=date()
[IMGNOTHUMB]https://bytes.com/attachments/attachment/9251d1504975047/1.jpg[/IMGNOTHUMB]
yes that's I want it's true it's complicated but I believe you can figure out. Thanks, I really make you so tired ....Last edited by NeoPa; Sep 9 '17, 05:13 PM. Reason: Made pic viewable and merged posts together that should be in the same post.Leave a comment:
-
Sorry for I using this word! Actually, I need to get some of them but I don't want to make you tired when I get Idea from you I will do it another part
ID Date WBC LYM MID GRAN LYM MID GRA RBC HGB
--- --- --- --- --- ---- --- --- -- -- ---Leave a comment:
-
dear I want result like this
ID SNO RBC
---- ---- -----
value value value
not like
Test Result
---- -------
ID value
SNO value
RBC value
--------
if you can do it these 3 I will check your code and I will complete rest of themLeave a comment:
-
Dear One last question hope you don't mind, is that posible we can get result like this for example:
SNO RBC ID
---- --- ---
27987 3.4 398774
not like this
test
----
ID
SNO
TestLeave a comment:
-
I just Want to say Thanks so much for your effort and helping me as much...........Leave a comment:
-
Thanks for all of you, but I don't know how I use your code and how to put in ms access, hope someone can do it I really need it...Leave a comment:
-
I edited my question you can check which words have been bold these words I want into my tableLeave a comment:
-
this code I got from Mr.arnelgp, so how I used? you know better than me how to use in ms access
...Code:Public Function fnSpclParser(ByVal strToParsed As String) As String Dim lngPos As Long Dim lngPos2 As Long Dim strResult As String lngPos = InStr(1, strToParsed, "<n>ID", vbTextCompare) If lngPos <> 0 Then strResult = "ID:"Leave a comment:
-
this file come from lab test machine usually I will get automatically from it, this is blood test result so I need import this text file into my database, in this case, what should i do?
for example in this sample have SNO and result is 26052 so I need to get a result from each one of themLeave a comment:
-
Complex text file into ms access
dear friends, I have one text file and I want to import to access table here is text file contains:
<!--:Begin:Chksum:1 :-->
<!--:Begin:Msg:2:0:-->
<sample>
<ver>1.1</ver>
<instrinfo>
<p><n>PRDI</n><v>BM800</v></p>
<p><n>FIWV</n><v>2.9.3</v></p>
<p><n>SNO</n><v>26052</v></p>...
No activity results to display
Leave a comment: