I would like to create a calulated field in Access 97. In this field I would like an if statement. The field should work something like this.
If field_z = 'x' than
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10042947.html
Zones:
MS AccessDate Answered: 04/04/1998 Rating: 7.2 Views: 0
I want to restrict, on input, the length of a memo field to 32760 bytes. I presume I use the 'validation rule' but don't know how to code it.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10100476.html
Zones:
MS AccessDate Answered: 11/24/1998 Rating: 7.0 Views: 0
I have seen some programs where one starts to type in text or info into a line, url, field etc and the rest of the line suddenly appears completed. It seems that some of the information must be sto...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10118906.html
Zones:
MS AccessDate Answered: 08/27/1999 Rating: 8.8 Views: 0
My access table has a 10 digit code as key. (It is defined as 'text', but the content will be always using '0-9'character. such as: 2934812344. Somehow I want to decrease its length in order to exp...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10141699.html
Zones:
MS AccessDate Answered: 03/22/1999 Rating: 7.8 Views: 0
I have a form that shows customer orders. It has a subform that shows a datasheet with the items in the order. The parent and child are linked by an "Order ID" field, so the subform only shows th...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10152137.html
Zones:
MS AccessDate Answered: 04/20/1999 Rating: 7.4 Views: 0
WHAT I NEED:
To add a field to a table in my database
Trying to use this code:
Function addflds()
Dim db As Database
Dim tdf As TableDef
Set db = CurrentDb
Set tdf = CurrentDb.TableD...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10206845.html
Zones:
MS AccessDate Answered: 02/05/2002 Rating: 8.0 Views: 0
How do I change field data-type from varchar to int??
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10227541.html
Zones:
MS SQL ServerDate Answered: 11/02/1999 Rating: 7.4 Views: 0
I've got a field in a table that holds an amount of time formatted as a "short time". Example: 0:34, 7:28, etc..
I am trying to add the values of that field together in a report, and have the e...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10284963.html
Zones:
MS AccessDate Answered: 02/01/2000 Rating: 6.6 Views: 0
I have a report i'm trying to do and the report field is "cost" I'm trying to get the cost sum and the grand total of sum.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10303944.html
Zones:
MS AccessDate Answered: 03/02/2000 Rating: 7.2 Views: 0
I am designing a database for keeping track of a large trail system. When the surveyors go out to gather data, they record the data in "stations" instead of using regular feet or meters. The nota...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10357385.html
Zones:
MS AccessDate Answered: 05/26/2000 Rating: 6.2 Views: 0
