I've imported a txt list into Access which has some rows that look
like:
0000 0100 CH Saze National Msr 1 M CH 4460b 4750x 4800q 5945b
6030b 6125s 7275b 7290b
9500s 9630q 9675b 9845b
0025 0130 SG Niskale V BNN 11720s 11750s
11760s 11925L
11960b 12045b 13610n
13700L 15550b
Now I'm wondering whether would be possible to automatically update the
rows which has some blank fields with its appropriate information
(that's the same stuff as in the first and fourth row).
Of course, most of the rows has all the fields properly filled up, it's
just too cumbersome and time consuming to fill the blanks by hand.
Thank you in advance for your aid! 4 2264
I can't tell if the data is just a string of text or whether it is separated
into fields in a table, but I'll assume the latter. In your example, it
looks like you either have all the fields or just the last field. Is this
always the case? If it is, then you can run an update query. Select field1
and field4 (or whatever the last field is called) in the query builder.
Under field4, set the criteria to "is null" (no quotes) and set the update
to box to [field1] (with brackets). Under field1, set the "update to" box
to "null", (no quotes).
"Sommerfiel d" <co*********@ya hoo.com> wrote in message
news:11******** **************@ g49g2000cwa.goo glegroups.com.. . I've imported a txt list into Access which has some rows that look like:
0000 0100 CH Saze National Msr 1 M CH 4460b 4750x 4800q 5945b
6030b 6125s 7275b 7290b
9500s 9630q 9675b 9845b 0025 0130 SG Niskale V BNN 11720s 11750s 11760s 11925L
11960b 12045b 13610n
13700L 15550b
Now I'm wondering whether would be possible to automatically update the rows which has some blank fields with its appropriate information (that's the same stuff as in the first and fourth row).
Of course, most of the rows has all the fields properly filled up, it's just too cumbersome and time consuming to fill the blanks by hand.
Thank you in advance for your aid!
The data is separated into fields in a table which always will, either,
have all the fields or just the last one.
In the following example:
AAA BBB CCC 123
DDD EEE FFF 456
579
333
GGG HHH III 789
In this case registers which have in the last field 579 and 333 are the
ones to be updated. What I need is to "write" DDD EEE FFF into the
three separate blank (null) fields on both registers.
A register having blank (null) fields will always need to be updated
with the same information as the preceeding one.
What expression I must write on the update query in order to perform
it?
Thank you in advance!
I'm wondering whether it is actually possible to do so.
Sommerfield wrote: I'm wondering whether it is actually possible to do so.
It's possible. I just didn't think it was right to tell you how to do
it.
See: http://groups.google.com/group/comp....ff3f71a41b982a
If you can, change your input forms so that this doesn't happen
anymore.
James A. Fortune This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JDS |
last post by:
Hi, all. I'd like to do the following, preferably *without* resorting to
JavaScript:
I have a long, dynamically-generated form questionnaire. Not all of the
form fields are dynamically generated, though.
I'd like to capture the NAME of every HTML form field element on the
server, even if that element is submitted blank. The trouble is, with,
say, radio buttons or checkboxes for example, a *blank* element does not
get submitted at all.
|
by: hennakapoor |
last post by:
How do the form filling software determine which text field gets what
data i.e. a typical form filling software will ask the user to enter
the username / address / password etc. Whenever it goes to a website
(ANY website) that requires these data - it tries to supply the
relevant data to the most appropriate text field. How does it decide
that?
If there is any place more relevant than this newsgroup to get more
info about this - please...
|
by: allyn44 |
last post by:
Hello--i have inherited a dataset that has records like below:
id locationid
1 7
2
3 5
4
5
6 4
|
by: allyn44 |
last post by:
Hello,
I have a table that has null fields that need to be filled in with the value of the previous record
(example below)
id date
1 2/2/02
2
3 4/4/02
4
|
by: No Spam |
last post by:
Dear fellow Access 2000 users:
I have a table where there are 5 columns and thousands of rows of
data. Every so often, there is missing data in the second and third
column. I wanted to write some code that would, when it came to a
blank "cell" in column two or three, to simply copy whatever was in
the cell above it.
For instance, here is an example of a few rows before the code is run:
A B C D E
| |
by: Brian |
last post by:
Hello,
Basically, I'm running a query on a form's activation, and I'd like to
have the results of the query be placed into other fields on the same
form automatically.
Does anybody know how this can be done?
I've tried setting the default value of the text fields on the form to
be equal to ! using Access' expression
|
by: billa856 |
last post by:
Hi,
I have to use the table(PRODUCTION) already generated in MS Access in which all fields are of TEXT type.fields like (orderdate,palletno,customercode,itemno,pono,carto n,pcs,totalquantity)Now i have already some data in table like 6000 rows.Now in that some fields are blank.
Now I have created one Form in MS Access in which there are three ComboBoxes.1st one is independent,2nd one is dependent on 1st one and,3rd one is dependent on both...
|
by: hedges98 |
last post by:
Hello
I have a letter template in Word that has some blanks. I want to populate these blank spaces with fields from the database. These blanks are:
client name
client address
appointment date
practitioner (sender of the letter)
Ideally, I'd like to add a button to a form and when a user clicks it, it will take the information from the fields in that specific record and fill in the blanks of the letter template.
|
by: logicbloke |
last post by:
Hello,
All the browsers I tested are filling two fields that aren't for logging in, both have different names from the ones on the login form, and eventhough, the browsers fill them, I have read that removing the value tag instead of just writing empty would resolve the problem, but the value tag is already absent from my fields.
PS : Just to mention that my fields have text and password as types.
How can I avoid that ? Does anyone know...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |