Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Working with dates in Access
I have a numerical field "PM_Month" with 1 through 12 indicating the month a PM is due on a piece of equipment. Another field which is date format needs to hold the PM date for the current year using the month from the PM_Month field. I am attempting to use an update query to...- BobCrawf
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
from com port to xl cell
I need to send a "D" out to a device via com1 to cause it to send a string back to the pc via com1.<br><br>I then need to store the data received on com1 in a cell on a worksheet.<br><br>I can't seem to find any way to send or receive data to or from a com port from Excel using...- BobCrawf
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Combine lists on threes sheets with no duplication (Excell 97-2000)
Four workbooks: January, February, March, and 1st Quarter.<br> <br> Sheet1 of the monthly workbooks each have a list at A1:C20<br> A = Employees number B = Last Name C = First Name.<br> <br> Each monthly employee list may have the same or different employees.<br> <br> I need to combine the...- BobCrawf
- Thread
- Replies: 3
- Forum: Microsoft: Office
