Search results

How can I access the research cited in the article? Sometimes it takes a bit of clicking, but I'm used to there being at least some way to navigate myself to the actual data when I read stories like this...

Thank you for insisting... That worked! :) I didn't try that at first 'cause I didn't think it would make a difference what number I used (really it shouldn't make a difference, right?). But this program is a strange one. Here's the finished code that auto-sizes all the columns with the option...

Thank you. Unfortunately that doesn't work. Here's code based on that principal and the resulting Debug.Print values. In every case, the returned value of .ColumnWidth is still -2 and not the width of the column. From your link: "I should note that I did try assigning a temporary dummy...

Hello! I am trying to determine the width of my columns in datasheet view. My code first SETS the columns to auto-width (.ColumnWidth = -2). I then have need to go and grab their widths (ie, need to auto-width them and then figure out what that auto-width is). When I go back to read the...

Is it cbm or cmb? Not sure that's really the problem (I would suspect something like that not to compile) but it'll be easy to check to be sure.

Consistency is the real key. I use cmb for comboxes, which I suppose could be a dyslexic's nightmare with cmd, but it works well for me.

A properly-built database shouldn't really have that many fields, should it? But I agree with using a mapping table. Only I wouldn't go with having DLookup() to fill the table with friendly names. Users don't often go to audit tables and that would slow down data entry. Instead, store the...

I gotta ask... what are you going to use these for? The title and OP indicate these are to be usernames. But don't usernames need to be unique or at least (and perhaps more importantly) tied to a user and not just to one another? By the relationship you are saying you want to set up your users...

Would love to see the rounded corner code.

LEFT([Field01],InStr([Field01],"/")-1)

If you'll only ever use the form to enter data, you can set its DataEntry and AllowAdditions properties to Yes, which you can do through the GUI - no VBA needed.