Recent content by sthapa

Hi all Im not sure what is the best way to go about this. I have a table with 8000 records and on one of the fields the department name is wrong. eg should be "Marketing", but some records have the name "Marke" or "Marketi" Is there an easy way to update this field to add on the missing...

Hi all I have a field on a database thats generally used to enter notes. Within these are mobile phone numbers in no particular order(throughout the field) Im not sure what the code is to enter in the query to display only mobile numbers from this notes field ? Any help will be appreciated...

Hi all I just to know what the command or code is to generate the External data wizard is ? I want to import a spreadsheet, the thing this there will be a new spreadsheet everyday with a different name. I guess the easiest way is for the user to select the file themselves. instead of the user...

thanks for your help Chris

All the table comes into the table via a connection a pbx switch. The end time is not recorded, just when the call comes in, and how long it lasts for.

All there is, is a table with 3 fields, Date, Time, and Duration No queries have been created.

Hi all I have a basic database that stores call time, duration and date. Im trying to run a report that only shows me ; Numbers of calls per hour Total Duration per hour All grouped by the Date, So for exmaple, i want to know how many calls came in on the 7th Apr between 08:00:00 and...

All I am having a problem with records on my database automatically deleting themselves after they have been saved. Im not quite sure how to diagnose it Any ideas Im using Access 2000 with around 6 users

worked a treat thanks

Hi Is there a way when using sendobject to specify it to use Outlook instead of Outlook Express ?

is this the same route for Access 2000 ?

Hi all ive created a simple data entry form and was wondering whether I could textbox that displays when the record was first created ?

Hi all I am having a problem exporting a access report to Excel. Numbers starting with zero is automatically knocked out when exported to Excel. is there something I can change on Access that will allow the whole number to be shown in Excel ?

no the fields are just yes/no tick boxes and each of those fields will pertain to a different code

Hi im wondering if you can advise me on the best way to do this; I have 7 fields in a table that record a specific reference code the customer quotes to us. Of these 7 fields only 1 will ever be ticked(yes/no). I need to have a textbox on my report that shows what reference code the customer...