Search results

  1. D

    Strings and Invalid Qualifier

    Hallelujah! I've struggled with this subform concept a long time. Thanks Bob and gentlemen!
  2. D

    Strings and Invalid Qualifier

    Sorry guys! None of these are working. Here is a little bit more of the code in case I'm not sharing something crucial. Hope you had a Merry Christmas! Using this code when the embedFull form is opened Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer)...
  3. D

    Strings and Invalid Qualifier

    Thanks for the leads. The forms are actually called "embedFull", "ebedMid", etc. I tried both Form_embedFull and just embedfull as my string. With the first solution, I got can't find the name 'embedFull' that you entered in the expression. With the second solution, I got cant find the...
  4. D

    Strings and Invalid Qualifier

    I think this is just a simple tweak. I'm trying to create a module in which I can pass keywords and reuse the same code to generate some pricing on the form. I would pass words like Full, Mid, Basic as the SolutionType. Function MyFunctionName(SolutionType As String) Dim sumListPrice...
  5. D

    Saved Import Help Needed

    I created a button and put the code into VBA. I got a Run-time error '3200': The record cannot be deleted or changed because table includes related records. I deleted the relationship and was off to the races. Am I missing something? I'd like to clear it and the relationship remain. My...
  6. D

    Saved Import Help Needed

    Does this actually clear the table with relationships still in tact? I used this command and it would delete only rows without relationships. DELETE [TableName].* FROM [TableName]
Back
Top Bottom