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

    I have two separate fields and want to link them together.

    I have two separate fields in my Report. I want the users to select a project from on field and then the other field will automatically be entered into the second field. How do I go about doing this? Please HELP!!
  2. schines

    How do you place the user login name on a Report?

    Trevil Thanks that works perfectly!!!! It was exactly what I wanted. Thank you! Steph
  3. schines

    How do you place the user login name on a Report?

    I am trying to create a report that will print out the Users Login Name at the footer of the report. Thank you for any piece of advise. Steph
  4. schines

    Unnammed MFT Table entry

    I am ghosting one of my computers and it took about an hour for the ghost software to do one partition. It started slowing down when it was prossesing "Unnamed MFT Table entry". If you have any idea what this could be, could you let me know!! Thanks for your help, Steph
  5. schines

    Don"t understand an Error box?

    Tom That sounds good but I have to go through a few people at work first to see if I am allowed to send the Database over the internet. It might take a few days is that alright? Just let me know. Steph
  6. schines

    Don"t understand an Error box?

    Tom, I went into the form and at the bottom of the form displays the "qryConfigItems(find)". I then went and viewed the properties. when I closed out of the properties and tryed to go from the design view to the form view an error message appeared 'Query must have at least one destination...
  7. schines

    Don"t understand an Error box?

    Tom, The databases contain sesitive infomation so I won't be able to send you the database, Because, of course, that would be the easist thing to do. the other problem is that I'm located in Maryland. I looked at the "qryConfigItems(find)" since both of us couldn't find out the relationship...
  8. schines

    Don"t understand an Error box?

    Tom, Thank you for all of your help so far! I made all of your recommended changes, I located the code for PrtECPData, there is two seprate queries for Preview and Print, but they seem to be the same. Then I tryed to run the debug/Compile Inventory Control 1. It runs now without any errors...
  9. schines

    Don"t understand an Error box?

    Tom, Thank you for all your help so far. It's exsactly like finding a needle in a haystack, you took the words right out of my mouth!! The Record Source for the: qryConfigItems(find) SELECT qryConfigItems.[ConfigItem #] AS [CI#], qryConfigItems.ProductName, qryConfigItems.Version...
  10. schines

    Don"t understand an Error box?

    Tom, Record Source for the report: qryECPDataFind SELECT tblECPData.*,[Document#]&"-"&[NewRevLvl]AS ECPNumber, tlbProject.ProjectManager FROM tblProject INNER JOIN tblECPData ON tblProject.ProjectName=tblECPData.ProjectName WHERE ((([Document#]&"-"&...
  11. schines

    Don"t understand an Error box?

    May-be I can help by giving you alittle background! I just started working with my company and I have never delt with Access before but I was through into it and told to fix the problems. I took one class and thats it!! so Yes I have a Query named "qryConfigItems(find)" - not sure if anyone...
  12. schines

    Don"t understand an Error box?

    well each time that I open the form wether or not I make any corrections, the warning "Do you want to save changes to the design of query 'qryConfigItems(find)'?" appears.
  13. schines

    Don"t understand an Error box?

    I keep receiving this error message every time I close out of a certain form "Do you want to save changes to the design of query 'qryConfigItems(find)'. Please Help!
  14. schines

    Printing out multiple copy, when I only want one?

    Thank you very much!! I went through and found the one that was causing the duplicating, removed it and reentered the data. So far so good!! Thank you again!
  15. schines

    Printing out multiple copy, when I only want one?

    Thanks that helped! For some reason the qryECPDataFilter(Project)is duplicating in this job. can't find the duplication in the table, but I will still keep looking! If you know of anything else just let me know! Thank you.
  16. schines

    Printing out multiple copy, when I only want one?

    SQL view: SELECT {qryECPDataFilter(Project)}.*,tblProject.Introduction,tblProjectManager FROM tblProject INNER JOIN {qryECPDataFilter(Project)} ON tblProject.ProjectName = {qryECPDataFilter(Project)}.ProjectName; May-be this can help!! Thank you!
  17. schines

    Printing out multiple copy, when I only want one?

    I am not quite sure that I understand? I think that is's my falt!(sorry just started working with access and I was thrown into the database to fix the problems for work). I have a form that reads different data depending on the user chose and what Number they chose. The form prints out fine...
  18. schines

    Printing out multiple copy, when I only want one?

    When I am printing a set of forms from a selected job some how I am printing double. This only happens on selected jobs from the database. Some print out good and others print out doubles? Please Help!!

Part and Inventory Search

Back
Top