UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
4 Pages V < 1 2 3 4 >  (Go to first unread post)
   Reply to this topicStart new topic
> Data Entry, Access 2013    
 
   
msnarayanan
post Jan 25 2018, 07:00 AM
Post#21



Posts: 277
Joined: 28-May 13



Dear sir

I missed mentioning the step 2.5 included in your message.

After amending the default date, I opened the new record.
Entered the names and clicked on the date field. Not
Populated.

Would it be for the default date (text) and the date field (date)

I have given you so much trouble that you may curse me
For repeatedly requesting you for help.

M S Narayanan
Go to the top of the page
 
projecttoday
post Jan 25 2018, 07:34 AM
Post#22


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


Delete earlier copies and download it again to make sure you have the latest version.

Let's try it without changing the default date

1. open the form
2. press >* at the bottom of the screen to open new record
3. press tab key to go to first name
4. type in first name
5. press tab key to go to last name
6. type in last name
7. press tab key to go to entry date

default date should appear as entry date

--------------------
Robert Crouser
Go to the top of the page
 
msnarayanan
post Jan 25 2018, 07:54 AM
Post#23



Posts: 277
Joined: 28-May 13



dear sir

i followed the steps suggested by you meticulously.

sorry to note the entry date field is not populated.

m s narayanan
Go to the top of the page
 
msnarayanan
post Jan 25 2018, 08:01 AM
Post#24



Posts: 277
Joined: 28-May 13



Dear sir

I am sure you have tested and found to be working fine.

If this is the case, undoubtedly there is something lacking
At my end.

M S Narayanan
Go to the top of the page
 
cheekybuddha
post Jan 25 2018, 08:15 AM
Post#25


UtterAccess VIP
Posts: 10,342
Joined: 6-December 03
From: Telegraph Hill


Robert's examples seem to work for me too (using Acc 2007)

Another approach:

In design view:

Select textbox 'txtEntrydate'

In the 'Event' tab of the properties sheet delete '[Event Procedure]' from the 'On Enter' event.

In the 'Data' tab of the properties sheet for the textbox, enter in default value:
IIf(IsDate([txtHeaderDefaultDate]),[txtHeaderDefaultDate],Null)

Then, return to form view.

When you go to a new record the date field should populate with any date contained in the 'txtHeaderDefaultDate' textbox at the top of the form.

If that doesn't work, then something more fundamental is wrong!

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
msnarayanan
post Jan 25 2018, 08:26 AM
Post#26



Posts: 277
Joined: 28-May 13



Thank you very much, Mr.david.

Shall try and keep you and Mr Robert posted.

M S Narayanan
Go to the top of the page
 
projecttoday
post Jan 25 2018, 11:08 AM
Post#27


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


Thanks for jumping in, David.

msnarayanan, have you tried restarting your computer? What version of Access are you using?

--------------------
Robert Crouser
Go to the top of the page
 
jwhite
post Jan 25 2018, 12:52 PM
Post#28


UtterAccess VIP
Posts: 5,818
Joined: 31-August 06
From: North Carolina, USA


Both solutions worked fine for me, Ac2013.

--------------------
Go to the top of the page
 
projecttoday
post Jan 25 2018, 12:56 PM
Post#29


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


Thanks.

--------------------
Robert Crouser
Go to the top of the page
 
msnarayanan
post Jan 25 2018, 08:10 PM
Post#30



Posts: 277
Joined: 28-May 13



Dear Mr Robert

I am using access 2013 version

M S Narayanan

Go to the top of the page
 
projecttoday
post Jan 25 2018, 11:13 PM
Post#31


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


This database was created using Access 2013.

--------------------
Robert Crouser
Go to the top of the page
 
msnarayanan
post Jan 25 2018, 11:41 PM
Post#32



Posts: 277
Joined: 28-May 13



dear mr robert and mr david

I extend my profound gratitude for your help in solving my problem.

it is now working fine.

as suggested by mr.david, i deleted the "on entry" event and typed the default
value.

great!

once again, thanks a million.

m s narayanan
Go to the top of the page
 
projecttoday
post Jan 25 2018, 11:45 PM
Post#33


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


Glad you got it working.

--------------------
Robert Crouser
Go to the top of the page
 
msnarayanan
post Jan 26 2018, 02:30 AM
Post#34



Posts: 277
Joined: 28-May 13



dear mr robert

i have created a db and also a form to meet my needs.

i have exactly followed the steps as you have done in the specimen db.

it works alright but for the tr_date. i typed in the default value box:
=iif(IsDate([txtHeaderDefaultDate]),[txtHeaderDefaultDate],Null)

when i tried to exter data, tr_date field is filled with "name".
i tried several times.
i am attaching the db for your perusal and correction, if needed.

thanks

m s narayananAttached File  accounts_2017_2018.zip ( 100.23K )Number of downloads: 4


Go to the top of the page
 
cheekybuddha
post Jan 26 2018, 03:02 AM
Post#35


UtterAccess VIP
Posts: 10,342
Joined: 6-December 03
From: Telegraph Hill


Hi m s narayanan,

My guess is Robert is getting some sleep right now.

In your form you no longer have a control called 'txtHeaderDefaultDate' in which you are entering your default date.

Therefore you get the error because the expression =iif(IsDate([txtHeaderDefaultDate]),[txtHeaderDefaultDate],Null) in the default value of textbox 'tr_date' can not find 'txtHeaderDefaultDate'.

Where do you want to get your default date from?

d

--------------------


Regards,

David Marten
Go to the top of the page
 
msnarayanan
post Jan 26 2018, 03:31 AM
Post#36



Posts: 277
Joined: 28-May 13



dearn mr david

i want to get the tr_date from credit form which is available in the db file

thanks

m s narayanan
Go to the top of the page
 
cheekybuddha
post Jan 26 2018, 03:37 AM
Post#37


UtterAccess VIP
Posts: 10,342
Joined: 6-December 03
From: Telegraph Hill


Ah, I see!

You have not renamed your unbound control (you have made its label caption = 'txtHeaderDefaultDate')

In design view:

Select the unbound textbox (it's called 'Text6')

In the property sheet select the 'Other' tab

In the 'Name' property change 'Text6' to 'txtHeaderDefaultDate'.

Then you form will work as in the other db.

hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
projecttoday
post Jan 26 2018, 03:44 AM
Post#38


UtterAccess VIP
Posts: 10,060
Joined: 10-February 04
From: South Charleston, WV


Also, I recommend that you use Me.txtHeaderDefaultDate.

--------------------
Robert Crouser
Go to the top of the page
 
msnarayanan
post Jan 26 2018, 04:31 AM
Post#39



Posts: 277
Joined: 28-May 13



dear mr robert and mr david

i have changed the control name (this time text 10) and also add "me"

in spite of this, the tr_date field is filled up "Name" instead of default date.

i am attaching revised db for your perusal.

if you could please correct it and send it back to me, i shall be much grateful.

thanks

m s narayananAttached File  accounts_2017_2018__2_.zip ( 99.72K )Number of downloads: 2
Go to the top of the page
 
cheekybuddha
post Jan 26 2018, 04:44 AM
Post#40


UtterAccess VIP
Posts: 10,342
Joined: 6-December 03
From: Telegraph Hill


Follow my instructions in Post#37

The textbox must be named 'txtHeaderDefaultDate'.

Don't worry about 'Me'. It will not work in an expression, only in VBA code.

d

--------------------


Regards,

David Marten
Go to the top of the page
 
4 Pages V < 1 2 3 4 >


Custom Search
RSSSearch   Top   Lo-Fi    22nd September 2018 - 12:39 AM