Search results

ilanray, First, I agree with the others that checking that there are records in the recordset (eg Not EOF) is fundamental. Second, do you have any evidence that the recordset has any values? And what those values may be? You could do a recordcount. It just seems that you may be assuming...

Kev, How did they deal with this before you joined the company? Or is this some new process since your arrival?

Does anyone understand the requirement sufficiently well -- and can provide a description of same?

See Form.Form Properties

Suggest you pick a small subset of your data; put it in a separate temptable; get your query working and vet the result; T H EN adjust your query to work with real data. No need to test on 700K records.

Welcome to AWF, CatDad! The articles/links in my signature may be helpful to your learning Access and database.

Here's a link to a youtube video show a listbox trick for adding/removing items from listbox. Iy may offer a method or at least some insight to a solution.

Ben, I am not a developer and do not have any sort of multi-user testing. Have you determined that the Lock is acquired before attempting changes to a record? Can you/have you checked/verified that the same record is locked by more than 1 user at 1 time? Perhaps one of the active developers...

You may get some insight from this Implementing Queue-based applications article by Philipp Stiefel.

Tony, I don't know the significance of Colin's "handle" Isladogs. For a long time he was Ridders. Here's the wikipedia view that I have associated (my guess, probably incorrect) with his newer moniker. I remember hearing Isle of Dogs from a Sherlock Holmes radio broadcast. Perhaps, we should...

asteropi, This thread is marked SOLVED--- what is the solution? It could be helpful to others. Please describe.

Welcome to AWF and back to Access!

I'm not sure if your question is academic or if you're approaching tentatively asking how to search and show few records at a time. An option, pending clarification, could be a form with search field and max number of records to show...??? Reports are for print typically.

?? Why would/could Investments01_tbl.Stock_Name be Null? SELECT Investments01_tbl.Symbol_Stock, Investments01_tbl.Stock_Name, Investments01_tbl.Investigate, Investments01_tbl.Trade FROM Investments01_tbl WHERE Investments01_tbl.Investigate=Yes OR Investments01_tbl.Trade="Purchased"; Query1...

Welcome to AWF!

Is Sales.Price Currency datatype?

Generally you would run a query to calculate the total. You would not store the total in a table. You would put the Total value on a form or report as needed. What is the ultimate goal? What additional calculations?

asteropi, You seem to be focused on manipulating text box contents. I think it would be helpful to you and readers if you told us more about WHAT you are trying to support with automation. You mention Customer code and Customer type... and that suggests to me some business activity involving...

cheekybuddha/David, Do you have a sample database using Dymeng/ Jack Leach's JSON Parser that you could share?

Welcome to AWF!