Search results

Hi, I have a table in Excel with number of prints along the top and postcodes down the side (see example, below):- Prints..1....2.....3.....4....5 AA....£1...£2...£3...£4...£5 AB....£2...£3...£4...£5...£6 I use VLOOKUP and MATCH forumlas to return the results. How would I achieve something...

Hi Paul, Thanks for the reply. Yes, I have tried the Format option as well, but still no joy. The original format of these dates is "mm/dd/yyyy hh:mm AMPM". For example: Format ([2/22/2012 12:00 AM],"dd/mm/yyyy") returns 22/02/2012 Format ([3/7/2012 12:00 AM], "dd/mm/yyyy") returns...

Hi all, A csv file I am working with has the following example dates: 2/22/2012 12:00 AM using DateValue converts it to 22/02/2012 (dd/mm/yy) which is correct 3/7/2012 12:00 AM using DateValue converts it to 03/07/2012, but it should read 7/3/2012. It seems like some sort of date conversion...

Hi Mark and thanks for replying. I'm having an issue with this, but it may be because I haven't placed the code in the right place. What form event do I place this code in?: Dim ctrl As Control For Each ctrl In Me.MyCtrlSubset ctrl.SpecialEffect = 1 Next ctrl I've placed it in the OnCurrent...

Hi all, I have the following code in the OnLoad event of a form: Dim ctrl As Control For Each ctrl In Me.Form If ctrl.Tag = "cmdSpecialEffect" Then ctrl.SpecialEffect = 1 End If Next ctrl There are several buttons on this form. I could place a MouseUp/MouseDown event behind each one so that...

Got a bit further with this and have this error on the following code: "the execute permission was denied on the object CreateTable": On Error GoTo myError Dim dataConn As ADODB.Connection Dim dataRS As ADODB.Recordset Set dataConn = New ADODB.Connection dataConn.Open "DRIVER=SQL...

Okay, I have a bit more info. Apparently, I need to execute an SQL stored procedure via Access, but no values are returned. Apparently, this SP updates a table in SQL. I've been told that I can use a pass-through query or ado methods. Now, my two questions are:- a) which method is best...

Hi there, I've, today, created my first pass-through query (wahooooo!) which links my Access 2007 db to a query in SQL Server. Is there a way that I can refresh the SQL Server query from Access? For example, when I "refreshall" from Access, the pass-through always remains at the same number...

Hi there, I've been trying to work this out for ages, but can't get my head around it. Example data: A = 1 A = 2 B = 1 C = 1 C = 2 C = 3 D = 2 E = 1 E = 3 I want a query to filter-out any letters that have a value of 1 or 2, but not 3. Therefore, the result for the above data would be: A...

Isn't it weird. You spend ages Googling, foruming etc to find the answer you want. When you eventually can't, you post on this marvellous website. However, as soon as you hit submit and post your query, you get a eureka moment! And, voila, you answer your own question! Set fld =...

Hi all, I need help with this line of code:- GetSharedDefaultFolder(myRecipient, olFolderInbox). How would I access a user's folder other than Inbox, Calendar etc? For example: GetSharedDefaultFolder(myRecipient, olTestFolder), where TestFolder is not a subfolder of Inbox. Rgds.

Hi Paul how are you? I remember you from MDBMakers days and you helped me extensively during my Access initiation process, so many thanks again for your help back then. Yeah, thanks for your reply. To cut a VERY long story short, you are absolutely right as usual. The code does work as it...

Hi there, I'm trying to find an exact match in a body of an email. Obviously, InStr does not help, but apparently Split does. However, I am not sure how to implement this. Here is my current code: If InStr(1, msg.Body, "AB312") > 0 Then Msgbox "Found" Else Msgbox "Not Found" End If...

Finally found the answer elsewehere: This applies if you are using a for each loop, apparently (which I was). Have changed to With/Wend and it works!!!!

Hi all, I have code which iterates the contents of an email folder and saves the message body of each email to a text file. I also have options to select date range etc using the ReceivedTime property. This works without fail. What I am also doing is once the data has been copied over to the...

Thanks for replying Darbid. I've actually gone a different root and saving the data to a text file which gives me more scope to format the data to how I want it. Cheers again.

P.s. Forgot to mention that when using my existing code, it puts the whole content of the email body into on excel cell. When manually copying and pasting, the message is pasted over several rows and replicates the body of the email. Thanks.

Hi all, hope you can help. I have been Googling and searching all morning, but am still stumped. :o I have code which extracts the "body" of an Outlook message and populates to an excel spreadsheet. The problem is that it is very difficult to delimit the data once in excel as many "question...

Hi there. I've tried DFIRST, DLAST, DLOOKUP but I cannot get this to work. This is what I am using:- DLookup("[EmployeeHours]", "tbl_Hours", "[EmployeeID]=163 And [DateChange]>=#" & Me.txtDate & "#") This seems to work one minute but not the next. A bit hit and miss. Please advise. Many...

Thanks for your reply gents. Much appreciated. Paul.