Search results

Hi. It's been a while since I've used access so I'm a bit rusty. Not even sure if it can do this but thought I'd ask. I have a set of remote users. The type of users who have difficulty understanding how to detach an attachment from an email. These users need a slight change in the...

Very curious stuff has been happening as of late and I'm wondering if anyone has run into the same issue as I whereby a form becomes disconnected from it's module. All of the code remains in the form module and private non-event subprocedures will run but if one were to check the properties...

Heya... I just went looking for a piece of the forum I used often (modest's post about using rs.collect) and a google result brought up old access world forums pages (ones that don't exist anymore...) ... well, actually they do... Google still has them cached. If there are any posts you...

Okay, seems like it should be simple... maybe I'm wrong though: Any one know how to do real-time counting of the number of characters in a text box so that once it reaches 3 it automatically moves to the next text box? (Doing a phone number ... area code (int) and phone (long) to make for a...

Is there a 'catch all' way to select only the controls found within a specific section of the form... say I wanted to perform an operation on all the controls in the detail section of the form but not those found in the header or footer? Any quick way (collection) to this solution? Many...

So I've poured through the Access 2000 Sybex books and can't seem to find what I'm looking for... curious to know if anyone else has run into this: I have a couple reports that I'm using an automated print (to ghostscript) --> zip --> email function for but Access, like the rather unintuitive...

Heya folks. IT just switched all our pc's over to Office 2k3 (from 2002) and now I'm having some -very- curious behaviour in my modules and wondered if anyone else had anything similar... So, I've created a few custom functions to do various pieces of business for me in a new database, the...

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...

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...

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 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)...

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...

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...

Okay, anyone have an idea what's happening here? It seems like it -should- work to me but it's not which leaves me to wonder where I'm missing something. :confused: Any help'd be appreciated. :D Thanks, ~Chad

Anyone know why I might be getting a type mismatch error with the following? Private Sub cboBusinessTypeID_NotInList(NewData As String, Response As Integer) On Error GoTo Err_ErrorHandler Const Message1 = "The data you have entered is not in the current selection." Const...

Anyone know the proper syntax for passing string variables to d-functions as arguments? I keep trying variations on what's found below but to no avail. Dim strTable as String Dim strField1 as String Dim bytResult as Byte strTable = "Table" strField1 = "Field1" bytResult = DMax("'[" &...

Datasheet / XLS object created in function only... Okay here's an interesting ponderance-- We all know the DoCmd.SendObject or the DoCmd.Export etc, with acFormatXLS. But, does anyone know if its possible to create an XLS object that exists in the vba itself and can be passed to other...

So this may seem like a bit of an odd duck question but I've about 20 or so fields in a certain query that all require a certain set of calculations (all of which are related). What I'd like to is extract the field name of one of my arguments as a string and use it as a criterion for how the...

So I used the last hour or so looking for a similar query to no avail. Thought I'd throw this to the wolves as I keep stumping myself somewhere around the DMax(). Basically we're converting an old 97 database with very bad keys and no naming system to a newly modeled 2000 db. In our old system...