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...
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)...
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
Hello Guys,
I am new to Access 2000 and issue is ,I have a field name product_name with datatype MEMO,when I chek my report at the place of product_name instead of the name of product it shows a squared symbol ,i dont understand how I can see the values of product_name.
SO anyone can help me...
Hello Friends,
I just want to know I created dynamic form using docmd.tansferdatabase acexport,"Microsoft Access ,database,acform,"formname",formname" ,can I develop or transfer STARTUP FORM property,in another form.
Hello Guys,
I have proj name m1.mdb which has forms and reports.I have 2 forms form1 ,form2.In form2 I have button that creates new database named m2_date.mdb and creates report and form1 by using property DoCmd.TransferDatabase acExport, "Microsoft Access", sFilename, acForm, "form1", "form1"...
Hello Guys,
I am new to access 2000 and i have an issue,hope to get answer soon..as my boss needs fast ahh.. :o
1)I created access project name A.Mdb
which has forms,reports,tables
there are 2 forms ,Form1,Form2
in form 1 it has message which has 2 buttons yes and no.
Form 2 has a button to...