Search results

Hopefully I can explain myself correctly. Our surgical department currently logs all surgeries in a big book. At the end of the month, they hand count how many of each type of surgeries. I am wanting to set up a database so that, once they enter the information, reporting can be pulled to...

I have a database an employee uses to capture physicians' credentialing information. Anyone that needs added to our patient registration system, she emails the information to me so I can enter them. I had some help setting up a button that, when she clicks it, saves the current record and then...

I understand that. My question is HOW to send the email. I can't do it from the Front Page form since it's either to a database or to an email...I can't do both. And from what was said above, there is no event on a database that would cause it to send off an email. The user is not on an...

They want email notification....not all the data in an email. They still want that in a database, so I was trying to find an event to fire off an email in Access.

Well the users don't ever have any contact with the database. They fill out a form on the website (Front Page), click Submit, and the results can either be sent to a database or to an email, but not both. I currently have it going to a database so we can manage the data, but then it's up to IS...

Well I thought that too but couldn't get it to work so I assumed it was the wrong place to add it. And in this case, the form they fill out is on a webpage....the information is then sent to a database.

I know there are events on a form or report (On Update, On Open, etc) but is there anything similar on the database? I want to be able to send a email to one person whenever a new record is added to the database. I'm having a heck of a time figuring it out...any help would be much appreciated!

The coding is a little over my head, but thank you for the link! I'll print it out and shuffle through it this afternoon.

Kind of like a text message that will pop up over whatever they're working on at the time? I have tried on 2 different occassions to split my database into fe/be and because of networking/security issues, there are always problems. So since there were only 4 users, I just said to heck with it...

I have a database where a handfull of users enter charge corrections they want me to make to patient accounts. Periodically I print out a report, make the corrections, then go back in to the databased and mark them as completed. I have a field called Completed that is a check box and I...

Never mind, I figured it out. :rolleyes: We need a blushing emoticon because I'm a bumbling idiot. When I linked the table, I found the database by clicking on my drive L, and then the correct folders. I did it again, this time going all the way through My Network Places, Hercules, etc etc.

Be warned....I think I went about this kind of goofy, but it works. I had a database with only 4 users (I guess 5, with me) where they submit charge changes to me, and also enter chart tracking information in a separate table. A pretty simple deal. Recently they wanted me to give the charge...

My problem was I wanted to sort on a field without a header. I'd still rather not have one, but ah well....it works this way! :) Thanks!

I swear I've read this before but am unable to find it in the search. I have a report that displays information entered by user. I have it sorting by user initials, which is great. But I'd like it to jump to a new page every time it hits a new set of initials. Is this possible?

Very nice. I give the original a 5, the new and improved a 9.

Thanks for the information, Pat! I will play with that today and get it working. Another question....do you think it wiser to go with a subform, as opposed to the pop-up forms I currently have? I'm not sure if there's really an advantage one way or another, but I'm sure able to find a lot...

I think I'm trying to make this harder than it really is, I'll see what you think. I have a main form (PatientForm) with an autonumber (ID), account#, patient name and type. Their answer in the "Type" field brings up one of 3 pop-up forms. (Either Charges, Payments, or Balance Transfers)...

Mile, change your user title to "Genius hand-holder of coding ignorants". I changed the line and it works exactly how I expected it to!! Many thanks!

No I did not copy the code verbatim, I do have a couple active brain cells. ;) Combo was actually the name of the combo box since I only had one,but I changed it to type and changed it in the code as well. If I select "Charges" or "Payment/Adjustment" the correct subform opens. But when...

Thanks for your response! I plugged in the above code and got a "Compile error: Method or data member not found" and it highlighted the .combo part of the 1st line.