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

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

What would be the best way of creating the LMS for periodical certifications, training and retraining of the staff. I mean the dbase design. Trying to create a pool of ideas on this. Thank you very much Alexei

I have seen this problem somewhere but could not find the solution. I have dbase opened with db window hidden. When exiting the db, access application resides in the memory. I can see it in task manager, processes. the code i have is: Private Sub cmdExit_Click() CloseCurrentDatabase...

Can anyone help me or direct to ... I need the function in access which will act similar to the index function in excell .

Well my next question is : How to design the table/s structure for the data to be in a 3 dimensions. X,Y,Z axes? Any suggestion would be appreciated.

Normalization Denormalization of tables. Keep it normalized when it is possible. I might express apostate opinion but Recenly browsing the threads I have noticed that some of them are basically about whether it is needed to normalize the tables or not. IMHO the whole issue of normalization is...

Is it possible to build a 3-dimensional table in access ? Regards Alexei

Dear Gurus, Where do I need to post my message regarding the search in Treeview as I desperately need a solution ? Your help is really appreciated P.S. I have figured out how to subsequently find search item on the tree, but still can't figure out how to in "one shot" expand all the nodes...

Re: Search In Treeview Hello everybody. I failed to compress the database to the appropriate size with ZIP.exe, The best I was able to compress is by Win RAR program to 102 kb. So if it will get through, change the name of the file to the test.rar and uncompress with RAR.exe. When opened go to...

I have a treeview control set up on a form. Control has three nodes. Could anyone help me with coding so that by pressing some combination of keys I will have a functioning "find" and "find next" capability. I can send the sample of my database by mail :):):) sorry to say it didn't fit the...

If anyone can help. Here is the database, We need a report which will show the: [Cost center] [Company] [JDE#] [IN] [OUT] [DIFF] Subtotal by company Subtotal by Cost center The pivot form will give you the idea what is needed ( run Q1,Q2 ) The task only seems to be easy, consider that...

Is it possible to find the documentation on ActiveX controls. Some book which will list the controls, describe functionality and how to make them working ... Tnks in advance. Alexei