Search results

Hi David Sorry - I'm not sure I understand what you're suggesting I do :confused: I know that I could have had Chr(13) & Chr(10) instead of vbNewLine in the MsgBox, but as far as I know that wouldn't change anything and in any case I don't think it helps me to do what I'm trying to do: which is...

Hi to all 3 of you Very many thanks for all the suggestions - especially to Rookie for persevering :D Unfortunately none of the suggestions have worked :mad: Just searching for Chr(13) & Chr(10) on its own doesn't find anything, and trying to capture the linebreak as pr2-eugin suggests seems to...

Tried all these (on their own) in the Search: vbCrLf <vbCrLf> *vbCrLf* <p> *p* still no joy :banghead: Surely this shouldn't be so hard :eek:

I can't seem to be able to use the NewLine Insert Character <p> in either the Find or the Replace. Should I be typing it exactly as <p> i.e. the lessthan sign, then p, then then morethan sign or am I being thick :confused:

Ho Rookie I absolutely take your point - I know how 'powerful' (= undiscerning!) the Replace All feature is! Having thought quite long and hard though about the code we have, I decided it would be safe to insert the call to WriteErrors between the error handling label _Error: and the first line...

Hi All We have an accdb with lots and lots of modules, subs and functions, most of which have decent error trapping: so typically at the end of a sub I have uploadEIPs_Error: 420 MsgBox "There has been an error!" & vbNewLine & _ "Line Number: " & Erl & vbNewLine & _...

Sorry - I get the logic of what you've suggested, but does this assume that all the potential filenames to be deleted are exactly known? In the case I have, the filenames could be anything that meets the criteria: LEFT([Forms]![frm x main]![month name], 3) & "*" So I can't see how to move to the...

Hi 'namliam' Many thanks for your reply. I think your option 2 sounds like the best one for our purpose: but how do I Sorry to be a bit clueless :(

Hi All I have: Kill "Z:\Client_Reports\" & [websiteID] & "\" & LEFT([Forms]![frm x main]![month name], 3) & "*" This has been working fine - all the files that meet that criteria are deleted, but now I need the option to exclude a particular file from those to be deleted: the...

Hi Brian OK - I will try again to fathom Rx's code to see if the resize function will do the trick. I am surprised that this is being suggested though, because I had thought that resize would just have changed the dimensions of cells, whereas I need to merge them, which is different - or is it...

Hi Rx Thanks for your comprehensive post! I have to say that much of it was a bit beyond me :o , and I couldn't quite see whether what you've done applies to my situation. I do appreciate your help though. Hi Cronk Yep - I have Set objSheet = objBook.Worksheets("All Staff") at the head of the...

Cronk Adding the extra brackets round (lngRowCount + 1)) had no effect. Adding the .Select to the end of the statement gave me an "Object required" error :mad: Am I going to have to have 23 separate statements, instead of the loop? Hope for any more ideas :o Thanks again. Les

Cronk Now that looks interesting! I won't be in the office until Monday (it's Sat night here - UK - where are you) so won't be able to test your syntax until then: but my intuition leads me to be hopeful :cool: Cheers - I'll let you know. Les

Hi Cronk Thanks for your suggestion. I tried the extra brackets, but sadly no joy :( Hi Brian Thanks also for your link: very interesting, but I don't think that's it in my case though, because I'm not trying to do anything with the merged cells afterwards so don't need to change the size of...

Hi All I have a routine in an access module that writes an excel workbook with some very specific data, validation and formatting etc. Most of it works fine, but why doesn't this work?1090 For inc = 0 To 23 'With objSheet.range("AM7:BB7").Offset(0, ColOffset) 1100...

A feature - so that's what you call it! Thanks for the tip. Les

OK - this is getting weirder - straight after posting the above it occurred to me to check the value of [Forms]![frmAthletesRegistration]![optSex] when I am expecting it to be 3, so I removed the criteria that's causing no records to be returned, and when I run the query in the...

Hi All I thought I knew about criteria, but cannot for the life of me get this to work - should be simple, but no joy - so I suspect it's a Gates Gaff :eek: The criteria I have is: IIf([Forms]![frmAthletesRegistration]![optSex]=1,"M",IIf([Forms]![frmAthletesRegistration]![optSex]=2,"F","M" Or...

Hi DocMan Importing all the objects into a new accdb worked :D I don't suppose it's worth wondering how/why the corruption came along: frustrating :( Many thanks for your fix. Les

Hi All I have an access 2010 accdb on my windows7 laptop that has suddenly started to behave strangely :confused: After doing any development I always create a copy of the accdb: after doing so, I am now often finding that when I go back into the main accdb, the 'switchboard' form loads as...