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

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

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

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

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

i have a new notebook with a partitioned drive. I have lots of access databases. One of my databases reports that it is read-only when I open it from drive D: (Local drive). I can copy it to drive C: (Local drive) and it opens fine. I can even put it on a thumb drive and it works. I can...

I'm learning, but not very good yet. I can't find this in the forum. I have a simple button that calls a form. I want to sort the records different ways with different buttons. The one I have done does this: Private Sub fOpenByAmt_Click() DoCmd.OpenForm "fExceptionsProcess", , ...

I have a form with a subform. I am using SQL to populate the table which is the source of data for the subform. When I open the main form, I want the subform to update its calculations (I'm calculating a lot of numbers and displaying them for the user). Presently, I need to at least "touch"...

How many fields can there be in one Access table? I don't usually include 100 fields in one table, but I inherited one and it needs to be expanded. My client wants me to add more fields and include them in a critical form they use for data entry. What they have works quite well, but there...

Accounting user. Novice+ vb programming skills. Using Access 2003 for lots of accounting tasks and records. I need a utility routine to help with a common reconciliation problem. I have a known difference in a table of thousands of entries (as many as 200,000). I have a difference, say...

I have an extensive list of custom macros and icons I have developed for the kind of accounting work I do with XL. Other users want to have them also, but it's a chore to set them up. I know how to share my Personal macro workbook, but how do I copy my icon setup to other users? Some of my...

I wrote a spreadsheet app a couple years ago that has been used successfully since. I was making a change and now I'm getting an error I can't figure out. There are several sheets. Each has a different database query (using ODBC to a VFoxpro database) plus pivot tables to summarize data for...

I have date values in two fields in an Excel spreadsheet. I want to use those dates as criteria in querying data from an Access database. How do I pickup those dates and use them as begin and end date in my query? Dwayne Streeter, CPA, CITP http://www.cpe-interactive.com

Novice programmer; having problem with simple code routine. I have an input form written and it works. I have subs written to do perform appropriate print routines. I can't get call to work. Error says "Expected sub, function, or property" I must have made a rookie coding error. Can...

I have a table with a list field. The values are-- 1;Sales 2;purchases 3; etc ... When I list it in a query, I get "Sales", "purchases", etc.. as I expect. When I put the field on a report (using the query as the source), I get 1 2 3 etc... How to get Sales, etc on the report? Dwayne...

Probably a simple question. How do I make a report wider than 22"? Is that really a limitation of Access? It won't accept a page setting wider than 22" and I can't find away to change it. I know how to break the report using vb and just run two or more reports in one routine that calls...