473,394 Members | 1,722 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,394 software developers and data experts.

Problem with Report/Subreport/Image

Hi, longtime lurker first time poster.

I am developing a Db for school on assambling planes etc... well i have my tables

Model
Pk MID autonumber
Model Name txt
Model Type txt

Pices
Pk PID autonumber
Piece Number txt
Piece Description txt

this are the only ones that are independent.

Index
IID primary key
MID FK to Model MID
Group txt
Description txt
image txt
comments txt

and Assambly
EID Pk autonumber
MID FK to model MID
IID FK to index IID
PID FK to piece PID

Position number
quantity number

Ok so i created a report called "Sub Assably" wich is used in a Form called "Assambly". I have a imageFrame that is updated with the image path from index.

The sub form normally works fine, however i have found that my problem is with the detail section of Assambly wich has "can grow" = yes

therfore, when a sub assambly gets to long it goes to a new page.

Here is my question [i know finally]

Is there any way that when the page is change, the picture is in there too?

ok here is a quick example...

reddit alien is not golden yuo can see this
Attached Images
File Type: jpg untitled.jpg (15.7 KB, 161 views)
Jul 22 '10 #1

✓ answered by evildracko

solved by creating a new column with the page number... not clasy but working

basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that value

1 1888
solved by creating a new column with the page number... not clasy but working

basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that value
Aug 13 '10 #2

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

Similar topics

1
by: Ellen Manning | last post by:
I've got a report with a subreport linked on fund number. The subreport returns 2 columns of dollar amounts, both current and YTD, by object code for the selected fund number. The user can select...
1
by: last Name | last post by:
Hello all, I'm using Access 2000. I have a subreport control which loads a report in the detail section of a main report. I need to keep a count of each item price in the subreport and place it...
2
by: Keith Wilby | last post by:
A97 I have a report/sub-report setup and for some records in the main report, the sub-report is blank. I want to set the height of the sub-report to zero where it is blank. I've set all the "Can...
1
by: Kathy | last post by:
I have a number of reports in a MS Access application that have a logo picture embedded in the report. When I run the report and choose File, then Export to Excel, I get an error indicating...
2
by: Ron | last post by:
I have a report let's call rptOne. On rptOne I have a subreport called srptOne. On srptOne I have a subreport called srptTwo. Sometimes, srptTwo is there and shows it's data and sometimes not,...
6
by: xian2 | last post by:
Hi All, I know you have heard this all before from the millions of other people asking the same question, but I have read through many other posts and NeoPa's guide and another guide i found on...
3
by: Connell | last post by:
I am using a command button from a form (Access 2000) to produce a report. The form and the report each have a subform (subreport). Here is the expression that produces a total for one field on the...
0
by: EManning | last post by:
Using 2003. I've got a main report with a subreport and within that subreport is another subreport, all bound. The detail in the 2nd subreport is repeated multiple times for some reason. The...
5
krungkrung
by: krungkrung | last post by:
hi again to everyone! I made a simple program(for my VB.Net practice). The program loads an image file to a picturebox upon clicking a button. after loading the image file i have another button to...
2
by: hiranmaie | last post by:
I am having the problem with the image path. I am using a master page and the reference to the image in web content page which is not working properly. It shows Done, with errors on page error. If I...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.