Recent content by Lucky33

Thanks for all the efforts and support you always give

Thank you MajP for your solution, it is absolutely great. Just out of curiosity, what if the BE files are protected with a password? any work around?

Have you tried to create two FE files, naming one ED and the other Chuck and link each FE to its corresponding BE.

sorry I missed that one

Try this in a query: Extracted: Mid([PNum],InStr(1,[PNum],"09"),10) Equivalent to this: SELECT TblTest.PNum, Mid([PNum],InStr(1,[PNum],"09"),10) AS Extracted FROM TblTest; it should work for 10 numbers QueTest PNum Extracted CUT (09GN20T-01) 73" LONG 09GN20T-01 (09GN20T-01)CUT 6.50" -...

nachumy, what I see is that you are trying to get the count of Private Contacts.ID when the same ID appears in consecutive rows. If that is so, you need to clarify the following: 1- how are the records in this query sorted? by date? by primary key? is the sorting affects the results you are...

Wow Mike. this reserved word missed me although I learned many years ago to avoid any reserved word. Thanks for the feed. I changed the name and now all codes are working fine, even my original one. Funny though how Access behaves sometimes. Some codes did not work but one worked, and all used...

I want to thank both of you MajP and arnelgp for your efforts and for your help. I learned a lot from both of you today and I made it to the final line. MajP gave me the idea to use the top values and I used arnel's code, with a little tweaking by creating a new query with max dates, narrowing...

FYI.. I replaced in your code all references to the date and DDate with the DayID, the key for each record, and i got similar results, only this time TotValue dated 2/4/2021 .... go figure

and here is the underlying table of the query QueStocksDaily. I went through all the dates in the table to see if there was any deviation after 9/9/2021 but everything looks normal am really sorry for all the trouble

this is really turning my head.. while at your end you are getting the right results, here is a sample when i run the same at my end

DDate is a real date, no doubt there. Am attaching a snapshot of sample data, the real one has exactly the same structure, but much more symbols. Tell me, would the ID number for each record be of better use in your code instead of the date. i noticed that you are getting DMax values for both...

thanks MajP. that took care of this error, but now there is another one that popped out. the line strSql = "Select top 1 TotVal..... is giving again compile error: expected: end of statement ... and highlighting the last parenthesis

The query is a list of the same number of stocks, and their daily value. Those values are entered daily. And the purpose of what I am doing is to get the latest value for each stock (symbol) to be used in another table your code is returning the corresponding value for each symbol, but for the...

The line strShare = "'" & strShare "'" is giving compile error: expected : end of statement