Avatar billede petersen7913 Forsker
23. november 2009 - 13:18 Der er 14 kommentarer og
1 løsning

Recordset fra en query?

Hej

I Access 2007 bruger jeg et DAO recordset.

Hvis jeg laver min select på en tabel går det fint, hvis jeg førsøger at bruge en query får jeg en fejl, at querien ikke findes eller evt. er stavet forkert.

strSQL = "SELECT Instructor FROM q"
dbPath = ......
dbName = xx.accdb
Set dbsDB = OpenDatabase(dbPath & dbName)
Set rstRec = dbsDB.OpenRecordset(strSQL) ----- det går galt i den her linie
.....

Hvad gør jeg for at kunne bruge en query? Det er den eneste mulighed jeg har for at komme videre.
Avatar billede terry Ekspert
23. november 2009 - 13:55 #1
Make sure you have a refernce to DAO (Tools+references)
Avatar billede terry Ekspert
23. november 2009 - 13:57 #2
Ooops, maybe a bit too qick on the trigger there :o)

Where is the code in relation to the dB?
Avatar billede petersen7913 Forsker
23. november 2009 - 14:40 #3
Frontend and backend are in the same folder.

And I can make a recordset from a table without problems ....
Avatar billede terry Ekspert
23. november 2009 - 15:11 #4
why dont you just link the tables into your frontend and then make the query there?

I'll have a play around and see if I can come up with something.
Avatar billede petersen7913 Forsker
23. november 2009 - 15:40 #5
The tables are linked from backend to frontend.
I make the queries in the frontend.

And I have a problem ;o)

Sure you come up with something, you always do :)
Avatar billede terry Ekspert
23. november 2009 - 16:18 #6
:o)

I dont understand why you need to use DAO to make a query on the tables/queries in the frontend. Cant you just make a query?

Any chance of seeing the dB?

ekspertenATsanthell.dk
AT = @
Avatar billede petersen7913 Forsker
23. november 2009 - 16:50 #7
I need the resordset as parametres for a report. So I loop through the records and print the report(s).
Avatar billede terry Ekspert
23. november 2009 - 17:25 #8
can I see the dB?
It'll be tomorrow before I get time.
Avatar billede petersen7913 Forsker
23. november 2009 - 17:34 #9
OK, I'll send it later today
Avatar billede terry Ekspert
24. november 2009 - 08:31 #10
Have you sent me your dB? Havent received anything :o(
Avatar billede petersen7913 Forsker
24. november 2009 - 09:07 #11
No sorry. (have a dealine today for a customer)

I think it is part of my general Accessproblems. So later today I'll have to uninstall/install and try again.

If that doesn't help I'll send the db to you.

And thanks ;O)
Avatar billede terry Ekspert
24. november 2009 - 09:19 #12
No problem
Avatar billede terry Ekspert
03. december 2009 - 14:36 #13
how did it go?
Avatar billede petersen7913 Forsker
03. december 2009 - 17:25 #14
My customer got the new version ;o)

It looks like it goes back to my old problem, I have the files for libraries but in Tools -> reference there's one I can't see and mark :(

So I used ADODB.Recordset and tested on another PC.
Avatar billede terry Ekspert
03. december 2009 - 20:00 #15
Thanks, hope your customer is happy
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester