Recent content by Clintimania

a couple of hours and 2 advil later, I figured it out.

I have searched and I see that DAP's are going away, but even if this is a temporary fix, Ill take it until I can get something else in place. We are running Office XP, moving to 2010 later this year.

If I have a table that has a different staff person assigned to each record, and I want to design a data access page so that each staff person can bring up only their records on the page... how do I approach that? Basically I want the staff person to go to the data access page, choose their...

I agree, our remote users will not be wireless... I only used it to test a few things. It was the only not-on-network connection I had available. Thanks for the tip though.

120 local users... only about 18-20 remote. It is going to be a work order system, so they will only use it to report I.T. problems... I dont forsee a lot of traffic. One note from the first post, I was connecting to it remotely using a Sprint Air Card... I had low signal on it, so that...

This is my first attempt using a web page to work with access. Here is the setup. I have created a work order system in access that works great on network. However, we have some users that connect remotely through a portal that cannot use the access version. (their use computers provided by...

anyone who read what was here, please disregard

Woot! I added an "=" and it worked. To: =Forms![Order_admin]![User Name] & "@scdmh.org" Thanks Bob. I would have never put the domain in " " .

I put it in, it still says "unknown message recipient(s)" when it tries to send. I have the Order_admin form open and my user name in the User Name field so that it will email me whenever I get it working right. Anything else obvious that I might be missing?

Hello, I am working on a Support Ticket system and I am working on setting it up where when the admin checks the "complete" box, that the db sends an email to that person letting them know their ticket has been updated. So far I have most of it in place, but my problem is getting it to send it...

Thanks for the help.. its working great!

Ok so this has to be easy.. but for some reason I am struggling with this. I am writing some long code and I want to go to the next line because its going off the page and its hard to keep track of. So when I move an "Or" to the next line instead of continuing the line, it gives me errors...

Wow... abs.. I will look that up... because it worked! Thank you!

I am working on a report that will count statistics. There are several check boxes that I want to count the number of "yes" checks. So I made a report, then put this code in an unbound box... =IIf(([Case Opened]=Yes),Count([Case Opened])) Well instead of only counting the yes checks, it...

Wow.. I was trying to make it a lot harder than it had to be. Thank you all for the input.