473,407 Members | 2,359 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,407 software developers and data experts.

Open report on ative record (3 tables project)

Hi,
i'm trying to open a report from a especific article, but it always show all records from the especific article.

i've 3 tables:
clients
-id_client
-name

articles
-id_articles
-id_clients
-model

repair
-id_repair
-id_article
-repair_problem

I'm using this code to open report with only unique repair, but it always show me all repairs from some article

VBS
Expand|Select|Wrap|Line Numbers
  1. Private Sub Número_Reparação_DblClick(Cancel As Integer)
  2. Dim strDocName As String
  3. Dim strWhere As String
  4.    strDocName = "Report"
  5.    strWhere = "[id_article]=" & Me!id_article
  6.    DoCmd.OpenReport strDocName, acPreview, , strWhere
  7. End Sub
Hope someone can help me.
Thanks
Nov 4 '16 #1
0 709

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

Similar topics

3
by: Jer | last post by:
Using Access 2003 w/Windows XP. I have a database originally created with the tables internal. I split the database into a front-end/back-end with linked tables. Now when I open one of the...
2
by: news.zen.co.uk | last post by:
I'm a bit new to Crystal Reports - I have a query that runs in my program and I am putting the query results into a datatable... I then use the following code to show the report: repDiary...
1
by: yasinahmad | last post by:
Hi every one I have three tables 1-students 2-books 3-pens I wont to make report by data report to show tables like this student name
2
by: Andy | last post by:
Hi guys I having a problem creating a report in Access 2003 project talking to a SQL database through and ODBC connect. After hours of trying things from Access Help, MSDN and Google I still...
4
by: Phil Stanton | last post by:
I am opening a report (in Preview) from a menu system I use the following code if there is no data in a report Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no errors in...
0
by: Jraj | last post by:
While assigning dynamically to the crystal report i get the error Report has no tables. DataTable dtData=new DataTable(); dtData = objHIMS_Facade.GetBiz_MonthlyOPReport(rIndex, EmpType, year); ...
1
by: Robert Ingles | last post by:
I have a situation where my users need to enter details about new laptops into a table via FRMCreateNewLaptopID - the FRMCreateNewLaptopID includes a UserID field to identify the primary user. ...
8
by: trivanka | last post by:
How to open report directly in Access 2010 when we open the file? Under options - Current Database, I see Display Form. Do I need to write a VBA code for this and if so, which event. I also...
10
by: tajuddin | last post by:
I wanted to have a Command Button on a form to save a record & then ask to open a new record. I am new to access. I have MDFID on a form with primary key. Thanks Seth, To be frank, I...
7
by: Aftab Ahmad | last post by:
Hi! I have a button namely "Open Report" on my form "Orders". I want to open report i.e., "Order Detail" through VBA. I know "DoCmd" is nicely working but I want to show only current record which...
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: 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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.