Search results

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.

I currently have a db that will store the file path in a table field named "FilePath." IF the file is moved the link obviously does not point to the file. IS there a way to have the "FilePath" field auto update itself if the file is moved to another location? This would eliminate having to go...

Anyone that can interpret the SQL from what I currently have in the Record Source...I could use some guidance. Thanks.

Still not sure I am getting it. Is the "Select Somefield " & _ suppose to be everything after the SELECT Elements.*, and would the "FROM qryLargeTable " & _ be every table that is used in the query? and there would be no group of order? This seems like a lot of rebuilding of how Access...

yes, I was confused on that too. thanks. I will try it without it. thanks.

It's Friday...need I say more. :) This should be easier than I am making it. Here is whats in my Record Source: SELECT Elements.*, Contacts.[Last Name], Contacts.[First Name], Contacts.Company, Contacts.[Job Title], Contacts.[Business Phone], Contacts.City, Contacts.[Last Name] AS [Last...