Search results

Weird. Glad you got it working though. Have a good one.

Something like the following would be close to working. For i = 1 to xlsSheet.UsedRange.Rows Step 1 if isnumeric(xlsSheet.cells(i,2)) = True then R = i Exit For end if Next i

Yes you should be able to scan the couple of rows and use a function called isnumeric() and evaluate to see where the actual rows of numbers start. Depending on how many rows it had to scan down then that should tell you how many rows it needs to step through. After you have determined that...

Ok try this one. I noticed that the program would not compile so I debugged and noticed it had a missing reference for the Microsoft DAO 3.6 Library. This should have not directly affected the FileDialog library but was a necessary addition for it to work. Please let me know if this fixes...

Can you remove your password protection on the VBA modules so I can look and repost the database please. BTW I like the main form :D Looks like you been busy

Hmm can you make a copy of your database and dump out the data and post it here so I can have a look at the code? I used the old one we had I would just like to review a few things but as far as I can see there are no problems.

The FileDialog Class and it's property .AllowMutiSelect (which is set to true in the function) are appart of the Office Library. I tested this on a Windows 7 machine and it worked correctly. I can't imagine what exactly could be wrong as I believe even if they did a minimal install of office on...

Hmm I just tested it on a Windows 7 machine and it worked just fine. Does it give you errors when you try and select multiple files or does it just not let you select multiple files? Also did you make sure you created the folder on your C drive that says Report_Data ?

I don't know for sure but I'll take a look today.

Extremely nice example of what we can do with initing subforms and I enjoyed the scroll bar. I also had to laugh about the XP service pack statement :D Glad we are having some fun with Access instead of doing the same old thing everyday :D

ChrisO thanks again for the perspective. I doubt I will spend a ton of time on it but I'm still a little curious to find out if it is in fact just a painting routine but initing subforms on a form is a great idea. I would imagine to mostly make it complete someone would need to possibly tap into...

Take a look at the following link to my video demo of what I am doing inside of access. If anyone want's particular code I will send but I do intend on posting all of it in the samples area once I get a clean copy completed. http://wl.filegenie.com/~MAInboard/Access Dynamic form Demo.avi If...

Good point ChrisO. One thing though that makes me believe we can make controls unique on a continuos form is the simple fact that if you put a command button on one and have a few records. Click on that button. Does all of the buttons press down when you do this? No. So even though their code...

Thanks for the reply lagbolt but you can in fact override or provide access vba the ability to detect and tap into certain events through collection classes. It's the same concept as .net or java or whatever OO language but it still works with vba just in small portions. I want to assign...

I am wondering if anyone has figured out a way to make objects to support adjusting continuous form controls making them unique in a sense to be able to change info like captions or whatever. I've been working with collections for a while now tapping into event handlers such as the mouse...

Glad to hear you are up and running. Good Luck!

You don't want to use the thousands before your summing. After you sum then use the format on that and it will work. Ok good luck.

No worries after finally getting some sleep I remembered it was not supposed to be zero's in the field but pound signs. So it should have looked like format([Field], "###,###") which should work never the less I am glad you came up with a modified solution. Good luck

I think you can do this format([Field], "000,000"). Try that and see if that helps. Also to add another reason it's prompting for a parameter is one of your fields may have incorrect spelling of the field name or if you have a criteria set that is no longer applicable. Just look around and...

My point being if you are reading from the table with your form and consolidating the table with your code you get buffer overflow problems and is why you are likely recieving the error you got about multiple users. This happens often but you can clear the buffer on the fly and it will work by...