Recent content by pauljkeenan

sorry, im a novice and have only recently realised that coding the sum inside the details section is quite different from using a control source, thanks for the advice all the same. i cant use the control source method as there are some calculations for each page. for example certain fees are...

Hi Lads, Hope all's going well today. Ive had this real annoying problem for the last while and have been avoiding it. I have a database which can prepare a six monthly report for our consulate here. It works quite well and basically lists all applicants, fees payed and exchange rate. The list...

problem solved, as always a syntax error that somehow I missed from the examples theRate = DLookup("[Rat]", "tblRates", "Month([Dat]) = " & Month(Me.App_Date)) take it easy paul

Hi everyone, Ive just used dLookUp() for the first time today, and thought I had got the hang of it but evidently there is something wrong. Here's whats happening, if you can help at all please let me know I have a report, which will display record information including name, fee and...

Yes, the problem was the field name was month, stupid mistake I keep on making. thanks phv

that should work fine but Im getting weird results for the month function in certain forms. I get a type mismatch for the following code Private Sub Form_Open(Cancel As Integer) If Month(date) = 8 Then MsgBox "indeed" End If End Sub But if I use it in a different form it...

thanks a million lads, you've been great out there. sorry about the remedial questions, im learning by making mistakes

Yes Michael, thats how I was setting out doing it originally but if we wanted to "tweek" the ol' rates to ensure the total added up it would be necessary to change 100s of Xrate records just to get out a figure near to what our exchanged total is expected to be. The rate doesnt change that much...

thanks for the tip R, ill have a look at it.

its wonderfully easy, thanks for the help Majp. I assume 'date' represents the textbox containing the date?

Hi people I have an add record form where the user adds the date that an application was filled out. I need to know how I can check on start up whether the date entered is the 1st of the month. I know there is a month function but how do I check if its the 1st? thanks for any help I love you

Hey lads I have a nice report for our bi-annual consulate report which shows how much each applicant paid and in what currency. There is also a field for each record for the converted fee. However I want to prompt the user to input an exchange rate for each page or even for each group of 30...

Hi John Thanks for the reply, I just tried as you advise but it still gives me a syntax error again, saying there is an extra comma or bracket. I also changed the name of currency field to curr but it didnt solve the problem. To find out what the problem could be i copied an expression example...

Hi Guys Could anyone help me with the syntax for this expression Im using on a report. The textbox field is supposed to display yes or no depending on the text in another field. So on my report I have the fields listed like name, job, fee, currency simply listed from a table. The last textbox...

Hi PH Thanks for the help, it put me on the right track actually and its working fine now. Forms!frmMain!frmMainSub!frmDetails.Form.RecordSource = strSql & " " & strWhere I had been using the subform name, not the control name. an amateur mistake indeed. thanks again, much appreciated