I have synchronized combo boxes linking Account Type with Customer
Names based on the template that Microsoft has in one of its samples
databases. There are the appropriate relationships between the Account
Type Table and the Customer Name Table based on the ID field, so it is
the ID field which is stored in the main table. However, in the form,
the Account Type and Customer Name are displayed because the column
width property has been changed to hide the other columns. But, when it
comes time to create reports, it is the ID field that comes up whereas
I need the text equivelent of the Account Type and Customer Name to be
displayed. How do I replicate what is on seen on the form in a report.
I suspect it would be done with a special query which would be the
source for the report, but do not know what method to use to get text
equivelent of each of the two fields.
Any assistance would be appreciated.
Miguel 4 1975
Miguel wrote: I have synchronized combo boxes linking Account Type with Customer Names based on the template that Microsoft has in one of its samples databases. There are the appropriate relationships between the Account Type Table and the Customer Name Table based on the ID field, so it is the ID field which is stored in the main table. However, in the form, the Account Type and Customer Name are displayed because the column width property has been changed to hide the other columns. But, when it comes time to create reports, it is the ID field that comes up whereas I need the text equivelent of the Account Type and Customer Name to be displayed. How do I replicate what is on seen on the form in a report. I suspect it would be done with a special query which would be the source for the report, but do not know what method to use to get text equivelent of each of the two fields.
Any assistance would be appreciated.
Miguel
Hi Miguel,
Have u already try to use the code DLookup? I think it will do what u
need.
Dear Egidio,
I hadn't thought of using that function and will give it a go. Many
thanks.
Miguel eg************* @gmail.com wrote: Miguel wrote: I have synchronized combo boxes linking Account Type with Customer Names based on the template that Microsoft has in one of its samples databases. There are the appropriate relationships between the Account Type Table and the Customer Name Table based on the ID field, so it is the ID field which is stored in the main table. However, in the form, the Account Type and Customer Name are displayed because the column width property has been changed to hide the other columns. But, when it comes time to create reports, it is the ID field that comes up whereas I need the text equivelent of the Account Type and Customer Name to be displayed. How do I replicate what is on seen on the form in a report. I suspect it would be done with a special query which would be the source for the report, but do not know what method to use to get text equivelent of each of the two fields.
Any assistance would be appreciated.
Miguel
Hi Miguel,
Have u already try to use the code DLookup? I think it will do what u need.
Miguel wrote: Dear Egidio,
I hadn't thought of using that function and will give it a go. Many thanks.
Miguel eg************* @gmail.com wrote: Miguel wrote: I have synchronized combo boxes linking Account Type with Customer Names based on the template that Microsoft has in one of its samples databases. There are the appropriate relationships between the Account Type Table and the Customer Name Table based on the ID field, so it is the ID field which is stored in the main table. However, in the form, the Account Type and Customer Name are displayed because the column width property has been changed to hide the other columns. But, when it comes time to create reports, it is the ID field that comes up whereas I need the text equivelent of the Account Type and Customer Name to be displayed. How do I replicate what is on seen on the form in a report. I suspect it would be done with a special query which would be the source for the report, but do not know what method to use to get text equivelent of each of the two fields.
Any assistance would be appreciated.
Miguel
Hi Miguel,
Have u already try to use the code DLookup? I think it will do what u need.
On a report you can also have a combo box to display the account type
text or the customer name instead of the id number. When it is
displayed in print the combo will not show up as a combo but will show
the text instead of the id. On the combo box make the combo have two
columns id and text, make the column size 0;3 for example so the text
appears and the id is hidden.
Cilla:
Many thanks for your suggestion. I apologize for not responding sooner,
but was on holiday. It worked beautifully and has solved all my
problems.
Kindest regards,
Miguel
Cilla wrote: Miguel wrote: Dear Egidio,
I hadn't thought of using that function and will give it a go. Many thanks.
Miguel eg************* @gmail.com wrote: Miguel wrote: > I have synchronized combo boxes linking Account Type with Customer > Names based on the template that Microsoft has in one of its samples > databases. There are the appropriate relationships between the Account > Type Table and the Customer Name Table based on the ID field, so it is > the ID field which is stored in the main table. However, in the form, > the Account Type and Customer Name are displayed because the column > width property has been changed to hide the other columns. But, when it > comes time to create reports, it is the ID field that comes up whereas > I need the text equivelent of the Account Type and Customer Name to be > displayed. How do I replicate what is on seen on the form in a report. > I suspect it would be done with a special query which would be the > source for the report, but do not know what method to use to get text > equivelent of each of the two fields. > > Any assistance would be appreciated. > > Miguel
Hi Miguel,
Have u already try to use the code DLookup? I think it will do what u need.
On a report you can also have a combo box to display the account type text or the customer name instead of the id number. When it is displayed in print the combo will not show up as a combo but will show the text instead of the id. On the combo box make the combo have two columns id and text, make the column size 0;3 for example so the text appears and the id is hidden. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: badboybrown |
last post by:
I know that this is an age old question and it has been approached a
few times, but I've hit a wall and require some help.
I have various combo boxes that contain values that are both "current"
and "not current". The problem is if you try to limit the drop down to
only the "current" values then your old records show a blank if the
field contains a "not current" value.
One of the solutions I have found is this:
|
by: Miguel |
last post by:
I have an order entry database with two forms. One is for new orders
the other is to update orders. The forms are identical except that one
is strictly order entry. On both forms are three sets of sychronized
combo boxes. When entering test data everything worked perfectly. I
recently migrated 5,000+ records from an Excel file to the database.
The migration was successful and all records were copied over. When I
checked the underlying...
|
by: ChristianC |
last post by:
I have a combo box that is pulling data out of table that I created with possible selections for the users of the database. I also have another table where the data is saved after the user has completed the form. My question is...I cannot restrict the users to the options I came up with in the table, so how do I set up the combo box so that users can either select from the existing list, or add an item and have it saved to the list for...
|
by: ddog |
last post by:
I have a form with 3 text fields (one of which is a zip code) and 5
combo boxes. The combo boxes are all set with the first value as
'selected' when the page is first displayed. The 3 text fields are
required and are by default empty. I need to validate that the text
fields have an entry and that the zip code is numeric and the correct
length. If the form fails validation - one of the text fields is empty,
for example - I need to alert...
|
by: Dave |
last post by:
I want to put the information that the user selects in my combo boxes
into a subform that lies on the same form as the combo boxes.
Thanks for your help already,
Dave
| |
by: Dave |
last post by:
Hello all,
First I'd like to apologize...This post was meant to be put in my
previous post, but I tried many times without success to reply within
my previous post. Now here goes...
I have a main form (RD Form) with 4 combo boxes (i.e. cbo1, cbo2, etc)
and a subdatasheet (the subform...let's call it subInfo) below the
combo
boxes on the RD Form. I hope this eliminates any confusion of the
|
by: BeaBea |
last post by:
Hi All,
I have been reading some of the threads in your forum and decided to join and post my question. Hopefully it won't be too lengthy.
I have created an Unbound Form called paramform2. This form contains two combo boxes, a text box for the start date, a text box for the end date and a command button that runs the report.
The first combo box is named FindMgr. The row source of this box is set to: SELECT"All" As MgrName FROM...
|
by: rhapsodysolutions |
last post by:
I have a form with 7 combo boxes to to search various fields in a table in Access 2007. I am trying to construct "dynamic" or conditional SQL for my subroutine, that would only use the values from selected comboboxes for the "where" criteria if a selection has been made, otherwise it will ignore the combo box.
For example if cmb1 is not selected, the where clause should look like:
select * from myTable where myField2= 'value of cmb2' and...
|
by: PuddinPie |
last post by:
Hello,
I’m kind of new to Access 97 so please bear with me.
I have a form with four combo boxes linked to a union query. It’s a start date, end date, User, and system
What I am trying to do is, by there selections in the combo boxes I want to use the query to populate a report with the matching information.
All the combo boxes are populating with the correct information I just need to know the proper VB coding for the submit button.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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?
| |