Recent content by Krystoff

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

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

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

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

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

Any help with this? Shameless bumb.

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

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

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

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

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

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

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

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

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