Search results

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...

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...

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

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...

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

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...

Hi Can someone help what would be the best way to search multiple fields in a record and update only those whom value is equal to a varible string (stringX). There could be 60 fields in the record and only some of them will need updating. Looping through each record I can only think to do it...