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...

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?

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...

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...

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...

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...

Hi everyone, many thanks for the help on the last few items. Mistakes and face-palms on my part. This one is truly perplexing me. I have a simple form in which I enter in search parameters to search a particular table. The table is tbl_Log_Pages. Ordinarily I would simply add a control...

Hi everyone, I have a form that will not open when I call it. DoCmd.OpenForm "frm_Log_Results", acNormal The code looks right but I keep getting a Run Time Error 3008. Something about not being able to open the table programmaticly. The form is a columnar style with a function button...

Ok I'm stuck. I used a bit of a work around to get the results that I am looking for. I have individually tested these lines of code below. The first two work interdependently, but my attempt at getting them both continues to fail. I either get a "Missing Operator" error or "Expected List...

I am totally stuck. I have a query SELECT Count(tbl_Log_Pages.Logpg) AS CountOfLogpg, tbl_Log_Pages.tail, Format([disc_date],"mm"", ""yyyy") AS Expr1 FROM tbl_Log_Pages GROUP BY tbl_Log_Pages.tail, Format([disc_date],"mm"", ""yyyy") HAVING (((tbl_Log_Pages.tail)="N4615W") AND...

I have a project I'm working on and seem to be stuck. I think I'm close but the pass through is not working. I'm working with two forms. Sign off "frm_Sign_Off" and 8130 "frm_8130". The 8130 form is opened by clicking a button. The goal is to auto populate two critical values from the Sign...

Greetings all, so obviously I am missing something. :banghead: I have a form in which I have placed a sub form table. For the purposes of this post, lets just run with the counting issue. So what I am attempting to do is to have the code count the number of records in the table. Please remember...

Greetings Everyone, My name is Vince, I'm new to the Forum. I am still learning my way around Access, and while I understand things pretty well, I still have a lot to learn. Looking forward to working with everyone.