Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hildegoat15

    Excel: Lock Cells But Allow Row Height Adjustment

    It's actually just a cell that's been merged to go across the width of the page (actually about 4 or 5 of those rows). I've just shown them how to re-size the height of the row if need be. -Matt http://www.ranamedical.com
  2. Hildegoat15

    Excel: Lock Cells But Allow Row Height Adjustment

    Hi, I'm trying to lock-up cells in a spreadsheet that contain formulas, only I'm running into a bit of a problem. In the comments section of the spreadsheet, sometimes the comments go past the width of the cell. I showed them that if they change the height of that row (just dragging it from the...
  3. Hildegoat15

    Better question - how do I turn off Debugging Errors in Forms?

    Let me try to take a stab at a potential solution. If the procedure in code (for example, behind a button) has vBA-generated error handling, you could always just comment out the "MsgBox Err.Description" line like so: Err_cmdNewDocType_Click: 'Skip this line MsgBox...
  4. Hildegoat15

    adding record to Address table

    Hi, I've been banging my head against the wall for a while, so I thought I'd post. It's a bit of explaining, so bear with me. I have a form that show's a patient's information -- name, address, doctor, etc. Right now I'm just trying to get the name and address working, so I have two tables...
  5. Hildegoat15

    Is this even possible?

    i've used those links i gave you in my Access 2000 database with Outlook 2000, and they work for me. I was able to make appointments and tasks using those examples. who knew that Microsoft would actually SOLVE your problems, not cause them? good luck! -Matt http://www.ranamedical.com
  6. Hildegoat15

    Is this even possible?

    give these links a look: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q160502 http://www.applecore99.com/gen/gen022.asp http://www.microsoft.com/AccessDev/articles/outprog.htm maybe this sort of thing is what you're looking for. -Matt http://www.ranamedical.com
  7. Hildegoat15

    emailing outlook appointments via access

    Hi, I know there are ways to send email messages with attachments thru code (via outlook automation), but all the posts that i've found only show you how to add files as attachments. Is there any way to send actual outlook items such as appointments the same way? I'm basically trying to do the...
  8. Hildegoat15

    union query not working on win2000 or winXP

    ok, we tried running it on another win98 machine, and now it doesnt work on there. we're guessing now that it's not an OS problem, but that Access may be configured differently on the computer where the query actually works. here's the SQL for the queries, so if you find anything that may be...
  9. Hildegoat15

    union query not working on win2000 or winXP

    Hi, I've run into a bit of a problem that's got me stumped. I have two queries with the same columns -- clientid (text), due (date), future (date). in the first query, the due column is set to null and in the second query, the future column is set to null. A third query was created to stick the...
  10. Hildegoat15

    SPAM

    i just thought i'd put in my two cents. i just created a new free email addy because of all the spam i've been getting, and within two hours of me setting the addy up, i had over a dozen messages in my junk mail folder. i honestly really don't see any end in sight. -Matt http://www.ranamedical.com
  11. Hildegoat15

    printing word form letter thru access

    Hi, I'm creating a form letter in Word which is going to take fields from an Access query. I've got almost all the code worked out, but i've run into a problem. If i was to print the form letter using the PrintOut action, i'm not going to get a print dialog box, right? I want to be able to...
  12. Hildegoat15

    rst.open error

    hi, once agan i've stumped myself. i have a popup form that allows a user to enter a new City Code, City Name, and Province, and i'm trying to check for duplicates. my check for city code works fine, but when i check for duplicate city name/province combination, i get the error "No value...
  13. Hildegoat15

    RecordCount not working

    disregard that last post. i figured it out -- i was just missing a character in my rst.open statment. -Matt http://www.ranamedical.com
  14. Hildegoat15

    RecordCount not working

    how would i go about creating and opening an ADO recorset? for example, how would i make one from my "Sleep - Referral" table? -Matt http://www.ranamedical.com
  15. Hildegoat15

    RecordCount not working

    thanx for the tip about ADO, i'll look into that and i'll pry use ADO rather that DAO from now on. but for the time being i used rst.absoluteposition + 1 rather than rst.recordcount, and it seems to work. -Matt http://www.ranamedical.com
  16. Hildegoat15

    RecordCount not working

    Hi, i've ran into a bit of a snag with my code, but i think it just needs a fresh set of eyes looking at it. I have a form with textboxes full of patient information, and i'm trying to make sure duplicate patients can't be entered. I made up this function called DupCheck that checks the table...
  17. Hildegoat15

    Subform Event Not Firing

    i appreciate your help, but i did a bit of research on the Requery method, and if i requery the subform in the main form's Current event, it seems to trigger the Current event of the subform. so my code looks like this (for anyone who's having the same problem as me)...
  18. Hildegoat15

    Subform Event Not Firing

    Hi, I've been searching around the forums, and I can't seem to find an answer to my problem. I have a form with a tab control on it. The first page of the tab is a client's information, and the second page contains a subform showing phone calls we've made to them. In the Current event of the...
  19. Hildegoat15

    EMAIL FORMS, HOW DO I DO THEM

    you COULD just put mailto:youremailaddy in the action parameter of the form tag, but it's pry best to use CGI scripting to email the form. that way you really aren't dependent how the user sends the email. I'm actually attempting to do the same sort of thing that you wanna do, i just haven't...
  20. Hildegoat15

    stumped on INSERT INTO statement

    Hi, i've made a form which allows people to transfer region (RHA) or CPL. Based on the transfer they want to do, i run the appropriate INSERT INTO statment to add a record to the Transfer History table, putting nulls into the fields which aren't applicable. It works fine for the RHA transfer...

Part and Inventory Search

Back
Top