Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jadedinvasion

    How do I get reply status on outlook mail items in vba

    Hello everyone, I wonder if it's possible to get any reply information from a mail object. Specifically, I would like to get at the information on an email that's located at the top after the email has been replied to. It looks something like: You Replied on 4/19/2011 at 3:45 pm Is it possible...
  2. jadedinvasion

    Variables in control names

    Is it possible to use counter variables in control names? I have a series of dropdown boxes named cboDept1, cboDept2, cboDept3 ect.. and was wondering if I could reference them in my module with a variable instead of hardcoding the names. Something like cboDept & intCnt &.value (I know that...
  3. jadedinvasion

    Query producing duplicate records

    I'm having an issue with a query I'm writting in Access. It's producing duplicate results and the best way to explain it is I have one distinct record and the query is producing it a second time. to start off with here is my table set up tblCategory tblfuntn tblVolume...
  4. jadedinvasion

    Viewing a newly created excel spreadsheet

    Okay, this is a total newb question, but I'm hitting my head over this one. Just can't seem to get the right phrase to google... In my vba module, I'm creating a new workbook which is all fine and dandy. Since vba creates the workbook in the back ground (for lack of a better term) it's not...
  5. jadedinvasion

    User entering Values into a list view

    What I need to have is some kind of control that will list a bunch of products and have the ability to have the "amount" of that product entered in beside it. But because the list of products is dynamic, (based on a combobox selection), I can't just hard code them into the form. Also, the user...
  6. jadedinvasion

    Extracting an Image from an Access Database and Importing into Excel

    I have an image (bitmap) stored in a table in an .mdb file and was wondering how to extract it out onto an excel spreadsheet. I've been digging around and haven't anything all that helps. Any Ideas?
  7. jadedinvasion

    need help with strings and excel forumla's

    I've got a bit of a head scratcher on my hands. I want to assign a formula to an cell on an excel spreadsheet, but the formula itself contains " (example below) objWB.Worksheets(1).Cells(10, 17) = "=SUMIF(B10:M10,">0")/COUNTIF(B10:M10,">0")" Obviously this isn't going to work. I tried being...
  8. jadedinvasion

    ADO Recordset Filter using date criteria causing an error

    Okay so I'm having an issue with setting a filter on a ADO recordset using a field that has a date datatype. Here how I set up my connection: Dim objStatConn As ADODB.Connection Dim objStatRS As ADODB.Recordset Set objStatConn = New ADODB.Connection objStatConn.ConnectionString =...
  9. jadedinvasion

    Close a report, closes whole database in MS 2003

    In the Database i'm working on, users are able to run several reports. But when the reports are run, they automatically close the database once the report has been printed off. I have tried different options in the docmd.openreport call (i.e. acViewPreview, acViewNormal) I get the same results...

Part and Inventory Search

Back
Top