Search results

Hi All, I've written this Transposer function that takes the name of the source table and transpose(switch rows,columns) into the destination table. Everything works fine, except when there's space in the data fields. For example, if the original source table was a 5X6 and was filled with...

Hi All, I'm not sure where to put this question - forms, VBA, or query. So I put it here. So, I'm trying to display data that is in "percent" format in Textboxes on a form using a DLookUp of a query. Each textbox on the form has the following VBA code as its ControlSource...

hi All, Is there a size limitation on how many rows an Excel 2007 spreadsheet can have when importing to Access 2007? I have about 9300 rows of data in Excel(not big) and the eventual size will be much bigger. The file size is not even a 1000 kb. But even now, it's taking forever to import...

Hi All, So, I've built this fancy db app with nice frontend and it does a bunch of CRUD operations , etc. etc. What I've noticed is that the db gets FAT and BLOATED very quickly. I tested it by viewing the data in various slices and the db grows by 2-3x in matter of minutes. If I continue...

Hey Guys, So, I got a label created from using CreateControl. Let's call the label ctl. I can set the Name, FontBold, Caption, etc. just fine. However, I'm running to a problem setting the BackColor. I've did a search on MSDN and tried their examples as well as the examples on this forum and...

Hi All, I just ran across this Access World Forums. Looks like a great resource. I have some questions about design & implementation to handle concurrency in Access 2007. And I did a search on the keyword concurrency in the forums. From what I've read and other resources(books,etc.), it seems...