Search results for query: *

thanks for the help. Just got fired because I couldn't get this to work... DeletE thread.

Deleted extra post.....sorry. This is what I am getting now. See attached document w/ screenshots.http://files.engineering.com/getfile.aspx?folder=db8f7734-558c-442a-9186-df9582ff0c5f&file=URL_as_parameter_issue.docx

I am attempting my first asp.net/vb.net application. I have 15 clinical programs that a user may be a member of. When a row is selected in the gridview, I would like to get the value of the clinical program the employee is a member of. I would then like to set what page url is used for the...

I have a table of procedures done on a patient. The patient can have one procedure with more than one diagnosis or modifier (left, right, bilateral, etc.) The modifier stored in the patient procedure table is the key value, when I instead need the description. Everything brings back what I...

Thanks to the Judge! Solved by thread702-474982

Judge You are a savior! I've been trying everyone's suggestions, and getting many lumps on my head from pounding it on the desk! Your suggestion worked! This star is for you!

I am working on a database that if the user selects "Other" for certain fields, a text box then becomes visible. At that point, the newly visible field becomes required. I am having problems returning focus to that field. I enter the control and do not enter any text, but tab out of...

Mike and synapsevampire ... while you two were working, so was I. The initial posts put me on the right track. What I ended up using is almost identical to Mike's last post. Thank you so much for your help. I have had a Help Desk ticket in with the software vendor for 4 days. Post it here...

Mike... It's a string(YYYYMMDD). So would date_stopped > cstr(currentdate) work??? Thanks!

I'm very new to Crystal and am trying to fix an existing report. The database has a field "date_stopped". If that date is today, or before today, I do not want that record included on the report. I have tried using Now() and CurrentDate, both of which had errors. I know what I have...

Try this... prior to step that is failing, ALTER DATABASE databasename SET SINGLE_USER. Then once it has completed, ALTER DATABASE databasename SET MULTI_USER.

I am preparing for my Excel MOUS and am stumbling over the data/consolidate function. My main problem is lack of an example. I took a prep course, and the instructor offered no more examples or explaination that what was in the book (which wasn't much!). Any help would be appreciated...

Ok... figured it out. And maybe I am not good at explaining what I am doing wrong! The problem was (I think!), that I was trying to pull too much into the initial query. Once I broke it up into multiple queries, it worked. First I got the patient number and the latest date. Then I went for...

Problem solved... yet another instance of a corrupt normal.dot Get rid of the template, got rid of the problem.

cmmrfrds The database is Access 2002. I can add the timestamp, but that wont help with with the existing records (since they all would have the same time... right???). I really hate to have to go through this table and remove the old records manually, especially since I will have to use this...

I need to find the most recent record for a patient in a table of Lab Results. From this table, I need to get the Patient Chart Number, a specific test (Hgb A1C), the result of that test, and the most recent results (there are multiple records (dates) in the table for each patient). The...

Ok... I've seen all of the posts on how to set up Auto Logon with NT. I need to find out how to remove it. I can guess, but would prefer not to when messing with the registry. If I just remove the password from within the quotes, what happens with the user id that is supplied? Would you...

I have a user with Office XP. They create a letter, then highlight the address at the top of the letter. Going under Tools>Letters and Mailing>/Envelopes and Labels... this is where the problem starts. She ends up with the entire letter being formatted for the envelope. Then an error saying...

I have a report that checks values and if they do not meet the requirements, it turns the backcolor of the field to grey, and at the same time increments a counter. My counts are off, by just a few. Going through debug, I noticed that some records are being process twice. (This is after...

My bust. I changed the column count to one, but did not remove the "0" column width. I had two column widths... 0 and 1". Thanks for the help!!!!!