Search results

Thanks for the link and I knew the reason why it would hide the listings of the personnel before because I was changing the recordset of that cont. forms combo and since its all one instance you can't seperatly have them modified unless I create a class object to handle each row that I need to...

Forgot to mention the purpose of the 64bit changes in the connections was to make people focus on using the ACE connection objects but not everyone wants that. Another little 2 cents.

There for a while when it initially released it was almost impossible to get it to work so mostly everyone tried using the 32 bit development and code to keep it working under a 64bit OS. Even then there were conversion problems and hangups with the 32bit version due to the way it deals with...

Here is the updated file. Sometimes with code you feel like doing :banghead: but hang in there. It's the simple things that can bite harder. :D

I see what happend. You needed to replace your current GetDatafromTextFile function with the one I provided earlier. The one in the sample you just posted is the older function. I'll post the entire db with the changes back to save some problems.

You are correct the function was not putting it into an array I just opened it up in a recordset so I could scroll through it. I was not implying that my function had anything to do with an array so I apologies it sounded that way. I just wanted to give you an explanation on why your array was...

The fact that your application in the run time environment flashes leads me to believe the that form that your calling opens but "and this may be a far shot" have seen in the past that depending on the way the code is executed in the runtime environment it can cause the popup windows to be...

Thats correct because the ODBC drivers require different parameters and setup's to make them work. Plus they removed a ton of ODBC drivers from the 64 bit version and mostly focused on letting Jet do the job. It is a royal pain but it can be done.

Yup thats a tough one. I looked at all the src from the site and they are doing some hocus pocus in there to keep the data safe and also link purposes. I don't even know which direction I would take on this issue but good luck.

Your problably not going to run into complications with just that due to most of those references are internal to the office product will be X86 but if you work with any outside connections trying to connect to a SQL server or Oracle your in for a little bit of a headache due to the differences...

With that example does that make it clearer on what I am trying to do? I was able to write a function that builds the SQL needed to show the personnel by building a Crosstab query and then using a query on top of that to return only the individuals that have all the required courses in the drop...

Take a look at the function I revised in the example db I am posting. If you use the function called ImportFilesfromQuery that opens a recordset with the information from the query that you specified. Then I changed the function GetDatafromTextFile to use the file name being supplied and run...

Good to know and glad you got your logic working. I would keep an eye on the type mismatch and see if you can locate the line of code that is giving you that error but other than that congrats.

A type mismatch error means that some of the data was left out. You really need to double check hard because there might be some abitrary data in the file. The date function you are trying to do is not far off but you need to make sure your dates are in the same format for the comparision to...

Ok here is the modified file. I tested it against the example file that you sent and all works as far as I can tell. Let me know if you have problems but I generated a function in the Excel Functions module called GetDatafromTextFile Just call that function and it should take care of the rest.

Ok which table is this data going in?

Ok if you send me a copy of your db layout I can write the code for you but I hope that you have been learning and how code can work and how to get to certain resources.

Yes it is possible but are you asking to return the Filename: C:\Report_Data\Log Parser 8-10\MM9662\ENAProcessNotes.pnf And extract out the MM9662 from that string? The file itself with the data is easy enough to read but I need a little clarification on the MM9662 that you are refering to.

Ok so here is the corrected file. This has two people that are supposed to be able to do an inspector's position. The Inspector position required four courses to fill that role: 10865 - G320 10871 - G321 10872 - G322 10874 - G323 There are two people that have all those courses completed...

I appreciate the patiance. I have been crazy booked but I'll get it posted today.