Recent content by Sameer

This database is located in shared drive of our network with 15 people accessing it: The table has five columns: Name, Phone, Amount due, Called1, Caller1, Called2, Caller2 Called3, Caller3 Now, Name, phone, and Amount due are already filled. Out of 15 people having access to this...

Superb!!!!! You take away all my worries....Thank you very much for all the support.... S.

Thanks, Fizzio Item.Senton works perfectly alright now. Thanks a lot for your help.I think we will go with the way access stores the value and give away formatting and images. Also, one more quickie...please....the itemsent on brings in date and time it is sent on...like 8/1/2003 3:14:46 PM, now...

Any thoughts on this or did I post it in wrong column?? Thanks Sameer

I am using following codes to tranfer emails from particular folder to access database: Dim appAccess Dim nms Dim strFolder Dim fld Dim strAccessPath Dim rst Dim dbe Dim wks Dim dbs Dim itms Dim itm Sub CommandButton1_Click() Set nms = Application.GetNamespace("MAPI")...

Thanks, Neil....works great for me....appreciate your help.

Thanks for your response... Importing is done basically of the spreadsheets received from various sources on a continues basis.Once received it is saved in a particular name and then imported to Access. Exporting is done to four different locations as not everybody viewing it from those...

I receive data in Excel format and import them to Access.After updating records in Access( i.e.Deleting expired records thru macro), I export them back to excel. Problem: The program generates blank spaces for deleted records and also for remaining records, it generates duplicate records i.e...

Hi hth Thanks for the help.But I am looking for little more automated solution.I am getting atleast 100 txt file like this everyday.And following this long procedure would rather be difficult. Let's see how it works out or if anybody else have any better idea. Thanks once again Sameer

Hi I receive list through MS Outlook in one single format from various users. The list carry information for ex. like following: Name: Dave Smith Department: TR1 Date of Entry: Jan,03,03 Amount Adjusted: $300 Date Due:Feb, 28,03 and so on.There are around 20 fields like this but not necessary...

Great...Thanks once again...much appreciated

Thank you very much...I will give it a try...I am sure these will solve lots of my question...If I have any further to ask...for sure get back here...Thanks again

I have a form on intranet which sends the data in csv text file.The form is used by many users to feed in the info.I have to generate various reports from the data recd in csv file and I wish to do reporting MS Access.Is there any way to do the following: 1. MS Access should automatically import...

Thanks for your help.I do understand the busy schedules everybody has but it was just a request...and bring it back to attention...I didn't expect it to come back like this.And I understand these forums and also that no one gets paid to share the knowledge...and thats what it is for. Anyways, I...

It is urgent.Any help or clue is much appreciated.