Search results

  1. C

    Creating a new record in a sub form in a many to many

    Perhaps i'm over thinking this, i don't know. What i'm trying to do is add a new record to a subform. The problem is, I couldn't use a subform based on a table in order to achieve this. I needed extended information for it to be useful, so I made the visible part of the subform based on a...
  2. C

    What's wrong with this SQL statement? (error 3075)

    Here's the statement sqlfinal = "SELECT Employees.ID, Employees.Name " sqlfinal = sqlfinal & "FROM ((qryDeptVBA INNER JOIN qrySkillVBA ON qryDeptVBA.ID = qrySkillVBA.ID) " sqlfinal = sqlfinal & "INNER JOIN Employees ON qryDeptVBA.ID = Employees.ID) " sqlfinal = sqlfinal & "INNER JOIN...
  3. C

    Multiple Many to Many and querying

    Hopefully I use the right terminology here... Anyhow, I have a database with multiple many to many relationships. At the moment, i'm working with a Product. Each version has multiple categories of add-ons. For example. Item A can have Accessory1 Accessory2 Category1 Category3...
  4. C

    Len function oddity

    If i have a field where all entries should be 10 characters in length (a phone number, no formatting), and the in the table, i set the length of the Phone field to be 10 characters, max, AND I make a query and in the Phone field of the query i say Len([Phone])>7 That should return all records...
  5. C

    Combobox value and input masks

    How do they relate? I was under the impression, that input masks had no bearing on anything unless you set it to save the information into your table with the masking information (i.e. the ()'s for area code and - (dash) for a phone number. It just doesn't seem to be working that way. I have a...
Back
Top Bottom