Recent content by DocZayus

  1. DocZayus

    VBA error 6 overflow

    I'll try and change the value types. Thx!
  2. DocZayus

    VBA error 6 overflow

    I was using this code to see qho is currently logged into my access project, and it worked well untill our servers changed. I get the machine name ok, but not the user names and I get an overflow error. I've read that IIF can be a source of overflow errors, but I have no clue. Function...
  3. DocZayus

    get currentuser but how get password?

    I was wondering the same thing... I need the password, and also the group(s). Access 2000. Thank you. :confused:
  4. DocZayus

    Form with TreeView and subforms

    Hello all. I'm really new at VB. But I'm learning. I'm also learning to work around access too. What I'm trying to do is have a Form with a TreeViewCtl that acts as a menu for other forms. I'd like to have the TreeViewCtl open those forms in a subform so there is always just one form open at...
  5. DocZayus

    Treeview / Listview help plz!

    I'm trying to get a form listed in treeview to open in listview. Can this be done? What I really need is to have forms and treeview be always on the same form. I have too many forms to have them open in different windows. If you know a better option, please share it. PS: I know nothing of VB...
  6. DocZayus

    Inactive accounts?

    Is there a way to see inactive accounts stored in the .mdw? I have many people using my DB, but due to a lot of movement with our employees, it's hard to keep track of who's still here and who isn't. I have noticed that I have quite q few old names, which I deleted, but a "last logon...
  7. DocZayus

    Access to HTML

    Thanks for the reply. I know HTML and php. also some mysql. I was just wondering why so much co0de is needed, when in php all we need is a one liner. I'll have to do with it as is. Thanks again!
  8. DocZayus

    Access to HTML

    What is the code used to connect an html page to an Access DB? I don't have access to php or asp. Anyone have any ideas? I've tried the Access 2000 wizard, but it blurts out a ton of code for a small form. Hardly anything is comprensible.
  9. DocZayus

    Disconnect users

    N/M, I found the answer on other threads from this forum. Sorry for the trouble.
  10. DocZayus

    Disconnect users

    Hi. I have a question, it probably has been answered already, but I haven't found an answer. I need a way to kick out users when I want to mod the Main tables in my database project. I have a module that warns users that they will be booted in 5 minutes, that I didn't install, and it works...
  11. DocZayus

    Using Database on French installation

    I often get the same problems Valérie. I too work n french computers here in Québec. The thing is, some commands were translated to french, but not all. Now() doesn't work in French, and needs to be written as Maintenant(). So your problem is, you need to find all the code that needs to be...
  12. DocZayus

    Field auto-generation.

    field names are [MODIFICATION] (for the name - currentuser() ) [DATE MOD] (for the date - now() ) [MATRICULE] (the modified field) -doc
  13. DocZayus

    Field auto-generation.

    ccess can't find the macro called ME Me.DATE MOD = Now() I've also tried ="DATE MOD = now()" ="[DATE MOD] = now()" =(DATE MOD = now()) =[Me].[DATE MOD]=Maintenant() =[Me.DATE MOD]=Maintenant() and many other light variations with " " and () and [] any ideas? (ps: maintenant() and now() are...
  14. DocZayus

    Field auto-generation.

    Thanks, going to try that out. :)
  15. DocZayus

    Field auto-generation.

    thanks! Me.LastUpdateBy = CurrentUser() Me.LastUpdateDate = Now() Me. <- does that mean the current field? Because I need 2 other fields to be modified when the first is changed. and I don't need time of day, it's just to inform us of who last made changes and when. but I will try the Now()...
Back
Top Bottom