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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: DwayneS
  • Order by date
  1. DwayneS

    6.5" checks on panasonic 2023 printer

    I have been trying to get 6.5" checks printed from Peachtree 2010 using a panasonic dot matrix. The setup worked in 2007 for years. The routine is simple enough; I already have the check designed, but now it always prints on 11" length. In the old system I had a 6.5" form to choose on the...
  2. DwayneS

    How to disable AV

    What I saw was a notice when I tried to Install Peachtree server edition on the server. I got a message that Windows defender was detected and it should be disabled to avoid a conflict. I'm sure you're right. I think I need to install AV on the server. Dwayne Streeter, CPA, CITP
  3. DwayneS

    How to disable AV

    Sorry for the stupid question. SBS has Windows Defender included. I can't find it on the menus, icons, mgmt console, nothing. I need to turn it off and install something. Help? -- Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  4. DwayneS

    Linking Access 2007 to Excel 2003?

    The problem is compatibility. But the connection to 2007 has been solved. MS updated the MS Query drivers for Access 2007. If you get the newest drivers, then you will have an updated driver for Access databases. I now have the new drivers and I have established a new connection to each of my...
  5. DwayneS

    Linking Access 2007 to Excel 2003?

    I have a new client who is using Access 2007 and Excel 2003. They have never linked access tables and queries to Excel but they need to know how. Question is, can I link an Access 2007 table to an Excel 2003 sheet or external query with MSQuery? I do not mean export -- I want to LINK...
  6. DwayneS

    Shell in Access 2007 Vs 2003

    I might have figured this out. The computer came from my IT dept. They installed Office 2003 without Access, then installed Access 2007. Funny configuration, and I'll be a dollar it has to do with the resulting path. When I got them to install Access 2003 along with 2007 (Yes, they will...
  7. DwayneS

    Shell in Access 2007 Vs 2003

    That's true. My question is this: Why do I need to change all my 2003 vb code in order for it to work in 2007. In the 2003 version I did not use the full path and it worked. I have examined the environmental path and Office is not included, yet the first version of the code worked just fine...
  8. DwayneS

    Shell in Access 2007 Vs 2003

    I just got a new computer. It has Access 2007. I had 2003 and a lot of apps developed in that version. I use lot of Excel spreadsheets to calculate schedules from my Access tables and queries. Below is a line of code I use to open a typical Excel SS: Call Shell("excel.exe...
  9. DwayneS

    How do you get an autonum field to start at 1

    Delete all records, then compact and repair. It will start at 1 Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  10. DwayneS

    Access auto saves when closing, doesn't give me choice

    Check for auto-open forms with vb code in the On Open property. I've seen cases where someone for some reason puts docmd.setwarnings false in a place like that. If that is done, your warnings could be all gone. Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  11. DwayneS

    Simple coding error (Still learning vb)

    Tks. I was thinking about a references problem. I'll look into it. Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  12. DwayneS

    Simple coding error (Still learning vb)

    I have code I'm borrowing from others on this forum and am trying to use it to read a very large and messy spool file a line at a time so I can parse out information I need for accounting. My code errors out in the Dim statements. Here's the code I'm trying to construct: Private Sub...
  13. DwayneS

    How to test whether a table exists

    I found it. Thanks. I'm learning. Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  14. DwayneS

    How to test whether a table exists

    I have to import dozens of spool files, some of which are pretty messy. All of them result in import errors and I was using a simple line of code to delete all the error tables. Suddenly one out of a hundred files does NOT generate an error table and the code crashed. I tried to add a...
  15. DwayneS

    Deleting file if it exists

    Thanks, guys. I appreciate it. I struggle with vb, but not that much with your help. I'm learning a lot for a bean counter. Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com
  16. DwayneS

    Deleting file if it exists

    Simple coding error. I'm processing a long list of files sent to a directory as work is completed. I simply need to delete a file if it already exists. Here's the code and it doesn't run. The filename calculation is working. I need coding correction. Can someone who understands vb tell me...
  17. DwayneS

    finding and saving sequences

    I really appreciate Gol4's post. It was all exactly the help I needed. For someone who just typed this code without actually running it, it was nearly flawless. I'll continue to take time to answer some of the questions on this board which aren't so complicated so you guys with such quality...
  18. DwayneS

    finding and saving sequences

    Not sure I understand this. I don't know the check ranges except by analyzing the check numbers in my table. How do I set up the TblRanges table. I think I'm not good enough with vb to structure that code you are giving me. I appreciate the help, and I'll bet you can get this done for me...
  19. DwayneS

    finding and saving sequences

    I have a table with check numbers from 15,000 to 150,000. I need to summarize them into consecutive sequences so they can be entered as consecutive blocks (for example: Cks 15,000 - 17,807 = $1,111,111 ; 17,811 - 17,903 = $307,605, etc. PS: Checks 17,807 - 17,811 were not issued). If I use a...
  20. DwayneS

    Front end with variable back end data sources?

    I have one good front end that does everything I need. I have 30 + clients, each of whom has its own set of data which I can link to. All data sets are identical. I want to store each client's data set in a different directory and open the database with a menu or form to choose which data to...

Part and Inventory Search

Back
Top