Recent content by calvi

Hello,I want to retrieve lotus notes email document properties. With Outlook it is possible. I am wondering if it is possible with lotus notes. Set myFolder = myOlApp.GetNamespace("MAPI").Folders(MailboxName).Folders("Inbox") Set myFolder = myFolder.Folders(FolderName) Set myItems =...

Hello, I want to retrieve lotus notes email document properties. With Outlook it is possible. I am wondering if it is possible with lotus notes. Set myFolder = myOlApp.GetNamespace("MAPI").Folders(MailboxName).Folders("Inbox") Set myFolder = myFolder.Folders(FolderName) Set myItems =...

Sometimes when you bulid MS Access tool, you also leave the standard menu like File/new, open, close, print, exit, etc. Question: is there a way to catch this command in VBA code? eg. to catch the exit menu.

I've found it already. You can save the package with File save copy of package as ... Thx.

with deployment I have got 2 files: the package file and the deployment manifest file. Where in SQL Server do I have to move or copy these files? from the windows explorer? which directory (install directory or the data mdf files directory)? Then double clicking on the manifest file?

I have made an Integration Services Project with the SQL Server Business Intelligence Development Studio with the task: Transfer SQL Server Objects Task. to copy database to another database on the same server. Now I want to schedule this task with the SQL Server Agent to run it e.g. once a...

there is also a script used in T sql: like this: USE Adventure Works GO Is this correct or do I have to make a quote or something else?

Sorry but what is BOL? where can I find it?

There is a script is not working I think it has to do with because the name of the database consists of 2 separate words, e.g.: Adventure Works. I was told that I can do it with double quotes between these 2 words. But the script is not working yet. the script is like this: SET...

May be a simple question, but because I am quite new to sql server 2008: How can I copy a database from the same server to another existing database, overwriting all data. I need to do this for several times. so I tried to make a SQL Server Agent job, but I don't really know how to make the...

Thx.

I export data from SQL server 2000, 2 views to SQL server 2008 database. These views: the one has over 30000 rows and the other over 100000 rows. Both SQL Server I login via the windows authentication. I export 2 views from SQL server 2000 Database\All Task\Export data to the SQL Server 2008. It...

I have 3 tables and in between 2 helptables with many-to-many relationship. I want these tables to be shown in one Form with a grand-master, master and child relationship. grand-master in a listbox, then the other two in datasheet forms. I tried and can only connect between 2 tables and the...

I have 2 tables. the one is parent and the other is child. e.g. 1 customer has many orders. so there is a customers foreign key in orders table. So I want to make a form to show these and add many orders in Customer. So in the Customers form I put all the customers fields and a button to go to...

I am using MS Access 2007 European(dutch) version. I was told that before 1st of May 2010 when I sql select query in VBA code it is working fine with eg. "Select * from table where date = 25-4-2010"; The database will get this as (25th of april 2010). But after 1st of may 2010 when you put the...