Search results
-
-
Most efficient way to solve this problem
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. -
G'day from New Zealand
Welcome to AWF, CatDad! The articles/links in my signature may be helpful to your learning Access and database.- jdraw
- Post #5
- Forum: Introduce Yourself
-
Solved Combobox to return the values from a table that haven't already been used and exclude the values that have been used
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. -
Multi User Database with Record Locking
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... -
Multi User Database with Record Locking
You may get some insight from this Implementing Queue-based applications article by Philipp Stiefel. -
Colin's handle, "Isladogs," has always intrigued me.
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...- jdraw
- Post #10
- Forum: The Watercooler
-
Solved How to set up unique customer codes based on customer types
asteropi, This thread is marked SOLVED--- what is the solution? It could be helpful to others. Please describe. -
-
Report in general
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. -
Report With A Query Problem
?? 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... -
-
-
Solved DCOUNT
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? -
Solved How to set up unique customer codes based on customer types
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... -
Solved How to use MS Access Messages Properly
cheekybuddha/David, Do you have a sample database using Dymeng/ Jack Leach's JSON Parser that you could share?- jdraw
- Post #11
- Forum: Modules & VBA
-
-
Is it possible replace the value with regex in batch?
I agree Paul. However I was just working with your sample You could devise logic to deal with numeric street address. eg Split and process substring... -
Is it possible replace the value with regex in batch?
Perhaps: More than 999 and Not containing a comma. -