Search results for query: *

I am trying to printout all the *.pdf files in a directory "G:\Accounts". There are multiple subdirectories and each subdirectory may have multiple subdirectories. I've tried to copy code from VBA Developer's Handbook & from utteraccess without luck. Here is the code from utteraccess Sub...

What is the key field I can use to link AP_13InvHistoryDetial (A/P Invoice History Detail File) & AP_12InvHistoryHeader (A/P Invoice History Header File) ? I see Invoice Number and Header Sequence Number in each table. The problem I have is where two vendors have the same invoice number...

Here is my query: SELECT POP_RecptHistoryHeader.ReceiptType, POP_RecptHistoryHeader.ReceiptDate, POM_RecptHistoryLine.ItemNumber, POM_RecptHistoryLine.Description, POM_RecptHistoryLine.UnitOfMeasure, POM_RecptHistoryLine.ReceiptQty, POM_RecptHistoryLine.ReceiptAmount...

We are running MAS 200. I am trying to create a Received-Not-Invoiced report. If a canned report in MAS 200 exists, I doubt we can use it. Our predecessors were not very savvy in MAS and did more work arounds than anything. However, if you know of one I'll start there. In Crystal Reports...

I am using Crystal reports against MAS 200. I need to extract the last invoice for each item purchased. I am willing to download into excel and sort to determine the latest invoice. The problem I am having is that I don't understand what tables to link the AP_History table to in order to...

Good morning! I am trying to write a crystal report extract against our MAS 90 database. From the G/L I have the following data: Acct Period Date Journal Batch Dr Cr 3010 12 1/31/06 SO-R0966 BTCH:R031_ 1000 I am trying to pull all the invoices that went...

Store Account Amount 500 12000 1000 500 12000 2000 600 12000 2000 I want to loop through an Access table like the one above and when the store number changes the loop stops. Basically I am writing to a file and want a new file to be created when the...

SORRY for placing this request in an SAP forum,but I'm hoping somebody can help. I'm looking for a text book on QAD Mfg/Pro. Any suggestions? Thanks Craig Canter Cost Accountant Sipex Milpitas, CA

When I boot up XP I need to have my different user's show up. For example I need to have CCanter and ADmin pop-up so I can choose Admin. Is there a compbination of keys to make this happen? Craig Canter Cost Accountant Sipex Milpitas, CA

We have a Lotus Approach database on a shared drive. When we try to open it we get the message a "This file was last saved with a previous version of Lotus. Do you want to convert it to Lotus Approach 3.0?" We respond yes. We get a message "Couldn't find the power key for the...

I am trying to create a pivot table using xl 2002. The following code words using the macro recorder: With ActiveSheet.PivotTables("PivotTable2").PivotFields("STD COST") .Orientation = xlDataField .Caption = "Max of STD COST" .Function...

I have just started at a new company that uses SAP. I believe it is Release 4.0 but don't hold me to that. Can anyone recommend a book for end users? Specifically for accounting users? Also, is there a web forum for SAP end users that you could recommend? thank you Craig Canter Controller...

I am using Reflections VBA but I think this is a general question in nature. Here is the code I am having problem's with: If btnQTD Then temp = Round(3.5) <-------- problem is this line here thisweek = CInt(DateDiff(&quot;w&quot;, DateSerial(Year(Now()), 1, 1), Now(), vbSunday) / (1)) + 1...

I am getting an error message &quot;Unable to get Vlookup Property of WorksheetFunction class&quot;. Below is the code I am trying to use. I have just about every reference added that I can think of. Does anyone have an idea of what I am doing wrong? Please help, I'm desperate to turn a 3...

I have a table set up as follows (partial table) LotID Part CycleTime in Hours Process SuperPart A1 12N 100 SP522 06123 A2 12N 110 SP522 06123 A3 12N 112...

I am running the module below from Reflections Basic. I have used similiar modules so I don't think reflections is the problem. The first time I run the module, it works fine. I then close xl and run the module again I get an error message &quot;method of sheets object failed&quot;. If I...

I am trying to open and manipulate an MS Access Database from Reflections VBA. I have included the MS Access 9.0 Object Library in the &quot;Tools References&quot;. The following code compiles but does not open MS Access or the database I need. Sub RunAccess() ' written by C. Canter...

does anyone know how to load *.dif files directly into Access? Currently I load into xl and the save as an xls file. This is timeconsuming and I'd rather load directly. Craig Canter Cost Accountant Sipex Milpitas, CA

I am trying to install Novell Client on my home PC so I can log into work. I have downloaded the file. When I run the setup.exe file I get an error message &quot;SURegCreateKey Failed&quot;. What causes this? How do I correct it? I cannot get Novell to install but I believe the problem is...

I've created a little program that is going onto the CEO's desk. Therefore, I want it to be really really cool. A requirement is to place a shortcut on the desktop opening the program. I have searched the web and found a gif file of the particular piece of equipment this program analyzes. I...