Search results

  1. T

    Java code to vba

    Perfect Stopher, this does the same, funny now that i see it i didnt really need an array lol :) thank you for your time man.
  2. T

    Java code to vba

    Hi, after 19 houres I am proud to present the solution. I wouldn't have been able to do it without DJKarl's help. thank you again for your help. please find below the code Private Sub Command0_Click() Dim ssIn As String: ssIn = "GYM019680000005" Dim sCharPool As String: sCharPool =...
  3. T

    Java code to vba

    DJKarl your the best, I am trying to adapt your code, and i think its working as i need it, ill keep you guys posted thanx a milion
  4. T

    Java code to vba

    lol, thank you mate I really appreciate any help i can get good luck
  5. T

    Java code to vba

    Hello VBA lovers I Have wrote a simple code in java and i would very much like to be able to use it in ms access. Could someone translate it in vba please. I know it will be easy for most of the ppeople programming in VBA, cose it has only two loopes and some string variables. So I would...
  6. T

    inner, left or right join ?

    Hi Red17, thank you for your email, i have tried, copy and passed the code you provided. It didnt work :( and it looked complicated for me....
  7. T

    inner, left or right join ?

    Hi, Here is me with my problems again. its been 48 houres without sleep and without solution. So i hope someone can help me in here like allways. ok, this is bothering me: I have two tables, [orderTable] and [closeTable] I polulate [orderTable] by clicking on add button. that works fine. now...
  8. T

    Problem with IF and

    This does it. its working as it should. your the best my friend. thank you for your time. Best Regards
  9. T

    Problem with IF and

    its stupid 123 Mb file :( anyway i figure it out , well partialy, now the main form loads and display the correct picture: what i did i just put the code in the password form, the one that opens the main1 form: Private Sub bntlogin_Click() If passwordtxt = DLookup("password"...
  10. T

    Problem with IF and

    actualy the form is closing and reopening again. i have tried to put it on almost all events, on open, on current, on active ..etc all the same. is there somewhere that saves cash or something, or maby doing a repaint or reload ?! hmmmm i think i know what the problem is: the password form...
  11. T

    Problem with IF and

    actualy the form is closing and reopening again. i have tried to put it on almost all events, on open, on current, on active ..etc all the same. is there somewhere that saves cash or something, or maby doing a repaint or reload ?! hmmmm i think i know what the problem is: the password form...
  12. T

    Problem with IF and

    vbaInet AWF VIP Hi VbaInet, yes both of you are right, it was better to do it like you said. I have it now like this If DCount("Qty", "[openTables]", "[Table] = 1 and [Waiter] = '" & [Forms]![main1]![userlookup].[Value] & "'") = 0 Then but very strange thing happens, first time when the...
  13. T

    Problem with IF and

    Hi, I have tried that to :(
  14. T

    Problem with IF and

    Hi Clive2002, thank you for your reply, yes i have tried that and swiched from label to txtbox, but i get the same thin, i mean there is no error its just not doing what is suppose to do. i know i have somewhere a logic problem i just cant figure it out where. i have created a txtbox and in...
  15. T

    Problem with IF and

    Greetings, im struggling with this logic since three days now. I really need your help guys, something is wrong with me. My problem is that im trying to change a picture from table.gif to tablex.gif, if meet some criteria. please find what i did till now Private Sub Form_Load() Dim nCount1 As...
  16. T

    Insert Update Or Append Table

    yeeeeeee I found the solution. UPDATE tbl1LEFT JOIN tbl2ON tbl1.ID = tbl2.ID SET tbl2.Qty = [tbl2].[Qty] + [tbl1].[Qty]; works like charm I love you all regards P.S. Guess I'll get some sleep tonight afterall :)
  17. T

    Insert Update Or Append Table

    Greetings, I'm trying to update values of one table from another table by adding to existing values. I have two table , tbl1 and tbl2 in tbl1 i have items and qty same in tbl2 items and qty now i would like to update tbl1.qty using RunSql with data from tbl2.qty so if in tbl1.qty = 5, by...
  18. T

    Multiplying in Continuous Form

    Thank you very much, I just found the solution. I needed to mut the calculation in control source of my unbound textbox and works perfect finaly, lol Kind regards
  19. T

    Multiplying in Continuous Form

    Greetings, I am trying to myltiply two fields on my continuous form, I have a formula that i put in unbound textbox and works fine, but just for the first row, the next one in a line gives the same value of the first row even that is not correct: I hope im explaining myself what im trying to...
  20. T

    MOD36 check digit

    Hi again, I have tried all day long now, either its so easy and i just cant see it, or its really that complicate. I have gone deeper in to it and could you please look in to it and see whats what i have done: [code] my module: Option Compare Database Public Function Mod36(Val As String) As...
Back
Top Bottom