Recent content by Harley

You are right. What was throwing me off is I had zero as the default value in the form as well!!! Who would'a thunk??? :)

I have a table that has the possiblilty of zero as the answers. As it is now the default value is zero. Some of the fields have calculations. How can I accomplish this? Thanks

I can already manually add the data to the form, but that doesn't eliminate mistakes. By having the data entered into the form from the subform by double clicking the record in the subform would eliminate the possibility of mistakes. Thanks

I have a form with a subform. The subform is shown in datasheet view. I want to be able to doubleclick a record in the subform to fill in data on the form. I know that I can go to the properties of the subform and choose double click, but I have no idea what to do after that. Thanks a million!

I have added a subform to a form in an attempt to show data from a table so that the user can input data into the form. That is working ok, but I want to make the subform field sizes smaller and change the text above the fields. I have done it in design mode, but when I look at it in form view...

Well, I left clicked the square that is in the upper left hand corner of the subreport while in design view and went to properties as I have been doing all along and finally saw what you were refering to. Can I now just see? :) I deleted the linked child and master fields as you suggested much...

Which toolbar is that? I don't have it showing? This shouldn't be this hard! :)

I saw it, but I didn't know what the object selector is.

I am using MS Access 2000 and am not seeing what you have posted. I guess I have been viewing the report and subreport properties. What is and how do I view the "container" properties? Thanks for your help. :)

This is a subreport in a report, nothing to do with forms. I still looked in the properties of the subreport! :) I saw no mention of master or child fields. Am I missing something?

Ok, I give! :) how do you unlink a subreport from a report? Thanks,

I assume that it is linked. I used the subreport wizard. Is it automatically linked if the wizard is used? Thanks,

I put a subreport in a report so that I could show some data from another query. If I open the report that has the subreport, one of the rows of data is missing. If I open the subreport by itself, the row is there. I tried adjusting the space between the detail and Page footer, but that wasn't...

For other's information, it was a reference problem. :) Thanks for the suggestion! I had never run into that before and doubt I would have come up with the solution on my own.

Can anyone see a problem with this criteria in my query? SELECT Orders.[Date requested], Orders.[Item ordered], Orders.[Quantity ordered] FROM Orders WHERE (((Orders.[Date requested])>Date()-10)) ORDER BY Orders.[Date requested] DESC; I get and "Undefined function 'Date' in expression." message...