 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Labels on Form No Longer Preserved.
I have a form that is used to load data from Excel files to Access. To keep track of what was last loaded I assign the file and path to a label. The label had been preserved, that is you could load a file; the name of the file would be assined to a label caption; the form could be closed and whne you opened it the last caption assigned would still be there. All of a sudden it now comes up blank when it is closed and the opened. Any Ideas?? Thx Kevin When you close the form, try this: Docmd.Close acForm, Me.Name, acSaveYes  SignatureDave Hargis, Microsoft Access MVP > I have a form that is used to load data from Excel files to Access. > To keep track of what was last loaded I assign the file and path to a label. [quoted text clipped - 7 lines] > Thx > Kevin It reports that the form, "frmLoad" is not open. It is. ??? Docmd.Save acform, Me!frmLoad also reports "form not open". Again it is and that is its name. thx > When you close the form, try this: > [quoted text clipped - 14 lines] >> Thx >> Kevin >>I have a form that is used to load data from Excel files to Access. How does this work? SignatureKARL DEWEY Build a little - Test a little > I have a form that is used to load data from Excel files to Access. > To keep track of what was last loaded I assign the file and path to a label. [quoted text clipped - 7 lines] > Thx > Kevin It uses a TransferSpreadheet to load the data into the first Access table. From there an access query filters the data and moves it to a standard table. That works fine. Just the labels are a problem. Thx >>>I have a form that is used to load data from Excel files to Access. > How does this work? [quoted text clipped - 13 lines] >> Thx >> Kevin |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.