Search results

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...

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...

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...

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...

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...

I have looked over most of the replies given to similar questions and not able to run this my way. The report is setup that when you enter a P/N if it matches an existing number it will retrieve and fill in the form to add/edit, if not it lets you enter your new P/N. I want to have a button that...

Hello, I have a table with mixed font case entries and want to change the way reports look. I can set the format in the text box to upper “>” or lower”<” but I would like set it for “Title Case” and have not found a setting to do this. Has anyone been able to do this? Thanks, JWT

Hello, I have one Form set to one Table and need to know how to change to edit information in my Table. I have set a Macro to check for an existing number and reopen or start a new entry. My Macro is on “after update” and is in text box that starts: Go To Control Number], Find Record =...

1. I have reports based upon parameter value in a query. What do I need to add to this that will keep open or reopen the parameter value box after I close the report? 2. How do I format the parameter value box to make the entered information (e.g. Begin & End Date, or Location) appear on the...

Queries: What would be the best way to, I have two tables that do not match. I put in this Expr 1: Right([P/N].2) that is the only item to return data to match the other table. Want to know how to trigger or make the other table enter only the information needed. The small table has eight items...

Here is what I hope to achieve, I have a report/label that I put in a part number using an unbound text box, in another unbound text box I enter a customer number. All the but the customer number comes from one queries and just too many customer numbers to add in to its table. Have a...

Hi, I have a report that I want to Print/view on one page. The report is set to two columns with a total that uses report footer. Sum = ([items]) The total appears on the next page and I would like it to be at the end of the second column. What do I need to change to do this?

Change Print Color If Less Then Zero. Working with Access97 and company is upgrading to Office2000. I would like to have the color change to red if the amount is <=0. Can this be set to view and print red for zero or less but black if >=1? Would Office2000 let me run this type of report? Can...

Hello again, With some work and all the help I was able to get this format to run. Now I have another problem, labels will show on screen the way I have set my skip/print lay out but having trouble at the printers. When sent to our HP LaserJet III the number of labels to skip will not work...

Hello, I want to solicit an item from an inventory Query and use Avery 30-label sheet in Reports/ Label Wizard to print 30 of the same item. I have set up a “dummy” table as decried by Pat Hartman posted 12-4-01, but I have not been able to get it to repeat. This is how I have my query set to...