Search results

Thank you very much.. That will work

I have a form that has a date field. I have a button next to that field that opens another form that I've placed a calendar on. Is there a way to click on a date in the calendar and have it automatically insert the date into the date field on the previous form?

When I tried, it didn't work it still keeps it highlited Here is the code I used: memo=memo & Now() & vbCrLf When I tab into the field it only leaves it selected... Any ideas?

Thank You That worked out perfectly, thank you. When It enters the date it is selected. Is there a way to have it enter the date and time and then return to the line underneath it? (Like hitting enter in word to create another paragraph.) ex. I tab into the memo field and it enters the date...

I have a memo field on a form. I am trying to autopopulate it when entered into. For example: I enter in clients info and then tab to the memo field and it automatically enters date and time. Then later when I go back to that same record to append to the memo field it adds the current date...

I made the record source tied to the query. However now when I run the query it brings all the records up regardless what I choose. It's as if the list box is just there for looks. Any ideas?

I have a form that has a bunch of unbound fields on it. I have a query that is tied to the fields of the form. The purpose is the form is a filter and when you type something in it goes through the query and then creates a report. The form is not bound to anything. Is there a way to have a list...

I notice it's not going through any query. so, how would that work in my situation where all the other unbound fields are going through a query?

Query by form PLEASE HELP I have a form that has a bunch of unbound fields on it. I have a query that is tied to the fields of the form. The purpose is the form is a filter and when you type something in it goes through the query and then creates a report. The form is not bound to anything...

Now your the master genius...

There is one last thing I would like to learn from the Master... I am now trying to create a final count of that sequential column. In the Report Footer I have the following code in an unbound text box. =Count([Number]). "[Number]" is what I called the sequential column, but it doesn't work...

Your a genius!

one last stupid question... where do I set the default number to one. I dont see it in the property box.

Where is the running sum option located.

Just for a report

I am trying to create a sequential number field in a query. I cant use an auto number for the fact that i am combining multiple tables. Any help with this would be greatly appreciated.

Thank You Thank you. It works great. Is there a way to get the same outcome without using the "Triple State"?

I have a form that has unbound check boxes on it. They are linked to a query. The query has the following script in the criteria section [Forms]![frmTEST]![Check0] This is set up so that when I put a check in the checkbox and press the control button it envokes the query. I have 6 boxes on...