Search results for query: *

Hi all, I have a database in SQL 2000 that has to be moved to another server in SQL 2008. Please if someone could tell me the best approach to migrate this database. Thanks Eilob

Hi all, I have a database in SQL 2000 that has to be moved to another server in SQL 2008. Please if someone could tell me the best approach to migrate this database. Thanks Eilob

Hi all, I need to set up the properties of a dropdown list equal to nothing, so that when I open my workbook nothing is selected. I dont want anything to show on the dropdown.. So I need to place this code on a form so will have to specify the name of the Sheet first and then the name of the...

Hi all, I am working using vba in Excel. basically I have a form with two sections and both contain check buttons. I need some code to be able to get all possible combinations and paste a range of cells if certain check boxes are selected. Please if you could help me with some type of structure...

Hi all, I am working using vba in Excel. basically I have a form with two sections and both contain check buttons. I need some code to be able to get all possible combinations and paste a range of cells if certain check boxes are selected. Please if you could help me with some type of...

Have been working on the code to update a GridView in Visual Studio 2005. Have the AutogeneratedEditButton set to true. When I run it nothing happens doesnt give me any error but is not updating. In the aspx page I have a the the following code <%@ Control Language="C#" AutoEventWireup="true"...

Hi all, I am using Visual Studio 2005, I have created a web application that uses a Grid View with a Delete, Update, insert commmand field. But I am getting the following error when I try to delete a record: Must declare the variable '@FAQ1ID'. Description: An unhandled exception occurred...

Hi All, I have the following table: Week1 Week2 Week3 Week4 Week5 Week6 Week 7 0.49 0.48 0.46 0.45 0.49 0.48 0.46 and need to change it to this layout: Week Margin Week1 0.49 Week2 0.48 Week3 0.46 Week4 0.45 Week5 0.49 Week6 0.48 Week7 0.46...

Hi all, I need to take the first two or three characters from a text depending if the hour has two or three characters, there is any function in access that will take the first characters until finds this symbol (:) or will delete the last four characters? 78:39:06 78:08:48 195:06:22 71:24:16...

Hi, I got a problem inserting data on a column, The data is called Elapsed Time and contain values over 24 hours as: 162:58:42 03:27:55 164:19:51 00:28:10 If I set the field as Date/Time it wont accept values over 24 hours as 162:58:42, if I set it to number doesnt take it. How can I insert...

Hi, I have this module where I transfer an excel file into a table. The Date Submitted format is general date 1/2/2008 5:25:00 AM. I need to change this to a short date. So I was thinking adding code to the module specifying that when is transferred that the column is transferred in a Short Date...

Hi, I have two tables in a database in Access, the first one is a table with a week column and a date column. The second one has a colum called dates and if that date matches the date on the first table the week column has to be updated with the corresponding week from the first table. I tried...

Hi all, I am trying to move emails from Outlook into an Access table, the code below worked for me before, but now I am having a problem as this error message comes up: Run-time error 438 'Object doesn't support this property or method', for some emails is ok, but otherones, it just cant find...

How can I save a copy of an email automatically everytime is clicked(marked as read)? Thanks Eileen

I need to save into a folder a copy of every email read.. I have created a macro in Outlook and I was testing my code but is not saving them, the name of the folder is Read Mail and is a subfolder of the inbox.. I saved the code in the This Outlook Session and then if I restart outlook should...

Hi all, In the department there is a team of 17 people, I need to know how long time takes to read an email, I assume an average. Any suggestions? THANKSS

Hi, How can I specify the value of an Outlook field compared to a value on a column in an access DB I am coding a module in Access and I want to say that if the body in the email in Outlook is different to each record in the column body then save to the table, but is not working. As the...

Hi, I am copying messages from outlook and transferring them into a table in access. I need the security alerts from Outlook to be turn off, as everytime an email is copied I have to click yes to allow access to copy the mail. Here is the code I have and I got three lines of code which should...

Hi I am trying to get in an Access table all the emails that come into the Inbox in Outlook. I have writen a module with some VB code to get the emails on the Access table. What I need to know is how can I set up this module to be runned every second or every couple of seconds all the time. I...