473,890 Members | 1,429 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to take input to our application

30 New Member
hello.......... ..

i am developing access application

in that my application should take input database for every operation..

how to implement this

the method should be user friendly.....

i dont want to use inbuilt import database method of access

for ex:

i have access application . in that i have written queries and vba which extracts data needed from input database,.....

after extraction from input database(access table) data is calculted and reports are generated....

but for every operation input table is different . how can my application access external database table....

how should i implement this.
what technique i should use so that my application will be able to use different database table for every time.
how to design this proble .

gus please help me i am in urgent need
Aug 27 '12 #1
6 19391
2,322 Recognized Expert Moderator Top Contributor
I can't make clear from your question whether your application just reads different tables in the SAME database, or different tables in different database files.

Is this A)
Read table1 from Database1
Read table2 from Database1
Read table3 from Database1
Read table4 from Database1

or is this B)
Read table1 from Database1
Read table1 from Database2
Read table1 from Database3
Read table1 from Database4

or C)

Read TableX from Database1
Read TableY from Database2
Read TableX from Database3
Aug 27 '12 #2
prasad joshi
30 New Member
third case that is c)

plese help me urgently
Aug 27 '12 #3
2,322 Recognized Expert Moderator Top Contributor
Of course you just had to choose the most complicated one! :)

Do you in advance know the location of the database files as well as the table names?

Or does the user need to be able to select both files and tables "on the fly"? If so we are really approaching trying to build something that the access interface allready has (the import wizard)
Aug 27 '12 #4
prasad joshi
30 New Member
yes user know location and name...

please tell me
Aug 27 '12 #5
2,322 Recognized Expert Moderator Top Contributor
I would use VBA to ask the user for the database path (Use a filedialog) and then promt them for the table name.

You can then (by vba) write a query and execute from VBA, or store the query as a QueryDef and then execute it.

The syntax would be something like:
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM [Table Name] IN 'C:\TestFolder\testDatabase.mdb' INTO [Temporary Table Name]
You could as said, parse the query string together using vba and then execute it. I can't really provide you with more details, because you information you have have provided is very vague and general.
Aug 27 '12 #6
5,501 Recognized Expert Moderator Expert

TheSmileyCoder has provided you with a course of action that you can build on to solve the question asked.

Please make an attempt and post back your code.

Aug 27 '12 #7

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

Similar topics

by: wildchild | last post by:
Hi, I am new to grpahics progamming in/under Borland C. I have included the "graphics.h" header file but i am unable to take input on the screen. if i try to move my cursor to a specified position using gotoxy() function the pointer doesnt moves to the specified location and starts taking input at (1,1) coordiante. Plz help! Thankyou!
by: ashton | last post by:
Hello, this is been frustrating me all morning. Any help would greatly be appreciated I have a site (not my own, not done in asp.net) that will be posting data to my c# page. There is an input type=file in that form. How do I get the value? All the examples I see online tell you to set your form up as runat=server but tha won't work in this case since I won't be dealing directly with the form, just the returned data. This is what I...
by: Koji | last post by:
Ok. So, I don't know which class from javax.swing to use for this. I think it's JTextField, but anyway... I'm looking for a class that allows the user to type in, in this case, integer or double values, which I'll be able to take as a string, change to type I need, then perform operations with them. Example: 3 text fields. Miles, Gallons, and MPG. If the user puts in info for Miles, and Gallons, I should be able to take the user input, do...
by: j.smith2c | last post by:
Hi everyone, I wanted to run the following loop, and enter y everytime (I expected that it will ask me to enter y for 5 time), but just after 3 times program terminates. what is the error?? #include <stdio.h>
by: YogeshBhattarai | last post by:
if any one knows about it please guide me
by: gskbond | last post by:
#include<iostream> using namespace std; template <class T, int mway> struct BNode { int noofKeys; T keys; BNode<T, mway> *pointer; BNode();
by: Rabiya | last post by:
hi, i want to have the perl script that can take input from any text file. i have the one bt its not doing the required job
by: David Aghan | last post by:
Ok, so I am almost done with this question: Write and test a function to take as input a list of strings (each of which represents a number) and to return a list of numeric values. For example, if the input to the function is and return . The input should be as a parameter to the function. here is the code I have written: def func( num1, *numtuple): print num1 for num in numtuple:
by: Hataf | last post by:
I want to take input using urdu language in html form.So please help me.
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: 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: 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...
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...

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.