Search results

  1. M

    web access to forms?

    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...
  2. M

    SendObject isn't available

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

    Error 2046?

    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
  4. M

    Fax function malfunction

    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...
  5. M

    Design Question

    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...
  6. M

    Embarrassingly simple

    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...
  7. M

    automatically fill in address

    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...
  8. M

    display only fields not null or empty?

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

    print field list/ design view

    Hola guys, I know this is probably easy, but I can not figure it out. All I want to do is print out my Design View of a form. If I can't do that, at least my field list. thanks
  10. M

    subform pages

    Hola gurus, I have form that has a subform that itemizes charges. I would like to have multiple columns?, so that when all the space allotted is used, the next page appears next to it. attached is a .doc with a picture of my form. I would like to use the extra space shown to continue the list of...
  11. M

    displaying duplicate records or something

    Sorry, I dont seem to be able to go away;) I don't think I know how to ask this correctly. I have a form based on a UNION query (comprised of two SUM queries) that returns total amounts for invoicing, as well as the client count for that month. I would like to be able to list on the form the...
  12. M

    subform or combining records revisited

    Greetings, I have a form that is used to invoice clients. The invoice amounts come from a SUM query because one hospital often submits more than one sample, but do not want to be billed indiv. for each sample. I do need to list all records they are being billed for. (A sort of itemization of the...
  13. M

    SUM or combine text fields

    I have a SUM query that combines invoice amounts so that clients only get one bill for the month. I can't seem to figure out how to also combine text fields so that I can include an itemization on the invoice. Any ideas? Greatly appreciated, mfpoore
  14. M

    auto number starting from 1 million

    I need to add a autonumber field to a table from which I built a form. The problem is I have assigned numbers and it must start from 1000000 and number up from there instead of starting with one. Any help greatly appreciated! mfpoore
  15. M

    new approach

    I think I need to ask this differently. Can I create a form (or report or anything) that has consecutive pages with exact info except for a label or something at the bottom which will be "General Accounting copy", "Clienty copy", etc? The idea is for each record to have several (5 ideally)...
  16. M

    faxing from a form

    I currently use a form to fax out reports for bloodwork done on patients. I know a report may be more likely usually for this, however sometimes I filter for certain hospital ID's to fax them all at once, etc. Currently I have to go through this process: File > Print (choose fax program for...
  17. M

    need more than 22 inchesd height, or other solution

    I have created an invoice form to print out bills, but I need five copies, all of which have a diferent text box at the bottom, "General Accounting", "Client Copy", etc. My first plan was to repeat the data over five times with startegically placed page breaks, however I can only get it up to...
Back
Top Bottom