Search results

  1. P

    Is there a way to shut down the computer with VBA?

    logoff and s/down I want same as smercer. My db runs as soon as user logs on. (just standard runcommand in win2k registry), but i need commandbutton (or anything) in my db that will: 1.close db 2.close any other opne apps. 3.log off AND! shutdown machine. any help please ? regards Piet.
  2. P

    get domain name

    hi all, please help with this: my db runs on a WAN. i got this vb from here: http://www.microsoft-accesssolutions.co.uk/get_username_or_computername.htm it gives username and machinename. ok. question: can i also get the the DOMAIN name in the same way as above ? how? any help appreciated...
  3. P

    calculation problem

    yes KH, yes i still have plenty problems to overcome but Brianwarnock have been a great help with suggestions that suites MY! needs. (see /forums/showthread.php?t=75249) Like i've said to Brian as well, I do understand the consequences of not calculating the 'current/available stock' value...
  4. P

    calculation problem

    see this thread... http://www.access-programmers.co.uk/forums/showthread.php?t=69237 hi everyone, can we please start this thread again... - since may'04 (when we started this thread), i have tried many of the suggestions in the replies to this thread, and as i am no expert in access i...
  5. P

    calculation problem

    try and try again... hi everyone, can we please start this thread again... - since may'04 (when we started this thread), i have tried many of the suggestions in the replies to this thread, and as i am no expert in access i repeatedly ended up at the beginning. - if look at the history of...
  6. P

    module error

    thanks wayne thank you, all fixed up now. have a good day. Piet.
  7. P

    module error

    hi, i have 2 seperate db's that has no relation to each other. i have a module in db1 which i want to use in db2. - i have imported the module from DB1 into DB2. - in the access window (modules) the module name displays, and in vba window it displays the module name also. - this is all ok. -...
  8. P

    restore access window

    anyone ?! Hi everyone, (see previous posts re this matter) Is there really no one out there that can resolve this issue ? I will really appreciate any advice. It's very important that I get this sorted out because my from the db the user needs to access a lot of msword templates. Please ...
  9. P

    restore access window

    we never resolved this ! I'm still trying to do this and will really appreciate any advice: - From a pop-up Form, i have a hyperlink to a msword template. - msword opens BUT THEN Minimizes the Access window (not just the form)behind it. - when closing the msword window, access window...
  10. P

    restore access window

    Done that, no joy! (btw: it's a PopUp form, if it makes any difference) As soon as i follow the hyperlink, accesswindow is minimized. When closing the MSword window, i have to restore accesswindow manually from taskbar. Other suggestions please ? Thanks, Piet.
  11. P

    Please support these forums

    thank you !! In a short time I have learned so much from all of you. These forums are Great !! Don't have homepage yet, but will for sure put all your requested links on it. Thanks again for a great service. Like the young people say: You guys Rock ! Regards, Piet
  12. P

    mde not secure!

    secure db Thanks Sean, the solution in the above link is good enough for the pupose and environment where my db will be used. (madmaxx knows his stuff!!) Sorry for not searching threads for it first. Thanks again. Regards Piet
  13. P

    restore access window

    hi all, please help with this: on a form i have a Hyperlink to a MSWord template. so the msword window opens but when the user close the msword window, access is minimized. i want my access Form/Window to stay Restored behind MSWord window. how ? thanks, Piet.
  14. P

    mde not secure!

    advice please! the db will be hosted on a local file server and i don't want to mess with windows users/passwords etc. - the db has Password Protection. - in dbase window I changed all objects to HIDDEN. - in Tools/Startup, I disabled 'Show Database Window'. - in Tools/Options I disabled 'Show...
  15. P

    hide duplicates ?

    (sorry, not sure which post to submit to) - the Table 'Jobcard' has a (text)field named PLACE. - on the Form 'Jobcard', the user enters any! description into the PLACE field. - many 'Jobcards' can have the same PLACE; so the Table records many 'duplicates' of the PLACE Field, as it should...
  16. P

    =SUM sub-reports ?

    sum subreports i've tried that. it still prompts for textbox in mainreport footer. "you can't do a sum on a calculated field..." - only in a report ? - or not at all ? - can i make a query that will calculate the report's calculated field ? - any other method ? any advice PLEASE. thanks, Piet
  17. P

    =SUM sub-reports ?

    Quote: Originally Posted by Rich Use the HasData method, search the archives here for examples Got it. Thank you. But now this: 1. In MainReport's GROUP FOOTER section I have 3 sub-Reports. 2. In MainReport's GROUP FOOTER section I now also have a textbox (name 'text123') with the...
  18. P

    calculate sub-reports ?

    calculate subreports Thank you. Exactly what I wanted. Now I want more ! 1. In MainReport's GROUP FOOTER section I have 3 sub-Reports. 2. In MainReport's GROUP FOOTER section I now also have a textbox (name 'text123') with the =Iif/HasData function which calculates the "totals" of all 3...
  19. P

    calculate sub-reports ?

    Please help, (a2k) Can I do this ?.... 1. I have Main Report (data from a Query) with Group Header/Footer. In the GrpFooter section i have "TOTAL_1" (sumofvalue from detail section) 2. I have 3 sub-reports (data from Tables). Sub-reports are in MainReport's GroupFooter section. Sub-rpt1 have...
  20. P

    calculation problem

    just calculate the stock value yes, and i still don't have an answer. look at my db; say for example i have original stock value in products tbl(example 5000). in record1 i ISSUE 1000. now the stock value(5000) in products table must be 4000, yes? so in record2 the (available?) stock...
Back
Top Bottom