Search results

Hi Found the solution as follows, thanks for you help dim xDate as Date xDate = Format([ETC], "dd/mm/yyyy") c.FormatConditions.Add acExpression, acEqual, xDate < DATE

There is bout 30 fields so better in code I tried this but still returns odd results c.FormatConditions.Add acExpression, acEqual, "[ETC] < #" & DATE & "#" This does not work, returns an expression of 0 c.FormatConditions.Add acExpression, acEqual, [ETC] < DATE ?

Hi I am having issues with dates in conditional formatting. This line is not formatting all rows to red if the field [ETC] is less than today's date. But some rows are returned red, what tells me it is not passing as a date but string. (see attached) c.FormatConditions.Add acExpression...

Thanks that did work. In the end I used vba to loop through a record set, there were several million records and the queries struggled.

Thank you, close but when I say within a year, that is not the same calendar year but a year from the previous contact. So this should show as a the second contact was only a month later? personID contactDate 105 15/12/2008 105 1/01/2009 105 1/01/2017

Hi I have generated a table of dublicates records. I want to now filter all of those duplciates (people) that have been contacted more than once wihin a year. Eample personID contactDate 100 01/10/2012 100 06/11/2012 100 11/11/2017 show this as the first two reocords were withn the same...

Hi I Installed Access runtime 2010 onto 6 computers that were running the app ok in 2007 runtime. We then removed Access 2010 and reinstalled Access runtime 2007. Now when we view a picture box on a form that links to a pic we get this error Error: [App name] doesn't support the format of the...

Thanks, tried this but did not work, the pdf still has the focus?

Hi How can you return focus to the Access application (parent) after executing the shell command? E.g., I use Shell to open a pdf file, I require the focus to be on the access form not the PDF? Thanks

You could use the Link Child Fields / Link master Fields property, used to link relational tables with the parent.

Here is an example of the code if anyone can assist Dim AppName, Topic, Temp Dim chan As Single chan = DDEInitiate("winWord", "System") 'Must be open DDEExecute chan, CStr(Chr(40) & "Hello World" & Chr(41)) DDETerminate chan 'returns Hello World I require the ( ) to be passed...

Thanks, I tried this and only Hello World makes it through. I am using Word as a testbed. Any other siggestions?

Hi I have been given an old application to fix in Access 97 that works fine under Windows 95. Under Windows XP it fails. The issue is with the DDEExecute command. It appears that left and right parenthesis are not been sent to the external application that is expecting them. I need to know how...

Please help Sending email from Access 2007 I have installed Office 2007 and the additional Microsoft Office Add-in: Microsoft Save as PDF or XPS When use I receive error can’t send this e-mail message. A similar message occurs if I use the sendobject DoCmd.SendObject acSendReport...

I have a large table with street and city details, I need to find the postcode for them by searching a very large PAF (Postal Address File). If I match the street name and city I can retrieve the postcode from that record. Using DAO and the seek method? How can I search a table like this, I...

this worked great than you..

I am trying to find a way to best strip the numeric part of an address in a string. i.e extract the address number from the street name. Example is 21 Echo Valley Road (strip of the 21) 2 - 506 Devonport Road (strip of 2- 506) How can I do this?

I know this must be simple… How do you show the actual month from the results of using the datepart function in a query Query xMonth:DatePart("m",[ContractStartDate],[MaturityDate]) I want to show Jan, Feb march not the integer value. Cheers

Currently I am doing lots with Word automation from Access, but not with Mail-Merging, I did find this article that may help you... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/MailMergePartI.asp Is Mail-Merging what you really require? You can insert data...

Hi I want to find a string in a word document using Word Automation and create a bookmark. Most examples are based by searching for bookmarks within the word document, in my case this is no good. Has anyone done this before? I think I have to use .find or .findtext I want to postion over the...