I have an access report that I use to print address labels - it pulls data from a table that has the usual "Address1" "address2" "City" etc - often there is no data in the "address2" field.
When the labels print this leaves a blank line between "Address1" and "City". I want to be able to leave out the "address2" field when it is blank and have the fields below move up to fill the blank space - any advice on how to do this?
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…