Search results

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...

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")...

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 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...

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...

I have developed form using Front page(webbot components) and sending the data to MS Access.The form is in .asp format.There is approx.250 user who will be filling this form on our companies intranet based on customer calls they receive.There are around 25 fields in the form and approx.8000...

I am trying to export table to spreadsheet, everything works fine but even though format in table for text is upper case and table is auto sorted, the information in spreadsheet is received in unsorted format and also in the upper or lower case as it wasentered in the table.Since this transfer...