Search results

Hi all, I've searched on this to no result unfortunately.. but I am wondering if it is possible in Access/VBA to reference highlighted content within a text/memo box. I've tried several methods but nothing seems to work. This is Access 2002/XP. So for example, if my message above had the word...

Single Calendar Control Sample - Access 97 Single Calendar Control Sample - Access 2000 What these demonstrates is how to make a single form with one calendar control on it, and then call it from any other form in your database, even if that form has multiple date fields... This is something I...

I may have finally found a solution for those of us who would very much like to circumvent Outlook's nasty little problem with VBA-induced emailing. I found an activex control at this site... http://axsoft.hypermart.net/ it's called "axSMTP" & it's basically an SMTP control intended for...

Is there a way to get the index number of a list box row without the row being selected by passing the bound column value into VBA? Here's my example: If I have a row in a list box like this: A1 Apples B2 Oranges D3 Tangerines X4 Pineapple Assuming I want to be able to grab the index number...

I'm looking for a way to drag and drop file(s), i.e. from windows explorer into an Access list box. I don't need anything super fancy, just the ability to grab the path value from what is dropped into the box & have a procedure run from there. Is this even possible? I've scoured the web for...

Hi all, I'm reworking an existing database from the ground up & I've encountered an odd problem that occurs as a result of a procedure I'm building into a form. Essentially, what I'm doing is this: I have a form that displays a parent's information, and then below there are a series of tabs...

Is there ANY way to turn off the Outlook 2002 email warning asbout another propgram sending mail when I'm using the SendObject command from VBA??? It always worked in 2000... I use Access to run a lot of nightly stuff & this will completely ruin it... meaning I would have to sit here for 30...

Is there a way to convert a given hex value into it's corresponding character? If you look at http://www.asciitable.com/ as a reference, what I want to do is this: If a text box has a value of 64, I want to be able to return the subsequent character, in the case of 64 it would be d. [This...

I have a text file, similar to an .ini that I want to read only from an Access form... what I would like to do is populate a list or combo box with the section headings from this file, it looks something like this: ************** [Management] Manager One Manager Two [Support Staff] Support One...

Is there a way to clear the contents of an external file through Access? I want to import the contents of a text file into a database and then without deleting the text file itself clear all of the records I just imported, i.e. truncate the source file. I was thinking of compiling a small c++...

Does anyone know, or has anyone come up with a way to open a browser window from a hyperlink button and have it not display the toolbars, status bar, etc? Just curious... thanks!

I'm completely stumped on this, any help would be greatly appreciated. I don't currently use switchboards, I prefer menu-driven commands, as I can keep them consistent throughout my database, etc. I would like to be able to run VBA from a menu item instead of creating a macro for each custom...

Hi all, I was wondering if there is way to built an event based on whether or not a specific button/text control has the focus on that form. I wanted to add the ActiveX calendar to a series of forms... but as my space is limited, I created a single pop up form with the calendar control that...

Hi all, I was wondering if anyone knows how to write a property that changes a row color inside a list box based on a value within that specific row. What I have is a list of overdue orders on a form, the user can print the entire list (the report displays orders which are overdue by >13 days...

hello all, I'm writing a procedure that transfers an error log (the log is in text format) into an Access table, so that users can generate summary reports an analyze generated errors I've written the import specs, and they work fine. The only problem is, the error log is written...

Just a "curiosity question," (I'll use it if it's possible) Is there a way to have a single report toggle between portrait and landscape based on the section being printed? By this I mean for example, a charges report would have 2-3 summary pages, and then once the detail section comes up, the...

Hello all, My VBA journey continues... I wrote the code shown below for a form... what is intended to happen is that a user selects two dbf files from their computer and then once they do, the transfer database procedure runs and imports the files they have selected. I keep getting an...

This isn't somethingI absolutely have to do, but I thought it would be a nice addition if it's possible... I have several search results forms that use list boxes to display data. I would really like to be able to turn the column heads into "buttons"... and when a user clicks on the column...

Hello, I have created a form that returns a list of contacts with an outstanding balance greater than zero. the form is unbound, and the list results are being pulled from a query that returns the name & company name, and a charge/payment/balance summary... the bound column on the list box is...

Hi all, I'm creating a registration form, and I've set it up the following way: User enters the contact's first and last name. Once the last name field is completed, I run a check to see if any matching names already exist in the contacts table. If there are matches, a message box appears...