Recent content by vsap

Thanks for reply, but I want to start my OrdNum with 2501 so how I can achieve that ? I am not expert in access so can you please elaborate it ? Thanks vsap

Hello guys, I have this form where I have a field OrdNum which is Number now I want to convert to AutoNumber how I can achieve this ? as I inserted before the old OrdNum and other fields from old database now user wants old record and OrdNum should be autonumber starts with 2501. As i am...

Hello friends, I am using Access 2003 and my boss wants that a parameter form which will have button, and on click of a button parameter values is transfered to MSWord and it is attached to the Novell Groupwise.And then he can send it to user. So please let me know how I can achieve this...

Hi guys, I have this report which generates more than 1000 pages and it take so much time :confused: , and user are getting :mad: on me, is there any way that I can generate 0ne page at a time or 10 pages at a time. Any suggestions are welcome, and thanks in advance. -vsap

Hello guys, I am getting an error 2486 saying " You can't carry out this action at the present time." ,this comes up when I am running my application which creates the table in other database and it halts the operation in between. So anyone can guide me how to overcome the issue,I ran the...

Thanks,no I have not done any of them,how to achieve that can u please tell me. Thanks vsap

Hello guys, I Have a table call Hq_Cases in oracle database,I created same table in access 2000,and I created a SELECT QUERy in access ,now when I run this query it shows me empty table,so I want to know how I can bring values from oracle into my access database. Any suggestion is appreciable...

Thanks! for reply,I tried the way you said,I said public variant before private module ,then i used your code but somehow it hides the status bar before it being displayed,and if I comment that part (hiding status bar),I can see the status bar with the message,but before that I see all the...

Thanks! I tried what u said,I created popup,modal form,I said Openform.msgform and after finishing the process I said Closeform.msgform ,but when I hit button process ,it gives me object error. As I dont know much access 2000,so can you tell me what I have missed. Thanks, vsap

Hello guys, I have form with a button called process ,when I hit the button it select the column from oracle database tables and then it inserts the values in other oracle database table,so during this process ,I used docmd.hourglass true,but now I want to change to a message stating...

Hello guys, I need to know that I have created this database it has create button which creates another database .mdb file.For eg. a1.mdb file creates a2_month.mdb ,i have created users and permission, for the security purpose,but what is happening it works for a1.mdb but when I open...

Hello Guys, I have a form with a text field q_num and it stores the value in access table rqnum when i press the command button,now I want this value to be inserted into oracle sql ,how I can approach.I tried ,i get error it says object required. strsql = "Insert into lgl_cv_num (cid,vnum,q_num)...

Wayne, Thanks for reply,but it din't work,I want to know how I can execute the sql code residing in the field of given table. While doing this it gives me error stating,C:\..\..\ .mdb not found. Thanks vsap

Hello guys, Its a tricky question,hope to get answer ,well my question is ,i have a table name : refer_lgl_mgr it has col name : qrynm which holds my query select atab,btab from s_prod where atab like 'Asr%' how can I execute the qrynm column. if it can be executed I need to insert the value...

Thanks for reply,but how to get it as user wants.