Search results

If anyone ever reads this post again and has the same trouble as I did. Just create a text file using notepad or whatever... Type in this code: @echo off start /w cmd /c "C:\Program Files\myprog.exe" start /w cmd /c "C:\Program Files\myprog2.exe" '... start /w cmd /c "C:\Program...

No actually I never did, because I dunno how to do that! Can Access use a bat file instead of a macro? How can I create a bat file? Thx for your help! nico

Thanks travis thought it was harder than that it works fine! It avoids the exportation of all the reports to word! Just wot I wanted! I really appreciate you helping me! cheers nico

I have a similar problem, and I cant find an answer even in other expert forums. Does anyone have a clue? nico

Travis, I am trying to create a Word Document from a report. Sorry to be so unclear hope the attached example helps! My idea of the thing is: like my details button on the form, I want to use a button which will automatically create a word file of the viewed record (for instance...

example Travis, here's my table, with the form, and the two reports. The first one (rptCustomers) helps me to view the totality of the macthes, and the second one (rptCordisDetails) a more detailed description of each match appearing on the first one. What I wanna do is have a button which...

Travis, this tutorial explains how to send a word document to multiple recipients whose emails are contained in the original database. What I want to do is export a report displaying the values from a table. I manage to manually export the totality of my reports. But what I want to do is to...

Hello, I am controling a windows based application with a macro. This application sends multiples spyders to retrieve data from the web. I have about ten different spyders. My problem is that when I create the macro which is gonna run them automatically, they all run together which causes a...

Pease HELP!!! export to Word problem Hello, the code below allows me to open on a separate form one entry of a table with the use of cascading filters. Private Sub Commande31_Click() DoCmd.OpenReport "rptCordisDetails", A_PREVIEW Dim strSQL2 As String Dim intCounter As Integer 'Build...

Hello, I use MS Access 2k2 on Windows Xp. I have created an application thanks to the great concentration of grey matter on this forum. I now get down to publishing my results to my clients in a clean way. Indeed, I want to export my results, and not all the results but only the filtered...

OK! For the leading double quote I have made a stripping function which takes them away. For the multiple selection, I'll have to do the same selection as much time as there are text files. It's long but it works! thanks again nico

Wayne, thank you very much for your help!! You even went beyond what I hoped! Is there a way I could add up multiple text files using the SHIFT key when I import the text file? Any ways it works!! thank you I'll adapt it to my work! thank u! nico

Also, I did run the initial post with the correct sql statement! I would'nt repost a code I would'nt have checked!! ;) I am at home right now and I don't have the internet connection on my work laptop... Thats why the code hasn't been updated! my bad! nico

sample here's the sample wayne! for the sql statement its all good! thanks for checking this! cheers nico

OK wayne! I found out the same thing!! I now manage to import some parts of the txt files but the "µ" delimiter is not recognised and imported as part of the field. Maybe its because the µ is situtated between two" like this: "blahblah"µ"blahblahablha".... I dunno... But when it imports the...

Hello, I want to have a button dedicated to importing text files into tables on a click. Here's the code I was given but I can"t manage to have it work. Both of my field are memo type is there a special declaration for this type of fields? Is the String type OK for this type of fields? Is it...

Wayne, I tried both and I still get that dumb error message about duplicates, in french it says something like "no records running or in progress"... I dunno what's going wrong... From my point of view its got to do with the end of the field being parsed, as the parsing function finds nothing...

Hey wayne! I thought the end of the function was'nt set right and that it was going thru all the words again causing an error. I'll explain myself, the error message appears after the completion of the task... I still get error 3021, maybe its because I have a french version... The error is...

Hello, I use Access 2k2 on windows XP, when I run a module which parses the fields from table A and extracts the words contained between identified characters (",",";"," ","/","&") to table B, it does the job correctly, but it gives me an error 3021 at the end... here's the code: Option...

yep! thanks wayne! I'll try this at once and get back to you if I have problems. I don't think finding the ASCII code for µ is not hard. thanks again cheers to the both of you! nico