Search results

I have a form that has a command button on it. When the user clicks the command button I want the form that was up to be exited. I cannot find the correct syntax for this. Please help.

I have a form in which an individual has to input a date then choose a category. This is for keeping an individual's time. I want the date that user user first inputs to be the default date that is shown automatically unles the user changes the date, at which time, I want the new date to be...

I have a form that lets the user enter a beginning date and ending date in text boxes, then below that asks the user to choose a major category from a combo box. That works fine. The user the hits a command button below which opens a report. On the report is a chart based on the information...

I have a form that lets the user enter a beginning date and ending date in text boxes, then below that asks the user to choose a major category from a combo box. That works fine. The user the hits a command button below which opens a report. On the report is a chart based on the information...

I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?

I have a numeric month, as in 1 for January. I want to convert 1 to January. Any advice on the syntax?

I want to sum together the number of check boxes checked. The problem is that Sum gives a negative number. What shuold I do?

Try BETWEEN 1/6/2004 AND 8/6/2004 The second month you used (30) is not a month number. It must be between 1 and 12. Hope this helps.

I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need...

I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need...

I have a form with a check box among other itmes. What I want to happen is, when the user checks the check box, I want the text box to the right of it to be made visible and to let the user write text. But I only want this text box to be visible when the check box is checked. The check box is...

I want to place parameter values in my cahrt report. I have tried the syntax: =[Reports]![myreportname]![parameter] in a text box. This works fin in other reports but gives me an error in the chart report. Does anyone know why or what I need to do to get parameter values? Thanks

When renaming a field, can I write an expression that will rename the field. For example, I am trying to create chart reports for a query. Everything is fine except in my bar graph, my legend names or the names of my fields. I want them to be time periods, but these periods will be different...

Can I display the value of a field in my report if it is in the query that I used to create the report?

well, in another report I created, it worked, but there was no chart in that one. If I take the chart out of the one i am working on now, there are no parameters set up.

Do you mean do it in the report header or page header? Because that is where I have been trying it and it is not working.

yes, i think it may have something to do with trying it in a chart report. If i create a general report, it will work, but for some reason, in a chart report it is not working.

It is not working.

Well, they enter a begin date and an end date. From those two dates they entered I created a new field called Period in which I capture the two dates they entered. I want to display Period at the top of my Chart Report.

I have created a chart report from a query. My chart looks fine. here is what I want to do. I have a field in my query called Period. I was to diplay the value in Period on my chart report at the top, in the report header of page header. Is this possible?