Search results for query: *

~ We are having a similar problem and wonder if anyone ever found a resolution to the above issue. We have Outlook 2K and need to send broadcast emails (so everyone gets their individual "TO" field and sees no one else). But we also need to include both graphics and text in those...

~ Syntax for @ and & in VBA criteria string In an Access97 query, the following criteria works perfectly on a text field containing email addresses: Like "*" & "@aol.com" However, I cannot seem to get the syntax correct to use that criteria in my VBA string variable...

~ VBA Export to text file As suggested, I tried modifying my code with quotes around the Recordset variable for the TransferText argument: DoCmd.TransferText acExportDelim, "dbUsers", "rstEmail", "C:\myAccess\expSQL.txt" "rstEmail" doesn't work...

~ VBA Export to text file I have spent a number of hours on this problem but can't see what I'm doing wrong. Any help or direction anyone can give me will be greatly appreciated. Table: tbl_Users Multiple fields, but only one for this test Field: myUsers a 15 character text field...

~ Dan: Thinking of future users after I leave this site, I can't set Outlook options manually. Plus, I'll also have to add a variable at the beginning of the function to hold whether or not Outlook is already open when the code runs so that I can "IF it was open, THEN leave it open&quot...

~ Access97 Automate Outlook97 Send Access97 database Automation code to create and send emails using Outlook97. I have little to no experience with Outlook itself. My users do not keep Outlook launched and running. My Access code correctly creates an instance of Outlook and MAPIsp32, creates...

~ Rod: re: WD40 and duct tape -- the partner has to be willing? ;} re: 'Object invalid or no longer set' -- I've resolved the issue using Microsoft Knowledge Base Article - 160875 : ACC97: TransferDatabase Causes Page Fault If Object Exists...

~ Combobox Arrow Size problem in Access97: Other than using an arrow picture over the Access combobox or inserting a Microsoft Forms 2.0 combobox, does anyone know a resolution to this Access combobox short arrow issue? Thanks in advance for any insight. db ~ ~*~*~*~*~*~ All you need is a...

~ tunsarod What are your operating system and Access versions? I'm Win98 w/ Access97 -- and I've been getting the same behavior as you and Frodman, whether using code or the menus. Has anyone found the resolution? db ~*~*~*~*~*~ All you need is a can of WD-40 and a roll of duct tape...

:) Combobox Arrow Size problem in Access97: I need a couple of comboboxes to be 1/4 inch or more in height. However, Height = .23" or more gives comboboxes with short arrows. I have been searching off and on for a couple of weeks now for possible causes/resolutions for this behavior. I...

Thank you, arebelli. Absolutely perfect. DB ~*~*~*~*~*~ All you need is a can of WD-40 and a roll of duct tape. ~*~*~*~*~*~

I have a text field, size = 20, required. The acceptable data must be numbers and dashes, for example: like you would find in a telephone number (123-456-7890), a social security number (123-45-6789), or such ##-## structure. No other symbols, spaces, or alpha characters can be allowed. I...