Recent content by debbie1212

Thank you sooooooooo much!!!!!!! Thanks, Debbie

I need exactly the same thing. Have you found anything???? Thanks, Debbie

I have a page that contains an image that was originally a lot larger than the screen so I reduced the size. I want the user to be able to click the image to view it full size in a new window. However none of the code I've found works the way I need it to. Since the new image is larger than...

Thanks tlbroadbent. It worked!!!!!

Thank you so much. I intend to learn as much as possible about joins. Thanks again, Debbie

Thank you so much. I don't know much about join's. Someone else wrote this code and I'm just modifying it. I will give it a try. Thanks again, Debbie

I'm trying to set this up so that it only gets those that have a REF_EMP_REC_DATE but it's returning a record that is in the CAC table but not the Referrals table. Therefore it's putting a NULL in the REFERRALS.REF_EMP_REC_DATE. I don't want it to return a record if there is not a record in...

There is a problem with this website and I keep trying to send this reply and keep getting an error message. Hopefully I don't wind up with this getting entered 5 times but here is my reply again: Thanks for the information on how to test it. Learning how to troubleshoot is half the battle...

I'm sorry but I'm not sure how to add a test of sSentence.

Yes it is a string. I tried what you suggested and I no longer get the error message but it still doesn't put a NULL in the database field. Is there a way to do it with a string? Unfortunately, the way the code is written it doesn't work with a space in the field. I could probably get it...

If someone does not make a selection in the dropdown menu box, it is considered blank. Therefore it should pass "NULL" to the database. However when I do the following code it returns an error message that says "Invalid use of Null". If Len(Trim$(txtSentence.Text)) = 0...

The cint worked but the trim didn't. It's interesting because we have several other places in the code where we do the same thing and they work without the cint. That's why I couldn't figure it out. Thanks!!!!!!!

I have some code that I want to run only if a condition is met. The Request Location has to be the same as the User Location. I put the following code: If (objFolderRequest.intReq_To_Loc = objUserLocation.intLocationID) Then However it is going into the Else statement as if this condition...

I'm trying. I've tried several things and they aren't working. Thanks, Debbie

Thanks for trying.