Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Techniproshop

    varbatchfile - not working with Access 2003!

    If I run the batch file manually, it works but when the database call it, I got the "File not found" message. Why is it working in the first case and not the second? So frustrating!
  2. Techniproshop

    varbatchfile - not working with Access 2003!

    Mike, I did the pause and I get the message "file not found" Everything was fine with Win2k but with XP, it's not working. Here is the code: XCOPY "M:\04 - Adjudanterie\01 - Interne partagé\BAB\SGAD\Instal\*" c:\ /h /y /s I want everything in my Instal folder to be copied on the C: Because...
  3. Techniproshop

    varbatchfile - not working with Access 2003!

    Hi all. I was using a batch file to update a new version of my access database and the script I was using under Win2k and Office 2000 was: varBatchFile = Shell("M:\04 - Adjudanterie\01 - Interne partagé\BAB\SGAD\Installation\Install_SGAD.bat", 1) When I was opening my database and a new version...
  4. Techniproshop

    Automatic update database problem.

    Hi all. I was using a batch file to update a new version of my database and the script I was using under Win2k was varBatchFile = Shell("M:\04 - Adjudanterie\01 - Interne partagé\BAB\SGAD\Installation\Install_SGAD.bat", 1) When I was opening my database and a new version was available, the...
  5. Techniproshop

    On click, close database and open another one...

    Ok so I used pwise's code and it works fine. Thank you both for your help.
  6. Techniproshop

    On click, close database and open another one...

    Lena, I used your code but I get that error: "Microsoft Access encountered an invalid path to a data access page. You may need to re-create a page link" "Microsoft Access is unable to open the data access page" Here's my code: stAppName = "msaccess.exe...
  7. Techniproshop

    Secure a DAP with a password

    Yes I want to put a password on the database but I was told that the password has to be set before I create the dap. I forgot the password at the beginning and I want one. If I set it now and open the dap from the webpage, I got an error and no data are displayed after I entered the password.
  8. Techniproshop

    On click, close database and open another one...

    I've been surfing the web for hours and still can't find the answer. All I want to do is, on click or on open a form, close the database I'm in and open another one. Anybody could tell me how? Thanks!
  9. Techniproshop

    Secure a DAP with a password

    The first thing I tried to do is setting a password in my mdb access database. Problem is I should have done this before I created all of my DAPs. With the password, I cannot get the data when I run the DAP, I got an error msg. what's the easiest way to set a password in my database and have...
  10. Techniproshop

    DAP - Input mask in date field?

    It works but the user will get an error message and how can I add a msgbox to tell the user the proper way to input the date?
  11. Techniproshop

    Secure a DAP with a password

    I need to secure a DAP with a password. I thought I had to secure the access database itself but when I open the DAP, the system ask for the password and then I get an error. I would like also to give full access to certain users and restricted access to others. Thanks.
  12. Techniproshop

    DAP - Input mask in date field?

    How can I force users to enter a date the way I want in a DAP? Can I use an input mask? Thanks.
  13. Techniproshop

    Deactivate mouse wheel on DAP

    Good day. I wonder if and how I can deactivate the mouse wheel on my DAP? (on load) I have a .DLL I use in Access "MouseWheelDVPNoReg.dll" and it works fine and I'm looking for something for DAP. Thanks.
  14. Techniproshop

    Warning message when updating info in DAP

    Isn't there other options with 2000?
  15. Techniproshop

    Button in DAP that "showall" data

    I need a button to refresh the page and remove any filters. In Access I use docmd.ShowAllRecords. What's the code in DAP? Thanks.
  16. Techniproshop

    Print a report based on the recordset in DAP

    I'd like to know the code to based my report (DAP) on the selection I made on another DAP. I apply a filter on my main DAP and have a button I click to print another DAP with the data selected(set in continue). I need all the steps because I'm newbie with DAP's. Thanks.
  17. Techniproshop

    Total of lines in DHTML drop-down list (DAP)

    How to specify the total of lines that will show in a DHTML drop-down list in DAP? Right now it's 11 lines (default) Can I change that for 15 by example?
  18. Techniproshop

    Warning message when updating info in DAP

    I don't want to warn the user for each field he will change. I just want to confirm before the record is saved or the user go to another record. So where do I put the code for the entire record, i.e. not just for a control? under MSODSC in the script? There is no beforeupdate options there.
  19. Techniproshop

    Warning message when updating info in DAP

    I'd like to add a warning message to my DAP (SAVE/DISCARD) and ask the user if he wants to save the changes he made or discard. There is already an automatic message, can I custom it? Thanks.

Part and Inventory Search

Back
Top