Recent content by HowieG

This is difficult to explain, so I'll give an example. I have the following array of file names: Array ( [38] => CP.W.CC.0805 [39] => CP.W.CC.0812 [42] => CP.W.S.0805 [43] => CP.W.S.0812 [66] => IP.W.CC.0805 [67] => IP.W.CC.0812 [70] => IP.W.SP.0805 [71] =>...

Wow, three answers each 1 second apart. Thanks to you all. Taking out the GO's worked perfectly. I'm not sure I understand what you mean. This procedure is to be run from an Access application that allows the user to 'post' an invoice. By design, they can only post one invoice at a time...

I'm trying to do a stored procedure to update data in a couple of tables. I've written the following code: CREATE PROCEDURE procPostInvoice @InvNumber nvarchar(15) AS --SET XACT_ABORT ON --if one fails, they all fail and all data is rolled back --BEGIN TRANSACTION --GO INSERT INTO...

Great! That works. (Except it's querydef, not queries) Thanks!

Can you use a SQL server stored procedure (uses one parameter) as the record source for a MDB (non-ADP) Access Report? Thanks, Rob

Thanks, but that doesn't seem to do it. I tried opening Access first, then opening the mdb file using File/Open and I still get the same effect. Also, the KB article you indicated is for Access 2000. I'm running 2002 (XP) and have the latest service pack. Is this a common problem? Does...

I am using Access 2002 SP-2 (XP) under Windows 98. I'm developing a database that will be shared and I want to enable record-level locking. If one using is editing record X (through a form), another user should have full access to every record in the underlying table except record X. I do not...

I am using Access 2002 SP-2 (XP) under Windows 98. I'm developing a database that will be shared and I want to enable record-level locking. If one using is editing record X (through a form), another user should have full access to every record in the underlying table except record X. I do not...

Simply subtracting the two time values should result in a fractional number that represents the portion of 24hours that is the difference between the two. For example: A1 = 8:00 am A2 = 5:30 pm A3 = A1 - A2 A3 will be 0.395833333 (when you format it to General) To determine the number of...

Have you tried: FAQ181-1309

D'oh! Beaten by seconds...[smile]

I haven't used this, but try: DoCmd.RunCommand acCmdSelectAllRecords

Yes, the column names would be Month01 etc. If you want to do this in the design environment, make the Field say: Month01: iif(Month=1,Amount,0) and similar for the rest. To use if logic in a function like this, you use iif(test,true,false), but within VB code, you use the IF THEN ELSE ENDIF...

I don't know what other fields are in your table, but if you want to subtotal by month on something like a Transaction Type, then modify my earlier query by adding a GROUP BY clause (easiest to do this in the query design environment).

Try: SELECT Amount, Month, iif(Month=1,Amount,0) AS Month01, iif(Month=2,Amount,0) AS Month02, iif(Month=3,Amount,0) AS Month03, iif(Month=4,Amount,0) AS Month04, iif(Month=5,Amount,0) AS Month05, iif(Month=6,Amount,0) AS Month06, iif(Month=7,Amount,0) AS...