Sorry, but I didn't see the posts by PHV and Andrzejek before I figured it out. But I still have a problem. I need to trim 5 spaces from the left side of one field. Is it possible using the import specification box to trim this as I bring it in, or do I need to use LTrim after it's in? Also, how...
OK, I figured out how to serup the specification file in VBA. Thanks for the assistance.
If the square peg won't fit in the round hole, sand off the corners.
OK, I looked up "specification file" as I've never heard of it before. I've also never imported csv files before, which may be why. If I import this file manually I can select the fields I need, but I'm trying to do this in VBA, and have no clue how to use a specification file in VBA.
If the...
I need to import a csv file into a new Access 2003 table using VBA. The file I'm given has 24 fields, but I only need 8 of them, and if I could change their field names that would be nice.
DoCmd.TransferText acImportDelim, , "tblTestCSV2", "S:\WI\ACS\ACS QA\weektest.csv", True, ""
brings in...
I have 24 workbooks, each with a summary row. I need to link each row with a similar row in a workbook that summarizes everything. I can do them manually by going to each cell, hitting =, then clicking on the cell in the other workbook, but selecting each cell individually will take forever. I...
Years ago (mid 1980s) we had an original IBM PC at work, that was so old it had a 5 digit serial number. This was one of the original machines with 2 5 1/2 inch floppy drives! When we replaced it, we cut a hole in the top, sealed the rest of the case except for the holes in the bottom, filled it...
Well since the machine is almost 6 years old, if I'm doing that I may as well replace the PC. And I need to hurry, because I want Win 7, not Win 8. Thanks to everybody who tried to help.
If the square peg won't fit in the round hole, sand off the corners.
I tried to reinstall Vista from the reinstall DVD that came with the system. All it did was show a DOS window of rapidly scrolling items, close the window, and that's it. When safe mode w/ networking comes up, the last file shown is crcdisk.sys. I ran CHKDSK. It found a corrupt attribute record...
I had another idea as well. I understand if the machine will run Vista it should run Win 7 as well. Assuming the drive is ok, would you think upgrading to Win 7 Home Premium would work? In theory it should uninstall Vista and install 7 without losing any programs or files.
If the square peg...
Sorry if I misread the setup info. CNET says it should be a Western Digital, but I'll take the side off the machine and look this time to confirm. But since it worked perfectly when I was offloading a few gig of files onto a thumb drive, when we're talking about it going bad, are we talking...
The HD is a Sony, which isn't listed. However, I transferred a lot of files over to a thumb last night, so it looks like the HD is working. Actually, since running Registry Mechanic, the machine is running faster than normal. Overnight I tried to set it to a prior reset point, and this time I...
I have Vista Home Premium on a 5 year old Dell Dimension E521. Over the weekend I was downloading a program to print business cards. I got an error message saying it couldn't download to Vista, but after I clicked OK it apparently kept trying, and the download shut the machine off. On reboot, it...
I have copied a table from another database into a new db. I've added a field, and want the default data in that field to be "CR". New records will get this default, but is there any way, without writing code, to push the default entry into the existing records? I'm in Access 2003.
If the...
I figured it out. I'm following the guidelines in faq705-2562 "Hide the Access Window" to hide the environment. When I started this project there were no reports, so I ignored Step 5. When I added reports, I forgot the guidelines I'd used to hide the environment. Asking me how I hid it triggered...
The Access environment is not showing; the only thing up is a form. The form has a button that prints a report. What I want to do is add another button to view the report AS PRINTED, so the user doesn't have to print it every time he wants to see it. The owner/user of this portion of the db...
If that's 3 commas, as in DoCmd.OpenReport "rptOpenTickets", acViewPreview , , , acDialog it froze the program.
The only thing showing is a form. On the form is a button, and the above line of code is the only code in the click event for that button. Now if I'm working in the Access...
I have a report that needs to be viewed as well as printed. I have a button that prints it, and a button that views it. The coding on the VIEW button is simply DoCmd.OpenReport "rptOpenTickets", acViewPreview
This doesn't work, however, because the Access framework is not up when the button is...
If you let Access convert the macro to VBA, you get very generic VBA. You may want to clean it up a bit so it's easier to read.
If the square peg won't fit in the round hole, sand off the corners.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.