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 56
Search took 0.01 seconds.
Search: Posts Made By: dbartelt
Forum: Access April 8th, 2008, 12:22 PM
Replies: 2
Views: 21,475
Posted By dbartelt
Okay...Do I need to be using a different function...

Okay...Do I need to be using a different function than the DateDiff function?

Any suggestions?

Thanks

D. Bartelt
Forum: Access March 30th, 2008, 03:40 PM
Replies: 2
Views: 21,475
Posted By dbartelt
DateDiff to exclude weekends and holidays

Hi,

I am working on an On Time Delivery Report that is generated on a monthly basis. The form specifies a single customer name and the date fields are From: and To: Ie. From 12/01/07 to 12/31/07....
Forum: Access June 7th, 2006, 08:43 AM
Replies: 11
Views: 1,862
Posted By dbartelt
Hi Vision G I understand that DATE is the...

Hi Vision G

I understand that DATE is the control source for your DATE field on your subform. Is the text box name also "DATE"? If so, I would change the name of the text box to "TextDate" and...
Forum: Access June 2nd, 2006, 12:52 PM
Replies: 9
Views: 3,682
Posted By dbartelt
Use the formula ...

Use the formula

=IIf(IsNull(([subfrmYourSubFormName].[Form]![YourTextBoxName])),0,DSum("[Price]","tblYourTableName","[YourID]=" & [YourID]))

as the control source for the text box on your...
Forum: Access June 2nd, 2006, 12:05 PM
Replies: 11
Views: 1,862
Posted By dbartelt
I forgot to mention that the formula is to be...

I forgot to mention that the formula is to be placed as the control source of the text box on your main form. Whenever the DATE field is updated on the subform, the data will then show up on the main...
Forum: Access June 2nd, 2006, 11:57 AM
Replies: 11
Views: 1,862
Posted By dbartelt
Try this. =[9_PARADOSEIS].[Form]![DATE] ...

Try this.

=[9_PARADOSEIS].[Form]![DATE]

Use [DATE] only if that is the text boxes’ name. If DATE is not the text box name replace DATE with the name of the text box. Ie: Text52

Hope this...
Forum: Access June 2nd, 2006, 07:31 AM
Replies: 9
Views: 3,682
Posted By dbartelt
Do you have the sum([Price]) field in the...

Do you have the sum([Price]) field in the subforms footer? If so what is the text box name? Not the control source. Also what table is the subform data stored?

D. Bartelt
Forum: Access June 2nd, 2006, 07:22 AM
Replies: 4
Views: 1,824
Posted By dbartelt
Glad you found the solution. D. Bartelt

Glad you found the solution.

D. Bartelt
Forum: Access June 2nd, 2006, 07:05 AM
Replies: 11
Views: 1,862
Posted By dbartelt
Hi, Do you need to enter data on only the...

Hi,

Do you need to enter data on only the subform and view it only on the main form? Or do you need to be able to enter the data in either field?

D. Bartelt
Forum: Access May 31st, 2006, 06:24 PM
Replies: 9
Views: 3,682
Posted By dbartelt
Hi, I use this code and it works fine. ...

Hi,

I use this code and it works fine.

=IIf(IsNull(([subfrmToolShippingTickets].[Form]![Text56])),0,DSum("[LineTotalTools]","tblInvoicesOrdersTool","[InvoiceID]=" & [InvoiceID]))

D. Bartelt
Forum: Access May 31st, 2006, 11:25 AM
Replies: 4
Views: 1,824
Posted By dbartelt
Hello, I use the following code on a form...

Hello,

I use the following code on a form for Order Entry. This code will not allow the paperwork to be printed until all required fields are completed.
Private Sub PrintWorkOrder_Click()
On...
Forum: Access May 31st, 2006, 08:40 AM
Replies: 11
Views: 1,862
Posted By dbartelt
What is the complete name of your subform? Ie:...

What is the complete name of your subform? Ie: subfrm9_PARADOSEIS or is the name just 9_PARADOSEIS?


D. Bartelt
Forum: Access May 31st, 2006, 08:20 AM
Replies: 11
Views: 1,862
Posted By dbartelt
Hi, You can add a text box on the main form...

Hi,

You can add a text box on the main form and set the control source to =Forms!subfrmYourFormName.YourFieldName

D. Bartelt
Forum: Access May 31st, 2006, 08:15 AM
Replies: 3
Views: 959
Posted By dbartelt
Hi again, I have solved most of my request...

Hi again,

I have solved most of my request by using this select query.

SELECT tblInvoices.CustomerID, tblInvoices.InvoiceID, tblInvoices.InvoiceNumber, tblInvoices.InvoiceDate,...
Forum: Access May 25th, 2006, 07:33 AM
Replies: 1
Views: 1,209
Posted By dbartelt
I have had this problem also. I use Access 97 at...

I have had this problem also. I use Access 97 at work. When I take the db home to work on it I convert to Access 2000 1st, then convert to Access 2003. I am not sure if this a security issue with...
Forum: Access May 24th, 2006, 06:51 AM
Replies: 3
Views: 959
Posted By dbartelt
The PaymentDate of a specific Invoice may be...

The PaymentDate of a specific Invoice may be 30-60 days after a specific InvoiceDate, however, there will be new Invoices generated between InvoiceDate for Invoice 123 and the PaymentDate for Invoice...
Forum: Access May 23rd, 2006, 12:20 PM
Replies: 3
Views: 959
Posted By dbartelt
Multiple table help

Hello,

I need help making a Customer ledger report which will gather all information for a selected customer from 3 different tables, tblInvoices, tblPayments and tblCredits, and then sort it...
Forum: Access February 13th, 2006, 03:56 PM
Replies: 5
Views: 6,128
Posted By dbartelt
Kevin, I believe that i have solved it. I am...

Kevin,

I believe that i have solved it. I am trying to requery the entire form whem all I needed to requery was the SubTotal and SurchargeTotal fields.

New codes are:

Private Sub...
Forum: Access February 13th, 2006, 03:43 PM
Replies: 5
Views: 6,128
Posted By dbartelt
How's it going Kev? Thanks for your reply. I...

How's it going Kev?

Thanks for your reply. I tried what you suggested. When I compile and save all modules, I receive a "Variable not defined" error. I then tried Dim MyRecNum as Interger, as...
Forum: Access February 13th, 2006, 02:38 PM
Replies: 5
Views: 6,128
Posted By dbartelt
Continuous form / SetFocus help

I have an Invoice form that is formatted to continuous form view. The below event procedures work well if there is only 1 record. However, with 2 or more records, the SetFocus event moves the cursor...
Forum: Access January 4th, 2006, 03:33 PM
Replies: 6
Views: 2,869
Posted By dbartelt
Dartcoach & mmcdonal, Thank you for yur...

Dartcoach & mmcdonal,

Thank you for yur help. I believe I figured it out. I created a CustomerName footer and placed text boxes that are running sums both "Over Group" and "Over All". I then...
Forum: Access January 4th, 2006, 02:16 PM
Replies: 6
Views: 2,869
Posted By dbartelt
Thank you both for your replies. I have tried...

Thank you both for your replies. I have tried both of them. I am still having the same problems. Either a parameter box "Sum([0-30Days].[Value])" or "Sum([LessThanThirtyDays].[Value])" appears when...
Forum: Access January 4th, 2006, 10:58 AM
Replies: 6
Views: 2,869
Posted By dbartelt
Thank you for your reply. I tried what you...

Thank you for your reply. I tried what you suggested and I receive a parameter box “txt0-30Days” when I open the report. The text boxes I am trying to sum are calculated fields and are not in any...
Forum: Access January 3rd, 2006, 02:56 PM
Replies: 6
Views: 2,869
Posted By dbartelt
Help with summing calculated fields on a report

Hi All,

I am still working on my “Aged Receivables” Report. The report is a continuous report that is grouped by the “Customer Name”. All works fine except for summing each customers aging...
Forum: Access November 21st, 2005, 06:21 PM
Replies: 1
Views: 838
Posted By dbartelt
Help with sorting by days out

Hello again,

I need help sorting by InvoiceDate for the AgedReceivable form.

I have placed 4 text fields in the footer of the form "subfrmStatements". The control source for each text field...
Showing results 1 to 25 of 56

 




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