Search results

  1. M

    Delete Directory

    I am trying to delete a directory using a form. I currently use the following code.Kill Dir1 RmDir Dir2lets just say I have a series of directories in X:\data\ "dir1", "dir2", "etc." I think I've just discovered that if I create extra folders within my created directories for example...
  2. M

    Rename and move file to an existing folder

    SCORE!!! THIS IS AWESOME!!! OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE" Name OldName As NewName ' Move and rename file. Works great and takes care of both of the issues I faced with renaming and moving the file!!! SWEET! Thanks!
  3. M

    Exporting Records To An Archive Database

    Wow. This was so easy to do it makes me sick that I had to ask for help :(... An append and delete query did everything I needed to do... I just add a message box asking the user if they are sure then set "docmd.setwarnings false" and then open the append then the delete query, Done... Very...
  4. M

    Exporting Records To An Archive Database

    I have been trying to figure out how to do this and the transferdatabase function wouldn't do what I needed. I have a table that has a bunch of records, each being a request for cad work somebody wants me to do. I change the status of each one to pending, working, or complete. Anyway I want...
  5. M

    Hiding and Resizing Columns

    What I have: I have a main form with 3 subforms viewed as datasheets. I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to...
  6. M

    Having a Calendar show today's date

    Calender fix worked great Thanks that works great!!!
  7. M

    Adding a recored using VB CODE ONLY?

    I have a form that changes a part number. When a user changes the part number and clicks on save a yesno dialog pops up tells them what has been changed and askes the user if they want to document what the prior part number was. I have a table that contains 3 feilds, the key, partnumber, and...
  8. M

    Outlook queries automatic email

    Can you supress the messege in the code? I am having the same problem. I want to send some data to users specified when a button is clicked. This works great except for that message that pops up saying are you sure you want to send email blah, blah, blah. This is not making the mailing...
View older results
Back
Top Bottom