Search results

Hello all, Have not been here for long time. I would very much appreciate if someone can help me with such issue. There a form with linked subform, the subform is in datasheet view. On the subform there is a drop down box which provides the values for the field based on the selection of another...

Here is the issue: There is a number of departments Departments have employees and have a set of roles (ex Facility owner, Fire Safety watcher etc. ) Employees may have some roles assigned to them or may not have any role at all Every role has a set of training courses to be passed The set of...

Solution found I knew that there should be some solution to my problem. Here it is: Instead of putting the reference to the field like me.attachment I have inserted this: HyperlinkPart(Forms!issues.Form.Attachment, acDisplayedValue) And it worked ! Thank you very much.:D

CyberLynx, unfortunately the option of changing the hyperlink field to a text field is not an option yet for me. People who use dbase want to be able, by clicking on the field, to open the file linked. Now about the problem itself: I looked thoroughly before I posted the code here and found out...

Thank you for the solution of the first issue. Unfortunately the solution for the second issue didn't work in any way. I have posted the dbase to see what is the problem. You migt be able to see what is going on.

:) Well the error message won't help a lot because it says "Outlook is not running try to launch outlook and send again" ( you can see this message in the code ). Obviously there is some error but the message itself is not quite explanatory. Now regarding the second problem. If I click on the...

I have a code: +++++++++++++++++++++++++++++++++ Private Sub SendEmailToAssignedTo_Click() Dim myOlApp As New Outlook.Application Dim myItem As Outlook.TaskItem Dim myDelegate As Outlook.Recipient Dim strImp As String On Local Error GoTo SendEmailToAssignedTo_Err...

Please help with code: When Outlook is running procedure works OK When Outlook is closed it gives error message. I need the code to launch Outlook if it is not running and create the task. Thank you in advance :) +++++++++++++++++++++++++++++++++ Private Sub SendEmailToAssignedTo_Click() Dim...

I think there is a problem with association of program with file extention. Save any pdf file to your pc, right click on this file, select "open with", "choose program", select "adobe reader" and select "always use the selected program to open this kind of file" box, click "ok".

Hmm no one knows how to do it ...

I am using the MS Project Pro 2003. And it is not a server.

I have db which lists all the projects with related information in it. But also there is a MS project file which holds the milestones and everything else. Is it posible to have a subform which will be linked to a MS project file and will display only the portion which belongs to the project...

In this example you can see 2 total fields. On the main form I used Dsum function, on the subform used sum. Open form in design view and look in the properties of those fields.

As I could understand you need some fields to have default values when adding the new records. So what is the problem? Define in the properties of those fields the default values.

Dsum function will do the trick

Not sure why you could not set the subform return the related records. Once you insert the subform mainform is turned into a single form from continues form. On the properties of the subform there are: link childfield, link masterfield. Those two fields is used to relate one set of data to...

Why don't you create a listbox, press any letter see how it scrolls to that letter. Unfortunately it works only with one letter, means if you try to search the whole word selection will jump all over the lstbox.

Well ... if you have read what has followed the "LMS" you probably would be able to derive an LMS from Learning Management System. And I am looking into the design of the dbase. What needs to go there, table structure etc.

Create a list box with grouped source from the column you have mentioned. Then, next to it create another form which will select the values depending upon the selection from the left. This example is posted somewhere on this site and is called lstbxcriteria.mdb

Please see attached file.