Search results

Having never used class modules before, I am wondering if i am able to define my own custom object like a command button, that has common methods with each new instance of the same button. In my current concept, I have a form with about 20 command buttons whose click, gotfocus & etc events are...

Thanks all your responses have been helpful

Thanks I will do some research on self joins!

Super - thanks Doc Now I can hand it in to my teacher. just kidding (I am sure that teachers are smart enough now adays to search the answers online to see if someone is copying) I did some reading also on the earlier post re- recursion - wow - but a little over my head right now - will...

LOL No, I am learning it all on my own I just know that I am often looking at holding a little bit of information and have used dictionary items, tags, custom database properties, arrays etc but have often wondered say - should I use an array this time, or should I use a dictionary object -...

yes - I forgot the registry and of course a text file I don't necessarily mean storing a lot of data - maybe even one letter or integer! I was hoping someone has tabled all the advantages of each!!! Anyone?

I am trying to diod some research on the best places to store data when building a msaccess database application. I have found that yiou can store data in several formats & in different places - each having different advantages as far as scope, speed, useability, memory use, access, etc. I am...

I guess I/m hosed for 1 days work, now I'm making a backup every 22-3 hrs I guess. According to Microsoft, you can only delete user defined database properties but in my code I accidently deleted a bunch of builtin properties using: currentdb.Properties.delete ... bad mistake!!

"The database is in an unconverted state! This database has been converted from a prior version of Microsoft Access by using the DAO CompactDataas method instead of the Convert Database command on hte Tools menu. This has left the database in a partialy converted state...." I got this msg...

Yes that is what I was thinking next

Wow - I never thought of that - good idea - maybe I ll work off the drive vol

Is there a VBA code snipett to aquire the Windows Product ID from the operating system in which VBA code is currently running in? In licensing my simple distributed application (low security), my plan is as follows: After trial period expires, user is to email me with their name & company &...

Awesome - thanks

Thanks but it doesn't work: When the code finishes OpenExit: Exit Sub the error msg still shows. I've tried everything I know!

Please help I am trying to stop the err msg 2501 after the cancelling the open event - I tried on error resume next - didn't work Help access 2003 VBA the following is a simplified example in a form's module: Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer)...