Bind forms to query or sql statement - Microsoft Access / VBA

deekay

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

Please advise

thanks

Nov 5 '06 #1

Subscribe Reply

3188

Larry Linson

"deekay" <de*****@gmail. comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

A query is simply a saved SQL statement. The Query Builder is just a visual
interface for creating SQL statements. So, there is no difference in
performance or function.

The difference would be, if you have a Query which you want to use as the
Record Source for a Form and a Report, and you will always want the same
changes in one as the other, it is more convenient to create a Query to use
as the RecordSource for both the Form and the Report. If you want the
RecordSource to be independent, and not subject to being inadvertently
changed, then using an SQL statement directly in the RecordSource or a
separate saved Query would be appropriate.

Larry Linson
Microsoft Access MVP

Nov 5 '06 #2

tina

another consideration is that saved queries are not protected when you
convert a frontend database to a .mde database for distribution to your
users. if you've implemented Access security, that's not an issue. but if
you have not, then using a SQL statement for each form and report
RecordSource ensures that your users cannot make changes to the
RecordSource.

hth
"deekay" <de*****@gmail. comwrote in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

Please advise

thanks

Nov 5 '06 #3

Similar topics

31391

MYSQL, PHP and Bind variables in SQL

by: Jack | last post by:

Hi All, What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g. select x from y where z=:parameter Which in asp/jsp would be followed by some statements to bind a value to :parameter I dont like the idea of making the SQL statement on the fly without binding parameters as I dont want a highly polluted SQL cache.

PHP

4674

Tuning an Application Statement with Bind Variables

by: Daniel Roy | last post by:

Hi gurus, I just started to look at a very slow-running SQL statement generated by an application (Siebel). I spooled the SQL from the application, replaced the bind variables by their values, and tuned from the Query Analyser. But after awhile, I realized that the statement using bind variables and the same statement using the values instead of the bind variables often have completely different execution plans! Is that normal? Can...

Microsoft SQL Server

2482

LDAP Active Directory Bind Stops Working

by: Marshall | last post by:

I appear to be having a problem similar to Neil as posted at http://msdn.microsoft.com/newsgroups/Default.aspx?query=directoryentry+intermittent&dg=&cat=en-us-msdn-dotnet&lang=en&cr=US&pt=&catlist=DEA2432D-EA76-4E5B-AF80-E56902048BAD%2C774F24A2-F71F-425F-AC2B-DC48AB0DA5C9&dglist=&ptlist=&exp=&sloc=en-us I thought my problem was solved when I changed the bind statement to use a specific username/password like: DirectoryEntry entry = new...

ASP.NET

1436

Bind multiple selections to a query

by: John Hoge | last post by:

I'm looking for that elusive .net time saving magic. I have an application that presents a list of items which the user can select from. A CheckBoxList works great for that, but I want to query a database based on their selections. I'm forced to dynamically building a SQL statement in a method I could have done easily in classic ASP: SELECT fields FROM tablename WHERE ID IN (value1,value2....)

ASP.NET

3519

Windows Forms No-Touch Deployment problems using DAO on User-Level Secured Access DB to access groups

by: James | last post by:

I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The objective in utilizing this new deployment method is to reduce the maintenance overhead as well as making it easier for my users to setup and run the application initially. I have VS 2002, Windows XP, Access XP(2000 format). He is my problem....

Visual Basic .NET

2740

dataset.getchange always flag true when bind to a custom controls

by: AH | last post by:

Hi all, I noticed this strange behavior; I created a new control (example inherits from textbox) and add a new property, then I bind this new property to a field in my dataTable in a dataSet. After the binding statement, when I check for dataset.getchanges ... it alway returns that there is changes (even the propety just set the value and get the same value to return)... I have tried to understand what has changed by using the...

Visual Basic .NET

2176

Optimizing SQL: bind variables, prepared stms, histograms

by: lnd | last post by:

A few question regarding PostgreSQL handling of queries: - Is each query submitted parsed and planned even if it is identical to a query submitted before? For example, 10 queries "select * from animals where id=:b1" with possibly different bind variable :b1 values will be fully processed (parsed and planned) 10 times? - does it make difference for postgreSQL performance if bind variables are used or not?

PostgreSQL Database

2550

Bind combobox to sql statement result in VB2005

by: guy | last post by:

I am able to use the Server Explorer to create a dataset containing tables in my database. I am able to bind a table to my combobox and set a filter by including a where clause. But I am unable to concat 2 columns as an addition column in the select statement without getting an error. It seems that I am restricted to use only the columns of the table. How do I bind a combobox to the resultset of a SQL statement? Furthermore, I need to...

Visual Basic .NET

5278

Re: bind variables with jdbc

by: Dave | last post by:

ilee@bigpond.net.au (Ivan) wrote in message news:<90137e1b.0403301523.55aed707@posting.google.com>... Ivan - I little more specific to the java syntax. Right now you are probably using an implementation of the Statement interface...for instance, Connection c = new Connection(.... Statement st = c.createStatement(); ResultSet rs = st.executeQuery('select xyz from table1 where a = 2 and

Oracle Database

8379

What is ONU?

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...

General

8709

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

8494

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

7309

AI Job Threat for Devs

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...

Career Advice

6162

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

4297

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2719

transfer the data from one system to another through ip address

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

C# / C Sharp

1924

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1597

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General