no they are not too tall.
I know what you are saying, I can make pages very small, but that will show all the records in a sequence. I would like to place the records anywhere on the page. (10 records placed on one page)
let me know if I am not explaining this whole thing correctly.
M0ji
Last Activity: Jan 25 '13, 10:22 PM
Joined: Jan 2 '13
Location:
-
display several records per report - Access 2010
I have a table with 10 records in it, and I have created a report and added existing fields.
The report shows one record on each page (There are therefore 10 pages)
I need all 10 records on one page. -
It worked great
ThanksLeave a comment:
-
Update Query / Multiple criteria - MSAccess 2010
I have created an update query to auto populate the value of one field based on the value of another field.
I have two fields "Level" and "Document"
if Document is A, Level needs to be 1
if Document is B, Level needs to be 2
if Document is C, Level needs to be 3
as far as I can see the GUI only lets you enter one criteria, but I am sure there is a way to avoid three different... -
What I ended up doing which works perfectly was using a sub-form.
Since I had never used a sub-form before, I didn't know that it was the key to this problemLeave a comment:
-
Smiley
so basically, if I understood right, you are only going to give the user the ability to determine the children for every row (requirement) and have the parent field generated based on that selection correct?Leave a comment:
-
@ TheSmileyCoder
Oh, I guess I didn't answer your first question properly.
multiple children can have multiple parents.
so it would actually be scenario 3.
I am watching the video you posted, and it's great, but I don't think it answers all of my questions....I am watching it again.Leave a comment:
-
@ Set Schrock
The other thing I tried:
I have a form that presents my data.
- I go to design view
- There is a combo box whose control source is Parent field
- I open the properties and go to the event tab
- Next to "after update" I click on ... (three dots)
- I click on code builder and I try your code, but I get a syntax errorLeave a comment:
-
@ Set Schrock
I would like to try your code, but I don't know where to put it.
here's what I do (Access 2010):
- opening the table
- clicking on "table" tab under "table tools"
- clicking on "after update"
- Now there is a drop-down menu, which one do I choose to enter your code?
ThanksLeave a comment:
-
@ TheSmileyCoder:
The answer to your question is: 2nd scenario
A child can have multiple parents.
I totally understand your point and I was about to create the second table that is solely in charge of parent/child relationship.
so I guess I need to create a row for EVERY single parent child relation, correct?Leave a comment:
-
Seth
I am trying the first thing you suggested, an update query.
what would be the code you use to do it.
let's say the table's name is "table".
Is this update query going to be automatically run everytime a user make changes?
As for why I created a field name Children, because I show every row (requirement) on a separate page, and I want the user to see both parents and children of that...Leave a comment:
-
Parent/Child Relationship / Access 2010
I have started creating a database (There is only one table as of now).
The database is meant to store information about "technical requirements" in an industry.
Each row corresponds to one requirement. It contains information such as description, verification method, etc regarding that specific requirement.
There is a field, "RID" (Requirement ID).
There are also two fields ("Parents",... -
Thank you guys
What I ended up doing was slightly different, but very effective in this case.
I simply used a list-box, which allows you to display different fields (Including ID numbers) in a drop-down menu for the user.
Then the user can simply click on the ID-number of a different row, which will take him to that row in the form.Leave a comment:
-
Great, I would be totally content with doing the same thing in a "form" as opposed to a "report".
You mentioned you have "fields that act like hyperlinks that ...go to related records"
How do you do that?
In a nutshell what I want to do is to click on a value in a row and be taken to a different row (in that same form)
Thank youLeave a comment:
-
Access2010 database - Clickable reports
I have a database consisting of one table.
Some rows in this table have fields that contain the ID number of other rows. (as a value)
I have created a report of this database.
I would like to click on those ID numbers in the report and be taken to the row that corresponds to them (otherwise I would have to scroll down the page and do it manually)
Similar to the idea of hyperlink, except for I want to be directed to a...
No activity results to display
Leave a comment: