473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Redundant amounts

Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.

Thanks for any help you can offer.

Nov 13 '05 #1
5 1162
If you have 3 fields in a table which 'always' have the same amount then you
have a problem with database design. Assuming that by 'always' you mean
absolutely without fail no exceptions.

Looking at the names of the fields you've given I'd be surprised if they
really are going to always be the same.

Mike

<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.

Thanks for any help you can offer.

Nov 13 '05 #2
<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.

Thanks for any help you can offer.

Well without going into the rights and wrongs of your design you'd need
something like this in the edited control's 'after update' event (remember,
your form has *controls* and not *fields* - I have assumed your controls are
text boxes):

Me.txtMyTextBox2 = Me.txtMyTextBox1
Me.txtMyTextBox3 = Me.txtMyTextBox1
Me.Refresh

txtMyTextBox1 is the name of the edited control.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #3
Thanks, I will give this a try.

Nov 13 '05 #4
Unfortunately, there are no 'events' associated with data-entry directly
into tables. Which is why you should force your users to use forms for data
entry. Sometimes you must implement user-level security to prevent direct
access to the tables.

Another alternative would be to create an update query that reads the table
record by record and updates any blank fields with the desired value. You
could then initiate this query from a form or an autoexec macro.

Fred


<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.

Thanks for any help you can offer.

Nov 13 '05 #5

This worked out really well. Thanks for you help.

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: michaaal | last post by:
If I use a form to pass data (say, for example, through a textbox) the data seems to be limited to somewhat smaller amounts. What should I do if I want to pass a large amount of data? For example...
23
by: Mark Dickinson | last post by:
I have a simple 192-line Python script that begins with the line: dummy0 = 47 The script runs in less than 2.5 seconds. The variable dummy0 is never referenced again, directly or indirectly,...
4
by: oshanahan | last post by:
Does anyone have ideas on the best way to move large amounts of data between tables? I am doing several simple insert/select statements from a staging table to several holding tables, but because...
5
by: Julia Baresch | last post by:
Hi everyone, I haven't found any reference to this problem on this group or in Access 97 help. I hope someone here knows this - probably a simple thing, but not obvious. I designed a query to...
3
by: Dig314 | last post by:
I need to Total the amounts for each Property ID in a table. All the amounts are stored as positive in the database. Based on a transaction code, the amount should be added or subtracted. There...
99
by: Mikhail Teterin | last post by:
Hello! Consider the following simple accessor function: typedef struct { int i; char name; } MY_TYPE; const char *
14
by: Ian Pilcher | last post by:
It's pretty common to see declarations such as: static volatile sig_atomic_t caught_signal = 0; C99 defines sig_atomic_t as a "... (possibly volatile-qualified) integer type of an object that...
40
by: Neo The One | last post by:
I think C# is forcing us to write more code by enforcing a rule that can be summarized as 'A local variable must be assgined *explicitly* before reading its value.' If you are interested in what...
7
by: =?Utf-8?B?TW9iaWxlTWFu?= | last post by:
Hello everyone: I am looking for everyone's thoughts on moving large amounts (actually, not very large, but large enough that I'm throwing exceptions using the default configurations). We're...
0
bilibytes
by: bilibytes | last post by:
hi, I was wondering how to determine whether an information is redundant or not. if you have in a table "Main", the basic information for a thing: thing_id | name | image_id | city_id ok if...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.