Search results

I agree and maybe I would say the same, but I kinda/maybe need this to work with JET as well as it is going to be a Forms Record source and all the Pass-Through stuff is going to cause what's left of my hair to fall out. In building my SQL's because I really have problems with SQL - I test them...

That took less time than I thought to test. This returns the ultimate TOP 1 (if I can call it that). My little table above is just one example of a q_akz from the table. It must do this for each q_akz. My query needs to return the TOP 1 for each different q_akz .

I hope not, because I now think my SQL does have a problem (other than it takes a long time). I will take a closer look at your suggestion and test. The idea is that I would like the newest q_decision_date or the highest q_decision_number from the q_akz. As you can see it is possible for...

One thing and I know it is a little off topic but maybe it is not too difficult. The view in SQL Server looks like this SELECT mt1.* FROM Lutadmin.tbl_questionnaire mt1 WHERE (q_id = (SELECT TOP 1 mt2.q_id FROM...

I will have to do some research on what "compsote indexes" are. Right now I have moved my base sql as a view in SQL Server and then linked the View to access. No I am just executeing a where on the view and it is working much much faster. This might be my solution.

Hi spikepl, q_id, q_akz, q_decision_date, q_decision_number, q_bkz_id are indexed - but I cannot index them all as potentially the where could be anything.

I have the following query (I am sorry if it is not formatted correctly) SELECT * FROM tbl_questionnaire AS mt1 WHERE mt1.q_id=(SELECT top 1 mt2.q_id FROM tbl_questionnaire as mt2 WHERE mt1.q_akz=mt2.q_akz ORDER BY...

I am guessing here, but there are two things I would be looking at. 1. what type of email is it - HTML, RTF, TEXT 2. what "type" of paste are you doing into excel. What I would suggest is you do it manually like you have but record a macro in excel while you do it. Use the paste special to...

actually looking at the page I think it is pretty easy. Basically the HREF is a pretty good id CFFLAG is the name PURC - is the column I would follow what you have already started but just use "instr" To build flexibility you can use a select for the columns like this - you cannot cut and...

so you want to click on the link in the first column named "ready for vendor" for CFFLAG? so now why? what is the criteria ? Vendor name and column or what. Of do you always want to click on the first colum for CFFLAG

You have got your work cut out for you but you are on the right track. You can add as manny attachements as you like to an email as long as the email is not too big to be sent. So yes you will have to check for files attached to the inoivce record and if they exists attach each one. You could...

Words like "along with pictured associated to the "job"" or "But I was hoping to have a PDF created and attached "on the fly" rather than save to disk" confuse me. In my opinion "on the fly" has nothing to do with saving to disk. A program that does something on the fly must "save" it work...

There are a couple of ways to get folder, none of them easy. First you can make the Folder Picker dialog come up and then the user can choose a folder. see here http://www.outlookcode.com/d/code/getfolder.htm Secondly you can also work it out like this Public Function GetFolder(strFolderPath...

Hi Aubreylc, From my reading of the thread you need to be very specific on what you want. IE automation is not easy and is not black and white as you have found out. There is no ID so we need to make guesses about what the server will give IE and make assumptions based on that. 1. Is the web...

Look at this post which shows how to find something in a folder. This is an appointment item but the same principle applies. Change to mail item and change it to the folder you are wanting to search in. http://www.access-programmers.co.uk/forums/showpost.php?p=1000549&postcount=6

Thank you.

I receive about 100,000 records from another Database in Access 2003 format. I then read this data into my own database. Given a column how can I query it to find out which record has the most number of characters in it. Something like a MAX(LEN) function.

Ok to read the contents of you email you would have your email as an object eg myEmail. Thus you key is this below which is above in my original example olkSource.items.Item(intIndex).Move olkDestination I am guessing this must be pretty damm close myEmail.Move olkDestination As for this I...

You will move them because of an event that you will watch for - or if you initiate the code then you will have to get the email and maybe check the subject or the TO or FROM and decide whether to more or not.

This is not my code I have copied it to show you how to move emails from a folder - Thus you will learn how to get a folder and then how to get an email within that folder and how to move. source...