I have a sub Report in the detail section of its parent. I need to hide the detail part of the parent if the subReport corresponding to the record has no data.
Here is what iam trying to do but failing, any ideas...
Private Sub Report_NoData(Cancel As Integer)
Me.Parent.Section(0).Visible = False
End Sub
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Right now, my code looks like this for On_Click:
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
I have a main form (Parent) along with a subform(Children). I want to have a button that generates a report with the Parent information as a header and the items in the subform as details. In addition, I want the report to show only the children that were recently added not all of the children.
View 1 Replies View RelatedI currently use
Me!frmPatientLookupResults.Form.Visible = False
to hide a subform on my form that is in the detail section of my form.
Is there a way to collapse or Hide the Detail section of the main Form??
I notice that their is a property under the Detail section called Visible
with an option for Yes or No.. How would I manipulate that option through
VBA? I am assuming that is the option that I am looking for
I need to hide a row in my report for example (in Detail Format event of the report):
If me.txtReleased = "YES" then
hide row
endif
here I have capture what is error actually when i make a DLOOKUP wizard.the box of wizard. there i want to make a relationship with table2. but we could see that table1 still show. yes right, it's reality making error and show message ""you can't modify the structure of table, because it is already in use by another person or process"and warning message ""Microsoft access couldn't launch the lookup wizard, or this wizard has been disabled...blabla...blaa"
on my laptop, ms access 2010 nothing happen the mattter and when i make DLOOKUP, parent table have been not seen.and make DLOOKUP Wizard is successfull.
why in my PC, when i make DLOOKUP wizard, parent table still show?what is this bug for MS access 2010?
I have a parent form and a subform linked to the parent.
My client decided that he wants one of the controls from the parent form to be placed in the subForm area. The source of the control is still in the parent table but he just wants to place it in the subForm.
I am having a hell of a time doing this......
I tried to do it by changing the recordsource of the subForm by joining the Parent and Child tables so I could have access to that field in the subform.
But this is very ineffecient and I am getting new errors coming up as a result.
Any ideas ????
Thank you
Hello!
I have a problem figuring out a solution for following problem.
I have a database of details and their properties.
All the details have been described in one table.
As there is a need to describe groups of details I have found myself in a hard situation that needs to be resolved.
The structure of described detail groups is as follows:
Product
Detail Group1
Detail groupx etc.
Detail4
Detail groupx etc.
Detail groupx etc.
Detail1
Detail2
Detail3
Detail Group2
Detailx
Detailx
Detail groupx etc.
Detail groupx etc.
Is there a way of decribing my products in access so that there are no limits of how many groups does a product have and how many levels of groups the product have.
Thank you
i'm using Master and Detail table. Master table i have TaskId, ResId where ResId is mapped to Detail table which contains resource working on the task. i want to generate a query where for each task i want to display resource id in single column like below.
Task Id Resource Id
1 222,233,244,255
Do i need to use recursive query or any other method to get results like above.
Straghtforward problem I hope!
Header table keyed on ProjectID
Detail file keyed on ProjectID and then IssueID
IssueID shoud start at 1 for each project, then 2,3,4 etc.
Autonumber seems to just increment by 1 regardless of ProjectId, rather than within it.
I'm new to Access, so what options do I have for autonumbering, or what other technique can I use?
Thanks in advance
I am a novice to Access so bear with me please. I've just created a form to populate some tables.
When I switch from design view to form view, the detail area in the form view is blank. :mad:
The header is fine but fields, which are present in design view are not present in form view.
Any suggestions, I've tried font/background colors and searching for a switch setting.
Thanks in advance,
JA
Hi Everyone,
I have a problem here... i need help... could someone know that how to using a combo box to edit the details?
Now i am using the Employee Name as my primary key and i set it as a combo box to let user to select the name and list all the detail like IC, Job Position, Date of Employment and etc. But when i try to edit the detail of the employee, the access program do not allow!! And i know is because i am going to create a duplicate record by the employee name.
So, do someone know how to use the combo box to list out all the details and after i doing editing by pressing a 'Save' button then the detail just change without creating a deplicate record? Maybe someone just give me a little bit idea then is enough... Thank you!!!!
I haven't used Access in a couple of years. I created a DB some years ago where I did not want the users to be able to view/change the forms, queries, etc.
I only wanted them to be able to view the "finished" product and do the data input.
I remember there was an "alt+key" combination I hit when I opened the db file in order to view/change queries, forms, etc.
Now, I've forgotten the key combination at open which allows me to see the details of the db.
I have some formulaes in that old db that I now need.
Could someone please advise on the key combination at open which will allow me to view/modify the details of the db?
Thank you in advance for your assistance.
Sincerely,
Joel
I am looking for a way to only print the detail section (no header, no footer) using a print button on a form. it also needs to fit to 1 page. do i need code for this or is there a property that can be adjusted?
View 4 Replies View RelatedHello and Good Morning,
I am trying to create a 5 page report filled with colorful tables, charts, and graphs. This report will need to be reproduced 115 times. I am almost finished with page 2 of 5. When I try to start page 3, it appears that the height of the report is capped.
I have reset my computer to clear my RAM, but I still have the same problem. I try extending the length of the report, but the window will not scroll down beyond 22". Is there a way to extend the height of the report?
Thank you in advance, and I will try to answer your question in return.
Hi,
I'm trying to create a report that separates info depending on Prodno. For now it lists all the right information like this
Code:Product Aisle Rack Shelf0218 7 6 20775 5 6 20775 4 4 40775 0 1 30963 1 1 71000 7 4 61000 2 3 71006 8 8 8
which is fine and dandy. What I would prefer is it do like this
Code:Product Aisle Rack Shelf0218 7 6 20775 5 6 2 4 4 4 0 1 30963 1 1 71000 7 4 6 2 3 71006 8 8 8
I am assuming it is some kind of group by in the details section? Any help would be great,
Thanks,
I have been having alot of trouble with this and just can't figure it out, I am trying to get data from a parent form into a subform so I can use it in equations. Specifically I have a DOB (Date of Birth) field on the main form, and want to have a =DateDiff("yyyy",[DOB],Date()) to find their age.
I need this in the subform because of some other information that relys on it. The way I have it right now you have to manualy put the DOB in the subform, and it can be different from the value in the main form. Could any of you tell me what I am doing wrong here?
Hi all
I seem to be having a problem with acess 2003 in that when ever I set the parent/child relationships and go back to the front end the simple disappear?
any thoughts would be grate
Thanks
James
I currently have a subform that changes the image that is displayed when I click a button using
[student_picture].Picture = [student_image]
Is there anyway I could also update the image on a parent form, from the subform, something like
[ParentName.ImageNameOnParent].Picture = [student_image]
Thank You
Neil
I'm curious if anyone know's a way to access a specific data section on a tabular form. I'm attempting to have each section update a specific data item based on its position on the form, but am having problems since I do not know how to differentiate between one details section and another on the form. Any help would be appreciated.
Thanks
Hi
Got a form with a Detail section that can have any number of textboxes in it depending on the data a query brings back:
e.g.
QueryID Calculatedtextbox
QueryID Calculatedtextbox
QueryID Calculatedtextbox
QueryID Calculatedtextbox
The Calculatedtextbox has a DSum function, which uses the QueryID (another textbox).
I then have a footer at the bottom and need to sum all of the textboxes. Is this possible? Access doesn't seem to like it...
Dear Moderator and All This forum Member,
i have problem to how to make such a invoice report which in sub report detail have a vertical line per column for each page, and every sub sum in detail can continue for next page,
any one can tell me how? i really appreciate if any one can give me some exampel.
i had looking in microsoft forum for example but i it just for calculating per page which does'nt have sub report and explaining about vertical line in detail.
First of All i want say Thank you for All your Kindness.
Best Regards,
Hendra Susanto
Hi All,
It's my first post to the forum, but I've browsed it a lot the past week! Lots of info here. Unfortunately I couldn't find an answer to my question, so here it is: A simple Form attached to a Table. In the detail section of the Form the Table rows are displayed (all simple textboxes) and there is a hidden button on the row. When I put the focus on a textbox in a row, I want to set visible=TRUE for the little button in that specific row. Obviously I want the button remain hidden for all other rows!
Is there a way to accomplish this, changing the properties of a control in a specific row? When I set visible=TRUE, all rows suddenly display the button.
Thanks for any input!
hello. can i refer to a single record in a detail section, and not all of them? for example if i use something like this (after update in field1):
if me.field1 = 0 then
me.field2.enabled = false
any single field1 equal to zero will disable ALL of the field2's. i would like this to work within each record independently.
I have made a small text box in the header area, as to be able to tab from the header area to the detail area, and put the code Me.[Date Sold].SetFocus (Date Sold being the name of the text box I would like to tab to) in the "Got Focus" event. However for some reason it does not work, I get an "Invalid outside procedure" error every time.
Any advice on how to fix this problem would be most welcome.
Hi,
I created a form based on head/detail/foot kind of setup.
Now in the detail I have a combo box and a textbox. Is it possible for me to set focus to the next line textbox after the combo box fires onExit trigger?
so for instance:
form is empty. Fill in textbox, choose from dropdown, and then on Exit the focus is set to the next line textbox.
Thanks,