Recent content by poul0035

That did it. Thanks.

I have a query that combines a date field and a time field together. When I try to sort that it seems to treat it as a text so that either Jan (1) will be at the top or Sep (9) will be at the top. Is there a way to sort this concatenate field based on earliest or latest?

Thanks! that did the trick.

I have a text box on form A where a user would enter a number and then press enter. On Enter it would open form B. The query that is the back end of form B is based on the data entered into the text box on form A. However right now when I enter a number in the text box and press 'enter' it will...

Yeah, that should get me going. Thanks for all of the help.

Awesome, works great. If its not too much trouble any way that you could add another table (like employees) in which you must select one from each and an 'other value'?..Trying to make sure I understand the code. Thanks.

No the event does not seem to be working.

looks pretty similar to what i need. Thanks. But, maybe I am stupid for asking, how do you make it work? shouldnt the 'add record' button then make records in Other table?

Thanks. Pretty much, I would add an event and pick the locations and Description table would record event_id, location_id, and interest(y) If three locations were chosen, three records would be made: all three same event_ID, 3 different location_ids and 3 yes

I have a table (Events) in which I need the action to be: when I create a record in event it automatically creates records on another table (Event_description) based on another table (Event_location). Tables: Event -Event_ID -Event_name Event_location -Location_ID -Location_name...