Recent content by JWT

I have a Text Box on a Form set to change color after an update changes the text to read “OK”. The Font changes from black to white and the background from white to red. I want to make this blink/flash and need to have a button/action to stop/pause this for a set time (about 1hr.) so the update...

No Luck... Thanks fpendino for your reply. I had viewed and tried most ways to send to Lotus Notes but get the same errors pop up. I wanted to see if anyone had the same trouble that I had. For now I’m Exporting a Snapshot/format to my PC then attaching it to my e-mail. I was hoping to take out...

Hello All, Have a SendObject Marco to Lotus Notes that when I try to run it pops up an error “Invalid Class String” then a “Program Error” pops up and closes Access. I have been able to run the same Marco on my home computer to Outlook Express with no problems but at work my computer is on a...

Just another way. Hi, I was looking to run something like what you had set up to show dates but wanted different view on report. I just added a little to show as, 00 Years 00 Months 00 Days. JWT

Thank you GumbyD Thank you with this one, it ran OK and I would never have put that together the way you did. I had to modify it just a bit to work with the odd way the [ptlpyy] year comes in to the table. The years for the 90’s were fine but for 2000 to 2003 only the last digit shows. Dates...

GumbyD Thank you for the info; it was just what I needed to run on a form. Thanks again, JWT

What would I need to change to get a scrolling text to start on the left and run to the right? Thank you, JWT Here is what I have set on a form, but starts on the right and runs to the left. Private Sub Form_Timer() Static strMsg As String, intLet As Integer, intLen As Integer Dim...

Here is a screen shot of my query.

Thanks Namliam, Here a screen shot of the table I pull my dates from; the date is split in to four columns and sent, as numbers not date. I used Cdate(Format()) to put together a date I can view as mm/dd/yyyy. This is the same type of format used to find the date items added to the database and...

Hello, Have a stock room with some item rarely used and want to phase out items least used. I am going to list items added three years ago and not been used in the last three years. I have a table that is downloaded with the dates as [mm]=month [dd]=day [cc]=century [yy]=year. Put together as...

Not Working Fizzio, Did not get it to work maybe the way I set-up the two columns. Expr 2: reportdate (set to show Long Time) Between #7:00AM# and #3:00PM# Expr 3: reportdate (set to show Short Date) Between #7/7/03# and #7/13/03# With both in place the query came...

Hello, Lets see if anyone has had this problem before. In a Query that is set up to pull a downtime report and is set to key on by dates, weekly or monthly. The report works fine and the [reportdate] is in the system as #mm/dd/yyyy hh:nn:ss# AM/PM all in one column. Now this is what I would...

Hello, I am trying to use a ”WhosOn” check to tell me that my Access Database is open and who and what pc is running it. I have this database set up to help with inventory on the company’s network. Access opens to a switchboard and would like to show this information on this switchboard. I tried...

THANK YOU. Fizzio, Thanks for the step-by-step; this is my first go at forms. This has been a big help. I have been working with reports and labeling to assist our warehouse as a learn as you go setup. Again thank you for the time you took to work on this. JWT

A Big Thank You! Fizzio Would have never found the path for the .pdf file without your help was able set it in to my original form and work just the way I had hoped. Did see the macro I used was set on save form not the record. If I ask how do you work this to do in this order, On Click 1...