Search results

Thanks for your reply. Yes, I see the reasons for it. However, it takes away virtually all VBA-advantages. If you need to automate outlook, you will probably need to send email automatically, and this makes it impossible. Brilliant! Anyone else know what to do? Fuga.

Hi, I have an automated emailing function in a db. On an XP machine with outlook XP or Outlook 2003, the message; "Program is sending email on your behalf..." appears, making the emailing function totally useless of course. I noticed there was a similar thread on this topic, but I did not...

Yes, I was afraid of that. What I do now is I use the "ldownload" function to save the source as a text file. It works ok, but when it comes to some pages that have paswords etc, the "ldownload" function only retrieves data that can be view when not logged in. This is true even if you in fact...

Thanks for your reply. I see your point. Unfortunately, I´m not very good att internet programming (I tried once to make a connection between an access db and frontpage (supposed to be easy) and I failed, so you get the idea...) However, if you can download the information manually with the...

I´m thinking of starting to use office XP for a small system I have. My question is: Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven´t been able to do what I want. Fuga.

Hi, I´ve installed office97 professional on a computer with office 2003 standard on it. When I try to start access it tells me there is no license for it on the machine. Has anyone else had this problem? Of course I have a license, and there has never been any problems with it in the past...

Hi, Is there a way that I can save the contents of an activeX - control. In this case, there´s a picture in the webbrowser that I cannot save locally. Fuga.

Hi all, I don´t know if this can be done at all. When a process of some kind is using a file, you can´t access it in anyway, can you? The reason is we have an application that locks files it is supposed to go to work on (it is a printer, merging two or more pages together before printing)...

Hi, Is there a way in vba to retrieve your current IP-adress? thanks. Fuga.

I´ve sent a db to a friend who´s using XP. I use win98. Of course, the date() function does not work. I´ve had this problem before and as I recall there was a reference missing. Only this time, there isn´t. I´ve searched the forum, since I know this is a frequently occurring problem, but I...

Hi, I have a form with an excel chart linked to it. The chart, however, does not look good on the access form. It does not seem to be able to show the part of the chart which is below 0 on the x-axis. Has anybody had this problem? If not, is there another way I should go about this? I import...

Hi, I need an automated process which 1.finds a web page 2.saves the web page as html. Does anyone know how to do this? I use win 98SE and office 97pro. I am somewhat familiar with vba. Fuga.

Thanks for the reply. The reason I asked was I wondered wether I should recommend a friend to buy office even though he´s already got staroffice. I guess the answer is yes. He needs VBA. Fuga.

Hi, Is "Staroffice" VBA compatible? Fuga.

Hi, Is it possible to have an access application check if a program is active and, if it si not, start it up? The application is on a network, on an OS X computer. How would you do this? Fuga.

Thanks for the reply! 3075 - syntax error(missing operator) in query expression is indeed the message I get. I might have made a misstake with the datatypes. "loppdatum" is indeed a date. I´m not at work right now so I´ll have to check it out later. I'll let you know how it works out...

Is it possible to use a variable in the where clause? *** Dim rattdag as string, rattlopp as string Set rsdogs = CurrentDb.OpenRecordset("SELECT Starter.Loppdatum, Starter.Startnummer where starter.loppdatum =" & rattdag & " and starter.startnummer =" & rattlopp " FROM Starter ORDER BY...

Thanks for the reply! I asked a really stupid question. Sorry. What I meant was that the data looks like this: 1/1/44 1/2/13 1/3/25 2/1/22 2/2/55 2/3/11 etc So, what I want is (extra column for ranking) 1/1/44/1 1/2/13/3 1/3/25/2 2/1/22/2 2/2/55/1 2/3/11/3 Actually there are 6...

Hi, I would like to rank participants in a race from 1 - 6. The data looks like this: race(integer)/ startnumber(integer)/ odds(integer) 1 / 1 / 44 1 / 2 / 13 1 / 3 /...

Since you are thinking of hardcoding the filenames, I take it the parameters won´t be the same all the time. Where do the parameters come from? a table? The user? Fuga.