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. Krystoff

    Convert Function and Dates with DateTime

    Interesting, I will remember that for future reference. Thanks again! Chris
  2. Krystoff

    Convert Function and Dates with DateTime

    Thanks! Thats what I was looking for. Quick question, why would you convert it to Varchar and not to DateTime? Seems backwards to me but it worked brillantly Chris
  3. Krystoff

    Convert Function and Dates with DateTime

    Hey hey all! I have some data in a table that contains two types of dates. 1) Just the date 2/6/2004 00:00:00 2) Date w/ time : 2/6/2004 11:15:04 When I run this where statement against the date it will only give me back the date if I use a single date for @BEgDate and @EndDate. WHERE...
  4. Krystoff

    Capturing elusive data

    Gary, Yep Im doing that but I guess I should have made myself more clear. The problem comes up when I have these situations: 1 record in my database, 2 records in their database 2 records in my datbase, 2 records in their datbase 2 records in my database, 1 record in their database I begin...
  5. Krystoff

    Capturing elusive data

    Hello all! I am having trouble figuring out a way to search data and there really might not be a way. Here is the problem. I have a database that I made for my department. It has customer information in it. My company has a different database that houses customer information, and new sales...
  6. Krystoff

    On Dirty, After_Update and Pressing ESC

    Any help with this? Shameless bumb.
  7. Krystoff

    Check box question

    Goldy, It needs to actually read offer:iif(offer_flag=-1,"Free",$$$$$) The check_box was refering to what you had named your check_box Try that. Chris
  8. Krystoff

    Check box question

    Goldy, You would place that into the "Field" section. It takes the place of a field. Chris
  9. Krystoff

    On Dirty, After_Update and Pressing ESC

    Hello all, I have a form that has reservation code on the On_Dirty event and I have code that takes of the reservation in the After_Update event of the form. Basically it puts a value in a table when the form is dirty. When the user is done editing, the after_update code takes it out of that...
  10. Krystoff

    Multiple Appends in a Stored Procedure

    Ok, I tested it and it does append all new records into the second table! Woohoo! Now, the question I have is can that trigger only be triggered when it comes from Table1? I have users inserting data into table1 all the time but I don't want that trigger being run except when the command...
  11. Krystoff

    Multiple Appends in a Stored Procedure

    Thanks for all the quick responses! Having just started learning SQL and so forth, I don't really know how to do complex stored procedures or triggers at all. So if I understand correctly, Phil's advice will have my stored procedure do this: User press's button, Append Stored Procedure runs...
  12. Krystoff

    Multiple Appends in a Stored Procedure

    Hello all, I have just started learning about Output Parameters. I have a stored procedure that appends some data to table1. Then I want to get the identity of all the new records I just appended to table1 and append them to a another table along with some information from the first table. I...
  13. Krystoff

    Using newly created Autonumbers

    Hi all, I have some code that is going to make a new record in a table thus generating an autonumber. Then I want to take that autonumber and append that with some of the original data and paste it into another table. Whats the easiest way of doing something like that? I know I can do it the...
  14. Krystoff

    Including date range as a combo box.

    Hey Brandon, Do you have Winzip? That email address won't accept something that large. I have a couple more that will work if you can't zip it up. Either way, send it to krys_wilson@earthlink.net as that will be a better email system. The subform was the correct place to put the criteria...
  15. Krystoff

    Including date range as a combo box.

    Np, post here again tomorrow to make sure I see it or email me! Chris
  16. Krystoff

    Including date range as a combo box.

    If you can delete the info that other people arent supposed to see then email it that would work. Otherwise, lets muddle through as best we can! Ok, add the two new text boxes. It will be a little more work but rename the old text boxes so you can easily distinguish them. So the four text...
  17. Krystoff

    Including date range as a combo box.

    Dont worry about the help, it gets me thinking about other things than my own work :) Ok, so I assume that the vba window keeps popping up which is very strange. I have never heard of that happening. If you can send the db, you can email me at krystoff@exite.com with the db (as long as its...
  18. Krystoff

    Including date range as a combo box.

    Brandon, Ok, not sure about being taken back to the VB window. Try shutting down the VB window before opening the form. If that doesn't work, can you post the code exactly as it shows in the vb window? For the text boxes, in the format of the field put "Short Date" Also, if you...
  19. Krystoff

    Multi Table Record deletion

    ZeoGel, Do you have relationships built between them with referential integrity enforced? If you don't know how to do that, goto: Tools > Relationships If you have referential integrity forced between the tables, you can not have a record in the many table unless there is a record in the one...
  20. Krystoff

    Fill text box with query result based on combo box data

    You can change the record source of a form to do what you want. Then make the text box bound to the field that shows where the piece of equipment is. I would make a form with a subform and base the subform on the query with the combobox as the criteria ([forms]![yourform]![YourCboBox] OR...

Part and Inventory Search

Back
Top