Search results

Surely, reverting to the 32 bit version is just going to delay an inevitable crunch when MS stops supporting it? Along with creating, potentially, additional work in the future.

Thanks for all the advice. Most appreciated :)

I've just taken possession of a new pc with windows 11, and of course the latest version of access. One of my DB's (I'm sure there will be others) is now giving me the following error, which I have no idea how to fix. I'm pretty sure it is code I found in these forums sometime ago.

Nice (y) Thanks MarkK

I'm currently creating a pseudo combo box. The aim being to create a combo box that has a more flexible search. I'm using an unbound text box and button with an unbound list box (populated using data input into the text box, it's row source being a query that uses a Like "*" & [me.textbox] &...

At Table level, try setting your Data Type to Number, Field Size to Single, Format to 0.0000 and Decimal Places to 4 If you need to display a currency symbol, you can do that at Form level. You could even use the On Current event to change the symbol if you are dealing with multiple currencies

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...