Search results

Cheers neileg When I get the Error Text28 is displaying nothing - a blank field. The reason I have this twice is that Text28 performs a calculation within the subform - I could not get it to perform the calculation in the main form - see above for the code. Text28 is not visible. I then have a...

I'm now trying the following code and while still not working correctly rather than displaying #Error it just displays Error. It also now does the calculation if their are records existing. =IIf(IsNull([DelegateHistorySubform]!Text28),0,[DelegateHistorySubform]!Text28) Can anyone see what...

Ladies.....

This one works well for me..... >LA&&" "0LL;;_

Copied that into the Control Source but it still displays #Error :(

:o Sorry! Text342 on the main form - =[DelegateHistorySubform]!Text28 This points to a calculation done in the subform and displays the result Text28 in the subform - =DCount("[Status]","qryDelegateCourseHistory","[DelegateID] = " & [DelegateID] & " And [Status] = 'Completed'")

Private Sub Form_Load() If IsNull(Text342) Then Text342.Visible = False End If End Sub Still displays #Error with that code

I have some calculated controls on a form. They display figures based on information on a subform - No. of Courses, No, of Courses completed, No. of courses cancelled etc. This works fine as long as there are one or more courses within the subform. If there are no courses at all within the...

I have a form called Settings which is based on a table also called Settings. Within the form there is a subform of people [Delegates] who are employed at that Setting. The subform is based on a table SettingDelegateLink. On the main form I have various fields relating to certain key positions...

So would it not work if the code was... If IsNull([Forms]![frmAllOfficialActions_PD]![PriorityDocument]) Then [Forms]![frmAllOfficialActions_PD]![PriorityDocument] = Me.PriorityDocument So PriorityDocument is the link and it creates its own PDNumber?

To be honest Wally I'm really a novice myself at Access and I'm still learning so not too good at the old problem solving here. Perhaps someone else knows the problem. The only thing I notice between the two sets of code is that mine passes the same number [DelegateID] between the forms as the...

I have a something very similar within my database. It uses IsNull rather than the count of the ID. Here is the code - try to adapt it for your application and it may work. Private Sub cmdAccessFund_Click() On Error GoTo Err_cmdAccessFund_Click Dim stDocName As String Dim...

Been away for a few days guys so did'nt see the replies previously. I've decided to just use the Parameter prompts when the query executes for this one, guess I'm accepting defeat! Thanks for looking at it though.

Hmm very strange now..... I entered the following code DoCmd.OpenReport "rptSupplyCover", acViewPreview, , "[CommencementDate] Between #01/04/03# And #30/04/03#" And it displayed nothing so I changed the dates to #01/04/2003# And #30/04/2003# Now it filtered out the results after 30/04/03...

Yeah same results..... The report is based on a query, the date part of which comes from a table holding details of courses, including Commencement Date. There are also some other conditions in the query - where the person has completed the course and if they requested supply cover while they...

Cheers for the reply dcx There was a space there and I've removed it but it still will not filter the report correctly.

Just a thought but you might want to just comment the code out rather than delete it .....just in case you delete something in error. I know I'd do something like that :rolleyes:

I've had the same problem creating MDE files myself. I understand one reason for this may be redundant code within the database. For example a control which has been deleted but the event code for it is still sitting in the database. Try going through all your code and deleting any of it which...

Hi Guys, Got a report problem bugging now which I can't sort and hoping someone here could point me in the right direction. I have a report which is based upon a query. When I open the report from the Database window it runs fine - showing all the records held that fulfill the query criteria...

No, my fault dcx. It was doing this in 98 but I must not have checked the field properties properly. I've changed it around now to stop the rounding.