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 26 2018, 05:01 AM
Post#41



Posts: 277
Joined: 28-May 13



sir

i renamed the text box - this time without "me"

it returns "name" in the tr_date field

if you please correct the db attached earlier, i shall be thankful

m s narayanan

Go to the top of the page
 
msnarayanan
post Jan 26 2018, 05:15 AM
Post#42



Posts: 277
Joined: 28-May 13



dear mr david

i got it. i re-created the form and kept the text no. in tact and have not changed the name.

in the default value also i entered only the text no.

it works

thanks

m s narayanan
Go to the top of the page
 
cheekybuddha
post Jan 26 2018, 08:34 AM
Post#43


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


Brilliant! Glad you got there in the end!

Much better when you work it out yourself!!! thumbup.gif

Good luck with your project.

d
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 04:21 AM
Post#44



Posts: 277
Joined: 28-May 13



dear mr david
thanks for your compliments.

i am partially successful.

when i tried to enter data in the fields which include default date field, the default date appears and when
i continue filling in the other fields, the date field vanishes. again when i move to next record for entering
the same thing happens. i though the entire records are saved in the table. when i view the table,
all fields appear and the date field is empty.

i wonder you would help me out.

thanks

m s narayanan
Go to the top of the page
 
cheekybuddha
post Jan 27 2018, 05:12 AM
Post#45


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


Post the db
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 05:24 AM
Post#46



Posts: 277
Joined: 28-May 13



dear mr david

as desired by you, i am attaching the db

m s narayananAttached File  accounts_2017_2018.zip ( 103.31K )Number of downloads: 10
Go to the top of the page
 
cheekybuddha
post Jan 27 2018, 05:51 AM
Post#47


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


Hmmm ...

It works for me.

Try saving your form, closing it and re-open, and try again

Perhaps perform Compact & Repair as well.

hth,

d
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 06:44 AM
Post#48



Posts: 277
Joined: 28-May 13



dear mr david

i reopened, saved and tried.
the date field is not being populated.

in fact, i deleted all the records before trying.

i do not know where i am wrong. am i missing any step?

thanks

m s narayanan
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 06:44 AM
Post#49



Posts: 277
Joined: 28-May 13



dear mr david

i reopened, saved and tried.
the date field is not being populated.

in fact, i deleted all the records before trying.

i do not know where i am wrong. am i missing any step?

thanks

m s narayanan
Go to the top of the page
 
projecttoday
post Jan 27 2018, 07:25 AM
Post#50


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


I tried it. If you do this, it works.

1. Open Main Form
2. Click on Text0 (the one on the left)
3. Type in "01/26/2018"
4. Click on >* at the bottom of the subform. This is a little button. This is on the navigation bar which is at the bottom of the subform. It says "Record" over on the left and "Search" on the right. It's very small. Are you clicking on the right thing?

New record opens and tr_date is populated with value from Text0.
Go to the top of the page
 
cheekybuddha
post Jan 27 2018, 08:17 AM
Post#51


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


Something weird is going on.

Following Robert's instructions works to that point.

When you then select something in the combobox, the date in textbox tr_date disappears. pullhair.gif

Won't have a chance to look at this till later. Perhaps Robert can figure out what's happening.

d
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 08:45 AM
Post#52



Posts: 277
Joined: 28-May 13



dear Mr Robert and Mr David

I thank you both for the help.
Now it works fine.
I did wrong steps earlier.

1. To change the date I typed the date in unbound
Box instead of the label box.

2. I filled in the other fields instead of searching
For the new record.

As Mr Robert suggested I followed the steps
And it is working fine.

Thanks a lot

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


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


I've found something. I remembered that happened to me the first time I tried it. So if you delete all the records in the table then, yes, the date does disappear when you create the second record. What to do? The only thing I can think of is going back to code. Or just live with it. Or make a launching form.

And by the way you have to type the date in the unbound box. It's impossible to type into a label.
Go to the top of the page
 
msnarayanan
post Jan 27 2018, 09:55 AM
Post#54



Posts: 277
Joined: 28-May 13



Dear Mr Robert

I typed the date in unbound field only but not
Directly. I click on the label box and typed date
In the unbound box. Now I gather from you that
This. Can be done directly in unbound box.


Any way, it is working alright now. As an expert as you
Are you may further suggest improvement.

M S Narayanan


Go to the top of the page
 
projecttoday
post Jan 27 2018, 10:19 AM
Post#55


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


It doesn't work if the table is empty.
Go to the top of the page
 
msnarayanan
post Feb 5 2018, 02:17 AM
Post#56



Posts: 277
Joined: 28-May 13



Dear Mr Robert and Mr DavidJ
Sorry to bother you again.
Based on the attachment sent to me earlier I created a form an the following were the steps taken by me:
1. ,Opened a form in design view.
2. On the header I created a text box/unbound
3. Changed the textname to header default date
4. Dragged tr_date to details portion
5. On this field property against default value, I typed
=If(IsDate([txtHeaderDefaultDaye]),[txtHeaferDefaultDate],Null)
Filled in some entries to make sure the table is not empty.
6. Opened the form again and entered default date.
7. Clicked to locate new record

But the default date is not being populated.

May I seek your guidance.

Thanks

M S Narayanan
Go to the top of the page
 
projecttoday
post Feb 5 2018, 09:20 AM
Post#57


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


If you still having a problem then make a launching, or selection, form. Just make a form and put a textbox on it for the date and a button to open your data entry form.
Go to the top of the page
 
msnarayanan
post Feb 6 2018, 04:36 AM
Post#58



Posts: 277
Joined: 28-May 13



Dear sir

I tried to create a selection form and I am not successful
To create it. As you are aware I am not that good at access.

In the meantime I tried many times following your earlier
Guidance with vain.

When browsing i came across a method by using control&'
To have the value carried over to next record. Is it really possible.
If so, where and how to type the formula.

Thanks

M S Narayanan
Go to the top of the page
 
msnarayanan
post Feb 6 2018, 07:42 AM
Post#59



Posts: 277
Joined: 28-May 13



Dear sir

Further to my earlier post, I have some doubts.

The default value is entered for the text (unbound)
How is the date field in detail. Section related to the
Default date on the header section.

Should I make the default value for the date field.

Thank you

M S Narayanan

Go to the top of the page
 
projecttoday
post Feb 6 2018, 08:29 AM
Post#60


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


If you use a separate form for launching then then you remove the date from the header section completely.
Go to the top of the page
 
4 Pages V < 1 2 3 4 >


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2018 - 02:33 PM