Recent content by Dwight

Thank you for the suggestion. I tried Recalc instead of Requery but it did not update the form.

Yes, I placed code on the subform's On Delete event to requery the unbound form on the main form that has the account's cash balance. But I get the error that I mentioned in my previous post.

Thanks for the reply. I agree that simplicity is the way to go. I got it to do what I need.

I wrote a custom function to calculate an average. The function uses Public variables. Query1 has the fields required for the calculation sorted in the correct order. I call the function from Query1 and I get the correct result. The problem occurs when I create a second query, Query2, that...

You can slip in a 0 for in place of any nulls by using the NZ function. NZ(Field,0). Lots of examples here if you need help.

In the unbound text box you can use a domain aggregate function such as Dsum. I guess you will need two Dsums. One for each column and then subtract them to get the difference. My original proposed solution would only require one. But just as long as you get it working. Dwight

In a query enter an expression like this: IIf(IsNull([YourField]),1,0). All Nulls will have a value of 1. You can then sum the total.

How about a Dcount to count the records in the query. If the Dcount result is > 0 then your query has records.

I have seen this question asked and answered on this forum before. Search around and I bet you can find the solution.

I would approach this differently. I would write 2 queries: 1) an append query to move the data from the temp table to the permanent table and 2) a delete query to delete these records. Use the queries' Where statements to identify the checked records. Run both of the queries from the buttons...

Doc Man – Thank you for sharing your knowledge. I always learn a lot from your posts. First of all, the temp tables fixed the problem. The report now runs smoothly. Yes, my database contains a lot of lookup tables. Shouldn’t that be the case in a properly normalized database? The report is an...

You can set the forms AutoCenter property to Yes and it will be centered on the screen regardless of the screen size.

Thank you for the reply Ken. I will give the temp tables a go and see what happens. If it does not help I can always remove them. I think I have done a good job of normalization. My database has 109 separate tables. But I'm sure I could have done some things more efficiently than I...

My database sometimes produces Error 3048: Cannot open any more databases. After researching this on the Internet I now know that it is because Access has an internal limit of 255 simultaneous connections to Jet. A “connection” includes things like combo boxes, recordsets, queries, etc…..and...

Solved it. On the Docmd.Output set AutoStart to True.