Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pauljkeenan

    How can print preview differ from the actual print out?

    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...
  2. pauljkeenan

    How can print preview differ from the actual print out?

    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...
  3. pauljkeenan

    dLookUp error? (report->detail->on print event)

    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
  4. pauljkeenan

    dLookUp error? (report->detail->on print event)

    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...
  5. pauljkeenan

    how to check if today is the 1st of the month

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

    how to check if today is the 1st of the month

    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...
  7. pauljkeenan

    how to check if today is the 1st of the month

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

    prompt user for input for each page?

    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...
  9. pauljkeenan

    prompt user for input for each page?

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

    how to check if today is the 1st of the month

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

    how to check if today is the 1st of the month

    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
  12. pauljkeenan

    prompt user for input for each page?

    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...
  13. pauljkeenan

    report expression(as copied from microsoft help example) syntax error

    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...
  14. pauljkeenan

    report expression(as copied from microsoft help example) syntax error

    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...
  15. pauljkeenan

    Subform referencing - causing problems(beginner)

    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
  16. pauljkeenan

    Subform referencing - causing problems(beginner)

    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...
  17. pauljkeenan

    Error when trying to create report

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

    Create Report from results in Subform

    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...
  19. pauljkeenan

    Error when trying to create report

    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...
  20. pauljkeenan

    Create report based on data returned in a subform??

    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...

Part and Inventory Search

Back
Top