Search results for query: *

I have a form where you raise actions, when an action is raised and saved you have the option to send an e-mail to the actionee to inform them of the new action. I have been able to get the send e-mail working for the past few months but now I am getting a problem that it will only allow you to...

I am having trouble creating a report in a certain format. I have Paynumber, FirstName, Surname, Cost-Centre and Element Codes. Each person will have several different element codes, but I cannot get the element codes to list in a row rather than a column. Can any help please? Pay...

Does anyone know how to export to MS Project from MSAccess. I have been able to open msproject and open the file but I get the export format table coming up and the project start has changed so it does not include all the records. If anyone can give me any pointers. I have searched the web...

I have been asked to interface our database in MSAccess with MS Project. So that certain fields can be exporting to MS Project to produce plans for workloads etc However I am finding it difficult to find any code or information as to how I could do this. Could someone help or point me in the...

I have a form that allows you to send e-mails to the person that the action has been assigned too. However it has recently been producing an MSACCESS error when you close down the database, and others have not been able to send e-mails. It was all working a few days ago!! Does anybody know...

Do any of you have any ideas as to how I can overcome the error message that appears. I have a couple of databases and the first one has 300 records and search performs fine but the other database as 900 records and cannot produce the search when the records are high so prompts you with the...

I was wondering if someone could help me, I am currently using Windows 2000 and Outlook, I have put the following code behind the save button on a form to automatically send an e-mail to the person stated in a text field. Response = MsgBox("Do you wish to send e-mail notification to &quot...

I have a form which displays OLE Linked objects. On some users machines the access is instant, but others the icon takes it's time to show in the box and each time you scroll to the next it looks like it is trying to link the icon. They also find it really slow to add a new object and...

I am using Access 2000 and was wondering if there was any way to hardcode the pathname of the where the folder is with all the attachments on the Insert object dialogue box. I know there is a default folder in Access itself, but is there a way of programming it in the database.

I have a text box which I wish to be able to search using a keyword. However when I run the search it finds no records when I know there is 2. If I run it like a query it works however I want to do it in VB Code. I have the following code example: CSearch = CSearch + "AimDescription...

I have a field called SCE on a form which you can select No or Yes. This field is also pulled through on a report. The report is based on a query, however I want the report to display "SCE" if the field is Yes and nothing if it is No. How would I incorporate this into the query? Or...

Hi I am in desperate need of some help. I am new to this and have even been on courses but it doesn't teach you anything advanced!! The problem is I have a main form which has a subform Users at the top (I have made it a subform as I want the data shown in datasheet view) below the User...

I have a form with a subform which are linked and show the correct records when moving through the main records. However on the subform which is in datasheet view I want to open a form which has the same information as the subform which I can do but it does not link the records so no matter...

I have a form which is not linked to anything as it only has buttons. I have created two subforms on this form as I want both to be seen in datasheet view. One has users and the other training information. However I cannot get it so that when you are on a user the information about training...

Hi there I have a form with actions there is a button "Progress" which is linked and allows you to put any progress reports for that record. I have created a delete button which will delete the record and the progress reports however a system warning message appears...

Hi I need some help. I have a form which allows you to add records (one at a time). I wish to have a copy button on this form, when this copy button is pressed I would like a small form to appear from which the user has a choice of fields whose values they wish to copy from that record...

Hi there I was wondering if there was a simple way in which to have a search button on a form with thousands of records. This button is to open a small form with two combo boxes, one represents the categories and depending on what you choose the second combo box will show values which are shown...

This is probably quite easy to do but how do you restrict the size of a memo field so that you cannot enter more than 200 characters etc? Any help? Thanks

I have a form with four pages on it, on one page I have a memo field which allows the user to type in a lengthy description, however this should automatically populate a summary description field (max 500 characters) on the next page. Which I was able to do. However, when I have entered in 500...