Search results for query: *

Thanks! Worked great! Always wondered how to add a module to the Normal.dot

Skip, Can you walk me through how I would go about implementing this code and then running it in MS Word? Thanks!

I have a document with lots of pictures in it. Is there a way to resize all the pictures at once instead of going through the document and resizing them one by one? TIA!

Curious where you find the Reset. I alphabetized my controls and I don't like it that way and would like to reset them back like they were originally (which seem to be most used at the top). Anyone know how? TIA

Thank you!!!! I had to "tweak" a bit, correcting a misspelled word and giving the Max column a name, but after that it worked liked a charm. I look forward to feedback from the Customer as it took the records for one day down from 269 to 27! Thanks again...

Thanks, I'll let you know when I get to this office whether this works or not... Here's a star for you efforts!!!

I'm sure it won't let me have 2 WHERE clauses on that last select. I'll try playing with it when I get in to the office.

Thanks for responding... I still don't quite understand how I would write the query to get all my other criteria as well. Is this what I would do? Unfortunately, I'm not at the office at the moment to try it, but will be in a few hours and need to get this resolved. Select * from FROM...

First of all, I just realized that I posted the following question in the SQL Server Group, but probably should have posted it here instead. Don't mean to "over-step" boundaries, but I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement...

As I'm reading back through my post, I realize I didn't state this correctly, so I will correct it. I really need some help, so hopefully someone will come to the rescue... I have the following SQL statement, however there may be multiple records for a TrackingNumber. The TrackingNumber and...

I tried this, but get an error message that says "syntax error in FROM clause" and then highlights the word JOIN in the statement. Remember this is MS Access with a link to a SQL Server table. SELECT a.TrackingNumber, a.InboundDate, a.InboundUser, b.DeliveryDateTime, a.ScannedBy, a.Recipient...

I have the following SQL statement and there may be multiple records for a TrackingNumber. The TrackingNumber and the DeliveryDate (which has a time stamp in it) make up the unique key. I need to look at the most recent DeliveryDate and then check the criteria, but I'm not sure how to do this...

Exactly what I needed! Thanks!!

Can you give me a bit more info on how to do this? Thanks

I'm having problems getting either of these to work. dbomrrsm: I don't know how I can use a field to bring back the data instead of hardcoding it... mwolf00: this brings back an error that says-- The data type int is invalid for the substring function. Allowed types are: char/varchar...

I have a Modal Pop-up report that is called through an Access form from within another application. Everything works fine, the Access window is not visible, however, the user needs to be able to print or export the data from this report. Is there a way to do this, such as a command button on...

I have a field that is char(14) and I would like to write a query (for a view) that will return a datetime field that will be recognized by MS Access as a datetime field. Here's a sample of the data in stored in SQL Server: 20041215163407 the field is named DeliveryTime Can someone help with...

Here's my issue... I need my scanner programmed so that after it scans a barcode for a package tracking number, it then tabs to the next field. (So the scanner does a tab after each scan.) That is working like it should when entering data for an individual record (often there are multiple...

I have a barcode. It is used to add a record to a program. I tried creating one, with no sucess. Here's my question... is there a way to tell what barcode language this barcode is using and what control characters were used to create the barcode? TIA

Does anyone know of an option in Microsoft Outlook where your reply to an email is positioned at the end of the email instead of the beginning... in other words, when reading several generations of an email they are in chronological order from the top down? TIA!