Search results

Here it is :) When debugging the code stops on this line and throws the error

Hi could anyone give me some reasons why this error is occurring? see attached :) thanks

EDIT : I have this error now: :(

I will give it a try now, I understand what you mean now Thanks a lot for the help :)

Each time I put a new module ID in from the list it needs to add another courseID to each row too, do I put the INSERT statement in the for each? Thanks for the help

My table that I am trying to insert data into is like this: CourseElementID(Auto) | CourseID | Element ID 1. 1. 4 2. 1. 2 ... ...

Hi Paul thanks again for the reply :) I have tried implementing the code here it is : Private Sub Command185_Click() Dim strSQL As String strSQL = "INSERT INTO dbo.CourseElementsDefault (CourseID) VALUES (Me.CourseID)" Set ctl = Me.lstElements For Each varItem In ctl.ItemSelected DoCmd.RunSQL...

Hi Guys, I have a listbox on my form in access which holds strings, how do I insert these items into an SQL Database (Table)? Thanks :)

My modules per certificate are bit types, which are bound to check boxes where people can select which modules somebody has passed, do you have any other suggestions of a way of storing this? If not, how can I display on the the non null values in text boxes in an Access Report? Thanks Adam

Hi, The concept is: I have a table that has a certificateID, the certificate had a training course which somebody has completed, a person can complete different modules out of 45 on the course, the maximum modules that someone is likely to complete is around 15, so I don't want to be putting 45...

I have a table which has an ID and 45 other columns each referring to a module. I do not have the room to binid 45 objects onto the report and also there will only be around 15 NON NULL values which need to be printed on the report. How do i populate 15 text boxes with only NON NULL values and...