Most Optimal Way To Load Dependent Comboboxes From MSSQL Server Query

Best Microsoft Access Programmer Portland OR

Hello All,

I have a form with the following fields:

  • Origin
  • Destination
  • Region
  • Lane

The passthrough query in the background is set up like this:

Origin Destination Region Lane
Knoxville Memphis Southwest Knoxville-Memphis
Knoxville Nashville Central Knoxville-Nashville
Knoxville Chattanooga East Knoxville-Chattanoga
Chattanooga Memphis Southwest Chattanooga-Memphis

What I’d like to do is make the comboboxes dependent on each other, with each using distinct values from the passthrough query headers. That way, if someone was to choose any of them from the fields,

Read More

The 29 Best Things to Do in Portland This Week: Sept 16-19

Best Microsoft Access Programmer Portland OR

by Mercury Things to Do Staff


Jump to: Monday | Tuesday | Wednesday | Thursday

Monday, Sept 16

Greg Laswell
The Long Beach-based singer/songwriter best known for soundtracking some of the best moments on shows like Grey’s Anatomy and Parenthood brings his folk-rock sounds back to the Doug Fir stage for the Portland stop on a fall tour supporting his latest album, Next Time. (Mon Sept 16, 9 pm, Doug Fir, $20-23)

ILoveMakonnen
Makonnen Sheran, better known by his stage name iLoveMakonnen, brings … Read More

Is it possible to create a macro that adds the current Date & Time to a form field so that it’s in addition to a 10-digit number already in that same field?

Best Microsoft Access Programmer Portland OR

So I have a field on an Access form that displays the account number for a given record. I want to have a form button that will add the current Date and time to that same field. How might I do this?

For example, if the field displays “0123456789” originally, I want a form button that will then make the field contain “01234567899/13/2019 3/22:58 PM”

Would it be possible to do this and how?

submitted by /u/MrManager689
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Can Portland Deliver on the Promise of Publicly Funded Elections?

Best Microsoft Access Programmer Portland OR

Can Portland Deliver on the Promise of Publicly Funded Elections?
by Blair Stenvick

LUHUANFENG___GETTY_IMAGES___MERCURY_STAFF.jpg
LUHUANFENG / GETTY IMAGES & MERCURY STAFF

Carmen Rubio never imagined running for public office.

“I wasn’t sure I would have access in the same way that traditional candidates have access,” says Rubio, the executive director of the Portland nonprofit Latino Network. She says she was deterred by Portland voters’ history of electing well-financed candidates—mostly white men—as city commissioners.

But then Portland approved a new public campaign financing program: Open and Accountable Elections (OAE), a system built to give all politically … Read More

Police Officer Who Sent Protective Texts to Joey Gibson Cleared of Wrongdoing in City Review

Best Microsoft Access Programmer Portland OR

Police Officer Who Sent Protective Texts to Joey Gibson Cleared of Wrongdoing in City Review
by Blair Stenvick

presser.jpg
BLAIR STENVICK

A city review released Thursday has found that the Portland Police Bureau (PPB) officer who sent protective text messages to Joey Gibson, the leader of far-right Vancouver, Washington group Patriot Prayer, did not violate any bureau policies.

In February of this year, both the Mercury and Willamette Week reported on the text messages, sent by Lieutenant Jeff Niiya and obtained through a public records request. After the texts were made public, many community members and leaders questioned whether they … Read More

The 21 Best Concerts to See in Portland: September 12-25

Best Microsoft Access Programmer Portland OR

The 21 Best Concerts to See in Portland: September 12-25
Poison Idea! Gary Clark Jr! Mxmtoon! Jay Som!

{{image:4, align:right, width:250}}

Sunn O))), Papa M
If you’re new to Sunn O))) (just say “Sun”), have no new-fan insecurities. The long-worshipped ambient drone group from Seattle is still putting out great work, guaranteed to vibrate your whole body down to a cellular level. Seeing Sunn O))) live also remains a wholly rewarding experience—if being Maxell’s Blown Away Guy is your thing, and it is my thing—because unless you have a very finicky sound system friend … Read More

The 21 Best Concerts to See in Portland: September 12-25

Best Microsoft Access Programmer Portland OR

The 21 Best Concerts to See in Portland: September 12-25
Poison Idea! Gary Clark Jr! Mxmtoon! Jay Som!

{{image:4, align:right, width:250}}

Sunn O))), Papa M
If you’re new to Sunn O))) (just say “Sun”), have no new-fan insecurities. The long-worshipped ambient drone group from Seattle is still putting out great work, guaranteed to vibrate your whole body down to a cellular level. Seeing Sunn O))) live also remains a wholly rewarding experience—if being Maxell’s Blown Away Guy is your thing, and it is my thing—because unless you have a very finicky sound system friend … Read More

Canned Mixed Drinks: The Tasty, the Okay, and the Kinda Gross

Best Microsoft Access Programmer Portland OR

by Andrea Damewood

Canned rosé on the river? SoooOOOOooo 2018. Fall 2019 is all about cans of pre-mixed, locally made cocktails.

See, the Oregon Liquor Control Commission finally did something right! Those bureaucratic fun-smotherers at the OLCC changed a regulation in a way that benefits us degenerates: canned cocktails—like actual liquor-spiked drinks inside aluminum—are now legallllll (airhorn)!! Oregon was previously shut out of the unique pleasure of a mobile Moscow mule because liquor and mixer had to be sold in separate containers. Until … Read More

Canned Mixed Drinks: The Tasty, the Okay, and the Kinda Gross

Best Microsoft Access Programmer Portland OR

by Andrea Damewood

Canned rosé on the river? SoooOOOOooo 2018. Fall 2019 is all about cans of pre-mixed, locally made cocktails.

See, the Oregon Liquor Control Commission finally did something right! Those bureaucratic fun-smotherers at the OLCC changed a regulation in a way that benefits us degenerates: canned cocktails—like actual liquor-spiked drinks inside aluminum—are now legallllll (airhorn)!! Oregon was previously shut out of the unique pleasure of a mobile Moscow mule because liquor and mixer had to be sold in separate containers. Until … Read More

Our Anniversary

Best Microsoft Access Programmer Portland OR

by Anonymous

You were overwhelmingly attentive during the new energy phase, seemingly infatuated. Sure, I was smitten as well, which precluded an ability to sensibly gauge your intentions. We shared civil discourse, personal goals and devoured magnificent dinners without pausing for market prices or expectations. The days leading up to our three month “break” were undeniably whimsical! I briefly departed with a sincere aim to emerge refreshed, a more suitable compliment for your naturally complex palate.

Please tell me why I have not seen … Read More

Page 5 of 232
1 3 4 5 6 7 232