Search results

****oohh could not having qualified my DAO database, querydefs and recordsets account for the 100-200% speed reduction I've had since 'upgrading' to access 2002 from 97? opinions please and very much appriciated! WB

Thanks Pat, 90111 and 283881 both failed to resove the problem. The solution in the event was to update the Visual Studio service pack to sp5. For anyone searching in future - Couldn't Find Installable ISAM - Visual Studio Visual Basic Service Pack SP5

FIXED !! I have data control on a form datControl(1) which upon opening the form in vb goes through the following process to remnove the contact between the data control and its normal database. datcontrol.databasename = a different database datcontrol.recordsource = "select * from tbl_dummy"...

unfortunatly, i suspect my tables are already normalised.. hey ho, back to vb coding!

wow! I did start doing a search but it came up with a bucket load of posts, i'll study in detail later! thanks! WB

normalisation? explain away!

Thanks but confession time; theres ten fields not 3 I simplified the problem for posting and the size of the iif statement becomes unmanageable! i've resorted to vb using a simple loop counter = 0 do strsql = "update conditiontable set max_condition = '&counter&' where field1 = '&counter&' or...

they are condition categories the table structure (simplified) is id, field1, field2, field3 and I need to know which field reflects the worst condition and ideally update the table with another column (worst condition) so unfortunatly a restructure is not possible!

Help! how can I select the max of three fields? I have a table with field1, field2 and field3. I'd like to know which is the greatest value but the max function only works vertically.. any help to save me having to write a monster iif statement or coding in vb would be appriciated! thanks WB

many times!

hmm, originally once i'd run my query it put a very similar AS [^%"£!$&%!"£*_Alias] at the end which I removed. ever since access has been fubared and never added it back after run, but then again trying the same on another machine and database causes the same problems. unfortunatly still no...

nope unfortunatly no change. saving the query causings access to crash. As the original query appears to run fine , could it be problem in the program rather than the sql?

:confused:

SELECT [fiftykLabel] as section FROM (SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label) where [twofivekLabel] is null every time i try to save this query access closes with an...

am I going mad - table names and errors In access 97 changing the name of the table meant that a query that used the table would no longer work because the table reference would be wrong In access xp changing the name of the table automatically updates the reference in the query. Can this be...

Hi all, A friend has asked me to write a simple search tool to lookup records in a table containing certain words. I can do a simple query using SELECT * FROM table WHERE name LIKE '*word1*' or name LIKE '*word2*' but was wondering if there is a more appropriate method of doing so.. I...