Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. merlynsdad

    Importing CSV into Access 2003

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

    Importing CSV into Access 2003

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

    Importing CSV into Access 2003

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

    Importing CSV into Access 2003

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

    Linking cells in different workbooks

    I just did a copy/past special paste link and it works fine. Thanks. If the square peg won't fit in the round hole, sand off the corners.
  6. merlynsdad

    Linking cells in different workbooks

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

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

    OK, I ran the Quick Test and the drive is fine. Now what would you recommend? If the square peg won't fit in the round hole, sand off the corners.
  11. merlynsdad

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

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

    Vista OK in Safe Mode but won't start normally

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

    How to fill a copied table with default data

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

    View an Access Report using a button

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

    View an Access Report using a button

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

    View an Access Report using a button

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

    View an Access Report using a button

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

    create a button to run a query and I get a macro

    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.

Part and Inventory Search

Back
Top