Recent content by MistyEE

Forgot to say...I still don't understand why it comes back type mismatch.... I am in a form, I have a control....

You will see that it is not really all that complex or pretty. just a quick way to apply your rules to the different series, to create a data file to import into an Access table. If you think you are gonna do this more than once, then I would definitely make something a little more robust...

If this is a one time thing---then I wouldn't spend a lot of time programming something for this. Okay..I know this is an Access forum, but I have something that will help you build an excel data file for importing into Access. It is an excel file with vba....the great thing is that you can...

I believe it could be done...since he is letting you use the dlls... Install the program; then go into Access and set the references in the IDE window, to the DLL file names (they might have a different title than the file names so watch for those). Now you should be able to use his object...

Sounds like you will need to call some Windows APIs; to get to the file properties of the selected diretory. Dev Ashish's site might have something...otherwise I am sure there are alot of folks in here who are well versed!

Okay...it is starting to uncloud here, if it is an access object as lagbolt said...then, as pbaldy had mentioned, it is probably in the calling. I will post the calling procedure below... What I am trying to do is read the properties of controls on a form in an external database. I can query...

Can anyone PLEASE tell me why I the code below produces a type mismatch error? It breaks on highlighted... Public Sub ReadFormProps(frmOpenForm As Form, HistoryID As Integer) Dim ctrl As Control 'to loop through controls Dim prpty As Property 'to loop through properties of...

Are you just trying to get the data...or imitate the code in Access?

which line is highlighted in the debug window?

Do you have one of the objects/properties, etc set to a global variable? That will hold it open until access is closed also.