Linking form - Report - Microsoft Access / VBA

Gt394

I have a form called frm_quote and a report called rpt_quote.
I want to be able to view the form on a particular quote number (field:
QuoteNo - autonumber) and then go to the report where the the info on that
particular quote no. is shown in the report.

frm_quote is linked to query: qry_viewquote
rpt_quote is linked to: qry_viewquoterp t

In design of qry_viewquoterp t - I simply have the expression (for the
field: QuoteNo ) [Enter Quote No]. This method does the job however I
would like it to automatically recognize the quote number as described
earlier without this manual input of the user.
thanks.

Nov 13 '05 #1

Subscribe Reply

2410

Ed Robichaud

It's a common solution to put a command button on your form that will open
your report. Set the criteria to limit your report to a value on the form.
An example:

Private Sub PrintForm_Click ()
On Error GoTo Err_PrintForm_C lick

Dim DocName As String
Dim LinkCriteria As String

DoCmd.DoMenuIte m A_FORMBAR, A_FILE, A_SAVERECORD

DocName = "MemRecord"
LinkCriteria = "[V-ID] = Forms![MemEntry]![V-ID]"
DoCmd.OpenRepor t DocName, A_PREVIEW, , LinkCriteria

Exit_PrintForm_ Click:
Exit Sub

Err_PrintForm_C lick:
MsgBox Error$
Resume Exit_PrintForm_ Click

End Sub

The command button wizard will do most all of this for you.
-Ed

"Gt394" <g4****@hotmail .com> wrote in message
news:43******** *************** @news.optusnet. com.au...

I have a form called frm_quote and a report called rpt_quote.
I want to be able to view the form on a particular quote number (field:
QuoteNo - autonumber) and then go to the report where the the info on that
particular quote no. is shown in the report.

frm_quote is linked to query: qry_viewquote
rpt_quote is linked to: qry_viewquoterp t

In design of qry_viewquoterp t - I simply have the expression (for the
field: QuoteNo ) [Enter Quote No]. This method does the job however I
would like it to automatically recognize the quote number as described
earlier without this manual input of the user.
thanks.

Nov 13 '05 #2

Tom van Stiphout

On Wed, 28 Sep 2005 07:43:34 +1000, "Gt394" <g4****@hotmail .com>
wrote:

Take out the [Enter Quote No].
Then when opening the report using DoCmd.OpenRepor t, take a look at
the WhereClause argument. Set it to something like:
"QuoteNo=" & Me.QuoteNo

-Tom.

I have a form called frm_quote and a report called rpt_quote.
I want to be able to view the form on a particular quote number (field:
QuoteNo - autonumber) and then go to the report where the the info on that
particular quote no. is shown in the report.

frm_quote is linked to query: qry_viewquote
rpt_quote is linked to: qry_viewquoterp t

In design of qry_viewquoterp t - I simply have the expression (for the
field: QuoteNo ) [Enter Quote No]. This method does the job however I
would like it to automatically recognize the quote number as described
earlier without this manual input of the user.
thanks.

Nov 13 '05 #3

Similar topics

6002

Linking Crystal Reports To ADO .Net Dataset

by: Colin Graham | last post by:

I have recently created a report in crystal(10) linking to a dataset as the datasource. I notice however that the fields available in the report all have STRING format and therefore i cannot change format in crystal(10) e.g. I wish to change a date field to have the format dd/MM/yyyy. The main problem here is that the dataset seems to store...

.NET Framework

3226

Excel Linking

by: Mark T. | last post by:

Hi, I've got a simple DB (Office Win XP Professional). Basically, it's like a check book register - deposit, deduction and running sum. I'd like to somehow link it to an Excel spreadsheet that will do the calculations and then keep the data updated in the form and report in the DB. Apparently this isn't done in Access because the "cell"...

Microsoft Access / VBA

6227

Linking table to multiple tables

by: TheTamdino | last post by:

One of the things that is common between most genealogy databases is that they will have one screen were you log all the information for a given person and then (maybe) have a link to a source record. I'm trying to create a database where you have tables that record facts and then link those facts to a person record. For example, I'll have...

Microsoft Access / VBA

2001

Yet another Query Linking Question

by: hmiller | last post by:

I'm sorry to populate the server with yet another question about linking multiple tables and queries, howerver I have not been able to find the right criteria. My problem. I am trying to either link 3 tables together in a select query, and maintain the editablity that I get when linking two tables and creating a form. I know there is a...

Microsoft Access / VBA

2370

Linking Checkboxes to values in a table for a Report

by: schmidtmic | last post by:

I have a table that contains 20 checkbox fields. Each checkbox corrisponds to an Score amount. For Example: Checkbox1 is worth 10 points Checkbox2 is worth 5 points Checkbox3 is worth 2 points Checkbox4 is worth 3 points

Microsoft Access / VBA

2305

Crystal report linking in VB6

by: zaaza | last post by:

I'm trying to generate report within my visual basic 6 project. My problem is that i need just some specific records on the report at any given time. I create the recordset within the codes behind the viewer form, it works perfectly. Now if i pass this recordset to the report it gives me errors. Some common once being Do not have permission or...

Visual Basic 4 / 5 / 6

1810

Picture linking

by: Parasyke | last post by:

I have a form that has a bound textbox displaying a picture path (in another folder) for an image (e.g. C:\Documents and Settings\My Documents\My Pictures\SymbolVRC 6940.jpg). I need this actual picture to display on the screen and most importantly to display on a report. Any clues on this? Thanks!

Microsoft Access / VBA

1929

Image linking for Report

by: Parasyke | last post by:

I have a report that I want to print for a product specification sheet with a photo of the product. I have the photos stored in a separate folder from my Access 2000 database. I have a form that when I choose a product all the info for that product appears on the form appropriately, including the image path (e.g....

Microsoft Access / VBA

3715

Linking a Text Box in a Form to the Criteria in a Query using "Like"

by: JPG4 | last post by:

I have tried just about everything that I can think of, so now I turn to you all for help! I have created a form (titled "OAG") with an unbound textbox titled "DOW". I also have a Query that I have set up to return results using the abbreviations for the day of the week, and periods when that day is not present. For example, if the pattern is...

Microsoft Access / VBA

7446

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7956

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

6041

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5368

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5088

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3498

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3480

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1936

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1058

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP