Search results

  1. J

    Access 2003 Security Warnings

    Or if its only going to be used on your PC you could create a digital signature for the application this would enable you to leave the macro security settings as is. You can also "force" other machines to add the digital signature to their trusted list even though it will not be a "signed...
  2. J

    Question access 2007 does not close

    Have you tried repairing the installation this can sometimes clear up "odd" behaviour. Good luck John :)
  3. J

    Form (List Boxes) Updating (n00b)

    Have you tried zipping the database first to reduce its size when posting?
  4. J

    Form (List Boxes) Updating (n00b)

    Try Me.Requery instead of refresh however seeing the actual DB might allow for a better solution regards John :)
  5. J

    Create New Record

    Because your structure is wrong if you link the tables in that way a memo must be created for each record instead of creating a memo when required thats why I asked if the memo was contained a subform... The way you have your structure REQUIRES a memo to be generated... Give the memo table a...
  6. J

    ACCESS 2000 Validation Script

    Seems like someone doing something http://www.access-programmers.co.uk/forums/showthread.php?t=171389&highlight=doctor like this.. try searching the forum might throw up more :)
  7. J

    Create New Record

    You need to do this through a query using the 2 tables then use that query for the record source of your form. Also is your memo field contained in a subform? Can't really greasp what you have done is there any possibility of attaching an example of the database (make a copy and delete the data...
  8. J

    Import Error spec wrong datatype

    Won't work what do you want to do with the seperated values anyway? append them to your table (which is possible after removing the ; seperator) were is this data coming from why is it being imported? More information will let us help you..
  9. J

    Ever used Hamachi?

    Have you actually looked at the specs for it.. the wan is no more likely to drop out if connected to terminal services or any other solution (used VNC not bad but not great either) It IS a secure connection then packet loss is not restricted to what method you are using just a fact of not being...
  10. J

    Use Duplicate List Box on Multiple Tabs in a Form

    You could probably do it in the afterupdate event but why would you want to..
  11. J

    Access 2003 - Pop Up Calendar - same date for each record

    Your welcome it was ^^^ John who asked the right question thanks for letting us know its resolved :)
  12. J

    Mobile Workers

    I've just started playing around with VPN connections again after having some troubles before might be a solution/option for those on lower budgets and not wanting to go to the expense of Terminal services have a look at my post here...
  13. J

    Access 2003 - Pop Up Calendar - same date for each record

    Needs to be bound to a field so the date can be "stored" for each record created, if I'm following what John Big Booty is getting at correctly..
  14. J

    Disable Access close button

    Somewhere might take me a while to find it though... usually only works when called so if not needed just ' out and restart the db window should be back :)
  15. J

    Ever used Hamachi?

    Ever used Hamachi? or Software VPN Hi all, Just wondered if anyone had used it to set up VPN connections had tried it a while back before LogMeIn bought/took over but thought I'd give it another try. Still a free version for personal use although the commercial version is only $39 been...
  16. J

    Disable Access close button

    Copy the following into a new module: Option Compare Database Option Explicit Private Const GWL_EXSTYLE = (-20) Private Const GWL_STYLE = (-16) Private Const WS_MAXIMIZEBOX = &H10000 Private Const WS_MINIMIZEBOX = &H20000 Private Const WS_SYSMENU = &H80000 Private Const HWND_TOP = 0 Private...
  17. J

    Disable Access close button

    Spam links reported^^^^ idoit....
  18. J

    Microsoft's Issue Tracking Database Template

    Sorry someone else will have to help 2007 format and I have removed this from my machine at the moment causing to much hassle with 2003 installation until I set another virtual installation up.....
  19. J

    Add a record in subform w/o typing on parent form

    So you have a form with customer details and you want to say click a button that opens your purchase order and passes the cutome details to it and autofills the fields yes? I would use an openargs procedure to do this something like this in the on click event of your first form...
  20. J

    Add a record in subform w/o typing on parent form

    Depends on the form/subform relationship and if its genertating a new record or searching for and exsiting one....
Back
Top Bottom