Recent content by Thumper75

Greetings all, Thanks for everyone's help as I have worked through my project. I'm entering the next phase now and it will rely heavily on queries. This is an aspect I have struggled with. For the most part I understand the basics of queries. I can manually create them and have had a fair...

Ok I'm not sure what happened but it is now returning values.

I put it in control source and still getting the #ERROR. The code looks correct....... =DCount("[ID]","TBLAcft_Desc","[Visit] = '" & [txt_visit] & "'") I have it in the Control Source property of the field.

This is the code that I entered into the Default Value property field. =DCount("[ID]","TBLAcft_Desc","[Visit] = '" & [txt_visit] & "'") It still returns #ERROR on the field list. Is it possible I am putting this in the wrong property? Perhaps it would be helpful to mention that the form...

Hi Everyone. I have a form that displays all open work orders. I am trying to get a calculated filed to count the number of items on that work order using the dcount. The code looks right but it keeps displaying "#ERROR". I'm sure the mistake is in the parameters I am laying in but I'm not...

Greetings Guru's I have two forms that I am working with. The first is a Parent form. On the load event I have it check for records pertaining to a tail number and log number. That code works without fail each time and is listed below. Private Sub Form_Load() Dim t As String Dim lp As...

Hi all, I feel like a dope at the moment. My form is returning the current record in the subform as history. Any idea's how to exclude the current record? I'm thinking a recordset count if any records are not equal to the LogPage #, but I can't think how to write it. Suggestions?

If you are still having problems with your forms, let me know and we can work out a time to get together. I'm not an expert but I am an Advanced user so I might be able to help you. I think what you want to do is have one input but retrieve several results from different tables. In that case...

Thanks for the suggestion. I tried changing the Enable property and am still having the same issue. The conditional formatting function is working just fine, but its applying the conditional formatting to all the records. Any idea how to apply a loop to check each record?

Hi Everyone, This one should be simple but is still cooking my noodle. I have a sub-form the finds and displays records where two conditions meet. In reach record I have placed and install button. If the part is not available, I would like to set the button to Visible = False. The code...

Galaxiom, I found what I was looking for. That did the trick. Thanks for the suggestion.

Galaxiom, I thought I was using conditional formatting. Hence the reason for my confusion.

My part monitor form is a columnar form displaying 4 fields from a table. The Status field only has 2 inputs, Open and Accomplished. The goal is to display the Status field in Yellow if the value is Open. This has been working fine, but if I change the value to Accomplish it changes to white...

Alright everyone I actually found the solution. It has to do with the order in which the code appears and I fired off the refresh right from the Submit button on the Remove Parts form. Private Sub cmd_submit_Click() DoCmd.Save DoCmd.Close Forms(frm_Prt_Monitor).Refresh...

The form opens in Dialog mode, that was one of the first things that I did when setting it up to begin with. I can set the focus to the parent form but its still not refreshing the sub-form.