Recent content by DHookom

With the code I suggested with the code in the link, it’s very easy to reset the SQL to the original. You can also build a fairly sophisticated where clause, apply it, and call it from any form. Using a control on a form limits you to having that form open and setting the correct value.

I would look into antivirus software. Try disabling to see if performance improves.

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?