Recent content by Balder

Thanks, that worked. Super happy, only problem is they will pester me for more stuff to fix. Well, maybe it is time to read up on Access again..... Best regards

Hi Because of changes in my work life I have not been active on this forum for some years Several years ago, I created a reservation system for my company. It was supposed to last for a few years only and I have since changed jobs several times, but are still in the same company. It turns out...

Hi folks Finally found the solution to the problem. You will find all the info you need here : http://www.accessribbon.de/en/index.php?Access_-_Ribbons:Ribbon_XML___Controls I downloaded the sample databases from here : http://www.accessribbon.de/en/index.php?Downloads Use these examples to...

I have tried to find out if there is any way to hide the PRIVACY OPTIONS under FILE TAB in Access 2010. Tried to look at customized ribbons but found no solution there. A customized ribbon without the PRIVACY OPTIONS would be perfect for the system i am building now. If anyone now how to do...

Hi Thanks GHUDSON. Works great. This will keep some nosy people out of the system...... Balder Norway

Hi Have been trying to do the same in Access 2010. But even after unchecking ALLOW FULL MENUS under CURRENT DATABASE, the user can still click on PRIVACY OPTIONS and change these values back again. Any way to completely remove this possibility in Access 2010 ? Have tried to search this forum...

Hi I am in the process of finishing a project i started building using Access 2007. After the release of Office 2010 i upgraded from 2007. My project was at the time about 60% ready. After the upgrade the only issue i encountered was when applying themes in forms, but i found a solution to...

Hi The following code works great for me. In is in the ON CLICK event of a button on my form. Private Sub sendmailbutton_Click() 'send email to email adr. in the email field.' 'If email field is empty tell user that there is no email adr.' On Error GoTo PROC_ERR Dim stDocName As String...

Hi JDRAW You saved my day. I just did a mistake first time, now it works like a charm. Thanks ! :) Balder Norway

Hi Sorry JDRAW but that don't work for me. "WHERE [companyid]= '" & Me.cbocompany.Value & "'" Still same error, i have tried many changes now, but not about to give up yet. Balder Norway

Hi Companyid is a text field. The strange thing is that i now get a dialog box that pop up after i choose a company. I i write in the name of a company here, the second combo filters correctly. But if i just click ok or cancel on the dialog box i get the error i mentioned above. Balder Norway

In a subform i have 2 combo boxes. The first combo uses COMPANY table as record source. The second uses Department table as record source. In the after update event of the first box i have the following code : Private Sub cbocompany_AfterUpdate() Dim strcompany As String strcompany =...

Hi Thanks Will try a soon as i get back from work tonight. Balder Norway

Hi In my Human resources system the user can add a task in Outlook 2010. The code is : Function fncAddOutlookTask() Dim OutlookApp As Object Dim OutlookTask As Outlook.TaskItem Set OutlookApp = CreateObject("Outlook.Application") Set OutlookTask =...

Thanks Will try that. Balder Norway