Recent content by piggitypow

Listoboxes have arrows too so same problem.

I would like to have a combo box that doesn't show the drop-down arrow when the user selects it. You say, doesn't that defeat the purpose of the combo box? Well, look. In a form I have a datasheet (in a subform) that only displays data, so it is locked from editing. Within the datasheet is a...

YAY! That worked. Man, not being a programmer drives me mad sometimes.

Got the subform to work seamlessly by altering the SQL code of the corresponding query a bit. Thanks for the insights though.

Please refer to the attached file. The form of concern is frmAssessmentInput. Select the appropriate criteria per instructions (in red), including entries on the continuous subform. Then click the "Input data" command button. A 2nd form opens (frmObservations) that contains a textbox labeled...

thanks. got it to work. didn't realize access wants you to just stack forms if you want them close. also had to disable the scroll bars. i had tried that before, but obviously not with enough diligence.

yup Wow! I have Macafee. There was zero indication that virus software was the culprit, but that did the trick. Thanks.

still having problems I disabled name tracking and autocorrecting, but am still having problems. For every 10 simple design tasks I perform (including just toggling views) 4 or 5 cause the program to freeze up for about 5-10 seconds. When access freezes it always performs the task, just with...

Still stuck This public function method is new to me, and I only have a little VBA experience (Excel, at that), so I need some babying if you can be patient enough. If I can get one form to work as a subform without asking for query parameters in the parent form, then we have success and the...

I'll keep looking into the public function stuff a little more, but not sure that will work. Here's what's going on. My big form is for data entry. It pulls data from two tables (tblDocuments and tblStreams) via two separate searches embedded in the form, allowing the user to both select a...

Hello? I get the impression I'm being ignored because people feel this topic has already been addressed in the forum. However, I have searched all over and have come up with only part of the solution. There should be a simple substitution in query design criteria to address my problem, right...

Please refer to the screen snapshots. I've got two subforms on an input form, and space is critical. In design view the forms are very close together (how I want them), as depicted in one snapshot. But then when I go to form view, each subform has a big gap below it, which spreads the two...

I have a search form that includes the following expression for the criteria component of query design: Like "*" & [Forms]![frmDocumentsUpdate]![Search2] & "*" In the form frmDocumentsUpdate this works fine, but I want to apply this single query to several other forms without designing a...

I have a search form that includes the following expression for the criteria component of query design: Like "*" & [Forms]![frmDocumentsUpdate]![Search2] & "*" In the form frmDocumentsUpdate this works fine, but I want to apply this single query to several other forms without designing a...

I'm new to access and am designing a form. For what ever reason, when the form is open and I'm in design view, the field list button on the design toolbar is grayed out, so I can't click it. I need to add source fields to a few controls (also, no fields are available in properties>control source...