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!

Register Log in
  • Congratulations derfloh 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. Toya2176

    3052 Error

    You are my hero. I really appreciate the help. That worked perfect.
  2. Toya2176

    I know that this is a involved prob

    I know that this is a involved problem, but I thought I'd post anyway in case someone is up to a challenge. My problem is this. I understand that Top Values can't be programmed, you can't create a input box to input Top value. So I thought about it and I have a chart where you can determine...
  3. Toya2176

    3052 Error

    Does anyone know what a runtime error 3052 - File Sharing count exceeded. Increase MaxLocksperFile registry entry means? This database works fine at home, but just recently at work it gives me this error and then halts. Does anyone know what I could do to correct this?? All help is appreciated.
  4. Toya2176

    Connecting 2 Forms

    You know if I go through the actually table section and manually input the File ID into that second table for Form B, and then on the forms click the button the file information will come up it actually finds it then. I thought that maybe I could have the two seperate forms that acted like a...
  5. Toya2176

    Connecting 2 Forms

    Sorry, guys wrong forum. I didn't realized where I was when I posted this.
  6. Toya2176

    Connecting 2 Forms

    I have two forms that are linked through FileID. I could have Form A and then Subform b, but I need all the space I can get so I wanted one form that allowed me to type all the file information, click a button and connect it to a Form B where you list everything in that file. I wanted a form...
  7. Toya2176

    Connecting 2 Forms

    I have two forms that are linked through FileID. I could have Form A and then Subform b, but I need all the space I can get so I wanted one form that allowed me to type all the file information, click a button and connect it to a Form B where you list everything in that file. I wanted a form...
  8. Toya2176

    Networkdays

    Thankyou, THoey
  9. Toya2176

    Networkdays

    In excel you can type a formula using Networkdays that counts all the days excluding the weekend and Holidays, is that also possible to do in Access?? Or something like that??
  10. Toya2176

    Help.. Selecting "n" number of records

    Here you go... "SELECT TOP" & _ Me!NoTechCheck & "Heading.HeadingID, Heading.[File:], Heading.Location, Heading.Building, Heading.[File Clerk], Random.TOID, Random.[Technical Order No], Random.QTY, Random.TmpRandNbr, Random.[Audited Date];"
  11. Toya2176

    Help.. Selecting "n" number of records

    Mikevh Ok, I'm not sure if I'm doing this right. I created a form and added my text box. Then in the after update I entered your code as an expression, and its giving me errors. Can you take it step by step if you have the time. Toya
  12. Toya2176

    Selecting "N" Number of records

    Thanks LameId, but I don't want to set a fixed number. Basically at any given time any given number of records will need to be selected. I don't mind myself setting the top value in the SQL properties, but users won't understand how to do that. Here is what the SQL view shows : SELECT...
  13. Toya2176

    Help.. Selecting "n" number of records

    I was wondering if it was possible to select any given number of records without changing Top Value in the Queries properties. I want to be prompted : "Please enter # of records to return". I don't need any particular order because I have a mod already set up to randomly pick what...
  14. Toya2176

    Selecting "N" Number of records

    I was wondering if it was possible to select any given number of records without changing Top Value in the Queries properties. I want to be prompted : "Please enter # of records to return". I don't need any particular order because I have a mod already set up to randomly pick what...

Part and Inventory Search

Back
Top