Search results

  1. S

    Terminal Server and FE/BE Configuration

    Sorry to drag out of the ancient history channel. But for the past 4 years we have been using 2003 version with next to no issues (other then my code:p) on Terminal Services (Windows Server 2003 enterprise x64). As I type this there is currently 20 people using the program, granted not the same...
  2. S

    Import XML into Table

    A new update... figure ill keep posting reports of my mission. according to more trail and error and reading up, also the below link. looks like my xml files are attribute-centric XML and i need to convert it to Element-centric XML first. http://support.microsoft.com/kb/285329 Will post...
  3. S

    Import XML into Table

    made a little discovery... using: Set xmlnodelist = xmldoc.getElementsByTagName("*") For Each xmlnode In xmlnodelist For Each mynode In xmlnode.childNodes If mynode.nodeType = NODE_TEXT Then MsgBox xmlnode.nodename & "=" & xmlnode.Text End If Next mynode Next xmlnode...
  4. S

    Import XML into Table

    Im trying to import an XML file and having a terrible time trying to find information on it. Even got a book which hasn't yet got me on the right path as it was trying to explain exporting more then the importing. I have found some info on here from gemma-the-huscky which i was fiddling with...
  5. S

    Access to Word then Format

    Thanks for your comments, im still stuck though. The text that is inserted is string that access generats which comes out looking like a title and then a paragraph. but can be two of these linked into the one string resulting in two heading and two paragraps been inserted into the one...
  6. S

    Access to Word then Format

    Hi All Quick note: I had a search and couldn't find much (pretty rare on this site) and also I wasn't sure which topic this fell under so please move if needed, sorry if so. Anyway, Question: I use a form to move alot of data from a record into a word template using a series of strings put...
  7. S

    Word Merge .. again ... I think????

    Finally tracked down my post... as above i figured instead of a form field it needed to be a bookmark. Used the following: doc.Bookmarks("bookmarkname").Range.Text = Forms![formname]![txtbox] (so simple now... but this has been my days work... im going home)
  8. S

    DATA entry in Word Doc

    http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
  9. S

    Word Merge .. again ... I think????

    Actually having a bit of trouble on the same thing at the moment.... Trying to add multiple records to a particular section on a word document. I initially did a string which was made up of the connected fields of a record together, looped it, then added the final string to the word document...
  10. S

    Newbie Web designer

    I have used Oscommerce on a couple of shops and although i dont have PHP skills the forum has ample help on the customization and help fixing things you may break :p Im biased because it was free and its done what I needed at the time. I suggest you have a look on the site and there is also a...
  11. S

    EVE-Online

    Ahh same, always been FPS/RPG and strategy enthusiast. The last simulator that i was into (also space actually) was wing commander on the 486, lol. Eve are working on First Person at the moment, although no combat I hope it is a stepping stone towards it so the game can have the best of both...
  12. S

    EVE-Online

    Don't normally post about things on forums but I wanted to share my addiction and love for this game which despite been out for years I have only stumbled across a month or two ago. Work may have suffered just a bit from it :D www.eve-online.com I wont go into why or how its the best I figure...
  13. S

    Field Selection in SQL from form.

    Hi thanks for the heads up, Im still having trouble finding anything referencing what im trying to do. I can make a combo box and then make it copy the selected field to a variable or a text box to then be used in the SQL. I just cant find anything other then dynamic tables? Iv tried...
  14. S

    Field Selection in SQL from form.

    ok, sorry wanted to repost something that made a lil more, um.... English? lol. SELECT DISTINCT Customer_advsearch.[cbofeild1] FROM Customer_advsearch; Ok, im trying to make the cbofeild1 link to a form... a combo box on a form. this possible? This added question help or confuse more?
  15. S

    Field Selection in SQL from form.

    Hi, Thanks for the replys. I think im going to go fourth and search the dynamic SQL (should have tried that one, im sure iv tried everything else) Sorry to clarify (i think) I need to insert the searchable feild into a SQL query. the feild will come from a combo box primarily but if it needs...
  16. S

    Field Selection in SQL from form.

    Hi I cant find this for the life of me... this is the second day trying to figure it out. Anyway enough crying:D Question: Either using a SQL statement or query builder, how is it possible to make the field selection come from a form, ie a combo box, text box etc. or a variable? Reason: Im...
  17. S

    Hyperlink Download

    Ok...Finally I have success... Ripped out the guts of the program started from a different direction which was found: http://www.mvps.org/access/modules/mdl0037.htm I had to copy the class modules over manually... rewrote a few lil bits of the code and hay presto... downloading the full file...
  18. S

    Hyperlink Download

    should this be moved to another section? Ie code section? I cant find anything on the net about this problem either, anyone got any ideas at all?
  19. S

    Hyperlink Download

    Here is the latest code. It is supposed to do download the CSV file and then Convert it to XLS. The conversion process seems to be fine, I even removed it and used the original code to check if the csv file was been downloaded properly and when i saw the csv file was only containing 10 (10.5...
  20. S

    Hyperlink Download

    every now and then (most of the time now) it seems to only get about 10 records of the file. Usually there should be anything up too 1000 records. boblarson can you see anywhere i can alter it? i can post my new code should it help?
Top Bottom