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

THANK YOU! We tested 40 invoices and got it right each time. Craig Canter Controller Elgin IL

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

Breaking down the query into separate tables worked great! Thank you! One further question - where do I find invoiced quantity? I have invoiced amount but not the qty. Craig Canter Controller Elgin IL

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

Hi Big Louie - I'm sorry to ask again, but I'm not getting it. I'm getting two receipts: One appears to be the actual receipt and the other the receipt of the invoice. For example: PO GC18042 will have receipt G020971 and I017014. The kicker is that I017014 will appear for more than one...

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

Sorry, that doesn't work. I need to tie from the invoice back to the item that the invoice is paying. Craig Canter Controller Elgin IL

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

Oops. We are on MAS 200. My apologies I cannot find the SOSourceJournal or SOGLBatchNo. Could they be called something else? Craig Canter Controller Elgin IL

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

Sub CarryOver(frm as form) ' this is written for MS Access ' ' This was written by Allen Browne, abrowne@odyssey.apana.org.au ' http://odyssey.apana.org.au/~abrowne/ser-24.htn ' 'notes: this example limited to text boxes and combo boxes. ' Dim rst as recordset Dim ctl as control Dim i as integer...

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

Do you have any links to closed files? when this happens to me, I am usually linked to a files on my hard disk. If the file is huge like you suggest, you may be going to your hard drive, or worse a server file, several thousand times. If you are aware of any links, open the link-to files...