Recent content by adamtate94

  1. A

    2003-2010 Migration Problem #NAME

    Hi Guys I have developed quite a large database within Access 2003, with alot of VBA. Having finally decided to move to Access 2010, I have opened the 2003 version on 2010, everything seems fine apart from some subforms having '#NAME' in the fields, but in the 2003 version they are fine. Any...
  2. A

    Multiple Report Problem

    I have the Link Child Fields and Link Master Fields as the same value, is this correct? Or is it one or the other
  3. A

    Multiple Report Problem

    Hi Guys I've got a really long report that I need to print out, I've used the method of adding multiple reports onto a single report to that when it opens/print it does this for multiple pages, there first few were fine, now that I have around 9 subreports on the form, the subreports aren't...
  4. A

    Uploading images to a certain file?

    Hi Guys, I am wondering if it is possible to have a button on a form which asks you to select an image from a location, it then takes that image and moves it to a location of my choice? Also, would be nice to have a preview of the image on the form, maybe asking a little too much! Any ideas...
  5. A

    How to check if a subform is empty?

    The expression you entered refers to an object that is closed or doesn't exist. On the line with the Me.subfrmHazardRAMS.Form.count on. Thanks
  6. A

    How to check if a subform is empty?

    The subreport is part of the form i am adding the code to, still getting an error. Please see attached
  7. A

    How to check if a subform is empty?

    The Recordset code has also given me an error on this line : (Attached)
  8. A

    How to check if a subform is empty?

    The If line with the code you gave me have the error
  9. A

    How to check if a subform is empty?

    still the same error :(
  10. A

    How to check if a subform is empty?

    Thanks for the reply, getting this error.. Image Attached
  11. A

    How to check if a subform is empty?

    Hi guys, been playing around with VBA on how to check if a subform has records displaying in it or now, i've tried things like if Me!subfrmHazardRAMS.Form!RecordSource = "" Then. Just getting error.. Thanks in advance
  12. A

    Text Box Issue

    Thanks for the reply They are unbound, im running an SQL INSERT using their values. Do they need to be bound?
  13. A

    Text Box Issue

    Hi, I have got a subform which has done data pulled in from a table, and the rest has text boxes for input. Whenever I put a value in one text box it changes the value for all of the other records. Show Below (attached), any ideas why? Thanks In Advance
  14. A

    If listbox empty then button not visible/disabled

    Perfect, thankyou :)
  15. A

    If listbox empty then button not visible/disabled

    I have a button that when clicked populates with listbox with everything that it ticked
See more
Back
Top Bottom