Search results

Pat Hartman Thanks alot. Dont belive but I understand :p

no first of all thanks! if the number is 102.1 or just 102, its not good I try now: num = 100.1 d = 100*(num - int(num)) not eligant but work Thanks! :)

I have a decimal number I want to recived just the numbers after the "." for example 100.26 >>> 26 1022.5 >>>5 10>>>0 I try with num = "300.25" d = num - int(num) but its not good becuse its get "0.25" and I want just "25" thank for any idea...

Thanks I got it Function changeIt(str) str = Replace(str,"א","%D7%90") str = Replace(str,"ב","%D7%91") str = Replace(str,"ג","%D7%92") str = Replace(str,"ד","%D7%93") str = Replace(str,"ה","%D7%94") str = Replace(str,"ו","%D7%95")...

When you search in Google word not in English, he change the code For example I write "ג'יבריש" in Hebrew And in the search its change %D7%92%27%D7%99%D7%91%D7%A8%D7%99%D7%A9 How can I change words like it? Another example: strString = “אבא” NewstrString = “D7%99%D7” Thanks a lot

Liv Manto thanks for your time... I found this file and it do my work Private Sub Command0_Click() Dim db As Database, rst As Recordset Dim qdf As QueryDef Dim Directory As String Dim MyString As String, strSQL As String Set db = CurrentDb Open "C:\Msv.001" For Output As #1 Set rst =...

Hello, I have a text file “c:/123.001” And I have a string. For Example: strString = “ 123 “ & chr(34) & vbcrlf & “4567 “ strString =strString & vbcrlf & “its Example “ And I want to replace the text file – to delete the old string and put the new. I search this forum and I found just...

Wayne Thanks Man :) Its take me some days to understand, but on the end I hope that I’ll get it. ;)

Hello, References… :eek: I did small project and my problem is that when I go to the customers, all the time the computer find Error “MISSING” References ‘Can’t find project or library’ First I have to DECLARE (write Dim to each) After I have to change each Date >>> Datetime.Date After I...

Great and if u dont have refrences (MISSING) like me, than U can write this: Dim dbs 'As DAO.Database Dim rst ' As DAO.Recordset Dim strBuffer As String Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Pouch") Open "C:\pouch.txt" For Input As #1 Line Input #1, strBuffer While Not EOF(1)...

Sorry, First of all, I understand if you don’t want to read this, because 2 things: a. to long b.My English It's hard for me write in English than I attach file “picture better then 1000 words” I don’t understand why don’t you can download the file? Now to my question: I have 2 tables...

Missing check Strings.Left I think it will help.

Hello, I want to export to excel a dynamic SQL. I try to ask in other forums and didn't have any answer. So I try here Hope that anyone know how can I do. If I export to EXCEL the SQL: SQL=Select…. Where category=”,1,2,3” It’s good. But if I export SQL=Select…. Where category like”*,1,*” It...

La La La I got it... :rolleyes: here: 27. How do I change the macro security level in Access? On the Tools menu, point to Macro, and then click Security. If you do not see the Macro menu item under the Tools menu, or the Security menu item under the Macro menu, click the arrows at the bottom...

New point all time i saw that i need to low the security Tools/macro/security but in my outlook there is, but in access there isnot that option SORRY, but for examle I attach 2 files picture esier from my english :p

ghudson u are 'KING' thank you! i'll try, and come-back with results ;)

Hello all, I install now office 2003 when I open a file i got this meesage <file attach> I dont want to see this message, what do I need to do? thanks alot S.

Thanks I got it KeyCode = 0 then Me.kod_book.SetFocus see u on the other question ;)

I have a form with textbox and click. I want when I write something in the textbox and click ENTER that the event of the click done. and after the focuse come back to the textbox My problem is that the event run good but the focus dosent return to the textbox here is my code: Private Sub...

thanks I got it! dont know how but after some playing with it I got it. thanks