Search results for query: *

I'm trying to create an estimating form that would contain 2 continuous subforms. The goal is to make it look similar to this (created in Word) Some bids are simple, just a few details, others are more complex like the attached. Right now I have a main form bound to the Bids table, and 2...

Hi everyone! I am attempting to use a parameter form to create the criteria in a query behind my report. The form contains several fields and 6 multi-select list boxes. The list boxes fill their respected text field properly. In my query, I reference the text fields in the criteria like this...

Hi! I have a filter form to run a report, there are 2 reports that can be printed. Summary and Details. Right now on the summary button, I have put a code to be sure selections have been made in both list boxes (used for the report filter) and it will pop a message telling the user they need to...

Hi! I'm trying to set a project number in this format 07-20-20-01; 07-20-20-02, etc. I've got it where it will now start at 1 on a new day, but it won't increment to the next number. Using this: Private Sub Command102_Click() Dim vDate, vRet, vNum, vOrder Dim i As Integer DoCmd.GoToRecord , ...

Good morning! I have a form (ReportParams) that supplies (criteria) values to various reports. End user would like to be able to recall the last values he used. I have no idea how to make this happen for him. Do any of you? I thank you in advance for any insight, and hope ya'll are having a...

Hello all! I'm back. I've written a report and subreport to compare sales between two time frames. I'm using Fancy Prairie's BuildWhere(me) function which works great on the main report but I need to pass it to the subreport as well. The criteria I need is between dates, status and manufacturer...

Hello! I am using Fancy Prairie's amazing code to filter records based on multiple selections on a form. Everything works great except for one currency field. Here's the huge code in it's entirety: '+******************************************************************************************** '*...

Hi and Happy Friday everyone! I have a query where I am getting the balances of a member's account. I am getting the error: "Your query does not include the specified expression "MemberID_PK" as part of an aggregate function. I will post the sql of the other queries involved following the...

Hello everyone! Working on an HOA database (Access 2016). Owners pay certain assessments: monthly, roads, dam, etc. These are of course viewable in a subform based on a cross-tab query IF I have fixed column headings. What I would like to do is allow the user to add assessments as necessary and...