Hello everybody
The name of the form that I'm working on is 'AddProduct' I'm trying to print a selected record that I have the focus, its name is "barecode"
My report name is 'barecodeprint' that contains a text box called 'barecoderepo'
I need to open the report with critiria 'barecode' ='barecoderepo' I'm using this code
Dim stDocName As String
Dim stlinkcriteria As String
stDocName = "barecodepr int"
stlinkcriteria = "[barecoderepo]='" & Me![barecode] &"' "
DoCmd.OpenRepor t stDocName, acPreview, , stlinkcriteria
Guys I spent maybe more than hours to be sure from all names above and I'm always getting in input box written on it [barecoderepo]....
Both text box are text
Can someone know something about this problem ... THank you
8 1948
Hello everybody
The name of the form that I'm working on is 'AddProduct' I'm trying to print a selected record that I have the focus, its name is "barecode"
My report name is 'barecodeprint' that contains a text box called 'barecoderepo'
I need to open the report with critiria 'barecode' ='barecoderepo' I'm using this code
Dim stDocName As String
Dim stlinkcriteria As String
stDocName = "barecodepr int"
stlinkcriteria = "[barecoderepo]='" & Me![barecode] &"' "
DoCmd.OpenRepor t stDocName, acPreview, , stlinkcriteria
Guys I spent maybe more than hours to be sure from all names above and I'm always getting in input box written on it [barecoderepo]....
Both text box are text
Can someone know something about this problem ... THank you
what's the name of the field that your textbox uses in the underlying recordsource? That's what goes into the [ ]
what's the name of the field that your textbox uses in the underlying recordsource? That's what goes into the [ ]
It is [barecoderepo] the name of the textbox on the report ...
It is [barecoderepo] the name of the textbox on the report ...
What version of Access are you using?
It is [barecoderepo] the name of the textbox on the report ...
try
DoCmd.OpenRepor t stDocName, acViewPreview, , stlinkcriteria
the same problem using
DoCmd.OpenRepor t stDocName, acViewPreview, , stlinkcriteria
Access version is 11.5614.5606 office 2003
Man the report that i'm using contains some special FONT barecode FONT ... Does this font are related to like these problems ...?
I tried a macro using DOCMD.OPENREPOR T .. It isnot working too but it works for other report ...
the same problem using
DoCmd.OpenRepor t stDocName, acViewPreview, , stlinkcriteria
Access version is 11.5614.5606 office 2003
Man the report that i'm using contains some special FONT barecode FONT ... Does this font are related to like these problems ...?
I tried a macro using DOCMD.OPENREPOR T .. It isnot working too but it works for other report ...
Yes, I can see where that would make a difference, however, the error you're getting points to only one conclusion..the name of the field you're trying to filter isn't on the report. That's why I asked what the "field" name, vs what the name of the textbox was. They can be different. The where clause in the openreport command uses the field name of the source of your report and not the textbox name.
J
Man I like your BRAIN ... Finally after 3 hours of [textname] verification it workes thank you ....:)
Man I like your BRAIN ... Finally after 3 hours of [textname] verification it workes thank you ....:)
Sorry I wasnt clear earlier. Glad you got it going.
J
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jody Gelowitz |
last post by:
I am having a problem with printing selected pages. Actually, the problem
isn't with printing selected pages as it is more to do with having blank
pages print for those pages that have not been selected.
For example, if I were to have 5 pages with every second page printing, I
would get the following results:
Page 1 = Print OK
Page 2 = Blank
Page 3 = Print OK
Page 4 = Blank
|
by: John |
last post by:
Hi,
I have simple database based on 3 tables. Relationship is 'one to many'
between table 1 and 2, also between 2 and 3 table'one to many'.
I have made form where I enter data in all 3 tables. Form has 2 subform
based on relationships.
I want to make report to print data which is shown on form. I want to print
only data from form, not whole records from tables. Does anyone knows how to
do this? I have tried with report based on query,...
|
by: Sami |
last post by:
I hope someone will tell me how to do this without having to do any VB
as I know nothing in that area. I am a rank beginner in using Access.
I have created a database consisting of student athletes. I have now
learned how to join two different tables in a query so that I might
generate a report.
Specifically, student athletes at a community college are required to
graduate with an AA or AS degree. Consequently, various steps are in...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy project in which I have two tables:
Person -- one record for each person in the family. Each record has a
unique Autonum field (IDPerson).
Partnerships -- one record for each marriage. Each record has a unique
Autonum field (ID), and also contains two fields IDPartnerMale and
IDPartnerFemale. Both of the latter fields match records in the Person
table via IDPerson.
|
by: John |
last post by:
Hi
If I have a form open, what is the code that is equivalent to using the
File->Print menu with select record(s) option to print the form with the
currently displayed record values?
Thanks
Regards
| |
by: Kaur |
last post by:
Hi,
I am having problem trying to go to same record when I close 3rd form.
I have a form called frmDepartment. This form has a list box that
displays all the departments. Clicking on one of the departments opens
up second form called frmEmployees. This form displays all the
employees for the department selected in frmDepartment. This form has
an unbound list box which retreives all the values from a query and
displays all the names of...
|
by: mci |
last post by:
Hi!
How can I print the selected record? I'm using visual basic 6. After I search the record, it display in the form but when I click the print button all the records will print. What I want is to print the selected record only.
Thanks!
|
by: Dave |
last post by:
Hello!
What's the best way to make a button print *just* the selected
(displayed) record of a subform, when that subform is currently part
of a larger form?
Thanks!
|
by: sirdavethebrave |
last post by:
Hi guys -
I have written a form, and a stored procedure to update the said form.
It really is as simple as that. A user can go into the form, update some fields and hit the update button to update the information which is stored in a SQL database.
In testing we noticed that the form was updating correctly but the update mechanism was also updating the first record of the table in the sql database every time. No error messages are on...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |