Search results for query: *

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...

I have a bound form to a query (querying main table)that displays dates and related data. When the form is opened it displays the entire database (which is what i want) but I need it to have the current date viewed on the screen not the first date in the database from a year ago - that's a lot...

Since the search function on this site is down I could not research this question so here it is... How do I get the Calendar Control 9.0 (access 2000) to key in on the current date ? I have a bound form with the Calendar Control on it but when I open the form it starts with the first date in...

ooPS sorry people it is calender 9.0 not 7.

I am using Access 2000, Calendar Control 7 on a windows 2000 system. I have placed a calendar control on a bound form. Looks good, works good if you use the navigation buttons for the form. But the minute you start using the "buttons" for the dates the record information is not...

sorry mastermage i didn see your post when i sent buckeye his star. You are right on all regards so i am also giving you a star for the assist to a meeting dead brain. thanks :}