Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jkestes

    Form won't open - Bug or Bad Code?

    Thanks for the corrected code, Duane, but it still didn't resolve the issue. No matter how I tell it to open the Main Menu screen, it won't. I can't find anything unique about this form that would cause it not to work with the macros when I have about 2 dozen other forms using essentially the...
  2. jkestes

    Form won't open - Bug or Bad Code?

    No, I want the current form they are using to fill the screen so I only keep the current screen open. When they select a new form to use, the macro that opens the form also closes the main menu. It is the reverse of the code in my initial post. I suppose I could change all the macros to leave...
  3. jkestes

    Form won't open - Bug or Bad Code?

    I have a database with some employee information. There is a Main Menu that starts when you open the database and it has a bunch of buttons you can click to open other forms and reports. Once you are finished with a form, you can press a button that closes the form and returns you to the Main...
  4. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    Thanks for the tip about the CODE icon. This is actually my first posting on here, so I was wondering why your code looked nice and formatted and mine looked like plain text. Also, it looks like this problem was the result of my own stupidity. Recently I changed the name of the field from...
  5. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    Ok - Now we have a whole new error. Maybe that is progress on some level. The error I get now is... Run-time error '3127': The INSERT INTO statement contains the following unknown field name: 'AssignedSkillNumber'. Make sure you have typed the name correctly, and try the operation again...
  6. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    Now I get a "Compile error: Syntax error" error and these three lines of code are in red. I can't figure out what is wrong with the syntax of your code. It looks fine to me. strSQL = "INSERT INTO [tbl_Assigned Job Class Skills] " _ " (AssignedJobClass, AssignedSkillNumber) " _...
  7. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    AssignedJobClass is Short Text AssignedSkillNum is a Number
  8. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    Not sure if this helps, but the full error that I am getting is, "Run-time error '3265': Item not found in this collection." Not sure if that additional info will help much.
  9. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    Hi Andy, You are correct about the names of the fields in the table. I should have mentioned that before. I corrected the line to the correct syntax as you suggested, but it didn't resolve the issue. Still getting the same error at the same line of code. Yes - there is a great need for a...
  10. jkestes

    "Item Not Found In This Collection" error when trying to create records using List Box and

    I am trying to write records to a table (called "tbl_Assigned Job Class Skills") that has 2 fields. The information for the first field comes from the items picked in a List Box (JCList) and the information for the second field is from a Text Field (SkillNumber). When I run the following code...

Part and Inventory Search

Back
Top