Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SteveCulshaw

    Access version and Visual SourceSafe (XP / SP2)

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

    Select only negative values

    Thanks, that looks good Cheers, Steve C.
  3. SteveCulshaw

    Select only negative values

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

    Substitution variables from a table

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

    Substitution variables from a table

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

    Accessing an outlook emial folder

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

    RunCommand equivalent for Convert To 97 Format

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

    RunCommand equivalent for Convert To 97 Format

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

    .NET opening MSAccess

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

    .net managed provider for Oracle

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

    PL/SQL default date in procedure

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

    PL/SQL default date in procedure

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

    PL/SQL default date in procedure

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

    Visual Studio corrupt or missing icons in Toolbox

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

    Visual Studio corrupt or missing icons in Toolbox

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

    Methods at run-time

    Thanks for the responses The CallByName sounds like a possibility The problem is, and I'm not 100% on this, but I believe the Uniface form can only call to the top level of the ActiveX, so the guy at work is wondering if by using a wrapper, he can take the "string" instruction from...
  17. SteveCulshaw

    Methods at run-time

    Is there anyway to access the methods and properties of an object at run-time ?? Situation a collegue has is, working from Uniface, he has to access a charting ActiveX component, but Uniface only allows him to get at the top of the components object model :-( The suggestion is he creates a...
  18. SteveCulshaw

    RDC questions

    Which edition of Crystal Reports 9 is the RDC part of? Also, is there an evaluation copy available somewhere on the Crystal site? - I've had a look at the Developer zone, but can't see one Finally, what's the licensing situation on it, especially the distribution of the run-time? Thanks in...
  19. SteveCulshaw

    Books on procedures and functions

    Thanks for the suggestions - I've always found the Oracle doc's very "dry" and not very helpful - just a style I suppose that doesn't suit me Cheers, Steve C.
  20. SteveCulshaw

    Report creation without RDC

    Thanks for the response. I'll see what I can do Cheers, Steve C.

Part and Inventory Search

Back
Top