Search results for query: *

How do i call MSAccess Forms using VBA Code. I have Access Forms which i need to call using VB Code. I tried using DDE but was not successful, maybe wrong approach or coding...Please help

Hi, ur sql statement is correct but u need to execute it before anything gets updated. Try it. All the best...vijay

Hi, i think the DataGrid doesnt support the UNBOUND MODE. So try refreshing the datacontrol or the recordset u r binding the DataGrid to (you may want to even requery it). Thats the best i can suggest. All the best...vijay

Hi, let me join this as i need to know them as well. What my view was that i use Recordsets of joined tables are to be used to retrieve information u want to show (to an extent u r right to say - reports) in forms, or data u might be interested to work on in ur validations. I can bet, there are...

Hi, i dont know if this is the right place to post this. Could anyone help me with this. The Scenario : There would be say ten users. Each of the user is doing database communication i.e., adding a record to a particular table at the same time and for the record to be added a unique id has to...

Hi Catrina, thanx very much for helping me solve a piling problem i had. I had to come to my own conclusions as i tried even DAO 3.6 and yes i had a Service pack 3 of VB6. i will definitely try your advice. Thanx again...vijay

Hi, even if we can maximise the form, the question still stands still. remember Alt+Tab. Hope someone can give a solid solution...vijay

Hi everybody, i had a similar problem and this is what i had observed so far. This information stands to be corrected as i cannot claim it to be correct : To connect a vb application to a database, it can be done in the following ways they say : i) DSN-less connection ii)connection using a DSN...

Hi, i think you cannot probably restrict the user to type and as well not allow him to erase what you have already in it. on the other hand what you can do is in the validate event you can just append your line of text after the user has entered his text. You can do this one like this ...

Hi, it may not be a complete solution. But still it is a idea. I use Seagate Crystal Reports and in that there is an option which asks the user if report has to be saved along with the data. And when a report is refreshed with new selection, we first set that option something like...

Hi, yes in ADO some operations are provider specific i.e., to use some options the Provider should support them. So try to see if the provider supports them. i havent used much of it. all the best...vijay

Hi chris, wouldnt this work. Scenario : i) First i would retrieve the record which has the max date. Here i should get 1990. something like (Select max(year) where name = 'Jim') should do this. maxyear = max(year)[what ever may be the value] ii) Then i would use this value in my update...

Hi catrina, do you use debugging while programming. ok leave that, why dont you try your code in the keyup event . Also why dont you use a function where update takes place only once. Why i am saying this is that u have used .update method at two places. This could turn out to be erraneous...

Hi, when u think of web i) the first thing you might want to know is HTML ii) How to make your page intelligent - use JavaScript/VBscript(ASP)/ JScript iii) How to respond to users actions - on the server side CGI programming using perl etc., (all the database comunication could be handled...

Hi, i had the same problem and found out that VB6 DAO is not supported by Access 2000 databases or the viceversa. The solution i found out was to i) convert my database to previous version of Access or ii) Use ADOs. I had the problem when i was converting my database in older version of...

Hi, sorry it didnt sound ok to me. The exact purpose of using bookmarks in ur case is not so clear. Could you be more specific as to the necessity of using bookmarks here. Sincerely, i am a bit confused as for ur requirement. As for the error, well in ADO some of the methods and properties...

Hi Chip H, could you tell me something more about the 2) Use properties on the callee form and 4) Pass the data in as function parameters to a function/subroutine in the callee form I am interested in knowing how exactly we do this within our forms. I am very much interested in knowing it...

Hi, well this is what i understand is ur problem and please correct me if i am wrong. What i think is that you are using nested procedures something like (This may not be the perfect solution at all as i myself hadnt tried before) parent proc child proc child proc - - -...

Hi, well this is what i understand is ur problem and please correct me if i am wrong. What i think is that you are using nested procedures something like parent proc child proc child proc - - - some statements - - - reply = msgbox "- - -&quot...

Hi vinod, are u sure that u r able to open the database for other purposes. Please check this. Or try to check other properties of the crystal report, i think u mentioned a database name while creating the report and saved data with the report. Try changing the report properties in ur code (i...