Recent content by johnmidcap

Good evening. I am totally new to connecting to mySQL and have been trying to connect for a day now. I appreciate any guidance. I have 5.1.6 and set this driver up on my computer. No problem connecting to the mySQL database. I am trying to write VBA in an Excel spreadsheet that requires a...

Good morning. Can someone point me in the correct direction about how to reference a specific form instance in Access 2007. For example, I have three of the same form opened as instances (i.e. a user is looking up three different customer detail records at the same time). I need the program...

MajP, Thanks! That works and saved me lots of angst. Thanks again.

Thank you. However, I do not see Microsoft Common Controls 6.0 as a reference. Do I need to download?

Hello. I migrated to Access 07 from Access 03 and once of my forms that uses treeview controls very extensively is not working in 07. It stops at the first DIM nState as Node declaration by saying user-type not defined. Any suggestions? Thanks.

Hello. I have no problem populating a listbox from a recordset with one column but am having a lot of difficulty trying to figure out how to do it with two columns. Any help is appreciated. Thanks, John

Hello. I'm a long term Access 2000 & 2003 programmer and just recently our company moved to Access 2007. A large mde (split fe and be) that we upsized to SQL, allows a user to login and then opens the Project again using the code below. The empid = 1 which runs a piece of code. The problem...