Search results

the 1st link is on a field which shows which project the data is for (so there are many fields with the same value) and the 2nd links on the actual record (e.g. Record 1 for Project ACB) Should I just link it on project and then group by record number?

Hi, I have a query which is based on 2 tables. There are 28 columns in the query, 24 of which are calculations using fields in the 2 tables and 1 of which is a d-look up. I had 1 link between the 2 tables and the query runs very quickly, however, when I add another link it takes AGES...

Ah right. I shall remember that! Thanks again!

Ah right, I thought they were needed because of MonthNumber being text... does it not need them because its calling part of a table rather than being a criteria?

Oh, ace! Thats brilliant, thank you!

The second options - it returns text such as Month01

It's Text datatype

The table the dlookup is looking at only ever has 1 record, so that is not a problem. I now have: CurrentDb.Execute "Update TblMpp Set TblMpp.'" & Me.MonthNumber & "' = 0 Where TblMpp.Phase = '" & DLookup("[PhaseNumber]", "[TblPhaseCurrent]") & "'" but its saying I have "too few parameters...

Hi! I am trying to work out a bit of code which I can put on a button which will set every record in a column to 0 if certain criteria are met. Example: The table has 24 columns - Named Month01 to Month24. I have made a continuous form with a button showing each of the month names. When I...

oh, right, so you would have the subform in the header, linked to whichever record was selected... so it would work the same way as the pop up, without there having to be a pop up? I think i get it now. And missinglinq - the OnActivate works well. I think i will give the subform in the...

Thank you for your help so far, however I am confused about what you say with subforms being possible in continuous forms. I have heard this a lot but whenever I try it comes up with the message: "A form with a subform object can't have its DefaultView property set to Continuous Forms" Am I...

I don't think I will be able to get the query updatable as it is not a 1-1 link in the query. Also, I can't use a subform as the form is continuous. If I went for the last option (update in code) would I put that in the unload of the updatable form?

Thanks for the reply... but that doesn't work as the main form is non-updatable. I'll explain a bit more and you might come up with a better way of doing things! Basically, I have a form which shows every record with some information. The information comes from 2 tables, which are linked in a...

Hi, I have a form which, when you click on a certain button, opens another small form (with the original form still visible in the background). This small from allows the user to add and change information about the record they selected. What I want to happen is for when I close the small...

Hi, I have a form which I am trying to filter on open using: DoCmd.OpenForm "FrmAbc", , , "[FieldA] = SomeCriteria") I have used this many times, so am fairly comfortable with it, however, this time I need to filter where a calculated filed in the form equals some criteria. I have named the...

Brilliant. Thank you!

Hi, I have a form (a) where I select an option from a ComboBox which then opens another form (b) filtered for the ComboBox selection. On the form b I have another combo box with the same options as the one on a (i.e. so you can open the form for a certain selection, then change the selection...

oh, ace! Thank you so much - I do love it when it's something that simple!

Filter changing fields?? Hi, I have something odd going on in one of my forms! Its running from a query, and it a continuous form. There is a combo box in the form header with an After Update code to filter the records for whatever is selected. However... The selection in the combo box...

Ok, thats cool. I shall put it in a query. Thanks for your help.