Search results

i cant tell if its trying to make a backup... here is the icon i get.

under Options > Current Database i do NOT have "compact on close" selected BUT everytime i close the application, it always compacts. I cant find another setting. anyway to stop having it db compacted when i close Access.

i have 13 million rows, i am trying to do a simple concatenation [Date]&" "&[Time] i get error, "File Sharing lock count exceeded, Increase MaxLocksPerFile registry entry i have increased it from default 9500 (decimals) to 20000. still getting error. Any advice? this is the location that...

hi Doc, thanks for the idea. I havent had time to test, I will tomorrow and give your feedback...

thanks for taking the time to explain. For each individual query (6 in total) the Symbols will appear 1x per query so each query has a distinct list never duplicates. But each individual query take from the same pool of stock symbols. I am a little confused about how to structure the SQL...

Hi Doc, Yes each individual query has different criteria and I need them individual. The only useful field of each query is the Symbol field. So, what common symbol appears in each query result. Query1: A, B, C, D, E, F Query2: B, D, F, G, H, I, R, S Query3: B, F, G, Query4: F, G, M, P What...

I have 6 different saved queries. They each query a list of financial Stocks symbols for different metrics. I wanted to create 1 query that returns a consolidated list of symbols that are in each of the 6 queries, so what Symbols are in each of the lists (hope that makes sense). thanks for...

thats a good point, i didn't notice, it matches now, thanks for the help

I have 4 fields of the same metric covering last 4 years. I want to find Stocks where there is a decline in every year. I currently have this query SELECT Ideas_Risks.Country, Ideas_Risks.Symbol FROM Ideas_Risks WHERE...

hello i have a db with a Field named date, formatted 1993-02-11 year start is 1993 till 2017. I want to filter for records that include everything from first year the record started (some records begin in 1993, some in 2000, some in 2008, etc) and include only records that have data within...

thanks Paul, you bring up a good point about a smaller table as the recordset . thanks

i have an array and I will be filling the table with, each field independantly with a loop. This works fine. It keeps adding to the last row, and each field with no issue. To avoid issues in future. Would this be ok, or should I make it more robust? Issues im contemplating.. - I have read...

i have this string that i want to assign to a variable. "*","*","APPLE INC","AAPL","USA" [EXTRACT]"754.889","Information...

thanks Hi TechCoach so there will not be a formal numbers (245, 246, 247) representing the autonumber, it will be a current date/time as the autonumber? this sounds like i can then check the last 30 values by using a .MoveLast and .Previous Loop without any issues i actually posted for another...

thanks for the advise on compact/repair. its a very small db, i was having weird behavior with my DB so i tried it. I originally had the 2nd table do the autonumber, but the order items come in is important. So i removed autonumber in 2nd table and placed it in 1st table. The append now brings...

so NEVER compact and repair the DB using Access?

thanks Colin i did several searches but couldnt find anything, it was difficult trying to come up with a search term to define it.. thanks for letting me know its common, ill test some options out.

hello i am having some odd (what I think) behavior with my autonumber. But i cant isolate where it is coming from. How i use autonumber: I created a table with an autonumber. I add data to this table and column 1 is my autonumber ID. I then do an append query to add that data to an archive...

thanks for your help in understanding this, it was very helpful I got alot out of it, hopefully others will as well.

thanks for the explanation. Being new to db design i had some more clarifying questions, then I want to tell you about what I was trying to accomplish which led me to test and then post here. so what I see visually when i open table is not what Access will use when retrieving data using the...