Search results

thanks for all ya help m8 , tried applying same method to an insert into later in the code and to the dlookup,both getting syntax error's the insert into is "syntax error missing operator", and the dlookup is "syntax error in string in query expression" believe they being caused because of...

worked a treat but now my dlookup errors out 'check if alias used before if not insert Counter = DCount("[Alias]", "[tblAlias]", "[Alias]='" & sNick & "' And [UserID]=" & sID & "") If Counter = 0 Then mySQL = "INSERT INTO tblAlias ( UserID...

hello got a bit of code here that keeps erroring out and not sure how to resolve my problem, basicaly ive got some code that runs through all the log files ina dir and strips out any id, alias and chat data in them, and stores them in a way that can be cross referenced later, prob is theirs...

your right doesnt look right, seems to work tho for some reason, their are some if arguments just prior to that so will check them see if that bit of code is being bypassed, only wierd thing is the code is doing what i want it to :/ seems to be working fine

was merely a test to see if a record already excists with that alias and id, because people with different id's can have the same alias i needed to test for both, basicaly its part of some code which records which alias's users have been using

chirst, thanks a lot, i swear down i'd tried that lol. thanks anyway, feel daft now :) scoobs

hello and heres yet another dlookup question, its annoying me and ive tried a few different variations. its a dlookup with 2 criteria, i cant seem to resolve why i keep getting data type mismatch error, here my bit of code If Counter = DCount("[Alias]", "[tblAlias]", "[Alias]='" & sNick &...

nice 1 cheers everyone, never would a thought of that

hi looking at the regex, seems a bit heavy for what im wanting, wouldnt the string have to be a set pattern to use regex, which im unsure how this would work as the alias can be upto about 50 characters long and may contain numerical, alphabetical and special characters, basicaly theirs no...

hi if u mean id as in the alias, then no, their alias can sometimes contain a < scoobs

hi, i know this has been covered many times but im completely stuck, im postive its something simple but after a few hrs searching this forum and the web i cant resolve it to cut a very long story short, i have a some code that runs thru log files, and strips out the info im after. all is...

cheers for your reply, square brackets did the trick, which is a relief :D:D:D:D

i have a small db which i use to automate tasks for me, one of the things the db does as well is update my website for me, as i have the necessary mySQL tables linked to my db this is usualy quite easy to do, the website is a pre built cms btw ive hit the snag where im using "insert into" to...

sorted thanks for your help

hi thanks for your reply. ive tried several variations of my own code , and just tried your code mid(sbody, instr(sbody, "http://"), (len(sbody)-instr(sbody, right(sbody, 55))+instr(right(sbody, 55), "-"))) i get the same results as im currently getting the --------- is always at...

hello, hit a snag which im sure can be resolved easily enough but i cant seem to work it out. basicaly im pasting contents of en email into a txt box and want to extract certain info into txt boxs, sort of like an autocomplete, i dont want to read the emails directly before anybody...

as usual post a question then find the answer 2 mins later, doh lol thanks anyway scoob

hello, probably an easy one for somebody to answer but ive tried searching the forum and cant find an answer.. i have a db which can already send emails np, the emails it sends are built using data from different tables so i was able to code the formatting of the emails as the db also has...

im interested in being able to convert a word in a string to md5 hash, wouldnt need or want it to reverse it or anything else just create a hash in a sting, how would i implement the class file above, tried searching for how to do this but not getting anywhere, plus its only a minor problem so...

nm ive found this article which i think does what i need, ill give it a go, only issue i have is if i use doug steeles code changing it for mysql not sql http://www.access-programmers.co.uk/forums/showthread.php?t=158159