Children’s Parade on Sandy

Best Microsoft Access Programmer Portland OR

by Anonymous

Like all my neighbors here in the Hollywood District, we are SO excited for the children’s parade! Just do us a favor please? Please take your garbage with you. Also know that just because you placed an X on the sidewalk on Tuesday with duct tape, doesn’t mean that is your spot on Wednesday. It’s a public street, not “dibs”, so don’t act like an entitled jackass when you get there, and your useless “reservation” was ignored. My property also isn’t a … Read More

It’s Pickle Time: Portland Pickles 2019 Season Kicks Off Tonight!

Best Microsoft Access Programmer Portland OR

It’s Pickle Time: Portland Pickles 2019 Season Kicks Off Tonight!
by Chipp Terwilliger

20170719_203745_hdr.jpg
Portland Pickles

It’s a proven fact that summer and baseball go hand in hand, and from June until mid-August, Portland is home to one of the best ballpark experiences in the country. In just three short seasons, the Portland Pickles (whose 2019 season kicks off tonight) have gone from charter members of the now-defunct Great West League to a powerhouse club in a competitive West Coast League. The WCL has produced dozens of major leaguers throughout the years, including current Yankees … Read More

A Fancy New Box Set Makes the Case for Traffic as One of the Best Bands of All Time

Best Microsoft Access Programmer Portland OR

A Fancy New Box Set Makes the Case for Traffic as One of the Best Bands of All Time
by Ned Lannamann

traffic-studioalbums.jpg

For me, the most exciting part of Avengers: Endgame wasn’t when our comic-book pals tumbled through time, or space-punched the bad guys, or saved the world from kingdom plum. For me, it came during the movie’s opening passages, when Traffic’s “Dear Mr. Fantasy” blasted out of the speakers, its buzzing-bee guitars serving not just as a “Comedy Tonight”-style opening number for the film, but offering, perhaps, a philosophical mantra for what we were about to see—a psychotropic commentary on the … Read More

IIf() statement not working in criteria field

Best Microsoft Access Programmer Portland OR

I want to create a query form where fields that are left blank do not affect the query. So far using this code in the criteria has worked wonders:

Like [Forms]![FormName]![ControlName] & “*”

However, the issue arises when it comes to numbers as enter the number ‘1’ will yield results like ’10’ and ‘100’. I’ve tried using this code in the criteria but I get nothing:

IIf(isNull([Forms]![FormName]![ControlName]), “*”, [Forms]![FormName]![ControlName])

Everything that I have researched so far has lead me to

Read More

IIf() statement not working in criteria field

Best Microsoft Access Programmer Portland OR

I want to create a query form where fields that are left blank do not affect the query. So far using this code in the criteria has worked wonders:

Like [Forms]![FormName]![ControlName] & “*”

However, the issue arises when it comes to numbers as enter the number ‘1’ will yield results like ’10’ and ‘100’. I’ve tried using this code in the criteria but I get nothing:

IIf(isNull([Forms]![FormName]![ControlName]), “*”, [Forms]![FormName]![ControlName])

Everything that I have researched so far has lead me to

Read More

Problem Appending CSV File To Table With Primary Key

Best Microsoft Access Programmer Portland OR

I am trying to append a CSV file to an existing table that has a primary key, but the first value from the CSV file is not being copied across, and an error message ‘Null value in an auto-number field’ is generated.

I can create the table without a primary key and subsequent CSV imports work OK, but my relatively limited Access knowledge tells me that a primary key is preferable.

Can anyone offer some insight into what I am doing wrong? Thanks.

submitted … Read More

Problem Appending CSV File To Table With Primary Key

Best Microsoft Access Programmer Portland OR

I am trying to append a CSV file to an existing table that has a primary key, but the first value from the CSV file is not being copied across, and an error message ‘Null value in an auto-number field’ is generated.

I can create the table without a primary key and subsequent CSV imports work OK, but my relatively limited Access knowledge tells me that a primary key is preferable.

Can anyone offer some insight into what I am doing wrong? Thanks.

submitted … Read More

Creating a Min-Max Time Calculation based on Transaction IDs

Best Microsoft Access Programmer Portland OR

Creating a Min-Max Time Calculation based on Transaction IDs

Good morning everyone,

I’m needing to calculate total time of a transaction. My report currently gives me the time it takes to complete individual actions in an overall transaction. Each action in a set transaction has the same transaction ID. I’m needing to take the minimum time (start time) in each transaction and the max time (end time) and calculate an overall elapsed time so I can account for time between actions.

I also have it broken down into the number of

Read More

Creating a Min-Max Time Calculation based on Transaction IDs

Best Microsoft Access Programmer Portland OR

Creating a Min-Max Time Calculation based on Transaction IDs

Good morning everyone,

I’m needing to calculate total time of a transaction. My report currently gives me the time it takes to complete individual actions in an overall transaction. Each action in a set transaction has the same transaction ID. I’m needing to take the minimum time (start time) in each transaction and the max time (end time) and calculate an overall elapsed time so I can account for time between actions.

I also have it broken down into the number of

Read More

Appeals Courts Consider the Fate of Oregon’s Youth-Led Climate Change Lawsuit

Best Microsoft Access Programmer Portland OR


by Blair Stenvick

Hundreds of kids rallied at Portland City Hall, calling for more government action on climate change, earlier this year.
Hundreds of kids rallied at Portland City Hall, calling for more government action on climate change, earlier this year. MERCURY STAFF

The fate of a youth-led federal lawsuit that could have major implications for climate change and the fossil fuel industry is being decided by an appeals court in Portland this week.

The lawsuit in question, Juliana v. United States, was originally filed in Oregon in 2015. In it, 21 young people posit that the United States’ lax environmental policies … Read More

Page 814 of 849
1 812 813 814 815 816 849