Search results for query: *

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

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

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

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

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

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

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

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

Hi, I work for a respiratory services company, and I'm trying to generate a query that shows the amount of installs and removals over a certain period of time. I've got 2 queries -- one to count installs and one to count removals. Installs: A 4 B 4 C...

I've got a problem that's got me stumped. I work for a respiratory services company and I'm creating a Transfer History table that records if clients transfer to another region (RHA). The destination table has the user's client id (text), old RHA (integer), new RHA (integer) and Transfer Date...

Hi, i've been searching around the messageboards, and i can't seem to find a problem like mine. it seems simple enough, but i havent done access for a while. I work at a respiratory services company, and our clients are assigned a certain region ID. when the user wants to transfer a client to a...

Hi, I'm working for a respiratory services company and i'm developing their website. i'm wondering how easy it would be to set up an online questionnaire, asking questions to see if the visitor would be a candidate for home oxygen, etc. the results would be sent via email to us, and we can...

Hi, I've got another site up and running, and I still don't have access to a Mac. I've checked it on a PC, but if users with other platforms could check out www.gamedayoperations.com and give me any feedback, it'd be greatly appreciated. thanking you in advance, -Hildegoat

Hey there, I'm still basically a newbie to site design, so i was wondering if you could do a little site check for me. I don't have access to a Mac, so i thought this was the best place to do a platform check. if you could check out my site and give me any feedback, it'd be greatly appreciated...

hi, i'm basically a newbie to website design (i've made only a few sites). during my research, i've heard a few people say that using nested tables isn't such a good idea. any thoughts on that? right now i have only one nested table. so i could have a border around the outside of my pages, i...

hi, i've made a site using rollovers made in dreamweaver 4 (just some "swap image" javascript stuff) and i was thinking of re-doing the rollovers in fireworks 4. i guess i'm asking which way is better, fireworks or dreamweaver?

Hi, I have a problem that's driving me insane! I have an graphic inside a layout cell. The graphic is 145 pixels wide, but the smallest the layout cell can be is 146 pixels wide. If i try to set it to 145, it says that "it will make cell smaller than its minimum size." I've made sure...

Hi, I'm making up a site in Dreamweaver 4, and i was wondering if there's a way for me to create a template that fits the amount of stuff on each page, so that i don't have big gaps at the end of some pages. For example, if i have a page on my site that doesnt have a lot of text on it, the...

I have a query that counts the number of clients, according to HOTID and by Bill Ref Code within that. My count numbers are all good, except that i want the records to show up where the count is zero. I'm thinking it has to do with my joins, but it won't let me do an outer join between Bill Ref...