Recent content by theferd

  1. T

    Solved Checking if a certain unique record exists using DCount

    I rewrote the entire on click event and added invisible text boxes to validate each value at each criteria and somehow that ended up fixing the data mismatch/syntax errors. I really have no clue as to why it is working now, but the line itself is not any different from what Doc Man gave. Sorry...
  2. T

    Solved Checking if a certain unique record exists using DCount

    exist = DCount("[Field1] + [Field2] + [Field3] + [Field4]", "tblcatalog", "[Field1] = " & Me.txt1 & " AND [Field2] = " & Me.txt2 & " AND [Field3] = " & Me.txt3 & " AND [Field4] = " & Me.txt4 & "") Returns a missing operator in the final part of the expression. Is there something I'm missing?
  3. T

    Solved Checking if a certain unique record exists using DCount

    I did make the four fields a composite primary key, but was concerned about how the error would produce itself while a user was on the form. Is there a certain line I'll have to introduce to exit the sub such that the VBA module doesn't open? Or if it is just a message box that appears, a way to...
  4. T

    Solved Checking if a certain unique record exists using DCount

    I am having difficulties creating a line to determine if a certain record exists within a table. I have a form where a user put in numbers in four different text boxes and those will be stored in the table. And before they are inserted I wish to check if it already exists. From my...
  5. T

    Solved Using a form to update a hyperlink in a table

    I appreciate the concern and might go with this method in a future project but for now the project has gone far enough that it would be tedious work to replace relationships related to the links. The documentation this provided though has helped solve my issue. The solution for those curious...
  6. T

    Solved Using a form to update a hyperlink in a table

    The link will be some url pasted into a textbox (Me.txtlink) by a user. After a button click it will be transferred to the table. Something like https://www.google.com/. But on the table and through searches, it will only appears "Link" in the hyperlink field.
  7. T

    Solved Using a form to update a hyperlink in a table

    This doesn't work. It just generates Link'Url' and causes a missing parameter error. updatesql = "Update Drawing Set Links= link" & Me.txtlink & " Where [ID] = " & Me.cmboID & "" - for reference
  8. T

    Solved Using a form to update a hyperlink in a table

    Hi All, I am having issues with making use of hyperlink object in an Update SQL. I have a form where a user pastes the URL to a drawing in a text box. I have a table, Drawings, with fields "ID" and "Links". The link will be transferred to the field in the table corresponding to the ID they...
  9. T

    Suggestions to improve form view

    I played around with it more and decided that a popup form with a click event on a small icon is good enough. It isn't exactly what I wanted, but it works.
  10. T

    Suggestions to improve form view

    Hi All, I am developing a form which draws information from tables putting them in neat rows. Each row has all the information necessary, ids, classification, hyperlinks to documentation etc. This is a database for connectivity in tubing ( T, Y, Cross, 90 bends, etc) However the last column is...
  11. T

    Inserting strings into variables - Syntax issue

    I went into more documentation on general string functions in VBA and finally got the result I wanted. Somewhere we got too focused on the database and end result of the string and it resulted in all this confusion. Simply put I wanted to put a variable, into a string, without the string...
  12. T

    Inserting strings into variables - Syntax issue

    I have a table with two fields. Serial codes, and a Number ranging from 1-100. Serial codes may appear multiple times with a different number. The goal is for a user to determine which serial codes are associated with all the numbers they selected. Combo box 1 has the number 4 Combo box 2 has...
  13. T

    Inserting strings into variables - Syntax issue

    Ok, let me see if I can clear things up again. A user will select 4 numbers in combo boxes. A button will initiate the code. Using the four numbers, (1,2,3,4) it will assign four variables, lets say var1,var2,var3,var4. These are assigned to a query under the same name as the number only...
  14. T

    Inserting strings into variables - Syntax issue

    Haha, I have always been poor at diction especially when it comes it learning a new language. So the long haul is the values selected in the combo boxes will return queries of the same name (prefixed with qry). This will form a SQL for a merged query comparing the queries in question. These...
  15. T

    Inserting strings into variables - Syntax issue

    I intended to use the combo box values for both SELECT and FROM. The long form of the code for just two combo boxes would be "SELECT qry1.number qry2.number FROM qry1 INNERJOIN qry2 ON qry1.number = qry2.number"
Top Bottom