Hello,
I'm having a problem having a recordset show up in a form. I designed the application and everything connected to the database just fine ..... all information showed up on the form correctly........... I could scroll through the recordset and select another name and the information for the person I selected was accurate. Well, the users had compiled more information in an Excel spreadsheet that they then wanted added to the SQL database for the application. I thought "No problem" I would just import the additional information (new records) into the SQL database. Well I did that and I get the employees name to show up so it can be selected but when the form is populated none of the information that is in the table shows up in the form. I already had a trim function. I go through debug and for some reason when I select one of the excel imported names the recordset .EOF value is True which would indicate that there are no records. I'm at a loss on where to look next. Has anyone had a problem similar to this? Thanks for any help you can give me.
Corinne
I'm having a problem having a recordset show up in a form. I designed the application and everything connected to the database just fine ..... all information showed up on the form correctly........... I could scroll through the recordset and select another name and the information for the person I selected was accurate. Well, the users had compiled more information in an Excel spreadsheet that they then wanted added to the SQL database for the application. I thought "No problem" I would just import the additional information (new records) into the SQL database. Well I did that and I get the employees name to show up so it can be selected but when the form is populated none of the information that is in the table shows up in the form. I already had a trim function. I go through debug and for some reason when I select one of the excel imported names the recordset .EOF value is True which would indicate that there are no records. I'm at a loss on where to look next. Has anyone had a problem similar to this? Thanks for any help you can give me.
Corinne
