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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. burton99

    Internet Explorer Question

    I tried disinabling the popup blocker to test and it still didn't display the page
  2. burton99

    Internet Explorer Question

    I have access to an insurance company web site (inquiry). I can get to the web site alright but when I put in my username and password and please enter the site comes up but I can't see it. I mean at the bottom of the screen it says done but there is nothing there to see.
  3. burton99

    VALIDATING AMOUNT OF TEXT THAT MUST BE ENTERED IN A FIELD

    give me an example of what to enter for the input mask
  4. burton99

    VALIDATING AMOUNT OF TEXT THAT MUST BE ENTERED IN A FIELD

    That would work fine if the text being entered into this field was only numbers or only letters, however, it involves both
  5. burton99

    VALIDATING AMOUNT OF TEXT THAT MUST BE ENTERED IN A FIELD

    I need to know who to restrict the amount of characters must be entered in a field. I have a field where you must enter the vin number of a vehicle. I want to make it so that you must enter exactly 17 characters.
  6. burton99

    LINKED TABLES

    Thank you so much! We are getting ready to try it in just a bit..will let you know how we make out. Thanks again. Holly
  7. burton99

    LINKED TABLES

    Thanks..we will try that. However, the only table that is not linked is the data files, is that where the change should be made? Do we need to remove the link in the linked table before the change will take effect?
  8. burton99

    AVERAGE A LIST OF YEARS

    Ok...now..I want to remove a link from the table where the field lives that I need to make the change. How do I remove the link and still be able to get into the table to make the change?
  9. burton99

    LINKED TABLES

    I work for a company who stores bit of data in a linked table. We would like to make a change to one of the fields in this linked table. I know that when you delete a link you don't delete the table but it does disappear when you do that. How do I make the change to the linked table if I can't...
  10. burton99

    AVERAGE A LIST OF YEARS

    So, the data type needs to be changed in the main form correct? I can't change it once it is in a query or report form, right? Thank you very much for all your help. Holly
  11. burton99

    AVERAGE A LIST OF YEARS

    I am just trying to take a list of years and average them. Sorry, I'm just not getting this!! I have a query that contains only calculations based on several different queries. Can I do the average in that same query which is based on the same records? Thanks.
  12. burton99

    AVERAGE A LIST OF YEARS IN A QUERY

    I have created a query that give me information on vehicles including the year of the vehicle. How can I take all the years that the query pulls and get an average for all of them? Each time I try to average them it tell me that it can't because of an invalid data type. I can create the query...
  13. burton99

    AVERAGE A LIST OF YEARS

    I am trying to find the average for a list of years pulled from a query that includes records with the year of vehicles included. I can pull a query that will give me how many vehicles there are for each year in my query but I can't average them from there. Each time I try it tells me that it...
  14. burton99

    yes/no fields

    Thank you very much. I will try this and see if it works and will let you know. Thanks again.
  15. burton99

    yes/no fields

    I have added a subform to my form that contains only 2 yes/no fields. I use it to run reports that tell me rather I have paid a vendor nor not using the yes/no fields in my subform. However, the only way that the yes/no fields in my subform will work is if I manually go in and check mark the...
  16. burton99

    Simple Report Questions

    Thank you VERY much for your help. I will try that and let you know how I make out. Thanks again.
  17. burton99

    Simple Report Questions

    First I created a query that pulled only the information I needed to create a report. When run the query pulls 175 records (based on the dates I enter as criteria). From this query I created my report, the report is based on these 175 records the query pulled. The entire report consists of...
  18. burton99

    Perimeters in a report with multiple queries

    I have a report which is based on a query that asks for specific criteria. I have also added several other subqueries to the report which also asks for the same specific criteria as my main report does, so now each time I run the report I am asked for the same criteria about 10 times (the # of...

Part and Inventory Search

Back
Top