Search results

I have a form with two text boxes in which I would like to insert the current date automatically when the text box has got focus. Default value doesn't work because the current date may occur on two different days, and the default has to be null until the current date is inserted. Can...

Thank you Meltdown, it worked great. Is it possible to change the color of the background of the message box?

I would like to have an update (requery) button on my form, that when clicked opens a message box that asks "ARE YOU SURE YOU WANT TO UPDATE?", if yes, a yes button is pushed, which requeries the record and closes the message box. If a no button is pushed, the message box is closed without...

Thank you RichO, with some tweeking by adding another date field into the mix it seems to work fine.

Hello, I have a date field in my form that I would like to have the date change color sixty days prior to the date entered. Can someone give me the expression to use in conditional formatting? For example: If the date is 9/30/05, I would like it to change color on 8/2/05. Thanks

I have found the answer in another forum. For those of you that might have the same problem, simply remove any formatting from the field in both the table design view and the field proberties view in the form. Everything you have typed that didn't show before will miraculously appear.

I have a form with a memo field. This field is based on a table with a field set as a memo data type. The problem is that although the form field lets you type endlessly, it only saves 255 characters. A memo field is supposed to let you enter up to 64000 characters. Has anyone else ever had...

Hello everyone, I found the answer in Access help, under trouble shoot forms, subforms. You have to go to the LinkChildFields and LinkMasterFields properties of the subform and change the properties. Help gives a detailed description of the process.

If I have a form with a main form, and two subforms, which are both continuous forms, is there a way to have the data from the primary key of the first subform show up automatically in the foreign key of the second form?

Hi Stef, thanks for the timely response. The only problem with making the second subform part of the first subform is that the first subform has to be a continuous form.By nesting the two subforms together Access does not allow the first subform to be a continuous form. How do I work around this?

I have a form with a main form and two subforms. The first subform automatically populates it's linked field with the data in the key field of the main form, but the second subform does not auto populate it's linked field with the data from the key field of the first subform. I have created main...

You can't update a record directly from a query containing two tables. You have to create a form from the query and change the "record set type" property to Dynaset (Inconsistent Updates). The "record set type" property is under the form properties. That should solve your problem. rbrule

Try changing the focus of the chart from by column to by row. In design view right click on the chart and choose chart object> edit. The datasheet view will show, as well as a menu bar at the top. You can switch focus by clicking either the by column or by row button. When you do this, the view...

Hi xili, In design mode, click on the insert button on the top menu bar and choose "chart". rbrule

We had the same problem. Our solution was to get a PDF writer. We used ScanSoft PDF Create. It cost about $40. Now we just save as a PDF and email as an attachment. rbrule

Hello everyone, I posted the above thread a while back and no one responded. I supposed it was because no one had an answer. In the mean time I figured it out and want to share with anyone else who has the same problem. 1) Create a crosstab query that shows the data the way you want it...

Thank you, I appreciate your help.

Hello, I have a calculated field in a query that returns " Check reason" if the [registration number ]field is null. The [registration number]field is a text field that has both alpha numeric and alphabetic entries. Is there a way to tell my query to also return "Check reason" if the...

Thank you Graham, I appreciate your help.

Hello, I would like to bold all fields in a record in my report, if the value of my [commission field] =0. In design view I highlighted all involved fields, and entered the conditional formatting menu. I know that I need to choose "expression is" . However I don't know how to write the...