Can one set limits on html imported records in Access 97? For example,
would like to prohibit importing records or a group of records whose
ReferenceID number is not within an acceptable number range. Can this
be done by modifying the wizard code. If so, where and how?
A second, less desirable option, would be an OnOpen form message that
states there are recent records imported that are not within the
acceptable range and must be deleted in order to open the form. How
could the out-of-range records be identified as to inform the user
which ones require attention?
Any code tidbits would also be appreciated. Thanks, Rolan 2 1512 co******@safe-mail.net (Rolan) wrote in message news:<52******* *************** ****@posting.go ogle.com>... Can one set limits on html imported records in Access 97? For example, would like to prohibit importing records or a group of records whose ReferenceID number is not within an acceptable number range. Can this be done by modifying the wizard code. If so, where and how?
A second, less desirable option, would be an OnOpen form message that states there are recent records imported that are not within the acceptable range and must be deleted in order to open the form. How could the out-of-range records be identified as to inform the user which ones require attention?
Any code tidbits would also be appreciated. Thanks, Rolan
If you don't know VBA, I would recommend importing the data to a
temporary table with the same structure as the final table. Then you
can write a query to filter out whatever records you want to exclude.
Just use a parameter query that prompts you for the acceptable range
(if it changes) or hard code it. Then once you've imported all the
records, delete the data from the temp table. co******@safe-mail.net (Rolan) wrote in message news:<52******* *************** ****@posting.go ogle.com>... Can one set limits on html imported records in Access 97? For example, would like to prohibit importing records or a group of records whose ReferenceID number is not within an acceptable number range. Can this be done by modifying the wizard code. If so, where and how?
A second, less desirable option, would be an OnOpen form message that states there are recent records imported that are not within the acceptable range and must be deleted in order to open the form. How could the out-of-range records be identified as to inform the user which ones require attention?
Any code tidbits would also be appreciated. Thanks, Rolan
Would have sworn I answered this before, but maybe it hit the bit
bucket.
Don't think you can do that with a wizard. You could open the file as
a linked table and then query out the records you don't want. then
turn that select query into an append qury and you're done. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JohnH |
last post by:
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit. I've tried increasing
both the command timout (I'm using an ADO...
|
by: ccr |
last post by:
Please view in a text editor so that the columnar text lines up. I
used Terminal 9pt font to compose this post and copied/pasted to my
newsreader program.
I am writing in the hope that one of you Visual Basic experts may
provide a solution, or at least some insight, to the problem described
below. I am not a programmer, but am fairly knowledgeable about
computers. If necessary, I could flowchart a process to do what needs
to be done....
|
by: ccr |
last post by:
Reposted with a longer line length. Apologies if I did not cancel the 1st attempt before you got
it.
If necessary, please view in a text editor so the columnar text lines up. I used Terminal 9pt font
to compose this post and copied/pasted to my newsreader program.
I am writing in the hope that one of you Visual Basic experts may provide a solution, or at least
some insight, to the problem described below. I am not a programmer, but...
|
by: deko |
last post by:
Is there any way to limit the number of records loaded into a ListBox?
I looked at qdf.MaxRecords (to apply to the query that is the RowSource of
the ListBox) but that only applies to ODBC data sources. I also looked at
Tools > Options > Edit/Find and tried setting the "Don't display lists where
more than this number of records read:" property, but that doesn't help.
The List Box in question is supposed to allow scrolling/browsing of...
|
by: Jim Archer |
last post by:
Hi All...
I'm been fighting this problem for a few days now, and it seems like it
should be simple. But the solution has eluded me so far...
I need to flag a record when it is updated or when it is a new insert.
Then I SELECT for the changed records and do something not related to
Postgres. Easy enough, I created a trigger procedure and fired it on
INSERT OR UPDATE and modify NEW to set the flag field to true.
| |
by: Montana_Trader |
last post by:
I have a product database that includes a memo field for product
descriptions. That database must be imported into a legacy system that
has four text fields for product descriptions, each with a 250
character field length.
So, I am looking for a way to write a query or script that will pick up
the first 250 characters of the memo field and insert them into the
first field of my query, the second 250 characters into the second
field of...
|
by: aaron.reese |
last post by:
Guys,
this is my problem:-
I have records which are linked by two fields on a left inner join
(there may be 0,1 or more records in the right hand table)
The relationship is not unique (it's a map reference so it can't be...)
so I am getting a cartesian join on the right hand table - look, it's
not my database OK, I don't have any choice!!!
|
by: markon |
last post by:
Hi,
I would like to run few lines of code and limit the time. If the
procedure would not be finished say in 1000ms I would like to stop
processing it.
Unfortunately I do not know where to begin to find resources how to do
it.
Thanks
|
by: bobh |
last post by:
HI,
I understand AccessXP file size has a 2 gig limit but I trying to
understand the following
I have a tab delimited data file that is 1.3 gigs big and I try to
import it into an empty AccessXP database and it starts to import then
stops, I look at the database size and it shows 1.99 gigs.
AccessXP blots to almost twice the size of the import file??? is that
|
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: 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: 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: 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...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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.
| |