Recent content by jardiamj

  1. J

    Parsing XML

    Hello again! I like the way the Siberian Husky friend does it, cause it works if you don't know how the structure of your XML tree is. But in this case the code you posted should work well, I'm almost sure you are just missing a loop. It seems to me you are looping through all the items for each...
  2. J

    VBA and Form help

    Can't that be done by doing a Query? I think you could do it by using a recordset. But I think I don't have the whole idea of what you are trying to acomplish to give you a precise idea.
  3. J

    Parsing XML

    As far as I can see you are missing a loop through all the contacts in contactlist like: For Each individualcontact In contactlist For Each item In individualcontact ............... Next NextI think that's what you are missing.
  4. J

    acess 2007 + connect sql server 2000

    You have to create an ODBC connection, and then you can access the MySql database by using linked tables or by using VBA code using the ADOB SQL ODBC provider.
  5. J

    appending query trouble

    I understand what you want to do. And yes, it makes a lot of sense. You could create an unmatched query of the Orders where ordertype = 3 and the OrderID is not in tblInvoice. And use it to run your append query. Cheers!
  6. J

    Unmatched query based on two criteria

    Happy to help! I'm not gonna have so much access to the internet during one month or so. So, I'm not gonna be around because of that, but as soon as I get to the internet again. I will continue in the forum. Jardi.
  7. J

    Loop through records problem.

    You could open a Recordset of the table and loop through all the records to move the pictures; for every record. I hope this helps. Cheers!
  8. J

    Enter parameter value

    Look for "Search by Form" as Namliam suggested!!
  9. J

    Problems with recordset.movenext

    Yep yep!! I think Honda is right. Do Until rst.EOF should do it.
  10. J

    Using code with more than one control

    Hello Adam! My mistake!, for the objects you have to use set. So it should be like this: set strImageFrame = Me.Controls(ImgFrame) set strImagePath = Me.Controls(ImgPath) set strErrorMsg = Me.Controls(ErrMsg)Some times I forget this kind of things. It should solve the error. Have a nice day...
  11. J

    Using code with more than one control

    You are just passing the name of the control to the variable not the control itself. To do so, declare your variables as objects and then pass the controls to them by doing Me.Controls(myControlName) and then you can call the properties of the objects like you normally do. Dim strImageFrame As...
  12. J

    Using code with more than one control

    Hello again! Just declare the variables as variant without the limits. So the array will start with 0, and you will have to loop from 0 to 5. It looks to me like a good solution for your issue. Private Sub Form_Current() Dim strImgFrame As Variant Dim strImgPath As Variant Dim strErrMsg As...
  13. J

    Using code with more than one control

    Hello Adam! I don't have so much time right now, so I just saw your code briefly. I think you just need one function for this. You will need to loop through all the controls in the form check if the control is an Image for example and then pass the object to the function you want to run related...
  14. J

    Return value if data is between certain ranges

    My apologize!, what I posted was very clumsy. You don't need to store data that is based in a formula or calculation shame on me. I must be sleepy when I posted that...lol! Raskew's example of the SELECT query should do it. Cheers!
  15. J

    Using code with more than one control

    Adam don't get confused my friend!... lol I was working with access 97 the other day and for some reason it didn't let me to pass a control to the function. So what I did was to pass the form Name and Control Name to the Function as strings, and then reference the control inside the function...
Top Bottom