Recent content by mtrant

Thank you both so much, everything is perfect now.

no errors, just the file being created in the main folder.

the file is renaming and the folder is not being created.

well basically I want a new folder to be created upon opening of the database in teh form of the current "Medium Date" but I am also exporting a report as the current medium date which I want to be saved in the new folder everyday. The reason why I need the new folder is becuase some of these...

I tried using your method above a few different ways and have yet to get it to work...any ideas? Maybe I am inserting it into my code wrong.

Hi, I am using a module right now to export a report into a folder right now using the "Medium date format to rename the file. I was wondering if at the same time I could also creae a folder by the days "medium date" for that file to go into. here is the code that I am using right now...

Thank you Worked perfectly, thank you!

Hi, I am trying to call my Autosave module from the Form_Open event. Everytime I open the database I get a compiling error. Private Sub Form_Open(Cancel As Integer) Call Autosave End Sub I have the form selected to "Has Module" and if I run the code from VBA it will prompt the macro box...

Thank you so much I finally figured it out..thanks a ton!!!!!

Is there a way to make my database a front end database? is there a way to make my database a front end database?

What if nothing opens? What if there is just a plank screen and the navigation panel?

Finding the Startup Form Hi, Thanks for the icredible reply I am trying to insert the "call autosave" event and am having a hard time finding where to put it. is there a specific place I should be looking? Thank you in Advance, Matthew Trant

Hi, I have a formula that will export a report and save it to a html file in a folder I ahve selected. Waht I need to do is have it auto save into a new folder named by teh current date everyday upon opening of the access database. Here is the formula I use right now to auto save it to the...

Thank you, huge help!

Hi, I was curious, I have an accesss database that we manage all of our products in. I have recently been sent a sheet that has a lot of discontinued products. I have matched those skus up to the products and was wondering if there was a way to change the value in a column based on if the cell...