Recent content by mfpoore

I use a MS Access database in a medical/diagnostic type business. I would like to give our clients access (password locked or something to prevent people from viewing others' info) web access. The problem is I dont know ANYTHING about doing this. Can someone please point me in the right...

references are there It appears that I have everything I need. Also, my computer seems to be the only machine accessing this database that doesn't have sendobject. make any sense?

Getting the message SendObject isn't available, and can not add it by Tools>Customize. any ideas?

The command or action SendObject isn't available now. Can anyone tell me WTF just happened? I upgraded to Office 2003 (did not install Outlook) and now I get this message. thanks, mfpoore

I tried used the code here: http://support.microsoft.com/?id=145787 to fax automatically, but it brings up e-mail instead. Can I somehow modify a print command button or something? The sendobject sends to e-mail thanks, mfpoore my fax is listed as one of my printers and I currently...

it works Thanks Chris, I went ahead and put them in, and it seems to be working fine. thanks for the help

function Thanks, that will be the plan.

I think I'm making it sound more complicated than it is. Really just need to know what I would do, if anything, to avoid a long series of iff statements that eventually get to the "query too complex" message. Would a macro be restrictive in the same way? (Is there a limit to the number of...

panel Just a combination of tests. PanelA includes tests 1, 2 and 3. But the client has the option of choosing additional tests, so many different combinations are possible. thanks, mfpoore

Let me give the break-down. multiple-lab situation, offer various diagnostic tests. We have panels that include tests for three different labs. So when I built the billing system, it is a couple of queries that go through repeated iif evaluations. For example if panel1 is requested, then labA...

works well That seems to work exactly as I need. Do I just add fields to the table and query to finish it off? (street address, city, state, zip...the usual) thanks very much! mfpoore

I only do this for about 30 seconds a year, but I know this one is easy, I just keep botching it. All I want to do is have a form that automatically finishes an address after you choose the facility name. Have a separate table for the facility name and addresses, just cant see, to get it to...

thanks trucktime and Ken! I've got it

Hello, I know this is simple (and probably listed here somewhere) I could not find it with the search mechanism. I have a table populated with facilty names, address, state, zip, etc. On a form I choose the name of the facility from the a drop down box based on the table, and I want the street...

Can I make my report, or a form, display only the fields that are not empty or null? thanks :confused: