Search results

  1. V

    Vertical ScrollBar of subreport (on main form) Not shown

    You can look into the Anchor menu on the ribbon. That allows your subreport to grow/shrink appropriately thereby allowing the vertical scrollbar to remain fixed (depending on which Anchor setting you choose).
  2. V

    Vertical ScrollBar of subreport (on main form) Not shown

    Why are you using a report inside a form anyway? I understand your point. The subreport/subform control is slightly wider than the main form that's why the horizontal scrollbar is showing up. Again, reduce the width of the subform/subreport control and the horizontal scrollbar will disappear.
  3. V

    Reset autonumber after deletion

    Yes, it's an odd mix. Perhaps WillM didn't think it was possible to "auto increment" a different way.
  4. V

    Create a new workgroup information file in Access 2010

    Your connection string is muddled up - it's mixing ODBC SQL Server with Access. Are you trying to open an Access db or a SQL Server db instance? And I see no where in your code where conWork is initialised.
  5. V

    Reset autonumber after deletion

    Hehe! I see.
  6. V

    Reset autonumber after deletion

    Not sure where WillM mentioned it being an import Galaxiom. Perhaps you've got some insight on this matter? :)
  7. V

    Vertical ScrollBar of subreport (on main form) Not shown

    If the main form is 22" then reduce the subform to 21.5" and subsequently reduce your fields to fit as well.
  8. V

    Reset autonumber after deletion

    If you want it to attempt to go to next value, don't use an AutoNumber, just use a Number field and handle the increments with the DMax() + 1 value.
  9. V

    Why there's a Type-Mismatch?

    Ignore my last post. I somehow missed the fact that Shape_Sheet is a field in a recordset. I was thinking that the name "Shape_Sheet" meant that it was perhaps a Chart object. :o Following The_Doc_Man's comments I think that the argument passed to CStr() is ByVal and as a result it gets a copy...
  10. V

    Message error

    Does this mean that you've solved your problem?
  11. V

    Runtime error on changing selection

    Glad to hear you got to the bottom of it!
  12. V

    Report Showing with Chinese Text

    Almost a 2 week vacation, nice! ;)
  13. V

    Abort filter that results in empty recordset

    It's a good approach. It makes sense to apply the filter and do a check. Well done! By the way, I would set the form's Filter property to "" as well.
  14. V

    Check if db is open

    There's an API that stops multiple instances of an application from being instantiated but I can't remember what it's called. However, if we think about this in simple terms, GetObject() will fail if the db is opened so you could give that a try. The other thing to do is to check for a lock...
  15. V

    PTO hours taken and automatically updating a field depending on hire date

    Don't implement anything yet. Let me double check the employees and pto tables and I'll advise. The code posted was just to give you an idea on how it could be implemented. I'll have a look later today.
  16. V

    PTO hours taken and automatically updating a field depending on hire date

    Don't implement anything yet. Let me double check the employees and pto tables and I'll advise. The code posted was just to give you an idea on how it could be implemented.
  17. V

    Open form and find specific data

    Convert the macro to code and we'll advise.
  18. V

    Comparing two tables to see if there is any match

    I am no longer keen to provide further help since you feel it's acceptable to create another thread whilst you're being helped. http://www.access-programmers.co.uk/forums/showthread.php?t=279257
  19. V

    Message error

    How does the user select a patient record?
  20. V

    Vertical ScrollBar of subreport (on main form) Not shown

    Reduce the width of the subform control or reduce the width of the controls on the subform.
Back
Top Bottom