Search results

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

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

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

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

Hi all, I have a table (lets call this "TBL_USERDATA") I also have data ("NAME") in a form (FORM_INFO) that the user has entered . When the user clicks on the "UPDATE TABLE" button on the form , I want this data to be appended to my table. Can anyone give me a clue as to how to write this...

Hi all, It's great to have you all back. I got nervous when this site was down for a few days. Newbies like me rely on you guy more than you know! Here's my question: I have a table called tblECR. It has 10 fields in it. ECRno, User and Mgr, as examples. I also have small amount of data that...

I'm new at Access and VB, so I need some help. On a form (called LOGIN), I ask the user for thier name and password. Then using VB, I open an Excel database that contains user info and confirm the password. Also contained in that Excel file is their "supervisors name". Lets assign it MGR$...

Hi again all, I posted a message late yesterday (~13 below) I've gotten closer to seeing the files in my directory. The following will read the list of files, display them one at a time, but each new filename overwrites the last one displayed. Can I list them one below the other? Please...

I need some help. Only a few weeks of Access under my belt so far, and we haven't cover this topic in class yet. I 've found a half dozen methods to read my directory, but I don't know how to pass the data to my form. I use the following lines to read a list of all the files with the extension...

Hi all, Here's what I'm trying to do. Can you help me? I assign a temp file name of "DP01.txt" If this file already exists on C:\, I'd like to try DP02.txt then DP03.txt ...etc Once I find an unused number (between 01-99) I'll open it and start writing data to it. I have the program working...

My first form opens a VB script that compares a users name to their password which is stored in an Excel database. Several forms later, I need the users name again. I assigned it to a string called "username" but once I close that first form it seems to lose it? Here's where it gets trickier...

I'm trying to create a form that has list of 12 option items to choose from. I need to show which order each item was selected. This can be just one item selected or up to all twelve. As the user clicks on them, I'd like to have the number 1 come up next to the first selection. Then the...