Search results for query: *

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...

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...

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...

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...

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...

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) " _...

AssignedJobClass is Short Text AssignedSkillNum is a Number

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.

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...

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...