473,387 Members | 1,517 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Passing data

6
I am using Access 2003. I have a simple OnClick() command button that does the following

Forms![Form2]![ProjectNumber] = Me![cboProjectNumber]

Why do I have to have Form2 open for this to work? is there something I can code in that will allow me to click the command button and the data from cboProjectNumber automatically copies to the ProjectNumber field in another table/form?
Feb 28 '07 #1
4 1181
vijaydiwakar
579 512MB
I am using Access 2003. I have a simple OnClick() command button that does the following

Forms![Form2]![ProjectNumber] = Me![cboProjectNumber]

Why do I have to have Form2 open for this to work? is there something I can code in that will allow me to click the command button and the data from cboProjectNumber automatically copies to the ProjectNumber field in another table/form?
explain it in detail with thy front endand backend
Feb 28 '07 #2
bronen
6
I have a form1 and form2.

Form1 contains two unbound textboxes "ProjectNumber" and "ProjectName"
Form2 contains two textboxes "ProjectNo" and "ProjName" that are tied to a table.

I have a button on Form1 that after the data is typed in and you click the button. What I want is the data that was typed in Form1 gets "sent" to the corresponding fields in Form2. How can I do that efficiently WITHOUT opening Form2? Or can it be sent from Form1 to a table? I need specific code..i'm a newbie.
Feb 28 '07 #3
vijaydiwakar
579 512MB
I have a form1 and form2.

Form1 contains two unbound textboxes "ProjectNumber" and "ProjectName"
Form2 contains two textboxes "ProjectNo" and "ProjName" that are tied to a table.

I have a button on Form1 that after the data is typed in and you click the button. What I want is the data that was typed in Form1 gets "sent" to the corresponding fields in Form2. How can I do that efficiently WITHOUT opening Form2? Or can it be sent from Form1 to a table? I need specific code..i'm a newbie.
see u can achive this task by storing data from form1 to any array and then at the load of second form collect all data from that array.
or u can create a file from form1 and open it in the load of second
see u can directly give values to other form also don'e use show method for socond form the form will be get loaded in the memory then hide it
Feb 28 '07 #4
Killer42
8,435 Expert 8TB
I have a form1 and form2.

Form1 contains two unbound textboxes "ProjectNumber" and "ProjectName"
Form2 contains two textboxes "ProjectNo" and "ProjName" that are tied to a table.

I have a button on Form1 that after the data is typed in and you click the button. What I want is the data that was typed in Form1 gets "sent" to the corresponding fields in Form2. How can I do that efficiently WITHOUT opening Form2?
I don't understand - what do you expect to happen, if form2 is not open? If the form isn't open, the controls on it effectively don't exist, so how can you put anything in them?
Feb 28 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Alex Vinokur | last post by:
Various forms of argument passing ================================= C/C++ Performance Tests ======================= Using C/C++ Program Perfometer...
58
by: jr | last post by:
Sorry for this very dumb question, but I've clearly got a long way to go! Can someone please help me pass an array into a function. Here's a starting point. void TheMainFunc() { // Body of...
3
by: Simon Harvey | last post by:
Hi, In my application I get lots of different sorts of information from databases. As such, a lot of information is stored in DataSets and DataTable objects. Up until now, I have been passing...
9
by: Just Me | last post by:
PARAFORMAT2 is a structure that SendMessage will return stuff in. Is the "ref" correct or since only a pointer is being passed should it be by value? Suppose I was passing data rather then...
3
by: Marc Castrechini | last post by:
First off this is a great reference for passing data between the Data Access and Business Layers:...
22
by: Arne | last post by:
How do I pass a dataset to a webservices? I need to submit a shoppingcart from a pocket PC to a webservice. What is the right datatype? II have tried dataset as a datatype, but I can't get it to...
12
by: Andrew Bullock | last post by:
Hi, I have two classes, A and B, B takes an A as an argument in its constructor: A a1 = new A(); B b = new B(a1);
7
by: TS | last post by:
I was under the assumption that if you pass an object as a param to a method and inside that method this object is changed, the object will stay changed when returned from the method because the...
3
by: DaTurk | last post by:
If I call this method, and pass it a byte by ref, and initialize another byte array, set the original equal to it, and then null the reference, why is the original byte array not null as well? I...
3
by: iu2 | last post by:
Hi all, I need your professional opinion about this. It is more a general programming dilemma rather then a C++ one, but since the project I write is in C++... We handle big structs of data....
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
0
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...
0
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,...
0
jinu1996
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...

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.