Search results

You could just log the difference of filenames in an After Update event like you would any other field?

Tips for working with Dates http://www.599cd.com/tips/access/dates-datediff-dateadd/

Hi Could I clarify: Do you mean changes in the actual file or just if the filename has changed?

Are you tracking the changes of other fields using another Table storing original value, new value, date, user etc? i.e. Audit Table What do you wish to track in the attachment field? Just the name change, if it's updated, the difference between the files etc?

Yes something like that. http://msdn.microsoft.com/en-us/library/office/ff820966.aspx I've quickly amended the code from the above article, it's untested but should get you started. Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strEmails As String Set dbs = CurrentDb Set rst =...

What do you mean by wipes out? I take it you amend the code to open a different form? If ContractID is a Number you don't need to wrap it in "'" & ID & "'". Quotes are used for Strings.

Do you know VBA? Create a Query with all the Email Addresses you need. Now use this Recordset and you could loop through it adding each record to a string separated by ";". You could then use this string how you want, save to a Txt file, open Outlook etc

Where are you getting the ID from? Are you opening the second Form from the First? You could refer to it using FORMS!frmNAME!ContractID

Do you have an example with sample data.?

For Query criteria ACROSS like you have it is an AND so the date ranges have to match in ALL 3 Fields. Try putting each Criteria in its own row, so DOWN, this will be an OR. It will look stepped A. B. C 1 2 3 Not A. B. C 1. 2. 3

There should be Save As options Choose .accde

You could switch to tabbed but that might not fit with your process. You could look into the insidewidth/insideheight properties of a Form. Here's a Tip video on the matter that might be useful. http://www.599cd.com/tips/access/misc/AC310-resize-form-vba.asp?key=AlexForum This can set to...

You'll want to look into the "OutputTo" http://msdn.microsoft.com/en-us/library/office/ff192065.aspx expression .OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding, OutputQuality) Example: DoCmd.OutputTo acOutputReport, "", acFormatPDF, myPath +...

Do you have 'Overlapping Windows' or 'Tabbed Documents' set. http://office.microsoft.com/en-gb/access-help/show-or-hide-object-tabs-HA001229281.aspx#BM4 Normally Access saves the Form size and position for OW. Are they maximising when you've added the code?

You can create the Queries you need in the Query Builder. Make sure they have matching columns, they do t have to be the name names but have the same type of info. This article should be useful...

Usually LIKE is used for a textbox search. So you let the user choose a term to search for so if you had a list of names "WHERE [Name] LIKE '*" & [txt_Name] & "*'" If you had Names of ALICE, ALEX, ALAN if the User typed AL and pressed Search it would show all 3. If you have a combo box with...

Ok, so you open the Form, you start typing in your information, are you getting any error messages? This should allow data entry.

You could UNION the three data sources the create a CROSSTAB from that Query.

Did you set the Source of the Form as your Table then drag on the Fields? Or did you click on the Table and select Create Form, this will auto bind it. Or did you just create a Blank New Form?

What version did you originally to have? Have you tried repairing office? Uninstalling/Reinstalling? Check you have the Latest SPs. What Security did you have on it? Could you remove the Security?