Search results

Good Morning, and a Happy Festivus. I have a form on Access 2003 that a user will use to input data into an account table. Because a number of users will be on this database, I have created user IDs (via Security Wizard) that they log in with. I want to create a sort of audit trail, so...

Ever solve this mystery TallMan?

Wow, I think I have a little ways to go before I can grasp this.

Thanks. I put in below: Dim reqdoc As String If Me.tax_id Is Null Then Set reqdoc = "Client's Tax ID Number" Else Set reqdoc = "None" End If But I get an "Object Required" error on the above red text spot.

Would that be something like; dim reqdoc AS string set reqdoc = IIF([field1] >5, "Pass", "Fail") Then just reference reqdoc in the body?

I'm back already. The set up is that the user will check off items on the form, and any items that are left unchecked will be included in the email. Is it possible to do an IIF statement within the HTML code? Such as IIF([Me.field1] Is Null, [field1], " ")?

Wow! You've been awesome. Thank you very much - it appears that all is working now (at least for the time being). I'm sure when I start added the bells and whistles, I may be back.

Very cool. Thank you soo much. What is the name of the google tool? Also, can you reference FORM items within the HTML code?

That part is over my head. I had to line out some items, but the code works great so far - except it sends the emails as 'low priority.' Ideally, I would like to do HTML code within the email, but that as well is over my head. Is it possible to view the HTML code of an existing email, and...

I'm trying to accomplish having a report sent via email in the body of the email. Can you provide more of your script?

Would that code, for the most part, work with Access 2003?

Good Morning, I have been searching through the forum the last couple of days for an issue I am dealing with. I have a form that will be used to open new accounts. On the form, the user can select which items are missing, then click a button to send an email listing the items that are...

Thanks. I think sticking with 2003 and waiting for 2010 would be best.

No IT policy - the company is sort of small and IT is often overlooked. They will eventually upgrade, but if it is a smart idea, I will press for the upgrade sooner rather than later.

Good Morning, I recently started at a new company that needs to have a good database setup. My task is to lay the foundations now, and build upon over the years. I'm basically starting with a clean slate (and no interferring coworkers with Access knowledge). My question is that we...

I would say mostly enthusiastic with a sprinkling of some "resistance to change" types. Fortunately, this isn't anywhere near my main job function or a firm priority - so I get to set my own timeline.

I need to learn FE/BE - thanks to all for the great help. I am excited at this new company because I can design everything the way it should be, unstead of suffering through terrible databases at the previous firm.

Thank you very much! I have never had to do a FE/BE sort of setup, but this will get me started on the right foot. I'm going to be meeting with all of the departments to determine exactly what they want (if they know that), and lay out the tables.

Been awhile since I have posted on here - but I am going to need some help. I've recently started with a new firm that has ZERO employees with any Access experience. I've recently introduced some process improvements that can be done via Access, and got those in charge all riled up. So now I...

Will do. Just to confirm, deleting these linked tables from my database (to make a read only user) will have no effect on the original tables on the server?