I have an app with a Front End and a Back-End. My date field is
INV_DATE
I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.
How can I do this via VBA ?
Rgds,
Prakash. 2 11064
On Jul 31, 6:32 am, prakashwadhw... @gmail.com wrote:
I have an app with a Front End and a Back-End. My date field is
INV_DATE
I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.
How can I do this via VBA ?
Rgds,
Prakash.
Are your FrontEnd and BackEnd linked to each other? Otherwise you have
to use a reference (filename and location) to one.
Dim dbsCurrent As Database, dbsContacts As Database
Set dbsCurrent = CurrentDb
Set dbsContacts = DBEngine.Worksp aces(0).OpenDat abase("C:
\Contacts.mdb")
>From here you may do as you please.
<pr************ *@gmail.comwrot e in message
news:11******** **************@ o61g2000hsh.goo glegroups.com.. .
>I have an app with a Front End and a Back-End. My date field is
INV_DATE
I would like to copy all data with year(inv_date) 2005 to a temp
table in both, the front end & the back end.
How can I do this via VBA ?
You might take a look at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm for a method which creates a
temporary database in which to create the temporary table. When you are
done with it, you can unlink, and delete it -- and not have to worry over
time about it bloating and having to be compacted and repaired.
I'm wondering why you might need a temporary table in the back end _and_ the
front end. Perhaps if you'd tell us what you are trying to accomplish,
instead of the way you think you might accomplish it, someone could offer
useful suggestions.
If you use Tony's technique, you'll link both the table in the "temporary
back end database" and the table in the "temporary front end database."
Larry Linson
Microsoft Access MVP This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: dev |
last post by:
how create a temp table as a copy of a existing table and then update1 field
and insert the hole temp table back in the existing table?
please any help?
if i have 10 fields in 1 record and about 100 records and a field.status=1
in a existing_table and
i want to create a temp_table with all the recordse and values of the
existing_table ...
|
by: Galina |
last post by:
Hello
I am going to copy a data from MS Access table into Oracle table. One
of fields is memo type and data in this field range from 1 character
to 551 long string. Do I need to create a field type LONG in the
Oracle table to accommodate this data? If not, what field type would
suit best?
Any help will be greatly appreciated.
Thank you....
|
by: Sergio |
last post by:
Hi all!
I have a problem with a temp table.
I start creating my table:
bdsqlado.execute ("CREATE TABLE #MyTable ...")
There is no error. The sql string has been tested and when it's
executed in the sql query analyzer it really creates the table.
After creating the table, I execute an insert statement:
|
by: Liya |
last post by:
I'm trying to create a temp table in the stored procedure.
the syntex is the following:
create st_proc
variables declared
if something >0
create temp table #Table1
|
by: Wiggy |
last post by:
Hi,
It's probably easiest if I describe what I'm trying to do:
I have several tables I want to base a query on. In addition I have
some dynamic data that I want to join against that consists of several
records of information.
I could just create a temp table of the dynamic data and join it
against my tables, but I thought there was a...
| |
by: Donna Sabol |
last post by:
First, I should start by saying I am creating a database to be used by
some very impatient, non-computer literate people. It needs to be
seameless in it's operation from their point of view. I want them to
do as little as possible when they run their reports.
I have a crosstab query that displays usage of items for each month.
It looks...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and...
|
by: M Bourgon |
last post by:
I have two SPs, call them Daily and Weekly. Weekly will always call
Daily, but Daily can run on its own. I currently use a global temp
table because certain things I do with it won't work with a local temp
table or table variable.
I have been trying to get code so that if the table already exists, it
just keeps going and uses it, but...
|
by: Krustov |
last post by:
The question of how to create thumbnails with clickable links gets asked
on this newsgroup every so often - like clock work .
Just really posing this script here for google to archive it & so users
can be pointed to it in the future via a link to google groups .
<html>
<head>
|
by: lenygold via DBMonster.com |
last post by:
Hi everybody!
I have a UDF. It is working fine.
But when i try apply the same UDF to a view it is not working.
CREATE VIEW SSN_SORTED AS
WITH TEMP(EMP#,SOCSEC#,JOB_FTN,DEPT,SALARY,DATE_BN,FST_NAME,LST_NAME) AS
(SELECT MAX(EMP#),MAX(SOCSEC#),MAX(JOB_FTN),MAX(DEPT),MAX(SALARY),MAX(DATE_BN)
,MAX(FST_NAME),MAX(LST_NAME)
FROM PERSONNEL
GROUP BY...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |