Recent content by Phideaux

I’ve been working on a query problem for several weeks and I’ve kept hitting a rock wall. HELP!! I have a preventative maintenance (P/M) program that calculates the number of days from the start date and generates a P/M work order. All of this works smoothly. My fields are: [start date] +...

I am trying to use conditional formatting to solve a problem in a MS Access Form. I’m trying to turn a field’s conditional formatting on if a value passes a certain point based on the value set in another field. In this case it’s for Work Orders that have been open too long. Each work order...

I need to come up with the correct code to put behind a button so that after the button is clicked one time the form will not display in the future when the DB opens. it's for a EULA agreement and displaying once at the first startup is what i'm looking for. At present this form will open...

i'm totally befuddled :( after 2 days of not working... it started operating normally about 10 minutes after i posted the help request. i'm at a total loss as to why. thanks very much for your willingness to assist me, but the problem seems to be gone. Phideaux The mind is the best toy. Play...

for some reason i can't enter input when an input box for a query pops up. [ the one that looks for your input with these bracket boxes] i don't know if a software switch has been moved or what has happened. any thoughts will help. i can't figure what to do. when i go on the network and get into...

I need some good technical advive on this problem PLEASE help me solve this problem. 3 times in the last few days my data base has locked up and displayed the following message "AOIndex is not an index in this table" I've had to delete the data base the previous times and begin to...

i'm going to look at the reference you indicated.. the field contains a simple explanation of the part description in a parts inventory DB. The order of listing the parts might be "Bearing for Toyota Camry" from one data entry source and from another it may show up as "Toyota...

This works really good! I've encountered one item that can give me the crowning touch on it. What would the syntax be to ignore a blank or to pick up the key search words no matter where they fall in the field?? That'd be the absolute best situation. Thanks for all of your help and...

THANKS, it works fantastico !!!!!!!!!!!!!!!!! you got many stars on this one!!!!!! Again, Thanks..... Wayne Phideaux The mind is the best toy. Play with someone else's often

using this format nothing comes back??? it's not that i can't open a query and retrieve the information. note that i need to have an input perameter box pop up on the opening of the query and then enter the "c" or other word inforamtion into that input box. Phideaux The mind is...

in queries it is a search perameter when used as a criteris that is where i've been trying to use it. :) ex: Like "C*" or like "C" the first retrieves all fields with words starting with "C" and the second retrieves all words containg "C" Phideaux...

I'm Using MS ACCESS 2000 and I need to retrieve records having a descriprion field containing various words. It is a parts description field named "Descriprion" I've tried to insert variations of "LIKE" as a search perameter but that only works to a limited degree and won't...

I need to find a way to cause a form not to display if a check box on the form is checked. I only need to have the box show up once and if the box is not checked stop the program from operating untill the box is checked. It's for a EULA agreement at the first opening of the DAta base. I'm...

I looked at several other Dbs and found no table as the one named. on several copies of the malfunctioning db i deleted the named table.... to my surprise no ill effects were seen.... any thoughts? Phideaux The mind is the best toy. Play with someone else's often

when I try to close may Access 2000 db i get a message... what does it mean and how do i stop it?? Amessage pops up on close of the DB "Table 'TempMSysAccessObject' already exists." what does it mean and how do i g et it to stop coming up. this only started recently and i don't...