Search results

Did you put the WAIT 1 as a new line after the Shell line? I'm not familiar with the -mf part of WZZIP. How does it know what to freshen, when you don't give it a file name to zip to? Dave

ND, I'm a newbie too, and didn't understand the API code stuff. I went with the WAIT command becuase it was easier. ;-) I just tried the password thing for the first time. I added the command -s[dave] after the -A command line as shown below. I checked the ZIP file and it shows a + sign...

ND, Here's a clip from my program. It's an example of 2 things. First , it shows you the "Wait" command I used to delay the program one second which allows WZZIP to finish before starting the next section. Some sections I had to extend this to a 3 second delay. Second it shows the syntax...

Awesome!! Thanks Wayne Dave

Thanks Wayne, I had tried the search engine before posting but had no luck. If you come across any, please forward the link to me. I tried a few other sites as well, with no luck. Next I wrote to WINZIP tech help group. They said to use the command... START /WAIT wzzip -a filename.zip...

I am using WZZIP command line to zip up a bunch of files from within VB. It appears to run fine, but when I open the ZIP file, there are files missing and it differs which files are missing each time I run it. I put in a loop to slow it down and that seems to work, but it also defeats the...

No luck, I had tried that earlier, but not to the extent that you suggested. I had put the underscore between the spaces of the directory names only, but that didn't work either. Must be a WZZIP thing? They suggest using the -ys option to replace spaces with the underscore when writing, but...

Hi all, I am trying to put a file into a zip file. The directory I have to go to has spaces (NOT MY IDEA!). It seems to work, but nothing is in the directory once finished. Can anyone help? Here's the line. Maybe I have a syntax error? Call Shell ("C:\WINZIP81\WZZIP C:\PROGRAM...

Hi all, I have a numerical field in my table that has skipped a few numbers. That field has been changed to my key field now (a long story) Can I use VB to search the primary key field line by line and if the next record isn't one number higher than the last, it will add that number? My...

Hi all, I have a few strings of text in a ascii file that I'm reading with "Line Input". Lets say they looks like this: I put them into an array(?) like this: Data(1) = C1, 1.23, 2.4, 10 Data (2) = C2, 8, 5.67, 8.5 etc.... etc.... I need to extract the third set of numbers (2.4 and 5.67)...

Tech, I can sympathize with you. I HATE the help files with a passion. I would have failed a long time ago if not for this group. Here's a simplified example. Good luck, Dave DoCmd.SendObject , , , "dpasquino@actechdrives.com", , , "title of email goes here" , body of email goes here, False

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

I want to change the location of a text box from within VB. I try to enter a command like: box_left = 1" <---this is the problem line box_top = 1" <---so is this one Forms!Sorted.ECN.Left = box_left Forms!Sorted.ECN.Top =...

I can't help you with the first half, sorry! But to send email from VB, use the command: DoCmd.SendObject dp

For those who are curious, here's what I'm doing: Employees can suggest changes to our products, but there is a lot of information we require up front. Who wants to make the change, which product, the reason, disposition of existing stock, affect on field units etc. Some users even need...

In the real version of my program I have declared all my values. I never understood why I had to do it, but all the manuals I read tell me to, so I did. Your simple example lets it all make sense. VB is a blast to work with but at times can be sooooo frustrating. The help files are useless...

It works!!!!! I stripped the troublesome line out (makes sense, right?) and it worked like a charm. I owe ya both a pint. Dave "knows enough to be dangerous" Pasquino

I tried both your suggestions: I get the same error message ("User-defined type not defined")running them. For Rakier's code it highlights the line: Dim MyRst As DAO.Recordset And for Bukhix's code it highlights the line: Dim rsCOD As DAO.Recordset Thanks for being so patient with me. Dave

Not knowing much about Access, I think I tried this? I went to the "Control Source" and used the Expression Builder to set the Value of "Originator" on my table. When I open the form, it doesn't let me enter my name anymore. Did I do something wrong? Can you walk me thru this?

Hi all, I have a problem that I've been struggling with for a week. I have a form with one text box (called "Originator") and an "OK" button. I'd like the user to type in thier name, then when the "OK" button is clicked, I would like to write the name to a field in my table...