473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report doesn't read input data within VBA detail code

133 100+
The access application has a report that within, the report detail the data is manipulated for formatting. For some odd reason, the event procedure is not acknowledging the data set. Would appreciate any guidance. The code is as follows:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  2.  On Error GoTo Detail_Format_Error
  3.  
  4.  
  5.     Me.txtProductNumber = Q_AvgPrice_PerYR!ProductNumber
  6.     Me.txtProductDescription = Me.ProductDescription
  7.  
  8.     Select Case Me.FY
  9.         Case "08"
  10.             Me.txtFY08Qty = Me.QtySum
  11.             Me.txtFY08AvgInvPrice = Me.AvgInvPrice
  12.         Case "09"
  13.             Me.txtFY09Qty = Me.QtySum
  14.             Me.txtFY09AvgInvPrice = Me.AvgInvPrice
  15.         Case "10"
  16.             Me.txtFY10Qty = Me.QtySum
  17.             Me.txtFY10AvgInvPrice = Me.AvgInvPrice
  18.         Case Else
  19.             MsgBox "FY not 08, 09, 10"
  20.     End Select
  21.  
  22. Detail_Format_Exit:
  23.   Exit Sub
  24.  
  25. Detail_Format_Error:
  26.   MsgBox "Error " & Err.Number & ": " & Err.Description
  27.   Resume Detail_Format_Exit
  28.  
  29.  
  30. End Sub
  31.  
  32.  
Aug 17 '10 #1

✓ answered by dowlingm815

The report neglected to place the fields on the report as invisible in order to manipulate the data.

1 1361
dowlingm815
133 100+
The report neglected to place the fields on the report as invisible in order to manipulate the data.
Aug 17 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: BigAl | last post by:
I am using the following code in a servlet to send data back to a J2ME application:
2
by: none | last post by:
Hi, Any one know of some code to read cobol data files.... thanks timb
1
by: Magnus | last post by:
allrite folks, got some questions here... 1) LAY-OUT OF REPORTS How is it possible to fundamentaly change the lay-out/form of a report in access? I dont really know it that "difficult", but...
1
by: Luc Balemans | last post by:
Running Access 2002 (10.0) Is it possible to format data within a text box (a) on a form or (b) on a report? E.g. botanical names in Latin: <Hydrangea macrophylla subsp. serrata>, with the...
2
by: Steve Teeples | last post by:
I learned that C# doesn't allow global variables within a project. However, I have a structure that I wish to store data within. The data is retrieved from multiple forms within my project. How...
1
by: Grey | last post by:
I have created a asp.net form for user to input data. After input the data, user need to click a button to export the input data to excel for data analysis with excel pivot table function. is it...
2
by: Jim B | last post by:
I am new to VB.NET and have a question on validating user input from a Text Box. I'm writing a small program where I want to check the users input data and determine if it's an Integer or a...
3
by: gregpinero | last post by:
Would someone mind tell me what I am doing wrong here? I want to find all of the input elements within a div tag with id newID and blank out the values in the inputs. Nothing seems to happen when...
8
by: Mike | last post by:
Hi, If protect MS Access with password it doesn't mean to much. On internet, we can find plenty tools for opening forgotten passwords etc. I have a small c# aplication wit large amount of...
4
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I have created a report. This report needs to display records between two dates entered by the user. I put two text boxes on the report so I can enter the start and end date - I set them to use an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.