Hi, I'm sure this has been asked and answered before but I lost it.
How does one code a form to carry forward the only certain fields from
the previous record. Thanks. 7 2212
For each field you want to carry forward, put the following code in the
AfterUpdate event of the field:
Me!NameOfField. DefaultValue = Me!NameOfField
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"John" <jb**@cogeco.ca > wrote in message
news:sp******** *************** *********@4ax.c om... Hi, I'm sure this has been asked and answered before but I lost it. How does one code a form to carry forward the only certain fields from the previous record. Thanks.
On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am>
wrote: For each field you want to carry forward, put the following code in the AfterUpdate event of the field: Me!NameOfField .DefaultValue = Me!NameOfField
Thanks.
On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am>
wrote: For each field you want to carry forward, put the following code in the AfterUpdate event of the field: Me!NameOfField .DefaultValue = Me!NameOfField
I'm not that good at explaining what I mean. When I enter a new
record a new date (today) goes in the DateField, now when I tab to the
description_fie ld I want get the description from the previous record.
Does this make sense. Thanks again.
Do you have any other fields in the record?
"John" <jb**@cogeco.ca > wrote in message
news:c3******** *************** *********@4ax.c om... On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am> wrote:
For each field you want to carry forward, put the following code in the AfterUpdate event of the field: Me!NameOfField .DefaultValue = Me!NameOfField
I'm not that good at explaining what I mean. When I enter a new record a new date (today) goes in the DateField, now when I tab to the description_fie ld I want get the description from the previous record. Does this make sense. Thanks again.
Yes, I have the Date field,Descripti on Field and Distance Field.
On Sun, 09 May 2004 18:17:24 GMT, "PC Datasheet" <sp**@nospam.sp am>
wrote: Do you have any other fields in the record?
"John" <jb**@cogeco.ca > wrote in message news:c3******* *************** **********@4ax. com... On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am> wrote:
>For each field you want to carry forward, put the following code in the >AfterUpdate event of the field: >Me!NameOfField .DefaultValue = Me!NameOfField
I'm not that good at explaining what I mean. When I enter a new record a new date (today) goes in the DateField, now when I tab to the description_fie ld I want get the description from the previous record. Does this make sense. Thanks again.
Put the following code in the form's OnCurrent event:
If IsNull(Me!Descr iption.DefaultV alue) Then
Me!Description. SetFocus
Else
Me!Distance.Set Focus
End If
Put the following code in the Description Field's AfterUpdate Event:
Me!Description. DefaultValue = Me!Description
Put the following code in the Distance Field's AfterUpdate Event:
Me!NameOfDateFi eld = Date()
Me!Description. DefaultValue = Me!Description
Set the tab stop for the Date field to No, and the tab order to Description -
Distance.
When you go to a new record, if the Description field does not have a default
value, you will go to the Description field and enter the description. If it
does have a default value, you will go to the Distanct field and enter the
distance. The Date field and Description field will automatically be filled in
when you press enter, go to another record, go to a new record or close the
form.
Steve
PC Datasheet
put the following code in the AfterUpdate event of the field: >Me!NameOfField .DefaultValue = Me!NameOfField
"John" <jb**@cogeco.ca > wrote in message
news:g5******** *************** *********@4ax.c om... Yes, I have the Date field,Descripti on Field and Distance Field.
On Sun, 09 May 2004 18:17:24 GMT, "PC Datasheet" <sp**@nospam.sp am> wrote:
Do you have any other fields in the record?
"John" <jb**@cogeco.ca > wrote in message news:c3******* *************** **********@4ax. com... On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am> wrote:
>For each field you want to carry forward, put the following code in the >AfterUpdate event of the field: >Me!NameOfField .DefaultValue = Me!NameOfField
I'm not that good at explaining what I mean. When I enter a new record a new date (today) goes in the DateField, now when I tab to the description_fie ld I want get the description from the previous record. Does this make sense. Thanks again.
Thanks a lot, I will give it a shot tomorrw. Thanks again
On Sun, 09 May 2004 20:09:49 GMT, "PC Datasheet" <sp**@nospam.sp am>
wrote: Put the following code in the form's OnCurrent event:
If IsNull(Me!Descr iption.DefaultV alue) Then Me!Description. SetFocus Else Me!Distance.Set Focus End If
Put the following code in the Description Field's AfterUpdate Event: Me!Description .DefaultValue = Me!Description
Put the following code in the Distance Field's AfterUpdate Event: Me!NameOfDateF ield = Date() Me!Description .DefaultValue = Me!Description
Set the tab stop for the Date field to No, and the tab order to Description - Distance.
When you go to a new record, if the Description field does not have a default value, you will go to the Description field and enter the description. If it does have a default value, you will go to the Distanct field and enter the distance. The Date field and Description field will automatically be filled in when you press enter, go to another record, go to a new record or close the form.
Steve PC Datasheet
put the following code in the AfterUpdate event of the field: >Me!NameOfField .DefaultValue = Me!NameOfField
"John" <jb**@cogeco.ca > wrote in message news:g5******* *************** **********@4ax. com... Yes, I have the Date field,Descripti on Field and Distance Field.
On Sun, 09 May 2004 18:17:24 GMT, "PC Datasheet" <sp**@nospam.sp am> wrote:
>Do you have any other fields in the record? > > >"John" <jb**@cogeco.ca > wrote in message >news:c3******* *************** **********@4ax. com... >> On Sun, 09 May 2004 15:53:37 GMT, "PC Datasheet" <sp**@nospam.sp am> >> wrote: >> >> >For each field you want to carry forward, put the following code in the >> >AfterUpdate event of the field: >> >Me!NameOfField .DefaultValue = Me!NameOfField >> >> I'm not that good at explaining what I mean. When I enter a new >> record a new date (today) goes in the DateField, now when I tab to the >> description_fie ld I want get the description from the previous record. >> Does this make sense. Thanks again. >> >> > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: NotGiven |
last post by:
I need to send emails to about 100 people for a client - NOT spam. Rather
it is a notifying them of a page they need to view.
majorDomo - look stoo complicated to get up and running and I don't want
them to email it back abd get everyone's emails replies - so this option is
out.
The options are:
- use php mail() and run it several times with 250 emails in the BCC field
each time
|
by: Bryan Parkoff |
last post by:
I break one U_WORD variable into two U_BYTE variables. I prefer to
manipulate two U_BYTE variables instead of one U_WORD variable using Carry.
Please look at my example using U_WORD variable below.
typedef unsigned char U_BYTE;
typedef unsigned short int U_WORD;
U_WORD HighLow = 0x00FE;
HighLow += 0x04;
U_BYTE Carry = HighLow >> 8;
|
by: Almir |
last post by:
I have a simple problem, i just can get a grasp on it. I designed a
database for inventory of computer equipment. Now i created forms for
each table. Each piece of equipment is going to come in an order.
ORDERS --> ORDER CONTENTS --> DEVICES --> CPUS
--> PRINTERS
--> NETWORK HARDWARE
You get the picture. I want to make the updating easy. I start from
ORDERS table enter all the common information, then ORDER CONTENTS
table and get all...
|
by: Paul Malcomson |
last post by:
Hi.
I'm having terrible trouble with a form that displays several
parent/child relationships at one time. It is a sales force hierarchy
- Sales force, district, territory, sales rep are the tables linked in
parent/child relationships.
I'm using a form to choose the main-parent and then several subforms
in datasheet view.
|
by: campbellbrian2001 |
last post by:
I'm trying to get the "Carry data over to new record"
code to work from Allen Browne's site:
http://allenbrowne.com/ser-24.html
I follwed the instruction explicitly and somethings not working... any
clues?
Thanks all!!
Brian
| |
by: chunk1978 |
last post by:
hi there... i'm trying to make one text field contain the value of another... i'm assuming there's a really simple solution... here's a code i quickly wrote to further explain my issue:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />...
|
by: =?Utf-8?B?UmF5IE1pdGNoZWxs?= |
last post by:
Hello,
I have a DateTimePicker set to the custom format HH:mm:ss. (I used the
custom format to avoid the AM/PM part, even though my OS is set up for the
12-hour time format.) It works fine except that when the number of seconds
are incremented past 59 or are decremented below 00, it does not carry into
the minutes field. Similarly for the minutes field carrying into the hours
field. I assume this is something I must do myself within...
|
by: lilihope824 via AccessMonster.com |
last post by:
I am building an inventory control database.
But I want to create a inventory reconcilation.I will want to have the
database be able me to check StockOnHand at anytime during the month by :
Carried forward Last StockTake Qty+ Sum()- Sum(). Please
help!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200709/1
|
by: sass |
last post by:
Hi!
this must be a stupid question, but bare with me - I just started learning html!
My problem:
I have several html pages that use forms to collect user input.
On each page, submitting the data activates a cgi script that saves it to my server and then forwards the user to another html page.
I would like to carry a hidden variable (i.e., the user ID that someone entered on the first page) forward through all html pages, so that I can...
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: 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...
| |