Recent content by Steve2106

Hi RanMan, Thanks for the reply. Yes I am able to do that but when I look at it this way the variables from the code are not filled with values. It has something like: "Select * from tbl_items where ItemId = " & [pItemId] I need to temporarily stop the execution with a debug point and check...

Hi There, A few people have been helping me in the forum and I am now at a stage where I would like to view the built Record Source. I would like to put a debug point somewhere and be able to view the Record Source query that has been built so I can see why an error is occuring. Is there a way...

Hi there, Thanks for the help. Doc-Man no offence taken, thanks for sharing. I'll have another look and see if I can get any further. Thanks again. Best Regards,

Hi there, The programmer is no longer available and I have been asked to have a look at the code to see if I can help. This bit of code is in the form open event and I am trying to find where Me.Recordset("TaskId") is initiated or created. Thanks for any help. Best Regards,

Hi There, I am trying to find an issue in an access program but I do not know why there is a problem. I have narrowed it down to this piece of code: If (Not IsNull(Me.Recordset("TaskId"))) And Me.Recordset("TaskId") <> 0 Then there is a value in TaskId Else there is not a value in TaskId...

Hi There, I have an options box with around 5 options in. When I click on one of the options they all go grey as if they are disabled. I can still click on any one of them and they still work but visually it does not look good. Would anyone know what is causing this? Thanks for the help.

Hi There, I'd appreciate your help. I need to find out what has been added to a table and then add that for each record I have in a stringed list called "lstTasks". This is the scenario. I have a table of file links with multiple entries for TaskId. As I enter a procedure I need to get a...

Hi there, Can someone help me with how to use dbSeeChanges using my code below. Every thing was working fine with my code below until I had to use the primary key field in the sql statement. This is my code: Set dbs = CurrentDb Sqlstring = "UPDATE...