Search results for query: *

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

Hi People Im having this continuous problem with subform referencing. Let me describe the form fist of all. I have a main form, which is used as a navigaiton window to switch between various forms by just clicking one of the command buttons across the top. (frmMain) So the user selects...

Yes I just realised what my mistake was, its working fine now. Thanks for the advice dhookom, appreciate the help

Hi there, Yes its still not worling, Ive been messing round with it again and this is what ive come up with Private Sub cmdOpenRpt_Click() On Error GoTo Err_Handler Dim stDocName As String Dim SQL_Select As String Dim strOrder1 As String Dim strWhere1 As String Dim strSQL1...

Hi Everyone, I am trying to create a report from the search results displayed in a subform. I have tried to use the openArgs function but it just displayed all records, not the searched ones. So now Im trying a different approach but am having the same amount of success, none. Here is the...

I just noticed a mistake there actually. It should be... DoCmd.OpenReport stDocName, acPreview, , , , , OpenArgs:=SQL_Select and not DoCmd.OpenForm, Anyway at the moment it creates a report but includes all the records, not the ones between the dates chosen by the user. well its a step in...