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

The message is "MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created" This happens when I close down my application and access.

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.

Okay here goes I have a search form based on a my problems form. I have a command button which you click when you have selected or filled in the boxes you wish to search on. The code behind this button is....Private Sub cmdSearch_Click() Dim CSearch, cFilter As String Dim rsAims As...

Thanks for the replies. I'm afraid neither of those worked either. It didn't like the brackets around the solution from Stickarm, and it returned the same answer as I was receiving from the solution from Allanon. thanks anyway!!

I copied what I had in the VB and pasted into the SQL and it worked fine there. So I gathered that I had written it correctly. But it just won't do it when I run through it!!

+ and & do the same job. I change them to & but it made no difference! Any other suggestions?

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

Thanks Wildhare I have the two forms linked together so when I click on a user the training information is shown. However I cannot enter any information or new records. It isn't locked or disabled but I set the property to Data Entry Yes the records disappear so only the headings show. What...

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