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...
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...
Hello Guys,
I have a report in that there id #(text field),place order #(number)is customer name column and it has multiple orders(event column) ,now this multiple orders get repeated for the customers which has common orders.
Eg: custid,place order#,customers name,order name...
Hello Guys,
I just have an issue,I have report to be shown below:
COL1 COL2 COL3 COL4
-------- - ------- ------ ---------
AA 1 mycol1 genes1
mycol2 genes2...
Hello guys,
I have created a form which generates the data into new access database,now I have to show a message "Processing" while data gets generated. And when its done this message should go away by itself,so any suggestion please let me know.
Hope to get answer..
vsap
Thanks for ur reply,but my issue is that this product name are drugs name used by pharmaceutical group so I have to group it other wise it dont give the result what user wants...
I am grouping the memo datatype field (product_name),if I dont group I can c the value,so now issue is how i can group this field.
Hope to get answer..