Search results

I'm trying to count the number of projects based on the fiscal year (FY). I'm using an expression in the query called ProjectCount as shown below and it works but not with the condition of FY. It should also share that the database opens to a Main_F where there is a combobox for FY. The...

I think I got it. I had to add filter it first by way of an On Load event. Private Sub Form_Load() Me.Filter = "ContractInfoID=" & Me.OpenArgs Me.FilterOn = True End Sub Is that the best way to do it?

Using acFormEdit doesn't work for me either. I want to add a new record if there is no record there but, open the existing record if one is there. How do I do that?

I have a form (F_ContractInfo) with primary key of ContractInfoID. On the form is a button (ModRequestButton), that I want to open another form (SF_ModRequest) but have it linked to the F_ContractInfo via the ContractInfoID. SF_ModRequest has record source set to T_ModRequest that has a field...

You are 100% right Pat. Thanks for the input.

That worked! Thanks Arnelgp.

I've tried the following without success. Can anyone lend an assist? I'm using MS Access 2019. I get this error when trying to load the Microsoft DAO 3.6 Object Library. And it will not load.

I'm getting an error with the code from arnelgp. "Compile error in Access user-defined type not defined" I tried setting the reference library to Microsoft DAO 3.6 Object Library, but when trying to do so, give another error, "Error in loading DLL" Anyone know how to fix?

Very nice! Didn’t know about IsDate function before. Yes, that’s a better way. thanks!

Correct. I will disable it. I think that will work.

DB, that's a good thought but I think I want them to actually go to the F_Contract and edit it there. Arnelgp, Wow! I'm going to try that right away. AND study some of those code lines that I need to learn and understand. Many thanks guys!

Thanks Pat! That's great. I didn't see this for some reason but will definitely use this.

I have a database with multiple forms. Forms are F_Project, & F_Contract. On F_Contract I have a textbox called AwardDate. On F_Project I have a checkbox called ActiveAwarded. What I want is, when the AwardDate is entered (or deleted), I want the ActiveAward changed to True (or False). The...

Part of the issue is, sometimes the Property Sheet for the query will show the Text Format field for the text fields and sometimes it will not show it. Note below for the UpdateComment field, the Text Format is not shown. Then with the new query, that is identical to the old one, it does show...

I'm not sure what is going on with this?? I recreated the query and now it works. Go figure. Both queries are shown below. The first one is the OLD one with the problem of truncating. I recreated the query, with everything basically identical and it worked. Access glitch???

I'm still stumped on this one. Below is an example of the problem. I shrunk the query to just two tables. T_Project and T_Update. See tables below and then the simple query. Then I change it to a Totals query and it truncates my UpdateComment field. Why does this happen? Then, since I...

That's beautiful! I've never used the In(select ....) in a query criteria before. Thanks so much for your help!

On opening the database, click "Project Search/Add" button. Then double click on the contract, "TEMP-2021-0001", shown below. This takes you to the F_Contract where I'm trying to figure out how to develop a select query for the CAN combo box based off of the checkbox and LocationNumber. If the...

I'll do that. Give me a couple minutes.

I have a database that I want a combo box's selection to be based on data from a subform and a ckbox. Subform: The subform is SF_LocationForSelectedProject and is linked to the main from by the ContractID. It's record source is a query Q_LocationForSelectProject. The subform is continuous. I...