Recent content by Craftsman61

What I am looking to do is to have the user select one of five different criterias as basis for one report. In other words no matter which criteria the user selects (they can only select one criteria) the report design / output would be the same for all 5 criteria's except of course the criteria...

I had a text box set to equal the value of the date time picker. Even though the date time picker said just the date and its properties as well as the properties of the text box where set to short date the text box would still display the time. It looks like 'BEEPS' just might have the work...

Try the calendar control to do this. I have tried it here with a temporary database and got it to work. The problem I keep running into with the date time picker is that it always includes a time. This is the problem. If you can figure a way around the time showing up with the date I'm sure that...

I am back. I tried at home last night to get a single date picker but to no avail. I have success in using two date pickers to select a range of dates. Your problem maybe in the date format you are using in your table is different than what the date picker has. It could be that someone more...

I see what you mean hmm I use the date picker in a way that i have the user select a range of dates thus using two date pickers as a criteria for a query. the criteria formula goes something like this Between [Forms]![frmForm1]![txtDTPstart] AND [Forms]![frmForm1]![txtDTPend] If you want me...

Yes. When the user clicks on a date from the drop down calendar the date picker displays it thus it becomes the value of the date picker. [Forms]![form1]![ActiveXCtl0] try using just the above line as your query criteria. You don't need to use like or wildcards.

To use the date picker is fairly easy. insert the date picker on to the form. give the date picker a name or use the default name. create your query and in the primary field ( a date) enter the date picker name as the criteria for the query.

My experiences with this error message resulted in a shared database and someone was in / using the database while I was making changes to it. I do not know if this is the case for you - its just a direction to look in, possibly.

This is what I did to make the a text box equal to the value of the calendar control. first i created a form load event making the calendar control value equal to the current date. Private sub form_load() Me!ocxCalCon.Today End Sub (the ocxCalCon is the name of my calendar control sub your...

THANKS, for the direction and code. It's greatly appreciated !!! You've got a star from me.

Just a question here. Is it possible to have a workbook and take one of its sheets and save that sheet as another, seperate workbook. What I am looking at is a workbook with numerous sheets that the users can fill in, once filled we need to save that filled in sheet as its own seperate workbook...

Is it possible to have a user click a button to preview/display a report on the form itself say in a text box or ole box instead of having the entire screen changing to the report review mode then closing it out to view the form again ???

Hi, What I am wanting to do is to have a calendar control 9.0 on a bound form display the current date instead of starting with the date that is first in the database. I have seen where people have said to use the .Today after the control name but I have tried this to no avail. Any help would...

Thank you for the direction, it is greatly appreaciated. I will look into it here shortly. thanks again chrissie1

Like a student I need someone to point me in the right direction here. What I am wanting to do is to have a form randomly select an image (from a say a total of 5) and load it in a ole frame/box. Is this possible and if so what kind of coding would be needed to pull this off. I don't want anyone...