Search results

You really hit the bottom if you have to point out simple typing errors and use them to boost your already failing argument. lol did i not say that in my first post :rolleyes:, again i dont see in your post any mention of a path problem. Could you say with 100% certainty say the problem was...

:rolleyes: LOL do you know anything...... you dont need a moderator to block/filter ppl from the forum, there is a simple ignore list that you can edit your self :p :D as for the idot comment, i didnt see you spot the error in bobs code or even know how to ignore ppl in a forum...

no need for an essay just a line of text saying something like, "personally I would use the fso, this is how you do it". If he has not used the fso before he would have to be psychic to tell what you were trying to say. i cant deny that there may be benefits to rewriting code. But you dont...

Tripple post thats a new one.. Just set the control source of a textbox = [the totals text box] + ([the totals text box] * 0.175)

I did and was forced to respond the way i did, your post offered no help, if you are suggesting he use the FSO instead of the VBA functions then you should say so and not just post a couple of lines that probably mean nothing to bob and will just confuse him. besides why get him to rewrite his...

Step by step guide to Web sites in Access 1) add the "Microsoft Web Browser" control to the form 2) use the "Navigate2" function of the control to open a url, you can call this on form load 3) open the form 4) sit back and wait while the page loads. 5) go :eek: as you realise how easy that...

No you dont FileCopy is a VBA function. Bob, Ive just done a couple of tests with the function and can find no critical problems with what you are trying to do. I suggest you do as the error message suggests and check both the paths and source file exist. Function Nightly() Dim...

What ini file cant it find? When does the error accure? on the shell line or inside prog.exe? What is the exact error code/message given? is its an ini file accociated with your prog.exe or one accociated with cmd or Environ() if its your prog.exe then you will probably need to edit the code...

ok now you know what the error is you need to know where its occuring? Open the vba editor then run the code when the error message apears press debug, the problem line of code should be highlighted in yellow. If this doesnt work use a break point at the start of the function and step through...

that all depends on what the data is\how it is stored, and what he is about to do with it. So IanT, yes its is possible but in order to help we need to know how is the data stored and where is it going?

ok now what is the problem, what errors are you getting how can we help? [edit] temporarily removeing the error handleing would help deguging.

Strange i swear i tested the code before posting and it worked fine, now i go back and test again and it doesnt work :confused: to solve the problem i have revised my syntax below to call a command propt to run the command in. Shell Environ("comspec") & " /c [your program name and path]...

A simple solution to your problem, pipe the result from the exe call to a text file open the text file and read the value. ie Shell(stAppName & stArgument "> Outpath\outfile.txt", 1) open "Outpath\outfile.txt" for input as #1 . . .

If MsgBox("Has the project been sent to ITRM for an Estimate?", vbYesNo, "ITRM?") = vbYes Then MyTextBox = "Yes" Else MyTextBox = "No" end if

:confused: What are you trying to do?

It doesnt matter if the text is going into a memo or text field Changing the text qualifier from ' to " will not make any difference. They both do exactly the same thing. ie start and end a string. Richo the examples below below will both give syntax errors. Insert into atable (somestring)...

That wont solve the problem, using a ' as a text qualifyer is just as valid as using a " did you know that """" = " a bit easier than chr$(34) . the problem is that txtmemo1 can contain invalid chr like ' and " which if left unresolved will create syntax errors in the sql field.

To get round the problem all you need to find all the offending punctuation and replace it with two copies of the same chr. ie, replace(Me.txtMemo1 ,"'","''",,,vbtextcompare) the server will now enter a single ' into the text field of the database note the vbtextcompare at the end athough...

your almost there, except you need to define which element within the array you wish to display. ie , to display the count use the first element in the array (0,0) dim sql as string dim rst as adodb.recordset dim cnn as adodb.connection dim varsqlresults as variant set cnn =...

1)Should I create a single recordset from the three tables? only you can answer this question because its all down to what you are trying to accumplish. 2)and if so how (my SQL is underdevelpoed at this point)? you dont need to know much sql, you can use the query builder and just...