Recent content by MoxieCraz

Thanks Bob! I was thinking that too as I was sitting here, but was hoping there was something different. I will give this a whirl! Thanks so much! I love this site!!!!

yes, but what if I want all of the last day of the months from a table that contains multiple months by day records?

the next peice I need assistance on.... I have daily data in a table. I want my query to only give me the last day of every month. So all other days (for this particular query) is not needed. How do I write the criteria in the query to only pull the last day of each month?

This is what I needed!!!! Thank you so much!!!!

I have an unbound text box on my Access 2010 Form that has the default value of: =DateSerial(Year(Now()),Month(Now()),1)-1 This gives me the first day of the current month minus one...basically giving me the last day of the previous month. It is formatted as mm/dd/yyy. This shows up correctly...

If anyone has a solution so that I do not have to have all the tables viewed by the user and have the output function work...much appreciated.

So, I discoverd that when I hide the tables so that end user can not see the behind the scenes, then it breaks the Output function. Not sure why, but it works now.

I created an Access database that has a Macro that includes OutPut To Action. I created the database using Access 2007, on Windows XP. Some useres have this and others have Windows 7. The Output to excel worked on my computer; however, did not work on the Windows 7 computers. I ended up...

I have a database that does not run very quickly. I am wondering if having multiple muli-pick combo boxes would have anything to do with the slowing it down.

Thank you for the suggestion; unfortunately, in this case, each record must have an associated file, not just a folder. There is a button on the form, that when clicked, will open the file. IF the file is moved on the drive, the group using the database would only know that the file is no...

Sadly, that is what I thought would be the response. :( Thank you for your help!

yes...that is my question. Is there a way that when the file is moved that the db would follow the file to the new location and store the new path. Basically, when the file is moved I don't want it to loose the association to that file and am trying to avoid having to go in and manually find...

My thinking would be similar to a shortcut...if I move the file that the shortcut is associated with I don't have to recreate the link, the shortcut just follows the file to its new location.

to clarify...the file path is of a jpg, pdf, etc. related to the record information - not the database filepath. :)

I was using the table to store the path name. The db is created to track all marketing elements, assets and placements. For each element, asset, and placement there is a unique file associated with it. I am intrigued to how to implement your suggest. Please elaborate. thanks.