Recent content by arjun5381

Hi, i am getting an compiler error "User-Defined type not Defined" on below code Dim objOutlook As Outlook.Application can someone please help me.

Can any one please reply, i need your help for resolution.

Hi, Hi, can you please help me to change the result view, here the result is showing in Horizontal Table view but I need the same code with the Vertical Table view. Public Sub NewEmail() Dim olApp As Object Dim olItem As Variant Dim db As DAO.Database Dim rec As DAO.Recordset...

thanks for your suggestion but how can it is possible..... we received first initiated email on our outlook from customer side so how can i create a ticket in new application. (email volume everyday 2.5K to 3K) so manually is not possible, and if you talking any automated process so how can i...

Dear Team, I have a shared email id and it is configured in MS Outlook 2007. Some time we are initiating a new email and sending it to customer for more input and some time customer is initiated new email for resolving their issue (with attachment / without attachment, attachment format not...

because these values are change on daily basis, if customer is paid some/all amount of there Invoice OR customer using our services then these information will not constant. Please read my new comment there i just explained my working process.

I am working with Telecom Industry, we are service provide and we have 0.6 millions of customers and the have multiple Accounts ~ 3 Millions. I have a master table where customer details are available and static like customer Account Number, Customer Name, Billing Address, Product Type...

Guys, which method is best for 3 Million Record (1) Append Query (2) Update Query.

I have a customer table where 3 million records are there, here we need to update customer details like [Current Outstanding & Ageing] on daily basis. If i choose option "Update Table using VBA/Query Wizard" then it is not possible to update 3 million records every day because In my process to...

There are 0nly 4 Text columns where i just update current outstanding and age of network of customer, here i just want to append daily updates on sql server. i did't get your question if you taking abut validation and rules.... There are no validation on text.

Thanks a lot of you guys for your support, here i just test simple wizard query and trying to append record 3 million record, on this process it it is taking 1.5 hr time. In my server table only one field have Indexed because it is a Primary key of this table. Here i'm trying to Alter Server...

My mistake it is ~ 8000 Records Per Minute

If i just use my code and DoEvents every 1000 records it is taking time ~ 8000 Records Per Second nothing much, [B]I have 3 Millions of records if i go with this speed then [3000000/8000/60 =~ 6.5 Hours]]/B]

In my Local_MS_Access_Table & Sql_Server_Table there are only 4 columns, one is primary key rest are text only. I want to Append 3 Millions of Records from Local_MS_Access_Table To Sql_Server_Table This will be run every day.

Dear CJ_London, i am mot able to use your query code in my application, can you please help me to provide complete VBA code as per my requirement.