Recent content by SteveCulshaw

Can anyone shed any light on this problem I've just tried to rebuild a MDB from my Visual SourceSafe, but I get the following error :- Error encountered at line 1. This object was created with a newer version of Microsoft Access than you are currently running. The change which I assume has...

Thanks, that looks good Cheers, Steve C.

Is there any "elegant" way to select only the negative values from a number of fields ? i.e. I have a table in which the users are entering values for the number of properties gained and lost, and I need to report on the total number of properties gained and lost, so I somehow need to...

In plain SQL it doesn't work, the only way I've found is to use PL/SQL DECLARE report_user VARCHAR2(200); BEGIN SELECT USER INTO report_user FROM dual; DBMS_OUTPUT.put_line(' User is : ' || report_user); END; / Cheers, Steve C.

Is there anyway to get a value from a select into a variable ? e.g. define report_user select user from dual so I can do some work later in the SQL script Cheers, Steve C.

Not done it myself, but I'd suggest looking through the MSDN HOW TO's, as they usually give some good indicators e.g. http://support.microsoft.com/default.aspx?scid=KB;en-us;q220595 Cheers, Steve C.

Thanks for the response Not sure if the acCmdConvertDatabase is the right one, but I can't get it to run from VBA code, get a 2046 error Access 2002 can certainly save back to older formats, under the Tools / Database Utilities / Convert Database, there is a submenu To 97 Format / To 2000...

Hi Can anyone tell me what the Access 2002 RunCommand is for the "Convert Database To 97 Format" and "Convert Database To 2000 Format" Cheers, Steve C.

On your question about querydefs (which is really DAO), I don't think ADO.NET handles them, i.e. this isn't an ADO.NET equivalent to ADOX, the extension to ADO that handles this sort of thing Cheers, Steve C.

I was at a MSDN day and talked to one of the Microsoft people about the Microsoft .NET Managed Provider for Oracle - he reckoned that the version in the next release of the Framework would have a lot of the features Cheers, Steve C.

Thanks for the response Naith Oh durr, showing my Access roots here aren't I :-) Still no luck - does the default appear in the package and/or package body definition ? - I only have it in the body PROCEDURE GetValidBCApp( o_CaseNo OUT tblCASENO, o_RefVal OUT tblREFVAL, o_Address...

Thanks for the response, but that doesn't seem to work :-( CREATE OR REPLACE PACKAGE BC_Pkg AS TYPE tblCASENO IS TABLE OF VARCHAR2(13) INDEX BY BINARY_INTEGER; TYPE tblREFVAL IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER; TYPE tblADDRESS IS TABLE OF VARCHAR2(240) INDEX BY...

I'm trying to get to grips with using stored procedures, and already I'm baffled :-( I thought it'd be sensible to set a default date .... PROCEDURE GetValidBCApp( o_CaseNo OUT tblCASENO, o_RefVal OUT tblREFVAL, o_Address OUT tblADDRESS, i_From IN tblDECIDD DEFAULT...

Well I've got a bit further. Selected the Customise option for the Toolbox and clicked the Reset button. This has restored all of the icons on each option (Windows Forms, Data, etc.), EXCEPT, for the Pointer Anyone got any ideas on how to get this back ? Cheers, Steve C.

Something weird has happened to my install of VS.NET - all of the icons for the Toolbox have changed to a crossed rectangle, except for the CrystalReportViewer one. Now I've recently had a problem with ASP not working, and the workaround seemed to be a small patch from the Crystal site which...