Search results

Oh it did and I'm working on it. I'll post shortly. Thanks Pat.

Ha. Read that wrong. I did find the problem however, and it's totally my fault here. I have an On Current event on the SF_Contract that has the cboContractNumber in it. Private Sub Form_Current() 'Q_ContractCombochoose1 only shows records that are not closed out and active...

Tried that this morning. No difference. Still shows the CloseOut TRUE and FALSE records.

I don't see the attachment. Can you resend? Thanks

I tried requerying the combobox on GotFocus but it did not help. Still give all data where CloseOut is TRUE and FALSE. Again, only for the combo that has something in it already. For a new record in the combo, it works just fine, only showing CloseOut with FALSE. Opening the query directly...

I have a combo box in a subform (cboContractNumber) that I want to be able to choose all the Contracts that are not closed. i.e. CloseOut = False. See below. The row source is Q_ContractCombochoose1 as shown below. The issue I have is, when I create the a new record in the...

I found the error. I had added the !ActiveAwarded = Not IsNull(Me!DateofAward) earlier. I removed that from the code and everything works as expected. It was left over from before. Not sure why I couldn't see it before. Thanks for all your help! Private Sub txtDateofAward_AfterUpdate()...

Pat, After reading your response again and looking at my snip, let me clarify something. Form A is not dirty when Form B opens. The picture may look like that but that's not what is happening. Form A goes dirty when I update the DateofAward in Form B. Form A - F_Project Form B -...

Thanks Pat. I will give that a try.

If I take the saving of the F_Project out (turned it to a comment), then it executes the "OBL". Of course, I get the Writing Conflict again. How do I fix this? It seems to skip the Forms!F_Project.Form.txtPropertyPriority = "OBL" !ActiveAwarded = Not IsNull(Me!DateofAward)...

Sometimes logic is not what the boss wants....so I'm trying to make it happen for him even though it might not follow good database practices. So are you saying it's not possible or not preferred? I still consider myself a novice at database development, so I would really appreciate some add'l...

So I tried the following but, now it won't put the "OBL" in the ProjectPriority text box. Where I'm going wrong? Private Sub txtDateofAward_AfterUpdate() DoCmd.RefreshRecord 'This will automatically change the Active Award in the F_Project. Dim projID As Variant 'get the projectid projID =...

Looks like a few folks have issues with the Write Conflict popup. I'm going to join that group today. I have a form that is open from another form. (F_Project has button to open F_Contract. See below) When a DateofAward is entered in the SF_ContractInfo (subform to F_Contract), I want the...

The problem was that the report was not showing the latest UpdateComment. So that's what was needing to be corrected. Thanks for the assist.

Plog, I stripped the UpdateComment, which was totaled by Last from the query and then created another simple select query, adding the UpdateComment. Thus I'm not using Last anymore. The report then, gets it's data from Q_SearchAll_for_Report. See below. Does this look correct? It seems to...

I’ll work with it tomorrow and report back. Thanks for the help.

I may be wrong, and I probably am, but with the totals query there seems to be an issue using a long text field, aka UpdateComment. I stripped the UpdateComment from the totals query and added it back in with a new standard query. That seemed to work but I don't know why. Any takers on why that...

My database was working just fine until a week or so ago. I have a subform that is used to provide project updates and is set to show the latest update comment, as shown below. The subform works as it should, which provides the last update, number 8 in this case. The table the feeds the...

Thanks Crystal! Linking the image resulted is a very clear pdf.

I have a pdf that is generated with the following code. The problem I have is the logo in the upper left corner, that I brought in as a png, does not print clearly once the pdf is generated. If I print it directly from the report, it prints nice a sharp. See comparison below. Any ideas how to...