Search results

  1. S

    Question Package Solution Wizard

    I solved this by removing all the foreign language packs. after removing the french one it changed to german so then i removed all of them except for english. Sorted.
  2. S

    Question Package Solution Wizard

    Hi folks, This is a weird one. For some reason on my copy of Access installed on my work computer the Package Solution Wizard is in what appears to be French. How can I change this? jpg attached.
  3. S

    Renaming files

    Got it! My problem was that I was looping through the files in the folder. What i needed to do was loop through the records in the table instead as each field contained the file name. I don;t know why i didn't see this sooner! Thanks for the help.
  4. S

    Renaming files

    Hmm cant seem to find an answer to what i'm looking for exactly. I know how to rename a file but i don't know how to do what I asked. I need to rename many files. I have a table with a column of files to be renamed and another column with the names i want to re name them to. Each name is unique...
  5. S

    Renaming files

    Hi folks, I have a bunch of .jpg files which reside in the same folder as my database. What i need to do is rename all of them at the click of a button. My database has a table with a column that lists all of their file names. What I want to do is add a column to the table that lists the new...
  6. S

    Modifying XML file using DOM in Access VBA

    Hey guys thanks for the helpful responses. In the end I discovered XSLT. I used an XSL file to transform the XML to a HTML table before importing. It worked beautifully!
  7. S

    Modifying XML file using DOM in Access VBA

    Is there a way of doing it without the DOM by parsing the xml file as text? It could be like for every line with <T_IMPORT> copy the next line and paste it after each line containing <T_COMMENTS> until </T_IMPORT> and repeat the process for each <T_IMPORT>...</T_IMPORT> after that. I don't...
  8. S

    Modifying XML file using DOM in Access VBA

    Thanks for your response spikepl but unfortunately that will not work for what I need. The xml file will vary in size, it will never be the same file. The number of <T_COMMENTS> within each <T_IMPORT> will be different. One time there may be one another time there may be 35! This needs to...
  9. S

    Modifying XML file using DOM in Access VBA

    Hi folks, I am having an awful problem. I have an xml file structured like this: <root> <T_IMPORT> <VIEW_NAME>0001</VIEW_NAME> <IMAGE_FILE>0001.jpg</IMAGE_FILE> <T_COMMENTS> <COMMENT_NO>Comment 1</COMMENT_NO> <STATUS>New</STATUS> <USER>user1</USER>...
Back
Top Bottom