Search results for query: *

the code has to be in quit event

Hi I have a macro embedded into Outlook 2000. It gets triggered when a user exit Outlook and that works fine. However if a user shuts down Windows, without closing Outlook first, Outlook shuts down without running the macro. Is there a work around for this? Thanks

what I really want to do is to code it with VBA where I can query the database and then drop the result into a worksheet, so with recordset I can achieve this?

Hi I am using Excel 2000 to connect to a database using VBA, which object/method would I need to use to achieve this? and which object/methods do I need to use to pull the data out? Actually is this possible with Excel VBA?

I put it in the page footer, didn't know there is a difference between then, thanks for that

Hours is a number, all i am trying to do is add the hours in each record and display it at the footer using sum(). When i run the report the textbox that should display the calculation just came up as #error

Hi I am trying to create a Access report base on a query (called query1 and the report called report1)I created earlier. I have a column called Hours in this query and I would like to calculate the total of Hours and display it at the footer of the report. I tried =sum([Hours]) and all I got...

Hi I am wondering if the function FLOOR() or CEILING() is available in Access, I am trying to create a SQL query which will round down a number like 2.88 to the integer 2. The round() function is useless. Also is there a function in Access where it will return the integer portion of a...