Search results

YOu coukd use a pass sthrough query. So the sql would be in a sql server format and be processed on eth sql server and the results passed back. If thats too slow - yes I think teh sql team would have to help you out with indexes or something else to help speed it up.

Has anyone integrated with an API to validate emails. Yes I could and do now validate within VBA code itself - but to future proof it in terms of valid formats maybe an API would be better? Thanks Tony

My advice is - at almost 70 I'm guessing youre no longer worried about making a bit of a berk of yourself. Join a salsa class, and have some fun. No matter if you have no talent for it at all. Or some such other thing outside your usual box. Good luck Col.

Cheers mate, I hope the code I just pasted is hopefully basically it.

Yes , thats what they will be doing.

I cant no, I wish I could - its from whatever source in whatever format an end user gets an address and tries to paste it. I suppose mainly it will be stright from a compnay website, or email. Heres the bones of what I have, teh main problem may be recognising differant carrriage returns...

As you point out the address could be in any format - could be 4 line, 3, could have country , postcode not etc etc. Again it could come from any source, so i'm just trying to detect a carriage return character. Right I think I'm under way, splitting field !One by VbCtlf Private Sub...

Heres an address I was working with , my first challenge is to split it into each line? THanks Company Name (Registered Office) 35 Scirocco Close Moulton Business Park Northampton Northamptonshire NN3 6AP

It would be an address at a time. I would hope teh end user would be bright enought not to copy/paste teh first line if that was a a persons name. Thanks

I was just doing a bit of data entry - copying an address from a website to my application. I had to line by line move the address to the corect fields. What I woudl like to do - sf maybe copy and paste the whole address and have it automtically split. So basically each line would be split...

Well does it work? I think a view can be updated as long as its updating just one of its base tables. THere could obviously be other underlying issues why data may not update.

YOu could use a sql function to return a table (select statement or whatver sql you want) to use as if its a parametrized view. I am looking at access to azure myself - any updates you have on your progress would be most helpful.

Thanks yes, I think I need to do a lot more reearch into Azure.

Hi we are stuck currently using client server Ms Access to SQL server technologies. We have a number of sites who run this same setup but in the cloud, so the ms access is installed on virtual PCS. Am a I right in thinking SQL azure could sit in the cloud and ms access work locally and...

I was wondering what people did in way of recording or removing invalid email addresses from their databases. I have a bounce back file containing my emails and techniocally its fine to remove them. And will remove them from tables such as contactname, company as these tables show current...

Welcome! I love Italy. NauticalGent really liked Naples when I was there all too briefly. Someone "stole" my underpants.

THanks I get it. I'll give it a go.

Thanks both - dont both of those show how each part of my comparison would make up a whole Say min = 25, max = 100 Booked = 90? Or min = 25 max = 100 , booked = 9 What would each part of a stacked bar or pie chart represent in teh above figures? Cheers. At the moment I have a grouped bar -...

I have been asked to show a succint "graph" showing upcoming events that havent reached their minimum viable delegate numbers or show those that have reached their max delegate numbers. There is also a minimum fees taken amount which has to be surpassed. Anyone got a nice way to show that. I...

Reminds me of the real debate of moving teh clocks forward in teh summer in Western Australia . Many were worried that the extra hour of sun would fade their curtains!