Search results

Before I embark on writing something to do this, does anyone know of a way to sort the field names (not the field contents) so that in Table Design view, they are sorted alphabetically? For example, these fields: LName FName Addr1 Addr2 City State Zip Phone Email Would become this in table...

I have an issue whereby all of the properties of a field are not exposed at the time the field is created. This isn't really a problem, but more of a nuisance. For reasons I won't go into now, we have to set the DisplayControl property of a Yes/No field in a table to be Check Box. This is...

Not only do a lot of people not format code (nothing a copy/paste dump of 300 lines with no spacing), they use control names like textbox1, combo47, and form12. It drives me bonkers. This is in part from Expert One-on-One Microsoft Access Application Development. Please read it and understand...

I've answered enough, so I get to ask one. ;) I've written a little module that will accept a table name, read the indexes on that table and drop those values into a temporary table, remove the indexes, perform a lot of data manipulation (updates, appends, deletes, etc.), and then put the...

Not too long ago, I wrote a top ten ways to make sure your question was never answered. I'm going to append it. 1) "Help Plz!!!!!!!!!!!!!!!" does not an answer give. 2) http://www.access-programmers.co.uk/forums/showthread.php?t=85042 3) "I'm totally new to VBA" is not an excuse when you're...

I'm posting this in the general area as it will eventually save nearly everyone a headache of mass proportions. Any regular reader of these forums has heard myself and many others talk about the importance of backing up your data on a regular schedule. I've described my method in a little...

I'm not sure there's an answer to this (I think it's a bug in Access), but I'll go fishing for an answer for a change. ;) I'm going to have to be generic as the programming I do is of a confedential nature, but I think I can handle this. I have a form with listbox (amongst many other...

This is not a question, but a short tale on what's happened in the past few days for me. We have a ton of data where I work (several terabytes) and I work with a lot of it. For a certain report, I link into several Access DBs of varying sizes (500KB to around 500MB) and pull the data I want...

This is a pretty useful poster, which I found here (2.8MB PDF). It's formatted to be at 18x24, which can make it hard to print out and read. However, I chopped it up a little and made a little PowerPoint out of it. It's too big to post, so I put on my own site and it can be found here (900KB...

I've been here for two months and answered over 400 questions. I'm seeing a pattern here, and I have decided to post the best ways to make sure you are never answered. 10) Blood, sweat, and tears are for losers. Spend no time figuring things out on your own. 9) Announce almost ceremoniously...

I've seen a lot of people here describe the use of a hidden form with information stored on it that can be accessed by other forms. While it's functional, it's clumsy and referencing it from various other areas can become a syntactical test for the best of us. In that light, I'm offering what...