Search results

Any thoughts on this?

I have stripped the excess from the database and entered a couple records. Note: The same Reg Z HELOC record shows for each loan/tran. Use the New function in the upper right to add a new loan record. Check or uncheck the Reg checkboxes on the Detail screen to show or hide the Reg tab(s).

Each transaction is evaluated on up to 8 different regulations. These are presented to the user via tab control on the Transaction form. Each tab presents the information related to the respective reg on a subform. In the case of RegZHELOC the number of questions require two forms (22" form...

(attached) one to many (Loan > Transaction), one to one (Tran > RegZHELOC) RegZHELOC is the subform with RegZHELOC1 and RegZHELOC2 being the subsubforms (not shown in the relationships).

I think that is the issue at hand - how should the forms be linked between the parent form and subsubform so the data flows correctly via the subform which is only serving as a "container"?

That makes sense to me and from that perspective I removed the link between the subform and the subsubform. Then when I attempted to input data in the form, I receive an error that the record could not be created without the primary key. The primary key fields (joint key) are only shown on the...

Yes. (Sorry if unclear.) And I attempted to link the subform with subsubform using with the same fields. This is when I get the "object variable or with block variable" message.

Apologies. If an admin can help, that is great! I have tried it both ways. My first attempt was to link the subform to the parent and then link the subsubform to the subform.

Hello All and Happy New Year! I am working on a project where I need to create a record from a subsubform while referencing primary key data from the parent form. I am using the Link Master/Child Fields to filter the data on the subform. I would not have to use the subsubform except my...

Hello All. I am looking for input on the presentation of data in a form. The form details the customer record. A subform contains two tab controls. The first represents transactions. The second represents elements of the transaction. Each customer can have a different number of...

John Big - I think we might be on to something with that code. Thanks!

Hello All. I have tried to find what I am looking for a while now but may not be wording it well. I am trying to recreate the equivalent of the search text box found in the Navigation Bar at the bottom of tables/forms in my form. I am primarily interested in searching two fields from the...

I was able to resolve the issue by resizing the tab control to fit within the screen size and limit the subform to the size of the tab contol. Now the subform has a scroll bar but the subform doesn't auto-scroll.

Thanks, Linq! I didn't make the connection between the subform being long and the auto-scroll. In my project the best arrangment is to leave the subform long with scrolling. (I am using tabs to group data by applicable subject matter.) I have verified my field tab order is correct. How can...

Pat - I have tried your recommendation. I created a test form and added it as a subform to one of my tabs and it works correctly. But I can't figure out how to re-size either my original subform or tab control so that they play nice together. Thanks.

Thanks Trevor G and kelvray for your input. I was able to use the macro recorder to get part of what I needed and then added a line code to complete it. The solution is as follows: 1. Add section break at the top of the document. By default, this associates the first page header/footer with...

I wasn't aware recording a macro created code. I'll check to see what I can figure out.

Thanks for your response, Trevor G. I am really looking to use vba coding to accomplish the protection. I have a form with loads on open. I use that to flood bookmarks. Now I want to lock the header and footer using code.

I am trying to figure out how to protect the header and footer of a company letterhead document using vba. How do I reference those parts of the document specifically and leave the rest of the document available for use by employees? Thanks in advance.

I have report whose data source is query3 based on a 4 fields from a query1 and one field from query2. When creating the report, the field from the query2 will display but if I close the database and reopen it, the control source for the field on the report reverts to the field name from...