Search results

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.

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.

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.

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...

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...

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!

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...

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...

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>...