Field Validation Rule to Exclude Ampersand
Tue, 16 Mar 2010 19:46:02 -0700
I am trying to create a validation rule for a table field that will prevent
the use of the ampersand character (&).
InStr(1,[strClientName],"&",1)<>0
does not work.
What is the correct syntax?
--
Ken Hudson ...
|
Sorting data
Tue, 16 Mar 2010 16:43:01 -0700
I have a table named Items, in this table the items are defined by Name,
Size, and Format. When first setting up the table I added a few of my items
to get the process going. I then created a query based on this table to sort
by name, size, and format. When creating a sort order in the query by
Name(Ascen ...
|
Memo Field Truncates my Data in Table?!
Tue, 16 Mar 2010 20:41:32 GMT
Ok - from what I understand a "MEMO" field type should allow at least 65k
worth of data to be saved in your database table. However, I am manually
opening my table and typing in text that is a half a dozen sentences and when
I hit enter to move onto the next field - it truncates my data. I go back to
the field i ...
|
A "push" function to produce an email on an event
Tue, 16 Mar 2010 12:58:16 GMT
Someone has asked me to create a database and include what they call a "push"
function that will automatically create an email to warn that a contract
renewal date is imminent. I believe that this can't be done in a desktop
application because although I can see how I can create the alert by running
a query agai ...
|
Re: help with database 2
Tue, 16 Mar 2010 05:38:40 GMT
start here maybe:
http://office.microsoft.com/en-us/templates/TC102512251033.aspx?CategoryID=CT102512241033
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201003/1
...
|
Printout Problem, error 2501
Mon, 15 Mar 2010 22:22:01 -0700
Hello -
I've created an application in access 2003, installed it on another computer
that has the following configuration:
Windows XP, Office 2007, Access runtime 2003, and I've removed the access
2007 from the office package.
The following error happens when the user is trying to print a report.
"The action ...
|
Point of Sale database - does it exist?
Mon, 15 Mar 2010 20:27:01 -0700
I need to (very quickly) create a program that is user friendly that would be
used by a small corner store to track sales/inventory/expenses/employees/etc.
the main issue is it need to track every sale by the employee entering (by
combo boxes) categories then choosing the product and then that would bring
u ...
|
|
|
Help with database
Mon, 15 Mar 2010 17:54:01 -0700
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?
...
|
Table field length limit alternative
Mon, 15 Mar 2010 15:49:48 -0700 (PDT)
Hi,
I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. M ...
|
How do I include more Help options for really inexperienced users?
Mon, 15 Mar 2010 12:35:02 -0700
Things like on the forms (beside each label), how can i include a question
mark symbol that, when the mouse hovers over it, shows the format needed for
the data that should be input? e.g. contact number - 028 90 000000 ...
|
