Search results

You could use listindex property to check if an item is selected.

You could pass the primary key of the newly created record to some variable then use find.

You could try to add " or is null" in your statement.

DMax(Len(rs.Fields(i).Name),strobjectname) will be firstly calculated to DMax(Numberic Value,strobjectname) , so DMax will not return the right thing you are looking for. You'd better to use select ... max(len(fieldname)) from....., will give you the max len and the field value. By the way...

No need to create an excel application for this case as Set xlwb = GetObject(myPath) will create an excel instance. Remove all codes about xl then Try below code: xlwb.Application.Visible = True xlwb.Windows(1).Visible = True