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 Chriss Miller 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. benu302000

    Working with dates in Access

    Can you you the add operator like that with dates?
  2. benu302000

    Working with dates in Access

    I am trying to implement a form that will allow a user to search for records that are about to expire (VIA a date field marked "expiration date") through a form that allows them to enter the number of days from the current date to check for records about to expire. For instance, if the user...
  3. benu302000

    Creating Tables/ Text Boxes on the fly

    But Does anyone know of a resource on how to add items to a form? Function calls and such?
  4. benu302000

    Creating Tables/ Text Boxes on the fly

    I have a set of three text boxes and a combo box. The functionality I need is: if the combo box is set to a specific value (I.E. "Approved") Then the form must create next to the set of boxes, another set just like it, which then in turn, must have the same functionality as the last set. So I'm...
  5. benu302000

    Form Open Error

    I have a form set up that I am attempting to get to act as a menu for several other forms (A data entry form, a data selction form etc...) I have set up command buttons to open each. However when I click them I get this error message: "The expression On Click you entered as the event property...
  6. benu302000

    number of records on form

    I have a form that displays results from a different "search" form. in this form, I would like to have a number for how many results were returned, any ideas?
  7. benu302000

    Checking for Blank text boxes in VB

    what is "trim$" and "vbnullstring"?
  8. benu302000

    Checking for Blank text boxes in VB

    I have a search form set up with multiple text boxes and a search button, which pulls up another form to display the results. I do this by building a "where" statement and sending it as a parameter to the next form. In order to do this, for each portion of the "where" statement I build I have to...
  9. benu302000

    Query Spamming

    Ok, I'm trying to work around the whole query thing by using the "where" parameter for docmd.openform I have a bunch of fields on the criteria form, and in this block I am attempting specify which records to bring up in an already created form, and it seems to work, kinda. It doesn't throw any...
  10. benu302000

    Query Spamming

    Thats not quite what I need. I intend to use the query as the source for a form I've already created
  11. benu302000

    Query Spamming

    I would like to create a query that allows the ability to search for some number of different parameters of data (Through User Input) but without spamming the user with parameter requests. Is there anyway to design a query so that a user can perhaps choose what criteria to search by?
  12. benu302000

    An Easy one for you vets

    Ok, How do I get a subform to refresh it's contents? I know its called requery, but how does that work? and is there a way to do it continually, or every so often?
  13. benu302000

    Messing with tables from visual basic

    already solved it, thanks anyway
  14. benu302000

    Append Query

    Thanks, I suspected it was the from statement
  15. benu302000

    Append Query

    I have an append query that is meant to copy a certain record from one table, and put it on the end of another table, but for some reason it refuses to copy from table to table unless the destination table already has a record with a related field in it. And then if I get it to run, and run the...
  16. benu302000

    Messing with tables from visual basic

    Alright, definetly making some progress now, but I'm having troubel tweaking the append query to work the way I want it to. For instance, it won't copy from the source table to the destination table unless there is already a record with the same billet number (the two table's related field) in...
  17. benu302000

    Messing with tables from visual basic

    I've got a form that allows you to select a record out of a combo box. from there, I have a button to launch a new form that will pull data from a different table using the record from that combo box as the relation. What I want to do, is then, when the new form loads up, take the record from...
  18. benu302000

    Command Button Blues

    Yep, That was it. No more problem, Thanks a ton.
  19. benu302000

    Command Button Blues

    Ok, I've got a command button on a form that opens up a new form populated by data thats related to a control in the old form. It was work a moment ago, and now I'm getting an error that says "Syntax error (missing operator) in query expression "[Billet Number]=" heres my code for the button...
  20. benu302000

    Combo box to list or subform

    It might be. I'm trying to set it up thus: combo box that has a table as it's source: already done list-box/subform that takes key value from combo box and uses it to populate list-box/subform: not done Get my problem? I don't know how to tell the list-box, or whatever, what to use as a...

Part and Inventory Search

Back
Top