Search results

  1. G

    using a form vairable in query

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

    Global hyperlink change

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

    SQL parameter help

    Hello, I have written the following sql command... SELECT * from tblCalibrationRegister Where [calibration due date] <now() and description =[] is there a way that when i have the enter parameter msgbox pop up i can have it display a dropdown list populated by the sql command... Select...
  4. G

    SQL select & Insert

    Hello! I am pretty new to SQL so I imagine my problem is extremely simple! What I am trying to do is select values in the columns Fname and Sname and insert them in to the column Uname Where the selected empNo emp = empno. i'm hoping this will run through every entry in my table. my query so...
Back
Top Bottom