I’m a newbie to Access and am working on a table to capture client contacts. I have 3 questions that I hope someone can help with.
First, I want the date to auto populate as soon as an entry is made on a form. I entered “Date()” in the default value for Date but it didn’t work. Is it possible I have it entered in the wrong spot?
Second, I have a comments section that I’d like to make it have unlimited characters. Right now it stops at about 32 characters. How can I change it?
Last, is there an easy way to perform a search on a form? In order to more easily find data and enter info, I wanted to add a search/find button on the form but I dont know how to set it up to actually search.
5 1635
I’m a newbie to Access and am working on a table to capture client contacts. I have 3 questions that I hope someone can help with.
First, I want the date to auto populate as soon as an entry is made on a form. I entered “Date()” in the default value for Date but it didn’t work. Is it possible I have it entered in the wrong spot?
Second, I have a comments section that I’d like to make it have unlimited characters. Right now it stops at about 32 characters. How can I change it?
Last, is there an easy way to perform a search on a form? In order to more easily find data and enter info, I wanted to add a search/find button on the form but I dont know how to set it up to actually search.
__1 I see no reason why =Date() should not work as long as it is listed in the Properties ==> Data ==> Default Value row for the Field. Make sure the underlying Control Source is defined as a Date/Time Data Type.
__2 In the underlying Table, for the [Comments] Field change the Data Type to Memo which will now allow you to enter 65,535 characters Maximum. Beware, a Memo Field does have its drawbacks. If you know for a fact that you [Comments] Field will never exceed 255 characters, you are better off setting its Data Type to Text with a Field size of 255.
__3 For generic Find Capability on a Form, you can place the following code in the Click() Event of a Command button. It is somewhat flexible in that you can specify several Parameters. One of my favorites is right clicking on a Field and using the Options on the PopUp Menu to search for a specific value in that Field. The only drawback is that the match must be exact. - Screen.PreviousControl.SetFocus
-
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
__1 I see no reason why =Date() should not work as long as it is listed in the Properties ==> Data ==> Default Value row for the Field. Make sure the underlying Control Source is defined as a Date/Time Data Type.
Just one further comment on this. The default of any field will only work when adding a new record and won't work on existing records.
Mary
have you tried putting =date() instead of date()
__1 I see no reason why =Date() should not work as long as it is listed in the Properties ==> Data ==> Default Value row for the Field. Make sure the underlying Control Source is defined as a Date/Time Data Type.
__2 In the underlying Table, for the [Comments] Field change the Data Type to Memo which will now allow you to enter 65,535 characters Maximum. Beware, a Memo Field does have its drawbacks. If you know for a fact that you [Comments] Field will never exceed 255 characters, you are better off setting its Data Type to Text with a Field size of 255.
__3 For generic Find Capability on a Form, you can place the following code in the Click() Event of a Command button. It is somewhat flexible in that you can specify several Parameters. One of my favorites is right clicking on a Field and using the Options on the PopUp Menu to search for a specific value in that Field. The only drawback is that the match must be exact. - Screen.PreviousControl.SetFocus
-
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Thanks Mary. A lot of times I overlook the obvious and make assumptions when I shouldn't. Thanks for being there.
Thanks Mary. A lot of times I overlook the obvious and make assumptions when I shouldn't. Thanks for being there.
No problem it was just something that struck me in the phrasing of the original question.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Limey |
last post by:
Hi All,
I want to write an application that will talk to a RDBMS.
The application needs to be platform neutral from both an operating
system and database backend point of view.
I have...
|
by: Megan |
last post by:
I am not that good at Access and don't know much about it, so I have a
few questions for anyone who knows Access very well. First off, I
should mention that the company I work for uses Access as a...
|
by: Megan |
last post by:
Okay, I have a few questions regarding an Access database our company
has. I should first mention that I'm not that knowledgable in Access
and don't really know how to use it, but I am learning. We...
|
by: SStory |
last post by:
have VS2002 installed on WIN XP pro machine that connects to the internet.
But my IIS is on a Win 2Kpro system networked via crossover. When I try to
transfer file using the VsCopy project it...
|
by: Cy |
last post by:
Hi all,
I wanted to start a thread that might help many of us. I worked for a
company for 12 years, until this past Christmas when they let me go.
Getting rid of the higher dollar guys, in...
|
by: Visitor No 3 |
last post by:
My local Crinkles group(U3A), of which I am one, want me to develop a noddy
database and web
site for their members. Some are computer literate, others not so. I thought
an Access 2000 .mdb on a...
|
by: ComputerTeacher |
last post by:
Hi,
I teach Access to high school sophmores and one topic our textbook does not cover is how to open a database without going through the steps of opening Access. Can I have an icon on my desktop...
|
by: markmcgookin |
last post by:
Hi Folks, Happy new year to all!
I have two questions here, which I hope will be relatively simple you you guys to answer!
1) Is it possible to stick a line or two of code in a form somewhere...
|
by: confused99 |
last post by:
Hi
This is my first thread here. I have a project in MS Access and i have 2 problems related to it.
1. In all the forms where i have the navigation buttons, the delete button is disabled. I am...
|
by: robertns5411 |
last post by:
I have two questions:
1) Say I have a form bound to a table. Assume the user is entering
data into a new record at the bottom of the form. Now, suppose the
user clicks a button on the form...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |