Search results

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

omg, never new that was their, i rly should open my eyes, thanks loads

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

i currently run a mySQL db on a laptop i have in the house, prob is i need the sql db to be able to be accessed from wan, i could prob rig something up with dynDNS as i dont have a static ip but dont want to keep my laptop on 24/7, and as its only going to be a small db dont want to pay loads for it

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

grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr, its their... cheers for your help, wasnt scrolling alway to the bottom, im an idiot scoobs

I selected File -> Get external Data -> Link Tables but when i goto the file type combo menu theirs only .mdb .mda .mde .dbf .xls and exchange no odbc, if i goto control panel > admin tools > data sources odbc it shows that mysql odbc 5.1 driver is installed and i can setup a dsn up np in...

sorry but thats what im doing and their no option to choose odbc database

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

thanks for the reply pbaldy, seems i double posted somehow, not sure how tho, my question was answered in the other thread, but thanks for the reply, as usual you guys are as helpfull as ever

thanks works a treat, seems obvious now i look at it but i never would have worked it out, thanks for the help craig

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)=' &...

thanks for your post, looking at your example realised why im making it difficult for myself and your prob right, adding an underscore will make it easier

sorry yeah not the best explanation :) if the image name already excists i wanted it renaming, so if theirs an image called test.jpg but it already excists in the tables it would become test1.jpg or if this already excists it becomes test2.jpg so it becomes a later revision if u like. only...

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

nm sorted, nothing seemed to work so deleted the sub form and any code ive placed anywhere to do with this then recreated the sub form, and used code blow and works fine, must a cocked it up at some point with my experimenting Private Sub Form_Current() Dim picpath As String If IsNull([Image])...

for some reason couldnt get it working last night, got it working but would def pref to use your method marianne, tried something similar last night but couldnt get it working, inserted your code and get error runtime error 2465 database cant find the field "|" reffered to in your expression...

nm sorted,

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