Search results for query: *

Act 6 generates some date fields that you cannot ammend for things such as Record Creating date, Last Look Up etc. Can you get it to generate an automatic field for say First Sale to a customer. If you can how. I would really appreciate help on this.

I have in error saved a password for Windows Messanger. I hve deleted and restored MSN in Windows but when I reinstall it and reboot my PC in automatically logs me on to messanger as I am on broadband. Is there anyway you can delete saved passwords in Windows. Thank you

When an external email that addressed to more than one person within the company is collected by our exchange 5.5 server each addressee receives the email the same number of times as the number of recipants. I.E. If 5 people within the company are emailed from one source they each get them mail...

A client has asked us to configure all users on his network to be able to send individual email, but all incoming email to be delivered to one address regardless of email address. Is this possible and if so can anyone tell me how. We are a Novell and Lotus Notes house and do not have a lot of...

A client has asked us to configure all users on his network to be able to send individual email, but all incoming email to be delivered to one address regardless of email address. Is this possible and if so can anyone tell me how. We are a Novell and Lotus Notes house and do not have a lot of...

I have a database that uses the main form for customer details and a sub form for contact history that holds date of contact, description and then a memo field for details of what has been said. On screen this works very well with all of the info linking. what I want to do is merge information...

I am running a query and for some reason it is not finding 1 particualr record. ie) search on company name nothing then search on first name "Steve" 6 other records come back but not the one I want. When I do a filter search on the form in comes back okay Any suggestions.

When I select from a combo box on a form the text is recorded, but when the information is recorded on the table it is just numeric. Can somebody please tell me how to get the table to record the text from the combo box. Cheers

As per previous posting. I have a Access database with long date field and Table formats. This information is transferred into a letter in Word to confirm appointment date, but in word the date is the short format 16/11/00 rather than 16 November 2000. Previous posting suggested that I alter the...

I have run a query in my Access database which uses the long date format. This field is used in a word document to confirm appointment date. Whatever I do the word document inserts the date as 16/11/00 instead of 16 November 2000. Everything in Accesss reads long date ie) the form and table that...

I am using the short date format in Acccess as it is easier to link to system date for queries and reports. My problem is that I want to merge with word in a letter and want to use the long date. ie) Access field date = 14/11/00 and I want a mergefield in word to read 14th November 2000. I have...

I have set up a query using 2 tables of information. When I do a search using a single filed from the main table the query is duplicating the record. I have checked and there is only one customer record. Any suggestions?

I want to produce a report linked to query. The query will link to tables, one called contact the other notes. The contact table holds customer info address etc and what I wish to do is bring the notes table info into the same report. The notes table has a date field, subject field & notes. The...

Could any one please tell me how you can transfer information from one sheet in a workbook to another so that the information is transfered to the next free cell, row or column in the selected sheet. ie) I want to be able to transfer information for certain cells in a sheet via a macro so that...

I am using a database that has a form & sub form updating two tables. The main form holds the customer data, with the sub form haolding contact details ie) date of last contact, Subject and notes. What I am trying to achieve is to design a report that will have a mixture of both forms on a...

I want to create a expression in a query that will look at todays date and everything else in the previus 7 days. I dont want to use the ie) BETWEEN 14/09/00 AND 21/09/00 as I want to attached a report to this query that can run automatically from the Switchboard. I have everything set up other...

I am using Access 2000. I have run a query using 2 tables to sort data. When run all the data is present in the query. When I do a report only 3 records have come accross in their entirity and the others not all the information from the fields in the query are in the report. Also on the fields...

I am using a database on a server. I want to prevent 2 people accessing a single record at anytime to ammend it. I have ticked the lock edited records in Options Can anyone help.

I ahve a database produced in Access 97 which utilised a switchboard. I have now upgraded to 2000. In Tools , Add In Manager 97 had a switchboard, my 2000 is empty. I loaded 2000 fully to hard drive on install. The database that I did in 97 has a switchboard that works in 2000 for the switches...

How do you get Access to auto format the capitalisation of the first letter of a word ie) in an address field in a form and can you get it to format say an incorrectly capitalised input mid word back to lower case Cheers