Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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