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) " _...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.