Search results

Chr(9) = Tab I can really use this one. Very good to know, can use right away! Chr(34) = " What would someone use this for? I cannot see how this is helpful.

[Internal Comments] & Chr(13) & Chr(10) & Date() & " 2ND REQUEST LETTER SENT" My final working code. THANK YOU SIR!

Adding the () took care of it. I also now know the difference between Now() and Date() where I did not before. Thank you sir.

I tried. As soon as I leave that field it adds the quotes back. I am using Access 2003 if it matters.

"Data Type Mismatch in criteria expression" Format(DateAdd("d",15,"Date"),"mm/dd/yyyy") Anything else maybe???

[Internal Comments] & Date() & " 2nd Request Letter Sent" This works well. The only thing I would like to add is a return line before the date is added. Can this be done? Thanks.

Also is there a way to add a return ahead of that so it will get its own line? Thanks so far.

"SET Internal Comments"="Internal Comments" & " 2nd Request Sent" Like this then?

I have a field [InternalComments] which is a memo field. Lots of data per customer Can I make an update query to add data to the existing data without overriding the data currenty there? Thanks

Thank you BobLarson, I know I can always count on you for the goods! You sir are the man. I did not know about DateAdd so that is good to know. :)

I have a date field that I run an update query on with this as the update to add 15 days to todays date in a date formatted field. What can I add to this to format the data for "mm/dd/yyyy" so it leaves the time stamp out? Now()+15(format"mm/dd/yyyy") or something like this maybe?

"normalized" is not a term I am familiar with. I am all self taught so it might be, but I just might know what it is called. I will try to leave everything as is, try a couple changes with it in the Access 2000 format and see what happens. THANK YOU for all of your help today.

O I see... I will not be making any MDEs anytime soon so that is of no use to me. So there is no need for me to convert all of my databases then. Just keep using them as I always have. Anytime they are opened it will just say (Access 2000 file format) at the top and that is no big deal...

thank you so far "unless you make changes and are creating MDE's" What are MDE's? And I will make various changes (ex: adding columns, generating reports, new queries) all the time.

My office is upgrading from office 2000 to 2003 this weekend. Should I run the "Tools - Database Utilities - Convert Database - To Access 2002 2003 Format" I have about 10 small databases various users access. Is it good practice to run this or just keep it in an office 200 format? Thanks.

is it better to do it your way or the way I figured out?

thanks all got it... thanks all Like Date() & "*"

I have a date/time format field. "8/21/2007 10:02:34 PM" is what my column shows. What would I add to the criteria to the query to find all records added today? at the end of the day my user needs to run a query that will show everything from today. Thanks.

I have 5 databases running 100% in Access 2000. We are switching to Office 2003 within a couple weeks via an upgrade. What should I do to prep my databases for the switch? Is there any upconverting tool I need to do ect? Thanks.

there are two sources tbl_temp for the main form. tbl_TESTS for the subform.