Search results

Are these initals going to be highlited when you type them or before an update? If it's before update then try: Note the Case Statement. Replace the Case "#" with your initials and the 255 with the correct color codes your want. Private Sub Form_BeforeUpdate(Cancel As Integer) Select...

I'm stuck trying to figure out how to update a query I have already saved. Here's my situation, I have already created a query called "REPORT_STMT_Breakout" and I want to be able to change this query based upon some date variables on a form. I'm using this query to create a pivot table. I can...

Anyone Anyone??? I'm trying to create an access pivot table with variables. has anyone heard of this?

Anyone Anyone??? I'm trying to create an access pivot table with variables. has anyone heard of this?

What are the fields of your table? What's your table name? Here's what I could think of from your question. Query: SELECT Student_Name, Class_Due, Date_Completed FROM basic_table WHERE Date_Completed <= DateSerial(Year(NOW),Month(NOW)-10,day(NOW))

I have a query I saved which pulls data and a form that creates a pivot table based upon the query. Is there a way to create a query based upon criteria such as dates to limit my recordset? I'm trying to set date values in a form and update my saved query but I cannot figure it out. Any help...