Topics Search

Forms and SubForms

Forms and SubForms
Views: 163
I have a Form that is a list of dates, and a subForm that is all the projects worked on for a given date, with the hours for each.
I would like to have a field on my main form that is the total hours on a given date, and I would like this field updated whenever the hours for a project on that date is updated. I have tried some VBA code in the "After Update" box on the subForm, but that does not seam to be working.
Sponsored Links:

Similar posts...


subforms in unbound forms

subforms in unbound forms Icon
I have unbound forms name: Project_List, in it there is two subforms bound in a query. Is there a way to link the two subforms, so that when I click a record on the first subforms. it filters a related records.

Let's say in field name: Doc_Name when I click a record from this field, access will filter related date in the 2nd subforms.

Prevent subforms in access from loading before main forms

Prevent subforms in access from loading before main forms Icon
We use subforms in Access a lot around here. Sometimes, we may have upwards of 5 or 6 subforms per form. Adding that many can be a real drag on performance if you’re not careful. This is part one of two posts on the topic. Ben will talk about disabling the loading of subforms on startup in our next post.

subforms update ALL records at once

subforms update ALL records at once Icon
I have a set of tables that are accessed by forms and subforms. A couple of the subforms seem to update ALL of the records in the relevant table when data is entered, while other subforms correctly update only the viewed record
Ideas on where to start debugging this would be greatly appreciated!

Sectional and Tabbed Forms, Subforms, Subreports

Sectional and Tabbed Forms, Subforms, Subreports Icon
Databases are made of various objects and it is not unusual for one of these objects to contain various fields. If you try to create a form for such an object, you may encounter a space problem. Even if you decide to reduce the amount of information on a table, because you still need to follow your customer's goal, you may not have this complete liberty. Therefore, instead of deleting necessary fields, you can use one of the various alternatives offered by Microsoft Access.
TOC: Sectional Forms, Tabbed Forms, Subforms and Subreports, Subforms and Subreport Design.

Subforms constantly refresh

Subforms constantly refresh Icon
I am having trouble with subforms constantly refreshing. I am building a form with a timesheet (first subform) and a sortable project list (second subform); each of the subforms is a continuous by default. However when both of these forms are on the form they start constantly refreshing. I commented out all the code on both subforms and the main form but it still does this. There are no macros either.

Does anyone know how I could fix this? As I said this doesn't seem to happen when only one of the subforms exists on the form, but I really need both to make this at all user friendly.

Edit: Forgot to specify this is in Access

Form event to detect switch between forms and subforms

Form event to detect switch between forms and subforms Icon
I have a form with lots of subforms and sub-subforms. Is there an event that fires when I move from one subform to another

Creating subforms

Creating subforms Icon
Microsoft Access Tutorial: To learn the creation of forms with subforms included.

Subforms : Create form within form

Subforms : Create form within form Icon
The advantages of forms within forms, Creating the main form, Creating the subform, Linking the main form and subform, Linking forms and subforms
manually, Non-synchronized forms, Aesthetic refinements. (pdf file, install Acrobat Reader to read this tutorial).

Designing forms - what is important?

Designing forms - what is important? Icon
I'm working on creating a database, and I've already set up the tables and relations. Right now, I'm stuck on the forms. My idea of forms is just forms with subforms, so you can update allthe related data in the same form.

But now that I'm designing the forms, I find that my forms are very cramped, or that I have a lot of subforms. what is important when designing forms? how do you knowwhen to put a subform and when not to put a subform? If you say related data, but the whole database itself is related isn't it?

Subform/tabbed form tutorial

Subform/tabbed form tutorial Icon
I'm still lurking and trying to do bits on my db when I can. Weather is getting a bit rubbish now so will probably be doing more on the PC.

Would someone be kind enough to point me in the direction of a good tut on subforms and tabbed forms?

I want multiple tabbed forms, I'm guessing I have to put them in as subforms? Before I start doing that can anyone tell me if there any drawbacks/limitations to using them this way?