Search results

RE Macro Writing Lin, to populate the PO number back to the frmPurchase you could do this by setting the Control Source on you PO field in the form you want it to show up on. Something like this should work. In your frmPurchases PONo field on the control Source put =Forms!Name of...

I hope this makes sense? I have a main form with a button that opens a new form. On the new form I have 5 fields. 1 of those fields is the Employee ID which I have the form getting from the main form (IE the Control Source is =Forms!Search_Employee!Employee_ID )and the other fields are bound to...

Thanks Guys Thank you to everyone for their help I will try these things and see what I can do. Thanks again

My Database I tried to zip my DB but it is 4 mb and it will not let me attach it. :(

Thanks Izyrider I am using Access 2K and have a little coding but not much. I agree that it is a very dangerous thing, it would not be good if only half of it worked. I do have ADO and DAO so any examples would be great.

I have an Employee Database with a form that displays the employee record. When an employee leaves they want to be able to click on a button on the form and have the record moved to a different table. My thought was to do a append query to move the record from my active employee table to the...

Thank you So Much Thank you so much ByteMyzer, that worked great. It was the whole CDATE thing thaqt made al the difference. :D

Does anyone know were my error is or of a way to query a table to find the number of calls from 8pm to 7 am for the whole week. (Error Message) Syntax Error (Missing Operator) in query expression SELECT [Half Hour Calls].DateTime, [Half Hour Calls].SumOfCallsOfferedHalf FROM [Half Hour Calls]...

:rolleyes: Ok Im a first time poster on here so if someone could help me I really really need it. I have a table that has a field called [DateTime] and another field that has numbers of calls via that time frame. I have created a form that has fields on it that are for the days of the week (IE...