Recent content by jacks

table : match fields : season, matchday, clubA, clubB, goalsA, goalsB, points I'v filled the table with matches. And also calculated how many points every match has. (1 for draw, 3 for a win). So I have 306 matches, for a league with 18 clubs. Now I want to make a query that makes a ranking...

I'v defined an update query as a string in my VBA code. Then I execute the update query with : CurrentProject.Connection.Execute however, I want the query out of the code and into the query folder where the other query's are. How can I execute the query from within the VBA code when I do this ?

THAT DID IT !!! Thanks man !! I'v been struggling for hours.. and your help worked !! GREAT. THANKS !!

eh.. schema.naam is a string. I'll try it again.. thanks.

I have an update query : vs3 = "UPDATE (wedstrijd INNER JOIN club AS a ON wedstrijd.[club a] = a.[club-id]) INNER JOIN club AS b ON wedstrijd.[club b] = b.[club-id], [schema] INNER JOIN regel ON schema.[schema-id] = regel.[schema-id] SET wedstrijd.[voorspel a] = regel.[goals-home]...

yes. I think it's called a compound key that I had to create. It's working now. I just had the key members wrong. But it's clear now.

English is not my native language. And the help I get in this forum is great. I'm really grateful for any help that I receive here. Thank you all for that.

hm. Your explanation is not very helpful.. With this text you'r not helping out. Just making me look silly. But thanks for replying as you'r the only one. I figured it out myself... and indeed.. I have to make class a and class b and the "foreign" key schema-id in the table regel the primary...

I have two tables : schema with : schema-id, Autonumber, primary key name, text and a table regel : regel-id, Autonumber class a, number (lookup from a table) class b, number (lookup from a table) schema-id, Long number they are linked 1:n. A schema can have many regel's. I want to make...

It took me some time to figure out how to iterate through a table. I'm using Access 2003. I'm not very interested in ADO vs DAO discussion.. I just need the thing to work. And it's frustrating that it's so difficult to get it going.

Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "tablename", CurrentProject.Connection this worked. phewww!

I have a table with the name : "wedstrijd" Dim rst As Recordset Set rst = CurrentDb.OpenRecordset "wedstrijd" as you explained me to do. I get a compile error. expected: end of statement okay, I changed it to : Set rst = CurrentDb.OpenRecordset ("wedstrijd") just to be sure, I'm...

a probably embarrassing simple question.. I have made a form and placed a button on it. At onclick() I want to iterate through a table named "match". I'm using access 2003. I need RecordSet I suppose. And commands like MoveFirst, MoveNext I guess.. Can someone give me a very simple...

handy to know !! thanks !

This works wonderfully !! The trick is to use AllowEdits. The Me.Dirty thing I don't grasp yet, .. but I'll read the helpfiles on it. Thanks !!!