473,890 Members | 5,876 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can't get information to display in a lable control on one form from another.

When I add the name of a new individual in a, bound form, it will not
display that person’s name in a label control of a second unbound form.

I have a scheduling program that I am working on. Included in the
application program is a data “GRID” which I believe was created using
Visual Basic, not standard Access. Its purpose is to display the
results of a range of “from-to-dates” of registrations for different
clients. The difficulty that I am having is in displaying new
registrant names in a display label of a second form when it’s GRID is
immediately accessed via a command button after a registration is
completed. The display label works just fine for existing entries that
came with the data GRID module that I previously purchased. It’s just
when I try to add NEW entries that the label control will not
work/refresh. However, other than the names of new entries not
appearing in the label control, the range of start to end-date for these
entries, created in the first form, does display in the GRID of the
second form as it should.

The following is a description of how everything is supposed to work:

I have three forms; two with tables and one (unbound) display form with
a data Grid that graphically start to end-date in a bar graphic:

1. Form: frmGuest (label name: fsubGuest)
Table: tblGuest
Field: GuestID (label name: cboGuestID) which holds the registered
name

This form is used to create individual records/accounts for future
registrations and the
listing of past Registrations.
2. Form: frmStatus
Table: tblstatus

Form is used to create registration schedules for individuals pulled
from the above form, “frmGuest” and table, “tblGuest”. You normally
would select a name from a combo box on this, “frmStatus”, form along
with selecting the appropriate start and end-dates.

This form contains a command button for accessing the data Grid for
viewing results of the date range for an appointment just created. .

When you press the command button, you are immediately taken to the
scheduling data Grid (frmMain).

Whatever name you had selected before pressing the command button,
above, should now appear in the, label control, “lblCurrStat” on the,
“frmMain form below along with the graphically depicted corresponding
date range in the Grid in the form of a bar graph.

3. Form: frmMain
Table: unbound

Form is used to graphically display the registrant’s start to end-date,
just made from the form, “frmStatus”, in frmMain form and the data GRID.

The form, “frmMain” contains the label control, “lblCurrStat” that
displays the name of an individual selected in the, “frmStatus” form
along with a couple of other pieces of information corresponding with
the bar graph.

Again, all the above will work, except ONLY WITH EXISTING registrations,
but not new ones. When you add the name of a new individual in the form
(along with a couple of pieces of information), “frmGuest” and table,
“tblGuest” described above, it will not display that person’s name in
the label control, “lblCurrStat” located on the, “frmMain” form.
However, the date range for the registration does show up in the data
GRID of the same form.

Here is a portion of the Module, "basGrid" that I use to reference the
label control, "lblCurrSta t" located on the, “frmMain” Grid form that is
supposed to refresh the registrants name and other information:

With frmS

frmM!lblCurrSta t.Caption = !cboGuestID.Col umn(1) & vbCrLf & _
!cboUnitID & vbCrLf & _
!cboStatusType. Column(1)
End With
ExitLine:
Exit Sub
End Sub

To show that it “should” work; all I have to do is change the
“Column(1)” number. The information in the, “lblCurrStat”la bel control
on the, “frmMain” form will change as a result, but only on old entries.


*** Sent via Developersdex http://www.developersdex.com ***
May 2 '06 #1
1 2626
"John Phelan-Cummings" <jp*********@ho tmail.com> wrote
When I add the name of a new individual
in a, bound form, it will not display that
person's name in a label control of a
second unbound form.
Why _should_ it? What you describe is not a feature or function of Access --
it is something that would have to be accomplished by programming. So the
question would be: _what_, if anything, have you implemented to make the
name be automatically displayed on another form.
I have a scheduling program that I am working
on. Included in the application program is a data
"GRID" which I believe was created using
Visual Basic, not standard Access. Its purpose is
to display the results of a range of "from-to-dates"
of registrations for different clients. The difficulty
that I am having is in displaying new registrant names
in a display label of a second form when it's GRID
is immediately accessed via a command button after
a registration is completed. The display label works
just fine for existing entries that came with the data
GRID module that I previously purchased. It's just
when I try to add NEW entries that the label control
will not work/refresh. However, other than the
names of new entries not appearing in the label control,
the range of start to end-date for these entries, created
in the first form, does display in the GRID of the
second form as it should.


Now, as I understand it, you have obtained/purchased/licensed a third-party
product, a grid, intended for VB and are using it in Access? And, it is
that third-party product (ActiveX control?) that isn't working as you expect
it to?

There are many grids available, most of them intended for use with VB, or
C++, or Delphi, or some other languages; most of them are also untested with
Access, and whether they will or will not work is just a "hit or miss"
proposition. If you don't state the name of the third-party product (grid),
your chances of finding someone who has happened to have tried it with
Access are near zero. If you do, you may not have much luck, because Access
has datasheet view, and continuous forms view, which have most of the
functionality of many "grids", and because they are parts of Access, and
thus not-extra-cost, are used by most Access developers.

My suggestion is that you likely need to take your question to the author /
vendor of the third-party product, if (as I infer) it is the third-party
product that has the problem.

Larry Linson
Microsoft Access MVP

May 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
7067
by: deko | last post by:
I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm, "frmReportOptions" <== popup form This is the error I get when I try to move to the last page of the report *after* closing the popup: "This expression is typed incorectly, or is too complex to be evaluate...."
12
10180
by: VB Programmer | last post by:
I know some sites will display the following message if you click on the BACK button in your browser. How do I implement this feature? Warning: Page has Expired The page you requested was created using information you submitted in a form. This page is no longer available. As a security precaution, Internet Explorer does not automatically resubmit your information for you. To resubmit your information and view this Web page, click the...
1
1253
by: Bob H | last post by:
Hi, I've a data repeater on a form that gets populated from an SP. In the repeater, I've a ItemTemplate row that outputs the field... <td colspan="1"> <%# DataBinder.Eval(Container.DataItem, "FieldValue")%> </td> ....Is there anyway to check the values in this Repeater field as it gets
0
2088
by: Brian Henry | last post by:
I thought this was useful, its a extender i just wrote for the new .NET menu strip and status strip to extend the menu items to add a status message so when a mouse rolls over the item it displays the text on the status strip lable specified for the extender.. all you have to do is copy this to a code file, and add it as a control to your form. set the status lable property of the extender control then set the status mesages of the menu...
4
1306
by: D | last post by:
Hi I'm obviously still learning here but what I've created is a page with a calendar and button. When I click the button I do a number of tasks and would like to output the progress in messages such as Starting TaskA Processing TaskA Completed TaskA
8
5381
by: =?Utf-8?B?R3JlZyBMYXJzZW4=?= | last post by:
I'm trying to figure out how to modify a panel (panel1) from a backgroundworker thread. But can't get the panel to show the new controls added by the backgroundwork task. Here is my code. In this code there is a panel panel1, that I populate with a lable in the foreground. Then when I click on "button1" a backgroundworker thread in async mode is started. When the backgoundworker thread completes the thread returns a panel to populate...
5
3488
by: iKiLL | last post by:
Hi All, I am trying to Bulid Windows Mobile Forms Control with C# in VS2005 using CF2. On this control A lable is created and some text set for the control. My problem is that i dont know how lond the text is going to be. so i need to set the height and width of the label a cording to the data. un fortunatly i have not been able to find a simple Auto Resize property
3
2509
by: Ryan Liu | last post by:
Hi, I have a big urgent problem to solve. I used to use Windows 2000 Chinese version, now I installed Windows XP (English) system. The problem is not about 2000 or XP, it is about English and Chinese. All forms of my compiled C# desktop application, as well as in Visual Studio
3
3820
by: =?Utf-8?B?UmljaA==?= | last post by:
I placed an empty label control on a form. I could drag the mouse across the form in design view to locate the lbl. But I have since moved a few controls on the form around, and now I cannot locate this label control. Is there a way to select the label in the design view besides dragging the mouse? Thanks, Rich
0
9979
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, 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...
0
9823
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,...
0
11234
Oralloy
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...
1
10924
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,...
0
9637
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, 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...
1
8017
isladogs
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...
0
5854
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...
0
6049
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4681
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 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.