Search results for query: *

I have an unbound form in an Access project that sets it's RecordSource to an ADO recordset in the OnLoad event. On the form's Dirty event, I start a new transaction on the connection object (if one hasn't already been started). When the user exits the form, I can prompt them to save or...

Thank you for looking into my question/problem! Here is my senario: I have the full SQL 200 on my desktop. Server name is BLK00FINA00129. From my ADP named Cumes.adp I am connected to SQL database named Cume2SQL. the following is what I am trying to do which is run a stored procedure from a form...

I am simply trying to append all records from table ORDERS to table ORDERS CUME and this is as simple as it gets but it does not work, I am greatful for any light! Regards Julio ALTER PROCEDURE StoredProcedure1 /* (INSERT INTO dbo.Orders Cume OrderNo AS Expr5, Sponsor AS Expr6, SponNo AS...

IIf([Units Cume].Flight = "FLT2",.001 * SUM([Units Cume].TotAlloc), 0) with an alias as GrossFlt2 The function is to identify the record by its FLT number, in this case FLT2 and then perform a calculation if FLT2 does not match then value is 0 (zero) I am linked via an Ms Access ADP to an MSDE...

Has anyone experience the change in orientation of reports(on their own or maybe influenced by an outside app) Puzzle?????