Search results

hi everybody i ned to make a reports record source and the control sources for a few text boxs a bit more dynamic, i have a report with 27 txt boxs going accross, the control source for these will change as they are named after dates, depending on a value set in a form.. they are named w1 to...

hello, ive got a problem im wondering if any1 can help me with... im trying to achieve data to be displayed in either a query or a table in a certain way... atm im using a huge peice of code to sort the data and insert it into a temp table (which still doesnt workk 100% yet) to achieve what im...

hello, i run a small app to manage various stuff to do with our server, im running access 2007 and a friend of mine is running access 2003 i have some code that downloads logs from a remote location if they are present, theirs a small bit of code that test whether its downloaded any and if...

hi i have an issue with what i thought was a simple bit of maths, i hae a formula to convert one sort of id to another, but because the key involved is a very large number, access doesnt handle it like i expected it to. is their a work around ? below is a quick example (145774 * 2) +...

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...

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 &...

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...

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...

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...

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 currently using a system dsn with odbc driver for mysql 5.1 to link to several tables which are in a mysql db , i'm wanting to make my access f/e easily distributable so was looking for a way to use a file dsn perhaps, only prob i have with this is a lot of the forms show information and...

hello and hope you can help me, have a problem i think i could solve but the way im thinking of doing it would be very long winded and could cause problems under certain circumstances as i cant work out a fast easy solution i have two tables webs_user and webs_squads_members webs_user has a...

anybody know somewhere where u can buy cheap mySQL hosting, dont need any webspace just a sql db, wouldnt need to be anything heavy as would only be used for me to play with while coding and to hold members info for a small organisation, and i mean small 20 members regards scoob

hi have a mySQL server setup and running fine on a 2nd pc, im trying to connect access to mysql from this pc, i have odbc connectoer 5.1 installed but when i go into access 2003 and go into link tables their no option to choose odbc.. anybody know what im doing wrong scoobs

hello i get this error "Data type mismatch in criteria expression" with the code below mySQL = "SELECT tblCatch.tblSpecies, tblCatch.tblBait, tblCatch.Image, tblCatch.tblReturned, tblCatch.tblSize" mySQL = mySQL + " FROM tblCatch" mySQL = mySQL + " WHERE (((tblCatch.tblTripId)=' &...

hello i get this error "Data type mismatch in criteria expression" with the code below mySQL = "SELECT tblCatch.tblSpecies, tblCatch.tblBait, tblCatch.Image, tblCatch.tblReturned, tblCatch.tblSize" mySQL = mySQL + " FROM tblCatch" mySQL = mySQL + " WHERE (((tblCatch.tblTripId)=' &...

hi i have 2 tables tblSubCatch and tblCatch both have a field called image which hold image names when images are selected they are copied to a specific folder and then their filename entered into the fields, what i wanted to happen is if the image name already excists in either table then...

hello, prob an easy one but is baffling me i have a form with a picture and an embedded sub form which is in datasheet view, in their is a field called image which holds the paths to various images id like the picture to update and show the image related to the path when i click the...

is their a way to create multiple google map markers on an embedded browser within a form just by altering the url thats passed to it their are solutions but all seem to work only if you running the google map api which im not

hi, im creating a simple db and hit a prob, prob a simple answer but for some reason i cant figure it out, doh i have a comobo box called comboGoToMark when i change the value in this box i want to change another value called MyGoogleMapURL which holds a url, the url has to include info from a...