Recent content by wordsmith

sorry forgot sql...here it is PARAMETERS [Forms]![frmChooseDateShift]![cboShiftDatePicker] DateTime, [Forms]![frmChooseDateShift]![cboShiftPicker] Long; TRANSFORM Sum(Downtimes.HoursLost) AS SumOfHoursLost SELECT Downtimes.LineID, Sum(Downtimes.HoursLost) AS [Total Of HoursLost] FROM...

Hi All, Im trying to create a crosstab query with parameter entry from a form. I wish to be able to specify a date (using Microsoft DTPicker control) and a shift (using a combo box to the relevant table) to make the selections. These two selections on the form are the criteria for the cross...

Hi all, I need to remove the time input from the DTPicker. i am using it as part of a data entry form and added it sometime after i created the form. However, i now find that for any entries which were made using the DTPicker, the queries I run on the entered data does not pick up the entries...

never mind all, i feel really duh right now. so i created the chart and once its on the form, i then right click and wah laaa! there it is, i can select the chart type and its got all this charty goodness available to me. thanks anyway all! regards Keji

Hi all, I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object. I'd do that except I'm trying to create a chart based on a query. Is there a way to make the chart wizard use...

Hi Rich, thanks for responding. sorry still quite novice on this so unsure what you mean by defined the query parameters. does that mean that in the design view of the query, in the query menu, there is a parameter option which brings up a query parameters dialog box. which has Parameter and...

Hi all, stuck on this, not sure if it can be resolved.... I have a parameter query for which the parameter is based on a form field entry (i wanted to avoid the dialog box popping up). No problems with this....however, I want to create a chart based on the same query however, i get the...

Hi John, here it is, cheers for having a look regards K

Ok, that was fine, i think the problem for me lies in the fact that my combo boxes are cascading and are dependent on the selection made in the previous combo box. In the OnUpdate event, i have the Me.cbo.Requery expressions and i think it is doing this even after the selection has been made...

cheers for that! taking a look now

hi, i have a form that uses combo boxes for entry, some of the combo box entries are dependent on preceding combo box selections. i have managed to make the combo boxes present options based on the previous selections, but am finding that after i move on to another record, some of the combo...

thanx soooooooooo much, here is the file. u will see that when u open the downtimes form, there are some records in there, but some of them have empty fields. this shouldn't be the case, they have been filled in, but it always removes the data. i also find that when i then re-enter the data...

yeah all the information has a control source,(should it be the same because they have different control sources) and do you recommend using the "after update" event? i think i had a problem with that before and that's why i used the "on change" event. i found with the "after update" event...

cheers for that! looking through it now. Kind regards, Keji

Hi All, I've got a form with a series of combo boxes which are dependent on each other, however i keep finding that after ive entered some data and left a record, when i then return to the record, some of the information ive entered has been deleted and the combo box is blank. I think it must...