Search results

I realize this was your version and expect the OP would understand (and possibly post text SQL versus an image). I wanted something to simply copy and paste.

Based on your location, should you use ";" in place of ","? DateAdd("m";[factor];[dailydate]) AS Expr1

Tell us exactly what you want to see in the subform and how you expect to add a new record? Did you consider changing the properties of the subform to Add mode?

Is there a reason you don't simply enter the new check at the New Record on the subform?

A method that has always worked for me is to change something in the record source of the report to limit the records returned. For instance if you have an employee table [tblEmployees] and want to limit the report to a specific EmpID, create a query [qselEmployees] with the SQL of SELECT * FROM...

Also, I have had issues in the past with larger image files not rendering. Do you know the size of the files and have you tried with smaller files? I would also add a line in your code to help troubleshoot: Debug.Print CurrentProject.Path & “\img\” & Me.txtPathImage

I found your images confusing. It seems that your field in question is a lookup field and behaving like lookup fields behave. You would almost always want to use and store the ID value, not the text. The text value is stored only in one table based on sound relational database theory.

I would place a breakpoint in the code so the values can be seen by hovering the pointer over your code. Also, use Me.[CheckBalance]

I think you forgot the S tblEmployees. I would question the join on a field where I can’t imagine being a primary key in either table.

Can you open the mdb files?

I would use a data driven solution (maybe a couple lines of code) where the number per day and times are stored in related tables. A plan with twice a day at 8 AM and 8 PM become a record in tblMedPlans with two related records in tblMedPlanTimes with TimeOfDay of 8:00 and 20:00. There is also a...

As long as the subform allows additions 😉

Can we assume you aren’t referring to the line at the bottom that displays default values but isn’t a new record until you modify any field in the bottom line?

Yes, it was #9 which I wrongly assumed was the table datasheet rather than the datasheet of June7 query recommendation.

So the fields actually are numeric and store 0s. Zeros are values, not blanks and the should not be compared to a string.

If the salary is numeric, remove the quotes from around the amount. I would also delete the inner ()s.

I would set the Where clause to; WHERE Trim(fld1 & fld2 & fld3 & fld4 &"")=""

I recall a support call from client at least 20 years ago with a larger monitor. I had code that automatically set a subform width based on the main form’s InsideWidth. I had to modify the code to accommodate the issue.

Is this a standard text box? Is there code in your form that provides the autocomplete functionality? Is your directory/folder trusted?

I agree with June7. I started writing the code on the form to modify the SQL and then realized it wasn't necessary if the expressions and a data value were changed. LeoM, your VBA hard codes in the values of Owner, StartDate, and EndDate while also locking in the number or heading groups to 3...