Recent content by danikuper

Thanks! I'll check the union queries help and see if I can figure out how to use it. As for your point with normalization, the tables do have some additional fields. In addition to that, I'd like to speed up queries since that's the purpose of the database 90% of the time and the user will...

I couldn't find a similar question already answered, so here it goes. I have multiple tables used to store information on different research materials: table Books: - BookID - Author - Title - Year - Cabinet table Papers: - PaperId - Author - Title - Year - Cabinet table Catalog: - CatalogID...

Can you post the code you are using? It's been a while since I last messed around with it but we might be able to spot what is causing the error. thanks. daniel

As you can see from my first post, I'm using the DoCmd.SendObject. I can't find anything wrong with my code (and it was working before I installed Outlook 2003). Any reason why I should go with the followhyperlink method (other than it might solve my problem)? :)

Hi, I've got the same problem.. generating the email with To and subject line works but the body of the email comes up blank. Did you ever figured this one out? thanks!

It looks like the problem is not a security issue because I'm not trying to send the message without the user intervention. My code opens outlook and creates a new message and waits for the user to send it. The part of opening and creating a new message and entering a subject line works...

I still haven't figured this one out... help anyone?! thanks.

Hi there! I've been using this code to send an email directly from my form and it worked great with Outlook 2000. Now that I've upgraded to 2003, the email gets created but the message body is blank! Here's what I'm using: Private Sub Image137_Click() On Error GoTo err_image137_click Dim...

And how do I get the toolbar to show up as a pop-up menu? I changed the properties of the toolbar to 'pop-up' but it's not shown when right-clicking... daniel

Is there a way to create a menu that shows up when the user right-clicks a record on my form? The same type of context-sensitive menus used in other windows applications. Thanks. daniel

Check this site. It may help you doing what you want. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cmctl198/html/vbevtitemclick.asp daniel

I checked and there's no formatting being applied. That user is using MS Access 2003 to open an MS Access 2000 database... could that be the cause of this problem? I haven't heard complaints from any other user. daniel

A user recently showed me a problem he was having. We're using a split database with user-level security and this guy was changing his password for a new one that contained two capital letters in the beginning (e.g. ABcdef). Access wouldn't give any error messages but when trying to logon back...

Does anyone know if there's a way (or a freeware or the like out there) to print a report showing users, groups and their access level to database objects? Something showing that group A has read access to such and such forms, reports, etc.... This would be very helpful in documenting my...

Try using this instead: =isnull(DLookUp("Report Ref","CAPs Report Reference","Report Ref "= & Forms!CAPs Initial!Report Ref)) This might take care of the syntax problem.