Missing Queries to Import in Excel

Best Microsoft Access Programmer Portland OR

https://imgur.com/a/GqSIw7g

I’ve got several queries that I’m looking to bring into excel via data connection, but they’re not showing up. I’ve done some research and found repairing the database may help, but that’s not done anything. do you have any suggestions as to fix this?

Thanks!

submitted by /u/Dr-Vader
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Missing Queries to Import in Excel

Best Microsoft Access Programmer Portland OR

https://imgur.com/a/GqSIw7g

I’ve got several queries that I’m looking to bring into excel via data connection, but they’re not showing up. I’ve done some research and found repairing the database may help, but that’s not done anything. do you have any suggestions as to fix this?

Thanks!

submitted by /u/Dr-Vader
[link] [comments]

Microsoft Acess Developer Portland ORRead More

There Are More Women Executives in Cannabis Than in Other Sectors of the Economy, But There’s Still Room for Improvement

Best Microsoft Access Programmer Portland OR


by Josh Jardine

GettyImages-1129397827.jpg
The Cannabiz Agency/Getty Images

Where do women stand in the labor force, aside from underpaid?

According to the US Department of Labor, “Of the 123 million women age 16 years and over in the U.S., 72 million, or 58.6 percent, were labor force participants—working or looking for work. Women comprised 47 percent of the total U.S. labor force. Women are projected to account for 51 percent of the increase in total labor force growth between 2008 and 2018.”

So, where … Read More

Use Checkbox to Update Record "Recordset is not updateable."

Best Microsoft Access Programmer Portland OR

New to Access and VBA and trying to create a credit card reconciliation form. In my subform I’ve got all the record information that is being pulled from a ODBC table. I’m turning a redundant field in the table to a field where the users can record a yes/no about whether the payment was reconciled or not. Currently the field’s format (transaction_desc) is long text. I’m trying to use a checkbox in the subform to control the contents of transaction_desc and change it, if

Read More

Use Checkbox to Update Record "Recordset is not updateable."

Best Microsoft Access Programmer Portland OR

New to Access and VBA and trying to create a credit card reconciliation form. In my subform I’ve got all the record information that is being pulled from a ODBC table. I’m turning a redundant field in the table to a field where the users can record a yes/no about whether the payment was reconciled or not. Currently the field’s format (transaction_desc) is long text. I’m trying to use a checkbox in the subform to control the contents of transaction_desc and change it, if

Read More

Ready or Not Review: Cracking Bone, Ripping Skin, and the Worst Wedding Ever

Best Microsoft Access Programmer Portland OR

Ready or Not Review: Cracking Bone, Ripping Skin, and the Worst Wedding Ever
by Robert Ham

ready_or_not_-_Eric_Zachanowich.png
Eric Zachanowich

It was right around the time when newlywed Grace (Samara Weaving) punched her pre-teen nephew in the face and subsequently fell into a pit filled with decomposing bodies that I found myself completely shutting off to Ready or Not, the new horror-comedy from filmmaking collective Radio Silence.

From there, atrophy set in—rendering me numb to each subsequent act of violence that was supposed to shock and/or amuse me. In Ready or Not, the significant efforts—expended by screenwriters … Read More

Following Protests, Mayor Wheeler Encourages People to Spend Money Downtown

Best Microsoft Access Programmer Portland OR

Following Protests, Mayor Wheeler Encourages People to Spend Money Downtown
by Alex Zielinski

Far-right protesters march in Portland on Saturday, August 17.
Far-right protesters march in Portland on Saturday, August 17. Stephanie Keith / Stringer

On the heels of a financially-draining weekend of dueling protests, Portland Mayor Ted Wheeler is asking locals and visitors to spend their money downtown this coming Saturday, Aug. 24.

“Whenever a situation like the one last Saturday happens, it has a negative effect on our local business community, their employees, and their families,” said Wheeler in a press release. “This is the busiest time of year, and businesses … Read More

Tickets on Sale NOW for the 2019 HUMP! Film Festival!

Best Microsoft Access Programmer Portland OR

Tickets on Sale NOW for the 2019 HUMP! Film Festival!
by Dan Savage

1200x630__GroupShot.jpg

When we issued a “call for submissions” for an amateur porn film festival fifteen years ago… well, let’s just say we had our doubts. We weren’t sure anyone would make a dirty movie for a film festival playing in the city where they lived, much less enough people to fill up a festival. We were so unsure about whether anyone would submit a film to what we were calling “HUMP!” that we announced the festival without first booking a theater. Why … Read More

How to condense date/time select queries to just show the date (and not time?)

Best Microsoft Access Programmer Portland OR

I’m combining several transaction batches into one batch table, but for one processor, my “batch date” field in it’s original table shows as a full date + time.

How can I select the dates (then append them to the master batch table,) with ONLY the dates i.e. 8/21/2019 instead of 8/21/2019 4:27 PM?

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

Microsoft Acess Developer Portland ORRead More

combo box look up query

Best Microsoft Access Programmer Portland OR

Is it possible, if so how, to use a query to pull up options for a combo box (in table view) base on one of the prior fields.

For example:
I have a table with addresses, and those addresses are associated with a customer. Each customer may have more than one address. I have a third table where they track some different things associated with the address.

Ideally I they would select the customer and then when they move to the next field they

Read More
Page 1 of 192
1 2 3 192