Search results for query: *

hmmmm I could do a compare of last modification and sent time... Thanks for the idea yoneek :)

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

bah! I should totally know that... Thanks for your help!

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

okay so... I'm an idiot some times. Totally shouldn't have drank so much last night :P What was happening what that I was linking tblfunction with tblVolume but by the function NAME not the ID. I thought maybe I could get away with it cause it was less coding. Apparently not. There are...

Oh ya, there are many many rows that have the same function ID with the same input date. The PK for tblVolume is comprised of inputDate, UserID, FunctionID, BusID, DepartmentID. The reason for this is that I need to allow a user to input volumes for any function, for business line, in any...

That's the thing, they are distinct records. If I use distinct on any one of the colums, i'll be excluding rows i need. What I have to do is sum up the volumes for the full month of August. There are multiple entries per user, per function, per day. Lets say I want to isolate one row that I...

gah hit the wrong button! So here's my table lay out again. tblCategory tblfuntn tblVolume categoryID --------->categoryID inputdate categoryName FunctionID------>FunctionID FunctionName busID...

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

Awesome, thanks for the help and the advice!

That's exactly what I'm doing, but it still doesn't show up. Dim objExcelApp As Excel.Application Dim objWb As Workbook Set objExcelApp = CreateObject("Excel.application") Set objWb = objExcelApp.Workbooks.Add Could it be a system config thing?

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

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

I'm sorry I should have been more specific. I was wondering how to do it with VBA. I'm pretty sure the conventional ways of exporting data from Access to Excel wont work for images. I was just wondering if there was some OLE object I need to use to get the picture from database onto the...

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?

Ah! This totally worked. Thanks for your help!

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

GAH! It's Alive!!!!!!! I remodified my sql statment with your suggestion above and it works like a charm. Thanks so much for your help :D

Thanks for your reply CMP, The field is a date (date/time datatype in an MS Access database, but formated as short date) When I tried the above code it gave me an error saying arguments are of the wrong type, are out of accpetable range or are in conflict with one another.

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