Hi -
I am developing a simple app, and just found a problem that I can't fix
after 4 hours of trying.
I display a list of customers, and the user chooses one and displays
"orders".
The frmOrders displays correctly, with the subform -
frmOrders_sfrmC ustInfo - on top that is correct. The subform displays
cust info - name, address, phone. Name is from a function that takes
the CustID and gets the name to display. The CustID field is hidden,
also uses a function to take the CustID off the initial form.
The Problem: When I choose "New Order" and open the "New Order" form,
the frmOrders_sfrmC ustInfo shows address, phone from record #1 on
tblCustomers, NOT the customer I am working with.
I tried to create a new frmOrders_sfrmC ustInfo and call it
frmNewOrder_sfr mCustInfo, but that didn't work. I thought I could
reuse the same subform, but I guess not.
My links are CustID and CustID, both fields exist. I have tried the
field name txtCustID as link and that doesn't work.
My subforms are based on tblCustomers. No selection or query.
I suppose I could hide all these data fields in the first List box and
refer to it from the subform, but I feel like that is not the simplest
route. Seems like the subform should Always work - don't understand
why it does in some places and not in others.
Thanks so much - I can post other details; not sure what is needed to
figure this out since there's no code. I'm so lost right now; just
don't know where to turn!
Sara
10  1726 
I don't know how You did your subform, but in making a subform into an
existing form when you click the subform wizard in the toolbox, the wizard
asks what fields do you want to connect. very easy, because even I managed
to do it... or else I misunderstood Your question...
-e-
"sara" <sa*******@yaho o.com> kirjoitti
viestissä:11*** *************** **@g43g2000cwa. googlegroups.co m... Hi -
I am developing a simple app, and just found a problem that I can't fix
after 4 hours of trying.
I display a list of customers, and the user chooses one and displays
"orders".
The frmOrders displays correctly, with the subform -
frmOrders_sfrmC ustInfo - on top that is correct. The subform displays
cust info - name, address, phone. Name is from a function that takes
the CustID and gets the name to display. The CustID field is hidden,
also uses a function to take the CustID off the initial form.
The Problem: When I choose "New Order" and open the "New Order" form,
the frmOrders_sfrmC ustInfo shows address, phone from record #1 on
tblCustomers, NOT the customer I am working with.
I tried to create a new frmOrders_sfrmC ustInfo and call it
frmNewOrder_sfr mCustInfo, but that didn't work. I thought I could
reuse the same subform, but I guess not.
My links are CustID and CustID, both fields exist. I have tried the
field name txtCustID as link and that doesn't work.
My subforms are based on tblCustomers. No selection or query.
I suppose I could hide all these data fields in the first List box and
refer to it from the subform, but I feel like that is not the simplest
route. Seems like the subform should Always work - don't understand
why it does in some places and not in others.
Thanks so much - I can post other details; not sure what is needed to
figure this out since there's no code. I'm so lost right now; just
don't know where to turn!
Sara
I did that and the fields connected are CustID on both the main form
and the subform. But still I'm not getting the same customer
information on the sub and main forms. THe main form has the customer
I want; the subform has the first customer on file.
Help!!
Thanks
Is there a relationship between the tables?
-elli-
"sara" <sa*******@yaho o.com> kirjoitti
viestissä:11*** *************** ****@g43g2000cw a.googlegroups. com... I did that and the fields connected are CustID on both the main form
and the subform. But still I'm not getting the same customer
information on the sub and main forms. THe main form has the customer
I want; the subform has the first customer on file.
Help!!
Thanks
Yes, one customerID (CustID) to many orders. CustID is on the order
table.
What does this tell us?
I have the custId hidden on both the main and the subform. Both show
the same custID - 26 in the current test.
BUT, you have me thinking here.....The form I'm having trouble on is
NEW ORDER. SO, I can see the info on all other forms (I think; I'm
checking that too), but I'm guessing on NewOrder it might have
something to do with the relationship? There actually isn't a record
on the Order table until the user enters data.
Your question brought me to this point, but if this is the issue, what
would I do about it? Pull the data from somewhere else?
I could probably figure out how to do that, like hide (select the
fields in the list box, but give them 0 width) them on the main form.
The main form is the one I use to get the CustId, which works fine. I
have 2 functions; 1 to get the custID from the main form and another to
use that custID and retrieve the customer name from the main form.
Your thoughts?
Thanks so much. I'm actually feeling a little better about this!
Sara
If you already have a form that shows users and orders and that works fine,
why not just add new order directly to that form?
Am I missing something?
-elli-
"sara" <sa*******@yaho o.com> kirjoitti
viestissä:11*** *************** ***@i39g2000cwa .googlegroups.c om... Yes, one customerID (CustID) to many orders. CustID is on the order
table.
What does this tell us?
I have the custId hidden on both the main and the subform. Both show
the same custID - 26 in the current test.
BUT, you have me thinking here.....The form I'm having trouble on is
NEW ORDER. SO, I can see the info on all other forms (I think; I'm
checking that too), but I'm guessing on NewOrder it might have
something to do with the relationship? There actually isn't a record
on the Order table until the user enters data.
Your question brought me to this point, but if this is the issue, what
would I do about it? Pull the data from somewhere else?
I could probably figure out how to do that, like hide (select the
fields in the list box, but give them 0 width) them on the main form.
The main form is the one I use to get the CustId, which works fine. I
have 2 functions; 1 to get the custID from the main form and another to
use that custID and retrieve the customer name from the main form.
Your thoughts?
Thanks so much. I'm actually feeling a little better about this!
Sara
For their a customer's first order, there would be no form that shows
their order.
This app is for a friend who has never used a computer. I have limited
development skills, so we're a match!
She is interested in learning, but it's hard when you run a business
basically by yourself. There is one guy who works part time with her,
and I hope he'll learn too.
SO, I've made it very simple - really for both of us. One thing on a
form, basically. You see all the customers (there are about 2000) and
then you can choose to see their garments, or their orders. If the
customer is new, you can add a customer. From garments, you can view, edit or add. Or, you can click a button
to go to orders. etc. Very simple. Also, I work full time so I can't
be there for my friend all the time, (and she doesn't have any internet
connection, so I can't dial into her machine to help her), so I wanted
something that is simple.
Long story, but that's the reason.
Your question from last night got me thinking and I fixed the problem
by putting all the data "hidden" on the main form. Works great now. I
am still interested in a better way to do it, if there is one, but am
Very happy it works!
Is there a better way?
Thanks
Sara
There is a better way, but it becomes a bit more difficult to do:
Place a combobox on the form to look up the customer and unbound text
boxes for the customer info and a listbox for the order information. In
the AfterUpdate event of the combobox, select the customer information
from the customer table and fill the textboxes with their relevant
information. You might want to put a textbox (visible=false) on the
form and then fill it with the primary key (or the value of the
combobox AfterUpdate) for the selected customer record for later use.
Select all the orders for the selected customer and populate the
listbox with this data.
It is really easier not to open a new form to enter new order data.
Just have a textbox where the new order number has to be entered and
then check if that order number has been used and fill the form with
that data if the order exsists. I have a sample db somewhere that
basically does the above mentioned, if you want to take a look at it.
Thanks, Helga, for the explanation. I'll try it, though it will
probably take me a while to figure it all out. A sample db would
probably help some, if it is available. How do you do that? Email it
to me? Not sure on the protocol here, as I'm a newbie.
Thanks
sara
I will send you a sample db. It was created quickley and some of the
form repaints don't work properly yet.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ken |
last post by:
Hi,
I have a MainForm and a SubForm. I also have a popup form that is
opened by a button click on the subform. On that form I want to set the
main form and subform.
to set mainform you do this:
dim f as form
f = forms("MainForm")
---this works
|
by: ken |
last post by:
Hi,
I have a MainForm and a SubForm. I also have a popup form that is
opened by a button click on the subform. On that form I want to set the
main form and subform.
to set mainform you do this:
dim f as form
set f = forms("MainForm")
---this works
|
by: authorking |
last post by:
I use the following code to insert a data record in to a datatable of an
access database.But every time I execute the command, there will rise an
exception and the insert operation can't be completed.
here's the code:
System.Data.OleDb.OleDbConnection hist_cnn = new
System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand hist_command = new
System.Data.OleDb.OleDbCommand();
|
by: meetmaruthi |
last post by:
Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password.
here is the coding and i get compile error:Method or data member not found.please help
Private Sub Command1_Click()
Set ch = ADODB.Recordset
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\sruniep\ssp\db\user.mdb;Mode=ReadWrite|Share Deny None;Persist Security...
|
by: Robert |
last post by:
I have a form with two subforms on it. Both subs have the same table as a
controlsource. SubformA is a continuous form that acts as an index. The
second subform displays a single record with all the fields from the table
that users can edit the records with.
When a user clicks on a record in subormA (via a transparent button), I want
that record to appear in subformB. Any suggestions?
Thanks Robert
| | |
by: lokidog |
last post by:
I am trying to automatically transfer data from one textbox to another between subforms within a 'main' form. I put this code into the Gotfocus eventprocedure:
Private Sub Date_GotFocus()
If Len(Trim$(Me!.Value & "")) = 0 Then
'This checks for blank or space-filled date field - it will only transfer data if it has not already been entered.
Me! = !!.!.!
SendKeys "{F2}"
SendKeys "{TAB}"
|
by: FNA access |
last post by:
I have a mainform that has a subform in the detail section and a subform in the footer section.(Both subforms are in datasheet view) When I click the navigation button to create a new record on the mainform. My subform in the detail section goes blank (this is what I want) but my subform in the footer section appears to have the data from the previous record displayed. When you click on the subform the data dissapears and displays blank. If...
|
by: 6afraidbecause789 |
last post by:
Kudos to anyone who can explain this one--how to duplicate a group of
continuous records in a subform for use in a new subform PK ID. The 2
entry fields (combo boxes) in the subform are RoleID and StaffID, and
the PK ID is StaffandIntsID. The subform's data is put into
jtblStaffandInts, which joins a Staff and Intervention tables:
So, here's what the data could look like in the table:
StaffandIntsID InterventionID StaffID RoleID
|
by: mseo |
last post by:
hi,
I have mainform with two cmdbuttons:
1- Save
2- Add Detail
the mainform has subform which is set to invisible, if I click Add Detail the subform appears, if not and user clicked Save the fields in the mainform will move to new blank record without having any details
what I need to do, when the user click save and the fields in the subform is not filled, In this case I need the save action (moving to next blank record) to be cancelled ...
|
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: 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: 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: 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: 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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
