Search results

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

Hi Is there an easy way to backup a database so it replicates all its data at a given time ?

thanks for the resolution guys I tried the first method, but because of all the relationships the table could not be deleted. Compacting the database did the trick. Im using Access 2000 Thanks a lot

Hi All weve had a database built recently and have been doing substanial testing. I was wondering if there was a way to refresh everything so all the relevent ID numbers start from 1 rather than 14211 Thanks

does anyone know how to make an input mask that allows you to enter the 01/03 as in mm/yy into a date field, for issue date and expiry date of criedit cards?

User defined Type Yes I think that is what it is