Search results

Hey there folks. Run into a pickle that I just can't seem to find documented in what I have available to me (which is mostly O'Reilly or MsVBA Help). Does anyone know the proper syntax for getting a comma-delimited text field (pulled via recordset) into a dynamic variant array using split()...

Heyo, thought I'd toss my line to see if anyone has had a corruption like this: Today I went digging through some of my tables on a db I've been building and noted that most (but not all) of my text fields had Unicode Compression/Off and Zero-Length-Strings/Allowed. Now, I know for certain that...

Sorry if this is just being obnoxious and you just didn't include it here, but you might want to dim strSql too.

Curious problem today. Working on the old international postal db again wanted to include a way to force automatic formatting of the various fields that go into creating a mailing address (Name, address1, address2, city, state/province, postal code, country). I have a country lookup table...

Damn those domain functions and their quirky syntaxes. Excellent Treason (doubly excellent fellow New Yorker). You've piqued my interest, I must say. Are you suggesting there is a method whereby I can check my non-numeric postal code against the already queried recordsource? This combobox.list...

Treason -- Thanks for the assist but it's particularly complicated because my second combobox (the one in question) is a text field. Specifically, the two comboboxes we're dealing with are an ISO Country Code and the Postal Code ... postal codes from different countries have different types of...

Heya folks. This is a pickle I've been working off an on for two weeks but now seems to be the time to stop it. I have two tables, tbl1 and lkup1 in an obvious many-1 relationship. The key for lkup1 is comprised of two fields key1 and key2 and we'll call the related fields in tbl1 fk1 and fk2...

So... NDA in standing -- When you just need basic recordset operations (retrieving data) or moving through a cursor or adding a record within one Access db, what do you use Pat? ~Chad

Yeah, I'm with you Ken. I'm very curious to know the advantages / disadvantages of each..

So playing along with one of my 2k databases this weekend and when I went to backup the database I had a very random error which systematically destroyed both my existing database and my new one *gah!* Well, I inspected what I could and found the MSysObjects table missing (never a good sign)...

ahh... simple guess work solved it: Response = acDataErrContinue... :)

Looking for a way to supress this message box... The text you entered isn't an item in the list. Select an item from the list or enter text that matches one of the listed items. ... when the NotInList event fires. Trying to just open an unbound modal form, pass a couple values to it, and set...

To do this, you'll need to have a datestamp attached to this time field, one would assume there is. So when you put together the recordsource combobox do a sort descending order by linking in the table your form is based on. Example, if your form is based on tblWorkTime and has the field...

Thanks SJ--caught that bit earlier but I don't think I understood it enough to implement properly. Or, maybe it just couldn't do what I wanted. The table I was working on was a postal codes table for international cross-compatibility (or at least as much as can be afforded for an average...

~ Why not just create a simple form with a text or combobox and a command button. In the textbox your user enters your equivalent of Contributor_ID including your * or whatever other 'catchall' you want. in the OnClick() event of your command button, then, you write a Select... Case...

Mile-O (or anyone else)... To expand on error handling further, if one wanted to supress the response altogether, would that be possible? (specifically, if one is opening a modal unbound form to add data not found in the combo...) Regards, ~Chad

Thanks for the reply Andrew. I think I've decided to make this an unbound form. I'll use ADO to add the record to my table. (It's a lookup table anyway so it shouldn't see many, if any new entries) and before the recordset updates I'm going to throw some checks for valid lengths based on the...

Here's a bit of a pickle I've been trying to wrap my noodle around. Anyone have an idea what route to pursue (unbound form, or afterupdate, etc?) to force a validation rule on the number of characters in a text box based on the value of combobox in the same form. Example: If cboBox1 = 840...

Did as you suggested and cleaned it right up. Thanks Pat! ~Chad

You know I initially thought I might've switched up the relationship too but I didn't. As for the relationship being shown, the error only shows up because I can't enforce RI as I should be able to do. Basically the issue is how does one set up a one-to-many relationship on a multiple key...