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

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

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

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 ?

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 ?

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?

Does anyone have a good order form that can retrive customers and different products ?

Hi all Could anyone tell me that using user data type to store data to be used in form to retrive relevant data is a good idea or not, I have a Database which i am using some user data types to store user ID which I am populating a field with it in a nother form, it does work fine, but I am...

Hi All is there a way to move a record to another table once certains fields on a form have been completed. Also once the record has been moved it is there any way of deleting it from the original table ? Thanks

Hi, I have a standard database and wanted to run a report based on a date range in a particular field. What I wanted to do is to link a report to the form via a command button. The only thing is before this report actually executes i want to have the option of inserting a date range. Any ideas ?

hi im sharing a database between 5 people and was wondering if there was a way to add a date/time stamp to let me know when someone has added data.