Search results

  1. C

    Populating text fields in Reports

    Its working now. The problem may have been associated with an issue I've raised in a separate thread, namely that I've found my database to become unstable when I've tried opening my report using acPreview. Now I've removed acPreview from the the VBA open report command everything seems to be...
  2. C

    Populating text fields in Reports

    Both "Property form" and "Job Form" are open when the report loads.
  3. C

    Database crashes upon report print command

    Bit of an ugly one this! I'm using Access 2007 and am wondering whether this is a bug or something I've done ... anyway I did notice that the preview content did not match the printed content. When Access crashes it prompts me to send a lengthy error report to Microsoft and then offers the...
  4. C

    Populating text fields in Reports

    Hi there! I can't seem to get any text fields to populate either via using some VBA within the Report_Load sub nor via the property control source. Here's some examples of what I 've tried: Within VBA: Me.Text2 = Forms("Job Form").[Text23] and then using the property control source...
  5. C

    VBA changes and saving a form as a report

    Hi there! I'm new to reports and want to create some report versions of the forms I've already created. My forms all have quite a bit of VBA behind them. To create a report, I've copied a form and re-saved it as a report object type. The VBA behind looks exactly like that of the original form...
  6. C

    Null value not recognised in conditional statement

    Thanks Keith, Paul, Linq and Bob - I've gone for the 'If IsNull(Me.Postcode) Then' route and my code works fine now. I understand about how Null works now and have noted Paul Hartman's explanation. Regarding using the Access reserved word Exit as the name of an object: I originally used the...
  7. C

    Null value not recognised in conditional statement

    Private Sub Exit_Click()
  8. C

    Null value not recognised in conditional statement

    Hi there! I've an If ... End If statement that's not working properly. Can someone advise how I should be coding this please? If Me.postcode.value = Null Msgbox "Postcode field must be populated." Endif I'm using Access 2007. The postcode is defined at table level as a text field. I've also...
  9. C

    Next record button runtime error

    I've just been thinking alongn the same lines and added some code to the new record button that first switches the Allow Additions property to true, opens a new record and then switches the Allow Additions property back to false again. Likewise I've done something similar to the form on load...
  10. C

    Next record button runtime error

    There are two occasions when I want to allow users to add new records: firstly on load form if the no records for the filter exist in the first place and secondly if they click on a 'New Record' button that's on my form.
  11. C

    Next record button runtime error

    The data entry property for the form is set to 'Yes' as are Allow Additions, Allow Edits, Allow Deletions.
  12. C

    Next record button runtime error

    I've tried your coding but it doesn't produce the error message. Instead it produces a new record page ...
  13. C

    Next record button runtime error

    Hi there! The first line of this procedure (If Me.LastRcd = True Then) is producing a runtime error 438 - 'Object does not support this property or method'. What code should I be using instead? Private Sub NextRcd_Click() If Me.LastRcd = True Then MsgBox "No further Booking/ Job records...
  14. C

    Full Screen Forms

    Hello again, Well it all seemed too good to be true...! Adding the MAX macro to the form's properties seems to cut off the bottom of the form, ie. the Access bar that offers the user the option to scroll through records, create new record, selected filtered/ unfiltered and search ... Can anyone...
  15. C

    Full Screen Forms

    Thanks, - It works! I've been avoiding macros to date as I've little experience in that area, but that's very straightforward. There is an enhancement I'd like to make to this though - I'd like the window to move up so that the blue Access bar can't been seen and just the form displays. The...
  16. C

    Combo when non-drop down display issue

    Thanks Shane, my combos now reset to blank fine!
  17. C

    Full Screen Forms

    I'm looking to do the same thing, however I'm using Access 2007 and your link only covers up to Access 2003. Is it still applicable or should I look elsewhere? thanks!
  18. C

    Combo when non-drop down display issue

    Interesting about ActiveX route, I wonder whether Microsoft, as part of a future Access release, might get the combo to display more than one column. Anyway, I'm going to stick with the combos for the time being. Would you know how I could reset a combo to just display blank as it does when a...
  19. C

    Combo when non-drop down display issue

    Yes a list box is a solution - the combo just looks better. Thanks for your help all the same. Catherine
  20. C

    Synchronising updates on subform with main form

    Fantastic! My subform and mainform are now synchronised using VBA. I've also used Now() which I wasn't aware of before. Thanks for both that tip and the link.
Back
Top Bottom