Search results

V.Odd, manual copy/paste does NOT work. I have this textbox where I store all that data collected from the query briefly made big so I can select, copy & paste but does not work.. Now getting a NEW little window that says "item 2 of 24 items collected" then "format not supported by office...

Hi, Sorry this is a little vague but just have no time, on holiday tomorrow & only have a few hours later. I know this copy & paste is not pretty but worked for years. Works well with keeping rtf formatting Get error, "paste is not available now." This Windows 10 or Office have done a...

Hi, Update on below. if I do not set as read or move that email as I go, I do not get an error, "array out of bounds" I guess to do with messing with the filtered list. Odd it works 99%& of the time & only on specific emails, no identifing traits (& can be replicated) that it causes problems...

I think I will have to look a little deeper, I had mistakenly thought the time was exactly the same & so pure copy on the server, safe to delete. Is stranger still as definitely when I have these, almost identical email it errors on loading, e.g. find 3 unread, reads the first 2, then nothing in...

Many thanks for prompt reply, That makes so much more sense than my way of thinking, I was considering see if outlook would do it & add-ins but of course this is so much smarter. I was not initially sure I could do this safely without comparison with the body of the email as clients re-send...

Hi, Really odd one this, I load unread emails from outlook, works 95% of the time, no error. From time to time & it seems on emails that are similar, I suspect identical duplicates! it will crash, array out of bounds. I am guessing when I mark as read, it then gets confused reading the next...

Probably should start a new thread but while here. Has anyone used google workspace as their email server, just wondered if be faster. I have used ordinary gmail via the CDO to send but not sure if more security, authorization. Working with outlook, little fiddly but think will get there...

Sorry my stupid mistake on original post, I had the port & ssl settings buried in a load of notes & when I copied to here I missed them off, so is SSL is set up correctly.

That's what I was saying but not very clearly, It works fine, In & Out, just rather slow. I have SSL, ports & passwords all OK Just having a look at outlook, not used for a while & now sodding around trying to decide if to use New or Old & then persuading the right one to open! cannot see an...

Not sure what you mean, is SSL & password etc all accepted OK & set up as such. Same with Thunderbird & even the webmail service as default from TSOHost & the new server, I suspect to be linked to godaddy which I hear are not the best. The emails go OK, just take longer than before, it might be...

Thanks for for all your advise. 99% of the time I am sending emails one at a time, I write, then send, When I exit that email I review the information in a list, with bookings & lots of other info. this list then highlights any mistakes I might have made while fresh in my mind. so don't really...

Hi, Been using code below to send emails for years, all worked well. However my service provider recently moved my server over to what seems like a DoDaddy service & ever since sending emails has slowed down. NOT the actual receiving at the other end, that's not too bad, but from the second I...

I know a really old thread but thanks for the LINK instead of Import advise. Not quite sure why people always think we should not expect data to be imported in the same order of an original source, just seems odd, shy does it have to change, if you want to change it then you do a sort or alter...

Hi, Just now looking to implement proper, being fussy now ... Is there a way to put this in a form, so that the fields can be adjusted, colour, size, centralized etc. I have added as a subform & the crosstab.query as the source so it works but thinking would like to manipulate the display.

Hi, Gone with ebs17 as the first I tried & just worked perfectly & seems an elegant solution but thanks arnelgp, will have a good look at that solution also. Thanks again,

Hi, I have a table with each day & totals related to that day. Dates will vary and number, perhaps 20 or more but I think will restrict to 30 although data may ask otherwise but will have to worry about that on the screen space. I know not really how access is meant to process, display data...

Hi, Very many thanks "In Column "TmHour" the Total row should be set to Where rather than GroupBy. That may be all that is required." WORKED I thought I had tried that & actually most of the other sum functions, just to get a dumb value to avoid the GroupBy but I guess not. Put it back to the...

Hi, Thank you for your prompt reply Not helped & can't see why it might?

Hi, I am trying to sum total the two values as below but Grouped per day ONLY, 1 total for the 7th, the 8th etc. etc. However I need the TmHour to filter the results just between those times This causes it to no longer be grouped by day but per time hour also. I just can't work this out, any...

I had tested, did not get an error message, it was deleting a record OK jut the WRONG on from a different form I am now using Me.RecordSet.Delete & cannot replicate the problem I would have liked to know why it somehow the focus goes to this form, even stepping through the code, does not show...