BEWARE beginner questions!!
I have some experience in Access but never as much as I want or need. I have
decided to get in on VB.Net. I would only
rate myself in Access as a Beginner/Intermediate VBA programmer. I have
decided to go at learning VB.Net in a
more organized manner. I have some questions where answers are not becoming
clear with VB.Net. So here goes.
1 All of the books I have accessed do basic one-two form examples utilizing
one or two basic tables. I have used
Dobson's book and created two datagrids on the same form using the
Relationship wizard. What I can't see and
I am wondering about is what code uses the Primary/Foreign key and ties the
two datagrids together. I have a major Access database that combines
multiple tables that have relationships. But I probably will be using
combinations of individual textboxes and datagrid to display the data on one
or more forms. I need to know how to keep all data synched.
2. I am assuming that a data connector and data adapter is needed for each
table or query that is used on the form. Correct?
3. What is the standard for program development in relationship to
resolution? Are most people developing for 800 x 600 or 1024 x 764 when the
ultimate end-user is unknown?
4. One thing I have never figured out is how to size/auto resize a form. How
do I work with the answer to #3 and allow the form still be displayed
properly in the other resolution?
Thank you for any and all answers.
Fay 2 2979
"Hi Fay
Programming is not like access filling in a table and do what someone has
decided for you.
You can do it mostly anyway you want, therefore most of your questions are a
little bit subjective for a programmer, and I gues you get a lot of
different answers. Not because they are wrong in contrary they will be
mostly right. 1 All of the books I have accessed do basic one-two form examples
utilizing one or two basic tables. I have used Dobson's book and created two datagrids on the same form using the Relationship wizard. What I can't see and I am wondering about is what code uses the Primary/Foreign key and ties
the two datagrids together. I have a major Access database that combines multiple tables that have relationships. But I probably will be using combinations of individual textboxes and datagrid to display the data on
one or more forms. I need to know how to keep all data synched.
Have a look at databinding, datasource and currencymanager
2. I am assuming that a data connector and data adapter is needed for each table or query that is used on the form. Correct?
I think that when you talking about the data adapter you are talking about
the drag and drop dataAdapter. It is very simple to use, but soon you will
see the disadvantages of it.
After a while you while probably do it in code and after a while than again
you will also see that it is much easier, have a look in code for (Oleddb or
SQL everytime before it) Connection, Command, Adapter, Commandbuilder.
3. What is the standard for program development in relationship to resolution? Are most people developing for 800 x 600 or 1024 x 764 when
the ultimate end-user is unknown?
This will of course be important where you live. I asume that in the rich
countries larger screens are used than in the other ones.
4. One thing I have never figured out is how to size/auto resize a form.
How do I work with the answer to #3 and allow the form still be displayed properly in the other resolution?
Have a look for that at "dock" and "Anchor"
I hope this helps something?
Cor
Yes Cor this does help. Thank you.
Fay
"Cor" <no*@non.com> wrote in message
news:O$******** ******@TK2MSFTN GP12.phx.gbl... "Hi Fay
Programming is not like access filling in a table and do what someone has decided for you.
You can do it mostly anyway you want, therefore most of your questions are
a little bit subjective for a programmer, and I gues you get a lot of different answers. Not because they are wrong in contrary they will be mostly right.
1 All of the books I have accessed do basic one-two form examples utilizing one or two basic tables. I have used Dobson's book and created two datagrids on the same form using the Relationship wizard. What I can't see and I am wondering about is what code uses the Primary/Foreign key and ties the two datagrids together. I have a major Access database that combines multiple tables that have relationships. But I probably will be using combinations of individual textboxes and datagrid to display the data on one or more forms. I need to know how to keep all data synched.
Have a look at databinding, datasource and currencymanager
2. I am assuming that a data connector and data adapter is needed for
each table or query that is used on the form. Correct?
I think that when you talking about the data adapter you are talking about the drag and drop dataAdapter. It is very simple to use, but soon you will see the disadvantages of it. After a while you while probably do it in code and after a while than
again you will also see that it is much easier, have a look in code for (Oleddb
or SQL everytime before it) Connection, Command, Adapter, Commandbuilder.
3. What is the standard for program development in relationship to resolution? Are most people developing for 800 x 600 or 1024 x 764 when the ultimate end-user is unknown?
This will of course be important where you live. I asume that in the rich countries larger screens are used than in the other ones.
4. One thing I have never figured out is how to size/auto resize a form. How do I work with the answer to #3 and allow the form still be displayed properly in the other resolution?
Have a look for that at "dock" and "Anchor"
I hope this helps something?
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: AK |
last post by:
I don't want any part of the previous discussion on Visual Basic
versus Visual Basic.Net.
My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard
for studying VBA.
I use Office 2000 and would like to use VBA as a tool to customize it.
I have zero programming experience.
I would like to read through and work on the examples of a beginners
|
by: Orange Free |
last post by:
I want to create a program that will ask a user a series of questions
and then generate a Microsoft Word document whose content is dictated
by the answers. I am not a professional programmer, and I understand
only a little about OO programming. Should I
a) stick to -- *gasp* -- Visual Basic to accomplish my goal;
b) use Python, with which I am somewhat familiar, and which I would
prefer to use; or
|
by: Michael Foord |
last post by:
#!/usr/bin/python -u
# 15-09-04
# v1.0.0
# auth_example.py
# A simple script manually demonstrating basic authentication.
# Copyright Michael Foord
# Free to use, modify and relicense.
# No warranty express or implied for the accuracy, fitness to purpose
|
by: Steven O. |
last post by:
First, this may not be the correct newsgroup. I have some relatively
basic questions on SQL. I tried to find a newsgroup that was
specifically just about SQL, and was surprised to find that all the
SQL-related newsgroups seem to be product related. But if I missed
something, and someone can steer me to a correct newsgroup, please do
so.
My specific questions:
1. I want to put comments in an SQL script. For example, I want
|
by: Ramesh |
last post by:
hi,
Let me ask some basic questions.
Can anybody explain me about the following questions:
1. When we have to create sn key? Whenever we compiled
Component we have to create or it is a one time process?
2. What information contained in sn key. I gone through
that it is having public key. How it is using this key to
intract with client.
3. When we have to run gacutil.exe file. Whenever we
| |
by: Jim H |
last post by:
If there is a site someone can point me to that answers such basic
questions, rather than taking up support's time posting answers, please let
me know.
I've developed C# .NET, unmanaged C++, and MFC applications. I have not
written any C++.NET apps yet and have some very basic questions.
Are managed C++ programs fully independent executables or are they still
processed at run time like C# and vb.net apps are? Is the finished product...
|
by: software2006 |
last post by:
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers
in my website
http://www.geocities.com/myinterviewquestions/ASPAndVisualBasic.htm
So please have a look and make use of it.
|
by: Goran Djuranovic |
last post by:
Hi all,
I am experiencing a strange thing happening with a "designer.vb" page. Controls I manually declare in this page are automatically deleted after I drop another control on a ".aspx" page.
- Why is this happening?
- Can I disable automatic declaration and have everything be declared manually?
- Any other options to fix this?
Thanks in advance.
Goran Djuranovic
|
by: LayneMitch via WebmasterKB.com |
last post by:
Hello.
This is a basic quiz. Only about 3 questions. I'm having issue with the
answer key which stays on a certain value regardless of acknowledging that
you have the correct answer for the first and moving on to the next answer.
Here's the code:
<html><head><title>Problem7</title>
|
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: 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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |