Search results

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.

Ok everyone, this could be something simple but it seems to be eluding me. It sounds really complicated but please try to follow. The main form is Log details. The main form contains three tabs in which I have placed 3 sub forms. One of the tabs displays part information. On the parts tab...

OMG where is the face palm emoji when you need it. I feel really stupid now. My thanks to both of you that was the solution. In the end I decided to stick with the For Each loop since it works when you tell it to set the correct value. My great thanks to the both of you that just made my...

I can't express my thanks enough to the members of this community. You have all been so great helping me find my solutions. I'm learning a great deal everyday and appreciate the welcome that I have received. :banghead: I'm working with a form that searches my records based on 4 possible...

Unfortunately I don't seem to be getting anywhere with this one so I'm going to move it to a new thread. I will mark this one solved because Gina provided me with the answer that I originally needed. This one however is making me scratch the skin off my head, and I have more information to...

where should I place the debug in the code. As for results, I manually checked the table and it should be returning something no matter what conditions I put in. Each condition has at least one record to display, I made sure of that for testing purposes.