Search results

Thank you very much. Unfortunately I used this Approach in a other case. And because I have >200.000 datapoints the query runs 7 hours. I solved the old case with: Public Function GDerw(ByVal varSymbol As Variant, _ ByVal varValue As Variant) As Variant Static...

That is what i intend to do :D I already have an new thread (http://www.access-programmers.co.uk/forums/showthread.php?p=1366372#post1366372) Maybe you can have a brief look into :D

Hello, one more thread of mine today :D I have this table: -> tblTest test_id | test_Name | test_Date | test_value ------------------------------------ 1 | Company A | 01.01.2010 | 0,90 2 | Company A | 02.01.2010 | 0,95 3 | Company A | 03.01.2010 | 1,10 4 | Company A |...

I will use the calculation method and the setting as header of the column. The column includes a calculation of an moving average. And for this i can choose the type (simple MA, weighted MA) and the time setting (2-500 days). And if I get the results in the form, I want to know which...

Man :D Yes a datasheet, and one column is calculated and I have some different calculation methods. I can choose the calculation method in a other form, and in this "datasheet form" I want to see what calculation method is used in the column. I hope I could it explain clearly :D

Thank you very much vbaInet. I decided to do the form variant :D

Or is it easier to name the captions of a form with my "variable field name"? querydef looks like a big vba code :D

Yes, you are right. I have never worked with querydef. Can you give me an example please? That would be very nice :)

I copied your VBA Code into a module and used this sql code SELECT tblIndizes.Indizes_Symbol, tblIndizes.Indizes_Region, tblIndizes.Indizes_Land AS MyFunction() FROM tblIndizes; But a error message appears: The selected code includes a reserved word or an argument name that has a wrong...

Hello, is it possible to name a field in a query or a table with a variable name? For example: I want to choose in listbox "fieldname" the name of the field. And the query field name looks like: forms![testform]![fieldname]: FieldOfTheTable Unfortunately it doesnt work. Also if I save the...

Sorry. I used this words to keep it simple. I will try it one more: I have a table: -> tblProducts products_name products_price products_deliverydate I have a form where I can select some products for a query -> frmSelectProducts With a listbox -> lstProducts products_name products_price...

Hello, I need support one more time :) I have a form with a listbox that allowed multiselection. The listbox depends on the field "name" And I have a table "names_should_be_selected" (fields: name, date ...) It would be great if alle names in the listbox are selected when the name is in...

Thank you very much pr2-eugin. I will test it :)

Can you give me an example how I could do this? Thank you very much :)

Hello, is it possible to call a function in a query with the input of a control element? I have a form, and there is a list box in which I can choose the calculate method. In the query, a field should calculated with the choosen function. Example: SELECT tblTest.price, tblTest.Date...

It is depressing :( I tested your code on the big database (company IDs instead of company name). It is still running since 8:00 and the progress bar is completely blank. If I match the tblPrice and the tblDates I get this table: PosNr PriceDate Company Price 1 01.01.2014...

Thank you very much CJ_London! :) If I test the code, a info box appears: "Enter parameter: tblPrices_1.PriceDate". Do you have an idea why? EDIT: Now it works. Maybe a typing error by me. It works on my test tables. I will test it now on the big. Thank you! :)

If I combine the tblDates with the tblPrice (RIGHT JOIN), and set as criteria Price Is Null, I get 20,602 datapoints. Out of 222,461, there are 20,602 prices missing. A VBA solution would be nice, too. Maybe a vba code which works with the combined (Dates & available prices) table. But...

Sry, the three options (code1, code2, code2 with "=" ) give the same (correct) result. Currently code2 with the company_ID is running. But even after >40 min I get no result. And the progress bar is not really growing.

I have changed "company" (short text) to a "company_id" (number). Additional I switched to a query which creates a new table. Now I see the the progress bar. The query runs now for 30 minutes and the progress bar is only filled for maybe 5%. That is very unfortunate. :(