Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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