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...
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
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.