Search results

Thanks. Thought I'd checked that...but only on the 2 comboboxes I was updating. Damn, schoolboy error! Cheers, El-d

Hi All, I've got a combobox that returns 4 values eg ID , Client, MinVal, MaxVal 4,SG,530,4500 Only the Client is shown in combobox. When I run the Row Source query it returns the 4 values as expected. I am trying to set 2 other comboboxes to the min /max values The min works fine but max...

as Homer once said "Doh!" Much appreciated. And yes you are correct in pointing out that I don't need to write separate tables. It was a quarterly thing I was writing out data for but as I'm writing the date into the table, I can continue to write each quarter indefinitely as a single table and...

Hi all, I'm trying to set a text box value from a table based on a combobox selection but keep getting a missing table error. Me.ExpiryClose is the textbox Me.WrittenOptions is combo expirytable is a string variable TGDec16 is my table When I debug print expirytable it prints TGDec16...

Back again :) Quick additional question hopefully. I've changed my function to return As Single but it returns as double. As a test, I changed it to return As Integer and that works correctly but I can't get it to return as single. Any thoughts? Cheers, El-d

Found out my problem. Schoolboy error probably . I was re-targeting my query so instead of targeting Mavg30 query, I'd changed it to the make table and it didn't work. RunAvg: RunAvgQ("MAvg30","SMAID",[SMAID],"AdjustedHistory",30) When I kept the query and created a make table, it worked...

That moment when I wanted to slap myself.....but I just tried that and it still doesn't work. I'm assuming that as the field is specified as a double that using "0" does actually enter as a number rather than a string which is what I assume you meant. :banghead: El-d PS. like the use of...

Hi Isskint, I'm obviously doing something really stupid as I just can't get this to work. I've added a stripped down version of my data. The form has 2 buttons - one just runs the query which works and the other makes a new table using the same query which fails. Would really appreciate if...

Thanks for the response. Apart from requiring RunAvgQ = "0" instead of RunAvgQ = "" due to a mismatch it works perfectly in the test file. :) Annoyingly on my actual data, I'm not getting my running average. Its using the RunAVgQ 0 error value. What I don't get is that I'm trying to debug...

Hi All, I found the attached example a while back (can't find the site again though :( ) and it calculates a moving average. I've hacked out the parts I need for my own work and I can create my moving average query without an issue. However, I need to extract the MA data into a table so planned...

Sorry. Up to my eyes in my actual work and probably won't get chance to look at this again for a while :( However, I did remove my open command and my values are still coming through so I'm obviously updating my query somewhere. The hazards of self teaching via trial and error :)

I'm away at the moment so won't be able to sort a cut down version yet. How do I execute a query though without opening? Googling Running a query via vb always seem to come up with do.cmd openquery or requery. Thanks El-d

Thanks anyway. I suspect its just a mindset that I need to get into for working with DB. Creating tables isn't the worst thing to do :). El-d

Hi JHb, Just checking in to see if you've had any chance to have a look and whether your initial ideas are workable. Thanks, El-d

Hi all, Probably a newbie question but can't see an answer. I have a query that I run to extract some values for calculations. Its run on an event based on a dropdown selection. At the moment, I run via: DoCmd.OpenQuery "CallMidprice" and then close it. this seems to take more time than is...

Cheers. I'll try some debug.prints with times. El-d

Thanks for response. It wasn't actual suggestions on what to fix (yet ;) ) , hence no details. Although version would help, Desktop 2013 and I'm a relative beginner to DB and scripting. It was more a question as to there being some way of quantifying what process is taking time. If I run my...

Actually misunderstood my Dads equation - trouble with spoken equation rather than seeing the brackets ;) However, I did end up with 2 queries . 1 to get my adjustment value and the other to process. Thanks for response. Put me on the right track to realise I was calculating the wrong thing :)...

Hi All, I've been working on my DB for a while and expanding on functionality with charts, calculations etc. It is becoming slower to update my charts, much slower than I would expect. Chances are I'm probably doing something wrong/bad practice but is there a way of determining what's taking...

Thanks, will try that. I think my issue is that Im trying to not have multiple queries poping up / open. Is there any way of running queries as a hidden background process. I did look a while back but never found a reasonable solution. I.e. turn screen refresh off and back on post queries. Is...