Search results

Hi, Im trying to sum a value within subform\table before I even start I get ####Error as I have put in the control source the rule to create the sum =Sum([TempTable].[hours]) I then have a function when another value is added it requires the text box which holds the sum value. Can anyone...

Sorry, and yes your right. But the bits I "jigged" were relevant to my names etc also strSQL = "DELETE * FROM TSTable WHERE ID In (" & lngID & ")" was missing the str at lngIDstr but that was about all :)

I had to jig the code a little but it now works :)

The value within ID which is in TSTable is returned as I changed the value from 0cm to 2cm to make sure - is this what you mean? And it is set to multiselect. Thanks :)

Wowsers, I didn't expect a response so quickly. The rowsource is set to Me.TSCorrection_listbx.RowSourceType = "table/query" All columns are in the list box but using the widths Ive hidden the ones which aren't necessary Me.TSCorrection_listbx.RowSourceType = "table/query"...

Hi chaps, Upon the results which populate my list box what I am trying to do is allow the user to select various values from the list box and then hit a button which deletes the values from the table. My code is currently: Private Sub Del_TsCorrection_tbox_Click() Dim lngID As Long Dim...

Hi, Im trying to get a value of a custom field within an application. The field within the table is made up or various values linked to different tables. The tables and how they are linked are shown here What I am trying to get is the value in User_Values.Text1 in relation to the employee...

All working, brought it home set it up on my PC and it works... Very strange :confused:

I managed to get the active records to display :) also managed to setup cascading prompts :) but then my luck changed. I was testing out my report making sure it works - and it does to a point. There are 2 tables - Image Link http://img833.imageshack.us/img833/3369/s2xm.jpg If I don't have...

Any reason why the splash screen which launches into Crystal Reports says 2008 and if I go into the help about it says Crystal Reports 2008 Version 12? And as said Im a total newbie to this so please don't think I am insulting you :) Cheers

Ok so Im starting to get a little cocky with this... After messing with the filters etc. I notice if I specify within a filter certain criteria such as if a company is active then when I select a company from the table if it IS ACTIVE it populates the record. If its INACTIVE it returns nothing -...

Hi, Got there in the end I was doing it completely wrong. I wasn't using the filters to produce the results - Ive since changed it and its working. Thanks for you help :)

I cant see any hands with circles on the toolbar - as below The parameter initiates the selection criteria as from it you select the name of the company to which (this is the bit that doesn't work) the address for that company should show up on the report as below (although it shows...

Hi, Ive taken a snap of the field explorer, looking at another example of a report the parameter field has the database behind it but the one Im currently working with doesn't - is this right?

Thanks, I think my links are correct. When you say dropping the fields on the report, are the fields your referring to Formula fields? If so (and this is how Ive done it but its not working) I create the formula fields such as Address2, within the Formula Workshop I drill down on the ODBC...

Hi Kevlray, Apologies Im probably not making sense due to the terminology used. Ive created a parameter which prompts the user to select a company name from one table. From that very same table I would then like to link the company's address which is made up of 5 fields and also link a...

Hi guys, Ok so go steady on me, I've just got myself a copy of Crystal Report 2008 and Im trying to build some reports. Ive managed to create a standard report which pulls the data in from the necessary tables and it works fine. What Im trying to do now is create a linked report, so a user...

ah ha!! Thank you my brain was almost frazzled trying to get to the bottom of it :)

Thanks but that didn't work - its still complaining about invalid use of null.

Hi All, Im trying to tidy up the form access as before I had it look up a name on a form. Now Im controlling it by groups. Ive added a yes/no field to a table and the VBA looks to see if they are set to yes or no. If yes they can access the necessary form if no a message box appears. If...