Search results

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

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

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

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

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

Enclosed is a screenshot showing the vba code, Table, & watch List with values... record count shows all 16 records but .MoveLast values are not the last values in table. Even with a explicit OrderBy DoCmd. please take a look at the attached jpg...any ideas to resolve? thanks

With a Table I want to do I lookup based on the value of another field, exactly like a Vlookup in Excel. I am trying the DLookup but dont know if this is what i need. Here is a visual (attachment) to help understand what i need. This is the DLookup() DLookUp([tblAnswers]![AnswerNumber]...

here is a screenshot. i created a calculated field which compares 2 column values. if its TRUE then the calculation returns -1 (which is odd) if FALSE it returns 0 is there a way to make True 1 and leave False as 0 . Or whats the reasoning..Thanks

i can retrieve, add, edit data to a table when it is closed but i get an error, "The command or action 'GoToRecord' isnt available now." if i try to move to a record when the table is not physically opened. seems odd to me. If i open the table this sub works fine. any insight.. thanks. im...

i am using VBA and recordset method to fill a textbox in my form. it was 'bound' to a table which i removed and got a different message... "cant assign a value to this object" anyone share the rules for using VBA to change values of controls on a form. thanks

i have attached a pic. I created a Option Group (no wizard) and dragged 4 option buttons into the frame. If I select any of the 4, they ALL get selected... i want the standard behavior, only 1 option is selectable at a time, so i can use VBA to get the 1 selected (i have the code already)...

I have 2 different forms I am working on and they come from the same table. I was able to drag 1 field onto the form, the 2nd field gives me a message, the table "my table name" is already opened exclusively by another user, or it is already open through user interface and cannot be...

I am trying to create an exam application. The questions, choices, correct answers, and explanation are in 1 table. I created a 2nd table to record the responses to each answer and deliver a score at the end of the exam. When i try to use Option Group the only option to store the result is in...

i have a text box in a form that is connected to a table, the text box seems to cutoff the text once it reaches a certain length. In my table the text column is it formatted as "long text". I did a Len() and the max length is 277 characters. I have Grow = YES and Shrink YES I dont know...