Search results

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

I'm not a programmer but am putting together a search form. There was a search form sample shared on this site, and I've taken it and modified for my own use. Here's how my version of the form is supposed to work: When the user provides a text input for the search, a number of records that...

I'm creating a form that has combo boxes pertaining to each of the following fields from table "Documents": DocumentID (primary key), DocumentTitle, DocumentAuthor, and DocumentYear. No combo box is used with any priority over the others. The working form will allow a user to retrieve the full...

I'm new to access and am having problems creating forms. When I design a large form (one with many fields) using the form wizard, it will not display in form view (the screen is just blank). I'm only able to see these forms in design view. This problem doesn't seem to come up with smaller forms...

I have a Dell Inspiron 8500 that is about a year and a half old with plenty of speed and space. I recently installed the 2003 microsoft office suite. I'm working on an Access database now, but almost anytime I change or navigate database (update tables with new fields, alter queries, enter data...