Search results

  1. I

    Procedure Too Large

    You guys are the best. Works like a champ. Thanks for all your help.
  2. I

    Procedure Too Large

    The Syntax error went away. but Yay! a new error. "The value you entered isn't valid for this field" on Me(X & "x" & Y) = MyRec!Points I'll keep plugging away it.. playing with field types and such. thanks.
  3. I

    Procedure Too Large

    It might not have to do with records not existing. Here's the message I'm getting. Syntax error(missing operator) in query expression 'SpecID=48 And Location = 1x1'. Any Help would be great. Thanks.
  4. I

    Procedure Too Large

    We're so close. It's getting stuck at the first record. I think because the first record [1x1] doesn't exist. I think I need to find a way to handle null values in the SQL code. Here's what I have so far. Dim MyDB As DAO.Database, MyRec As DAO.Recordset Set MyDB = CurrentDb For X = 1 To 20...
  5. I

    Procedure Too Large

    Hey Guys... The code you've helped me with works perfectly. I have one more question maybe you can help with. I need to take what we've dumped into the table, and put it back it the field it came from. I have a table 'TBL_SpecScore' that has 5 fields. SpecID, Product, Systems, Points and...
  6. I

    OnClick event function question

    That worked perfectly for me. Thanks for your help.
  7. I

    Procedure Too Large

    This works like a champ! Loops have always been a mystery to me.. like women. But now I know, the more I play with them, the more comfortable I'll be. Thanks again.
  8. I

    Procedure Too Large

    I will try these out first thing tomorrow. Thanks guys!
  9. I

    Procedure Too Large

    Well, take a look and let me know what you think. ---------------------------------------------- Dim SQL As String Dim SQL1 As String Dim SQL2 As String Dim SQL3 As String Dim SQL4 As String Dim SQL5 As String Dim X As String Dim Y As String SQL1 = "INSERT INTO TBL_SpecScore ( SpecID...
  10. I

    Procedure Too Large

    I have a submit button on a form where the code is extremely large. It works and I can't think of a more efficient way to run it. The code runs 400 individual SQL statements. I'd like to know how to split up my code into a couple different functions and run them sequentially. Or run the...
  11. I

    OnClick event function question

    Hey Everyone, I have a form for scoring where the user would click on a text box to make the value jump by 0.5 points. I have the code working from the Sub, but I'd like to know how to make this a function and how to call the function. Otherwise I'd need to repeat the code for each text box...
Back
Top Bottom