Search results for query: *

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

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

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.

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.

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

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

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

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

Can anyone recommend a good BEGINNERS book on writing Oracle functions and procedures ? Cheers, Steve C.

Is it possible to create and/or amend a report without using the RDC - issue is (I believe) the RDC is an extra licensing cost - I want to provide "quality reports" for our users, but there are a fair number of them, and at $199 a licence, there's is no way I can persuade the...

Is it possible to edit Oracle stored procedures in the same way as SQL Server ones? Cheers, Steve C.

Is there someway to emulate the way Access handles fields with the "Can Grow" property set to Yes? i.e. in an Access report, if I have two fields, one below the other, and the first field grows, the second one is moved down. But in my Crystal report, the first field overwrites the...

Can anyone explain how I convert the UNIX end of line character? - I think it's chr(10) I need to change it to a <space> I've tried formula = Replace ({BCCASE.ADDRESS}, chr(10), &quot; &quot; ) Cheers, Steve C.

Is there anyway to store Crystal Reports in Visual Source Safe? Alternatively is there a SCM that Crystal works with ?

Is there some tool available to convert MS Access reports? - I've seen the ComponentOne report component can convert Crystal and Access reports, so wondered if there was one for Access -> Crystal ??

Can anyone help on this SQL, as I'm just going round in circles? I've got a table CNCODE with fields CODEVALUE and LISTNAME, and I need to get just the first codevalue for each of the different listvalues So the table has CODEVA LISTNAME ------ -------------------- COM 16BH OFF 16BH RES 16BH...

How do you know what Foreign key is which in a ER diagram? - I've used the Database Model Diagram to create an ER diagram of a database, and some tables have more than one foreign key. OK, the diagram has these marked as FK1, FK2, etc. and if I select each relationship I can see in Database...

I've put together a wizard for form generation, but I want to fill a list box with a list of table in the 'user' database, i.e. the database where I'll be using the wizard, rather than the actual wizard database. I've used CurrentDb and CodeDb to get at most of the things I need in the...

Is it possible to use class methods in queries and reports?? e.g. I have an address field which needs some processing before use as it comes from a Unix based Oracle database. I have a function Reformat to do this, but I've got bitten by idea of classes, so I tried a 'TextConversion' class...