Search results

Hi Can someone please help me? I am not a VB programmer - i just know the very basics. I am using Stephen Lebans PDF code to create a report which converts into PDF format. Currently the user clicks on a button to preview the report - i have added the following line (in blue) underneath the...

Hi Can someone please help me? I am not a VB programmer - i just know the very basics. I am using Stephen Lebans PDF code to create a report which converts into PDF format. Currently the user clicks on a button to preview the report - i have added the following line (in blue) underneath...

Thanks Brian I knew it was something simple!! :o Works great. Thanks again :)

Hi Can someone help me with this please. I have 3 fields in a table - Pupil ID, Date and Price. I have criteria on the date field - between x and x date. What I would like is the sum of the price broken down by Pupil ID between the inputted dates. I have set the Grouping property of...

Hi Thanks for your reply. The reason I need to do this is because some of the fields are calculated at different rates for different times of the year. Also a couple of the users will still need access to the tables as they will develop on it from time to time. All I need is the...

Hi I have a form where users fill in some date fields and some cost fields. I have added some calculations which makes life easier for them: EG. Cost plus VAT. I would like to save these calculated fields back to the tables. I am aware that this is not great database design but it is...

boblarson - thanks for the tip - and it wasnt intentional - just a mistake. ANYWAY following on from the initial question: when using calculating fields on a form - is there a way to write this info back to the tables? I know this isnt strictly good database design but it is something...

It wasn't intentional

Re: IIF in Form Help! Excellent - that works great! I also got the old IIF statement to work by changing it to: =IIf([Forms]![frmInvoices]![VATRegistered]=-1,[TotalCost]*0.175,[TotalCost]) Thanks for your help!!

That worked a treat! Many Thanks for your help!!!! :):)

Hi Please can someone help me with an IIF problem. I have 2 fields on a form: VATRegistered (Yes/No) TotalCost (Currency) If the VATRegistered Field is Yes then I want TotalCost *0.175 if not - then just total cost. Here is the IIF Statement...

Thanks! Thanks for your help - I will give it a go! Thanks again :)

Hi Hi Thanks for the reply. I tried that but I get the following error message.... Can't create this relationship and enforce referential integrity..... Not sure why it says this, both data types are same (Autonumber/Number). Please can you advise what I need to do? Many Thanks Daz

Hi I have a form called frmPupil where users create a pupil onto the database (into tblPupil). The users can then go off and use this pupil to enter data in more forms which store in different tables using the PupilID. I would like a button on frmPupil which will delete the pupil and any...

Thanks! Thanks Rich I opened up a module - went to Tools - References and unticked a MISSING reference. All sorted now. Many Thanks! :cool:

Hi I have a form called frmPupilSelection. I have a field in there called 'Year Group' which works out what School/Academic year the pupil is in based on their Date Of Birth. Below is the IIF Statement...

No problem No problem. I greatly appreciate your expertise. Thanks again. :)

Reply I appreciate your help, but maybe you needed to make it more obvious that you were referring to yourself rather than me. If you re-read your comments, you will see that the way it was written implies you were referring to me. Thanks for your help anyway.

Solution Hi I added the following to my code Function AddWkDays(varDate As Variant, numdays As Integer, _ Optional pexclude As String = "17") As Date Dim thedate As Date, n As Integer, incl As Boolean If IsNull(varDate) Then Exit Function End If thedate = DateValue(varDate) incl = False...

Sorted I have got this working now. Thanks for your help.