Recent content by LanaR

The following SQL works fine as a Query StrSQL = "INSERT INTO TBL_TastNote ( WineID, AuthID, [Note] ) " & _ "SELECT TBL_Wine.WineID, TBL_Wine.Wine, 4 AS Expr1, 'See Attatched PDF' AS Expr2 " & _ "FROM TBL_Wine " & _ "WHERE...

In deed, it is :) thank you so much :love:

@ghudson do you have a newer version of the Browse [Find a directory or file]? The version at the link is .mdb which is not compatible with current versions of Access

@MajP thanks I think it is probably well past time that I did a major re-build on this DB

...and there is now a current back-up:)

I've resolved the problem by renaming the old form, making a copy of it and naming that with the original name. I can't even imagine how that fixed things, as the old form continued to show its aberrant behaviour if it was opened first but would work fine if the copied and re-named version was...

Thanks; I guess that will teach me to be more diligent with my back-up procedures 😢 my last back-up is less than four months old but I've made some significant changes to the form in the meantime 😭

In a long-term DB, I have a search from that had been working flawlessly. However, when I opened the DB this morning and tried loading the form I got a series of "Enter Parameter Value" dialogue boxes (relating to controls on the form) culminating in an "Error 3 Return without GoSub!", then when...

When you go to the query builder you can view your query in design mode (the default when you first start building a query). At the top left of your ribbon you will see a button called View a small drop down arrow, from which you can select Datasheet View (which will show you your results)...

Welcome to the forum If you create a Totals Query, you can group on Customer name and Sum the Paid amounts where Paid is "True". The SQL will look something like; SELECT Table1.CustName, Sum(Table1.Amount) AS SumOfAmount, Table1.Paid FROM Table1 GROUP BY Table1.CustName, Table1.Paid HAVING...

If, as I surmised earlier, you are flagging returns using a checkbox. I think you should be able to pick those up and using an append query to partially create your new record and simply go to that record in the form you already have open, so you can complete it.

The posted DB was just for illustration. On the live DB, I'm using the double click event (on the record selector) to filter another sub form on the same master form. I then decided I wanted to open a pop-up form, which is when I discovered the "quick" that started this thread :) I'll leave...

Sounds like it is going to be a lot of work, so hold fire. Opening and closing forms and maintaining focus on specific record(s) sounds was covered very well in the course I linked to. When I click the link, the course is being offered at AUD 19.99 down from AUD 124.99 If you are seeing...

Yes that does the trick (y) It also opens up the Double click event, as I'm already using that on the record selector to do something else :)