Search results

When I had to do the same task, I just attached my email action to a "Submit" button. But that would only work if you're requiring your user to click submit to change the data.

Is there a way to do this in Access 97?

Has anyone come across similar code using Groupwise? We use Groupwise as our email client here. This code looks great...I've seen similar examples and would love to have that level of customization, but most of the computers here don't have Outlook, and none use it as their main email client...

Again I thank you for your quick reply modest. Unfortunately, I left out the detail that I am working in Access 97. I think as soon as I get done posting this I'm going to try it in Access 2000 just to see whether it's an Access issue or otherwise, since my 2000 installation has SP3. However...

I have also tried that. acSendNoObject is implied by leaving it blank. As I was looking into this I realized that sendObject isn't working on other databases either...ones that have been used over and over again....so I think it has something to do with Windows Messaging. *sigh*

I'm trying to use DoCmd.SendObject to send an email alert when a user adds a new record to a certian table. Problem is that when I run my little email subroutine, all I get is an error message that says: "Object doesn't support this property or method" Here's what my code looks like...if...

I've had a lot of problems with this as well. One thing that helps is to look in the .ldb file and see what computers are still listed there. Once I figure that out, a lot of times going to their computer and logging them out of Windows will get them out. That works 'most' of the time. I...

Wow. Ever have one of those moments where you just want to kick yourself? I opened this up again this morning to look at it and there it was staring me in the face. In Form properties my filter property for some reason read " AND Completed = 0". So since I was doing things mostly dynamically...

Have you considered using ODBC and then linking your database to the text file?

What kind of errors are you getting? I find this situation awkward. Since VB is event-driven there has to be a good way to control the flow. Can you post the code from your main form so we can see what's going on?

I'm getting the above error message when I try to open a form. The error started occurring when I tried to have two filters to control the form content. One filter is for items checked "Completed" and the other filter is for any information that was included in a Search. The actual...

Hardcoded printer path Is there a way to hardcode the printer path? I have an application that is going to be used by multiple users on a network but I want a certain button to always print a report for the Tool Crib guy on his printer.

Solution Looks like I managed to answer my own question. For future reference, this is how I did it. On my read-only form (which uses the AllowEdits property to disable user input) I simply built an event on whatever field I wanted to work with. On GotFocus, the event sets the "AllowEdits"...

How to enable controls on a read-only form Looks like I managed to answer my own question. For future reference, this is how I did it. On my read-only form (which uses the AllowEdits property to disable user input) I simply built an event on whatever field I wanted to work with. On GotFocus...

I already posted this question in the Forms forum, but I thought I might be more likely to get an answer here. I apologize if this violates forum etiquette. I have a module that authenticates users and controls who has full or read-only access to certain forms. My problem is this; things such...

I have a module that authenticates users and controls who has full or read-only access to certain forms. My problem is this; things such as combo boxes and checkboxes that are meant to be used for any user are disabled in read-only mode. I was thinking that I could use the tag property on my...

Can this be abstracted? Is there a way to accomplish this within a module? I want to abstract the enabling/disabling of controls so that the module can look at the Tag property of each control and use it to decide whether or not to enable it.

Write your own security Module One way to do security on an Access 97 database is to start with a modal login form and write a module that controls priveleges. The one I did simply authenticates a user to allow access into the database and then opens forms in read-only mode if the user is not...