Hi All
I have a form which contains a command button"Command1 " which is linked to a query. When i click the command button it executes the query.
Now i want that the Query should close automatically after execution.
I am unable to write the code for this. Can any one please help.
Regards
Manoj
manoj9849967222
Last Activity: Mar 17 '08, 10:44 AM
Joined: Jul 29 '07
Location:
-
Help Regarding Query
-
Hi Nico
I am using the US date format only i.e mm/dd/yy. I have tried using your format also. still i am not able to come out of this.
Regards
Manoj -
Problem with query
Hi All
I have a problem with query.
I have designed a simple query which sould give me itemwise total qty sales during a given period.
the fields in the query are
startdate, modelno,model,q ty.
I have also designed a form where the user will give the period for example 1/1/2007 to 1/10/2007
My query looks like this..
SELECT Outwardmaster.s tartdate, Outwardmaster.M odelno,... -
Hi Nico
I have used the SQl given by you. But now it asks for the parameter asking me to enter the product id. I have 100 of productid & i want them all in a single report.
Can this be avoided
Regards
ManojLeave a comment:
-
Problem when Report is Exported to Excel
Hi All
I need a urgent help. I have a report in which one of the cloumn is "Productid"
My report looks like this
Productid Qty
1.3.2------------------------500
1.4.5-----------------------600
Now when i export the report to excel the productid column gets automatically converted to number.
Could any one tell me what is the... -
Thanks for all your help.
I used the second option & it worked out
Thanks Again.
Regards
ManojLeave a comment:
-
HI
I have used these codes
SELECT productid.Produ ctid, (Sum([Purchase.Qty])-Sum([Sales.Qty])) AS ClosingStock
FROM product, sales, purchase;
when i run this query it ask me to enter the productid & gives me a wrong figure
I dont know from where i am getting that figure.
or other wise i was think to get the closing stock using a query which would give me the total qty sold...Leave a comment:
-
Problem with getting values using Query
Hi All
I have a great problem.
I have three tables one is "SALES" other one is "Purchase" & "Productid"
Now i want to get the closing stock out of it.
Say productid is 1.2 --------- Purchased---100 qty & Sales-----50 qty
1.3----------Purcahsed---300 qty & sales-----100 qty
1.2--------- Purcahsed--000... -
Creating Menu Bar in a Form
Hi All
Is there a way to creat Menu Bar in a Form. Please suggest if this is possible.
Regards
Manoj -
HI pks00
I was going through the codes as i have a similar problem. I want to generate the report in PDF format when a command button is clicked
But as i am new to the access programming. I could not understand it properly.
Could you please help me out as to How to generate a report in PDF format when a command button is clicked. I too Have "PDF995" as well as "Cute PDF writer"...Leave a comment:
-
Hi Fish Valv
I was wondering if this can be Possible using some VBA codes
Regards
ManojLeave a comment:
-
Generating Reports in .PDF format
Hi All
I have designed a report & i want the report in PDF format Can i generate a report in .pdf format in aaccess.
Can any one guide me to generate a report in PDF format.
Please Help
Regards
Manoj -
Problem With Dates
Hi All
I have a problem with date format. I have designed a form where i have a colum called "Date". I have changed the format to "dd/mm/yyyy" in the form as well as in the Table. Now when i enter the date in the date field say if i enter " 31/7/2007" its works it takes it in the dd/mm/yyyy format but when i enter 07/06/2007 where 7 is date & 6 is month & 2007 is year. It automatically takes it... -
Hi mmccarthy
Thanks for your help.
Regards
ManojLeave a comment:
-
Using Calander control
Hi All
I have two Textbox "Textbox1" & "Textbox2" i want to use a calander control to populate the textbox.
But i dontknow how to use the calander control.
could any one suggest how to make this possible.
Regards
Manoj. -
Hi Hr
you can do this easily. Go to the Tools Menu Click on startup. Select your Form name in Display Form/Page option and then click ok.
Best of Luck
Regards
ManojLeave a comment:
-
Hi Jim
I am not able to view the report. It is directly going to the printer.
Regards
ManojLeave a comment:
-
Thanks JConsulting
Its working. Thanks for your valuable reply.
Regards
ManojLeave a comment:
-
Report Problem
Hi all
I have a form named "Form1" which has two textboxes "Textbox1" & Textbox3" which is ment to enter dates & also a command button "command9"
I have a report named "Report1" which is based on query. The query is working fine.
what i want to do is when the command button is click i want to load the report between the two given dates in the "textbox1"... -
Problem with Report Generation
Hi All
I have a form which has two text box to enter dates & a command button
now when i click the command button it runs a query and provides me the data between two given dates in the textbox.
Now i have a report based on query.
what i want to do is to have a command button on the form, which when clicked should generate a report between two given dates in the textbox.
Please...
No activity results to display
Leave a comment: