Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 47
Search took 0.01 seconds.
Search: Posts Made By: Ashfaque
Forum: Access March 9th, 2008, 06:54 AM
Replies: 2
Views: 1,840
Posted By Ashfaque
If you are asking about mde file then, you should...

If you are asking about mde file then, you should first compile your db to remove errors etc. Once found no errors in VBA code, you may goto Tools-->Database Utilities-->Make MDE File. This will...
Forum: Access February 6th, 2008, 09:59 AM
Replies: 2
Views: 1,252
Posted By Ashfaque
I was running my Access db in my company for last...

I was running my Access db in my company for last 6-7 years. One of its table holds more than 140,000 records. Db contains lots of forms and queries with many reports and modules was successfully...
Forum: Access August 1st, 2007, 03:50 AM
Replies: 5
Views: 1,480
Posted By Ashfaque
Ok If you did the same what I told you then do...

Ok
If you did the same what I told you then do the following.
1. in the Category header of report place 2 unbound textboxes (let us say Text0 & Text1) then place this...
Forum: Access July 28th, 2007, 07:12 AM
Replies: 5
Views: 1,480
Posted By Ashfaque
You can also do it in other way.. Create...

You can also do it in other way..

Create simple query and make a report. Once you made the report, goto design mode of report and created header over Category field n set the property as below:...
Forum: Access July 14th, 2007, 06:05 AM
Replies: 5
Views: 2,978
Posted By Ashfaque
You may avoide this using following method too. ...

You may avoide this using following method too.

This is just an example I used in my db. you may please replace the variables of your choice.

Set rst1 = CurrentDb.OpenRecordset("Select * From...
Forum: Access July 10th, 2007, 07:20 AM
Replies: 3
Views: 3,420
Posted By Ashfaque
:) Standalone program? What back end...

:)

Standalone program?

What back end you are using?
Forum: Access July 10th, 2007, 02:41 AM
Replies: 1
Views: 936
Posted By Ashfaque
You need an update query to perform this task. I...

You need an update query to perform this task. I have an example here
I have updated my Product_Master table in the same way you look for.

UPDATE Product_Master INNER JOIN T_Group_Master ON...
Forum: Access June 20th, 2007, 07:49 AM
Replies: 3
Views: 3,009
Posted By Ashfaque
If u got any solution why dont you put your idea...

If u got any solution why dont you put your idea here so that others could get benifit..?
Forum: Access June 16th, 2007, 01:16 AM
Replies: 1
Views: 1,573
Posted By Ashfaque
How about 2 records for a particular employee in...

How about 2 records for a particular employee in same date? I mean, is there any possibility of 2 records in one date? If so, you need first to change your date format that include times (hh:mm:ss).
Forum: Access June 10th, 2007, 03:01 AM
Replies: 6
Views: 1,121
Posted By Ashfaque
Chris, Sorry for the delay in reply... ...

Chris,

Sorry for the delay in reply...

If you already did using Dsum then no need of anything. Bcz I was planning to go ahead with same. But finding you are still interested how it would work...
Forum: Access June 6th, 2007, 08:55 AM
Replies: 6
Views: 1,121
Posted By Ashfaque
If still face problem, send your db to me in zip...

If still face problem, send your db to me in zip mode containing only source table (least records), query and report. I will look into it.(Write in detail)

Ashfaque

Ashfaque_Online@yahoo.com
Forum: Access June 2nd, 2007, 11:40 PM
Replies: 3
Views: 3,954
Posted By Ashfaque
Why you don't want perform it in a report?. That...

Why you don't want perform it in a report?. That would work the same you need.
Forum: Access June 2nd, 2007, 08:31 AM
Replies: 6
Views: 3,367
Posted By Ashfaque
[s] Try using something like; ...

[s]

Try using something like;

rst!AvgPurPrice = CDbl(Round(AvgPrice, 2))

If you use Sql Server as BE, I advice you to use float data type for the field.

Ashfaque
Forum: Access June 2nd, 2007, 08:22 AM
Replies: 6
Views: 1,121
Posted By Ashfaque
Did u tried Running Sum option in the report? ...

Did u tried Running Sum option in the report?

Try this way:

You put another unbound text box (let us say text0) near by the GrandTotal and inside that you put =GrandTotal and in the property of...
Forum: Access September 19th, 2006, 03:14 AM
Replies: 1
Views: 832
Posted By Ashfaque
If your combo contains and displaying columns...

If your combo contains and displaying columns like Id, EmpName, BasicSalary and so on then you could write following.

Let us say you have placed 3 text boxes named EmpId, EmpName and...
Forum: Access August 1st, 2006, 01:17 AM
Replies: 2
Views: 904
Posted By Ashfaque
Select Criteria fields in query first then set...

Select Criteria fields in query first then set the conditions. Then errors can be traced out.

Ashfaque
Forum: Access July 31st, 2006, 12:24 AM
Replies: 1
Views: 1,194
Posted By Ashfaque
Once you place the controls over to the form...

Once you place the controls over to the form object, it simply can't moved unless you are in design mode of the form.

If your aim is just to set all the controls in a specific distance...
Forum: Access July 1st, 2006, 07:09 AM
Replies: 2
Views: 1,584
Posted By Ashfaque
Rumon, The best practise is to make MDE file...

Rumon,

The best practise is to make MDE file and and apply ShiftByPassKey module (code) alongwith your db and then distribute. This will prevent user from re-designing your db objects such as...
Forum: Access July 1st, 2006, 06:16 AM
Replies: 2
Views: 768
Posted By Ashfaque
Try following : If Len(Me.txtProductCode) >...

Try following :

If Len(Me.txtProductCode) > 0 Then
' some code here
End if

Regards,
Ashfaque
Forum: Access June 13th, 2006, 06:24 AM
Replies: 4
Views: 4,861
Posted By Ashfaque
You can place following line of code in OnClick...

You can place following line of code in OnClick event of your command button that you will place on the form to view the report.
Let us say your printing report "A".
Then code will be

Dim...
Forum: Access June 12th, 2006, 07:21 AM
Replies: 7
Views: 1,051
Posted By Ashfaque
Don't you think false part in your IIF statement...

Don't you think false part in your IIF statement is messing?

I have an example for you that I used in my query which gives me desired result. Here it is.
...
Forum: Access June 12th, 2006, 04:19 AM
Replies: 7
Views: 1,051
Posted By Ashfaque
Value or Values is the reserve word in Jet. This...

Value or Values is the reserve word in Jet. This might be one of the reasom. Try using other field name something like TxtValue.

Ashfaque
Forum: Access June 11th, 2006, 12:13 AM
Replies: 2
Views: 1,615
Posted By Ashfaque
Basically it is not a good idea. If you need...

Basically it is not a good idea.

If you need this way then there is no meaning of one-to-many relationship. I would suggest one way only.

Ashfaque
Forum: Access June 4th, 2006, 01:39 AM
Replies: 3
Views: 921
Posted By Ashfaque
Hello Mike, Thanks Good you understand...

Hello Mike,

Thanks

Good you understand and solved the prob.

Regards,
Ashfaque
Forum: Access June 4th, 2006, 01:24 AM
Replies: 3
Views: 921
Posted By Ashfaque
Eb, Confusion.. Do you mean you created...

Eb,

Confusion..

Do you mean you created a form based on the Issue table and place 2 combo boxes those are based on the Company table and Employee tables? And when you select company name from...
Showing results 1 to 25 of 47

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.