Search results

  1. LanaR

    Insert Into SQL Syntax

  2. LanaR

    Insert Into SQL Syntax

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

    Solved Sample DB Update?

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

    Solved Sample DB Update?

    @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
  5. LanaR

    Solved Strange Form Behaviour

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

    Solved Strange Form Behaviour

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

    Solved Strange Form Behaviour

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

    Solved Strange Form Behaviour

    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 😭
  9. LanaR

    Solved Strange Form Behaviour

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

    Query Criteria fomula

    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)...
  11. LanaR

    Query Criteria fomula

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

    Solved Button on Popup Form To Open Same Form But With New Record

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

    Solved Moving Focus on a Continuous Form

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

    Solved Button on Popup Form To Open Same Form But With New Record

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

    Solved Moving Focus on a Continuous Form

    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 :)
  16. LanaR

    Solved Button on Popup Form To Open Same Form But With New Record

    Are you able to post an anonymised version of your DB with some sample data?
  17. LanaR

    Solved Button on Popup Form To Open Same Form But With New Record

    You might find this Course a valuable investment (especially if you can get it whilst it's on sale), as if memory serves me correctly, I think it does address similar scenarios to what you are trying to do. I worked through it earlier this year and found it really useful in taking my coding to...
  18. LanaR

    Solved Button on Popup Form To Open Same Form But With New Record

    You can not (re)open a form that is already open If product has been delivered to a client, that record (movement) is still valid, as the delivery did take place Given the above, the rejection should therefore be taken as a new (record) movement. It is going to a new destination, isn't it? It...
  19. LanaR

    Solved Button on Popup Form To Open Same Form But With New Record

    If the form is already open, then you will see nothing happen. It sounds like what you really want to do is create a new record partially populated with the items rejected from the current record?
  20. LanaR

    Solved Moving Focus on a Continuous Form

    Sorry my bad 🥵 I know I wrote continuous form, I should have said Datasheet. You are correct, in continuous view the form does not behave as I described I've attached a DB
Top Bottom