Search results

Call fHandleFile(DocName, WIN_NORMAL) where the DocName is defined as path & docname & extension

I'm getting this error .... any reasons why :banghead: ByRef Argument type mismatch ps im trying to open visio

Ha ha I've worked it out - it is because the data is in an attached EXCEL spreadsheet . .. now deleted is there a way that spreadsheets can be excluded from the search??

Thank arnelgp - after a bit of tweeking it worked great and I ran a number of times with great success. However, now I have the error "operation must use an updateable query" any ideas?:confused:

Yes the **** was the issue the odd thing is though that if the text is in more than one field in the same record - it only fixes one of them. If I run the code again it fixes the other. so it looks like it only does one "instance" per record . . . would that be expected? and how can I modify...

Thanks all could indeed be the **** I was just using is as a text example for the test before I included in my main database - let me try and see

Just trying this code now Private Sub Command0_Click() Call ReplaceAnyField("Pink", "****PINK****") End Sub but I get the error ... "Argument not optional"

Morning people of the Access World. I have a need to do a "Mass replace" to remove personal detail from a number of tables. For example:- I want to change all instances of the Name "Joe Smith" to "xyz" I need to do this across all my tables. Does anyone have a routine that can interrogate...

Yes - it is prefixed with "FAR":eek: don't worry I fell for it as well !!!! :cool:

I found it =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [FAR Number]) needs to be =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = '" & [FAR Number] & "'") SOLVED :D

I tried =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & me.[rptComplaintCustCAT3]![FAR Number]) and =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & me.[FAR Number]) neither worked it changed =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR...

can anyone see whats wrong with this syntax =DLookUp("[Defect Explanation]","[Complaints dB]","[FAR Number] = " & [Report]![rptComplaintCustCAT3]![FAR Number]) this is entered in a report to get round the problem of the memo field being truncated. :banghead:

I have data table with a date field going back 2 years How can I get a count of how many records per week note:- some weeks may have no records and so I need to have a zero value My objective is to do a graph showing all weeks Thanks in advance

many thanks - forms working and imported now working on query and reports etcx

thanks static for your help for the last little bit - how to I read the filename from the directory? do I need some sort of loop to read all the form names in the directory??

@Static I've done the export to text - but how does the IMPORT work ??? do I have to name each object individually???

thanks for the feedback so far and size is 25,856 kb. I tried importing forms one by one into a new database and its was one of the first forms loaded that fell over - first indication was the "View" button to move out of design mode that played up. Im' gunna try to decompile

Hi Guys, I am still living with this problem. So far I have:- - reinstalled whole MS Office suite - copied to another database I have determined that it is related to just this database and to a corruption within it. I have copied forms over and found the error reoccur. I'm not sure...

are there any "BETTER" (and safe) repair programs other than that supplied by MS

update - interestingly I have just tried to create a new database and import from the old one. A key error on the forms is that it says it can read the VBA on the forms and hence didn't import any of the forms. Suggesting to delete ALL the VBA before importing.:banghead: