Werner Hi
Did you ever get an answer to adodc not working on other pc, I have a similar problem, I can pull in a list of members, but when I select one, the form creates a recordset and uses this as the source for the adodc control, however none of the boxes are populated.
Wernerh
Last Activity: Jun 11 '09, 02:28 PM
Joined: Jul 24 '07
Location:
-
hi sir can i have a copy of your code for the picture capturing -
I have placed the brackets as you have indicated and still getting "False" as result in my datagrid -
Hi MTB,
Yes both fields are numeric. Tel 2 is essentially a lookup code and Sum of ..... is the result of a few tables against that code. So I have code 1-62 under Tel2 and the totals from the tables relevant to the individual codes as a single entry in this query. Does that make sense?
Thanks
WernerLeave a comment:
-
VB6 Reading Mdb query specific item
Hi all, I have a mdb with a query called ReportQ, it has 2 columns namely Tel2 and Sum Of knowledge and the querry looks like this:
Tel2 ...... Sum of Knowledge
1.............. ... 100
2.............. ... 325
3 ............... .. 243
etc.
Please could someone check my code to see where i have gone wrong as my result gives "false" as the answer.
... -
I did a new mdb from scratch and tried that and still same result, won't read on another pc?Leave a comment:
-
I assume system meaning diff PC's? No exe and mdb's on one pc, can access from diff pc's and open 1 instance as and when diff people need too. But even so, most clients just have it on one pc. Mdb not reading there on standalone.No network or anything..Leave a comment:
-
No, One exe file, couple of mdb's reading only to that one exe.Leave a comment:
-
Ok, could you just eloborate on how you define cloning. I used one of the other databases that work, deleted the tables and put new tables in for new form. Would you say that is cloning? Ok, will try redo the database from scratch and and see if that works. Thanks for the idea, will let you know if it works (holding big thumbs!!!)Leave a comment:
-
No, just can run through network to access app. It is a clone, basically each client has a copy with their data in it. On development pc database works perfectly. install program on any other pc and won't "read" database, yet paths are correct and installed mdb on pc. Even went and deleted mdb on other pc and ran software which gave error in locating database. (which was great, means it sees mdb) yet won't show in Textboxes, when mdb was...Leave a comment:
-
Just as a matter of interest, I have copied the database connection code within the same project from another point to this form. Just changed the name to the new MDB and set text boxes up for new mdb. So no reason why it should not work??Leave a comment:
-
Hi, the app.path is directed at the host pc (but also works across network). When software installed on a pc all mdb etc installed with it. So in effect a clone. I have other mdb links within same project on other forms and functions that work no hassle to host and across network. Just this one that will not work when I entire program to other pc. On development pc it works fine????? got me baffled beyond belief. Any Ideas would be apprciated.Leave a comment:
-
Does no one know what the problem might be?Leave a comment:
-
VB6 Adodc not working on other PC
Hi all, got a problem that is driving me insane, have tried everything and wondering what I am missing. Have a adodc connection to a mdb. On the development PC the database reads perfectly to the text boxes. Soon as I compile the project and run on another machine it does not populate the text boxes and previous / next command buttons don't work either. Yet if I open the exe from the "design pc" across the network it reads perfectly??????... -
Just realised how easy it is, used a command button to move records back and forthLeave a comment:
-
gbayhan your mail address comes back with errorLeave a comment:
-
Hi, have mailed you the source codeLeave a comment:
-
Adodc Link
Hi, please can anyone tell me if there is a way to navigate two adodc controls. I have a from with adodc1 and adodc2 - each linked to their own mdb table working perfectly. Is there any way by code that if you use the adodc1 control to navigate to the next record it will mirror this action in adodc2.
Would appreciate any insight, not even sure it can be done.
Regards
Werner -
Wernerh started a topic VB6 Reading data from Mdb to MS Office web component (excel)in Visual BasicVB6 Reading data from Mdb to MS Office web component (excel)
Hi all, I have a mdb with data in it. In my VB project I have Excel embedded on a form. The following code I am using to get data from the db and then "paste"it into the excel sheet. I get a read access error. The same database is feeding a Datagrid and exporting to excel (outside vb) with no hassle. Can someone tell me if they can spot a problem. Is there maybe a better way to do this other than this code. Thanks
... -
Thanks Veena,
I will give it a go and hopefully get ot to work.
I have it working already by exporting the query as a .snp file and then opening it with snapshot viewer, but for obvious reasons the client requires Snapshot which is not ideal. I can bundle snapshot with my software, but was trying to get rid of it all together. I will try your suggestions and hopefully wil be able to do it that way. Thanks again.
...Leave a comment:
No activity results to display
Leave a comment: