Runtime error 3420,Object invalid or no longer set (1 Viewer)

M

moodleybr

New member

Local time

Today, 21:40

Joined

Jul 29, 2013

Messages

3

• Jul 29, 2013

• #1

If(objRS.RecordCount >0) Then i = 1 j = 1 objRS.Move last.

The error message is in red.

 

pr2-eugin

Super Moderator

Local time

Today, 10:40

Joined

Nov 30, 2011

Messages

8,494

• Jul 29, 2013

• #2

Hello moodleybr, Welcome to AWF..

We need to see more coding to help you, general help is, make sure the recordset object is not closed before executing this line, make sure the object is Set..

PS: Please use Code Tags when posting VBA Code..

 

M

moodleybr

New member

Local time

Today, 21:40

Joined

Jul 29, 2013

Messages

3

• Jul 29, 2013

• #3

pr2-eugin said:

Hello moodleybr, Welcome to AWF..

We need to see more coding to help you, general help is, make sure the recordset object is not closed before executing this line, make sure the object is Set

Click to expand...

Hi. I have uploaded the coding via attachment.

 

Attachments

• back_order macro.txt

  2.9 KB · Views: 235

pr2-eugin

Super Moderator

Local time

Today, 10:40

Joined

Nov 30, 2011

Messages

8,494

• Jul 29, 2013

• #4

That is strange, the code looks alright to me.. I think this needs another pair of eyes.. Someone should be coming along.. Sorry could not be of much help here..

 

M

moodleybr

New member

Local time

Today, 21:40

Joined

Jul 29, 2013

Messages

3

• Jul 29, 2013

• #5

pr2-eugin said:

That is strange, the code looks alright to me.. I think this needs another pair of eyes.. Someone should be coming along.. Sorry could not be of much help here..

Click to expand...

cool any help from the crew would be appreciated.