Recent content by Goomba79

ahh took the square brackets out and it works......at last! thanks guys!

Ok so i have my sql now as follows SELECT * FROM tblSkills WHERE (EmpNo= [Forms ]![frmMatrix]!txtEmpNo.text); I have a textbox on my form that gets the vairable from the combobox but when the query runs its asks for the parameter [Forms ]![frmMatrix]!txtEmpNo.text in a pop up window!!?

hmmm that's a bit pants isn't it! oh well at least i know now!!! Thank you very much!

the bound column is the second column of the table which is the users name. i want to search by EmpNo which is the first column. i believe the first column is referenced as 0 and the second as 1 and so on?

Hello, Thanks for the quick reply!! I tried the above but i still get the same error??

Hello, I'm having a bit of trouble with my sql statement. I want to take a vairable from a combobox on my form and use it as a search parameter in my query. my sql is SELECT * FROM tblSkills WHERE (EmpNo=frmMatrix!ComboEmp.Column(0)); when the query runs i get the error undefinied...

Hello, I didn't want to go the module route as that seemed a bit of a long winded way to go about things. I knew that it should be possible to do it with an update query just wasn't sure of the syntax and access isn't very helpful discribing which part of the sql was wrong. after alot of...

OK i see what you are saying with the module thing, but surely i should be able to do it with a query??

looking at your link regarding the replace function I have modified my SQL to Update "Document Table" Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local") Where PathInformation Like "SERVER"; no when i run it i get syntax error in query. Incomplete query clause?

Hello, no i didn't try Post 6, can i just paste that into a query in access?

how would i write it? all the examples i can find look as how i have written it!

Hello, thanks for the replies! i have written this update query..... UPDATE Document Table SET PathInformation = Replace(pathinformation,"SERVER.srl.local") WHERE pathinformation Like "*SERVER*"; however i get a syntx error in update statement, i can't see what i am doing wrong (think i...

ah i just read changing the field from hyperlink to text and then changing back again will sort it!

i'll have a look into that, although not to sure how i would change the address and not just the displayed text

Hello, I'm having a problem changing the hyperlinks in my access table. the hyperlinks point to locations of various documents on the server i.e. \\Server\Quality\Documents\Doc1.docx we have 2 domains at work so on one domain the hyper link works but on the other it doesn't. I did a find and...