Recent content by diezzz

I don't know if it can be done, on BSD wget <adress> -o file.html grep "file to find" file.html (PS i suck on bsd as much as on VBA). I would like to automaticaly extract in Access each day when i press a button a table from a site. As for example, if possible, everytime i press this button i...

Hello, I'm trying to create a form that will pop-up every 60 minutes. I have no ideea how this could be done, i can't manage to build an event or something to make it pop every hour. Can it be done or are there any alternatives? Thanks for your answer, Diez

That worked great, thanks alot. However i have another question. In a mail the attachement is shown as a little telephon icon. The body of the mail is : Simply click on the "link" to have acces to the application, or use your desktop icon (the phone icon here). Bla bla bla... However, when i...

Hello, To build reports i use querys as source, however i do not build themin acces, i simply copy the query result and paste it in excel. Moslty i'm using crosstab querys, and as columns i have a field that can always change values. So after i copy the results in an excel, to have the final...

Hello, I've built an automatic mail to send from time to time to some usors. The mail is dispayed when i run a macro and then i send it. I'm having few questions however. The code looks like that set InfoMail as ... infomail.subject = ... infomail.body = .... infomail.display However, i...

it works now fine, thank you very much:)

it would work only that the field date returns not only the date, but also the hour.

PARAMETERS [Type the day here] DateTime; TRANSFORM Count(mails.ingempid) AS CountOfMail SELECT mailuri.Name, Count(mail.ingempid) AS [Mail totals] FROM mails WHERE Date(mails.date)=[Type the day here] GROUP BY mails.Nume PIVOT Hour([date]);

i have a date field when i open the query i'll want it to ask me to introduce the exact date, for example today is 11/16/2006. so i use Date(mails.date) = [type your date here] and the parameter is set up like PARAMETERS [type your date here] datetime, however it gaves me an error message ...

if i do PARAMETERS [type the date here] datetime; ...... where date([date]) = [type your day here] it won't work. I know i'm a pain...

That i didn't know. this is great. Thank you very much

TRANSFORM Count(mails.Mail) AS CountOfMail SELECT mails.employeeid, Count(Mails.Mail) AS [Total Of Mail] FROM Mails WHERE day([date])= [type your day here] date/time GROUP BY mails.employeeID PIVOT Hour([date]); won't work. When i open the crosstab query i would like to ask me for the day...

yeap it works now but i still have a problem. Could i build a parameter report on the crosstab query? If i use the clause where day([date]) = [type the day here] it tells me that microsoft jet sql can't recognize my parameter.

i don't know why, but it seem to work now!? In my where clause there was before Where day(date) = day(date()) that was the problem?

Yes i do use a date field Now this is my table : Mails(EmployeeID,Mail,Date) And the SQL of the crosstab is TRANSFORM Count(mails.Mail) AS CountOfMail SELECT mails.employeeid, Count(Mails.Mail) AS [Total Of Mail] FROM Mails WHERE day([date])=day(date()) GROUP BY mails.employeeID PIVOT...