One Year After Titi Gulley’s Death, Her Family Is Left With the Same Questions

Best Microsoft Access Programmer Portland OR

One Year After Titi Gulley’s Death, Her Family Is Left With the Same Questions
by Blair Stenvick

Titi Gulley, left, with her mother, Kenya Robinson.
Titi Gulley, left, with her mother, Kenya Robinson. Photo courtesy of Kenya Robinson.

Editor’s note: This article references suicide and alleged anti-trans violence, and may be unsettling for some readers.

When Minneapolis police officers killed George Floyd in May, video footage of the murder set off a global wave of protests against police brutality and racism—protests that are still continuing in many cities, including Portland. In addition to demanding justice for Floyd, the protests have also brought renewed attention to other … Read More

One Year After Titi Gulley’s Death, Her Family Is Left With the Same Questions

Best Microsoft Access Programmer Portland OR

One Year After Titi Gulley’s Death, Her Family Is Left With the Same Questions
by Blair Stenvick

Titi Gulley, left, with her mother, Kenya Robinson.
Titi Gulley, left, with her mother, Kenya Robinson. Photo courtesy of Kenya Robinson.

Editor’s note: This article references suicide and alleged anti-trans violence, and may be unsettling for some readers.

When Minneapolis police officers killed George Floyd in May, video footage of the murder set off a global wave of protests against police brutality and racism—protests that are still continuing in many cities, including Portland. In addition to demanding justice for Floyd, the protests have also brought renewed attention to other … Read More

Saving the Subform IDs

Best Microsoft Access Programmer Portland OR

Hello guys, thanks a lot for helping me out last time. It gave me a totally different perspectives on the further development of my project and I took the new perspective up.

But I am facing another problem.

I have main form M and a continuous Subform S. S contains list of products that are selected using a combobox.

I need to list all the Product IDs in S and store it in a memo box in M with each Product IDs separated with

Read More

Saving the Subform IDs

Best Microsoft Access Programmer Portland OR

Hello guys, thanks a lot for helping me out last time. It gave me a totally different perspectives on the further development of my project and I took the new perspective up.

But I am facing another problem.

I have main form M and a continuous Subform S. S contains list of products that are selected using a combobox.

I need to list all the Product IDs in S and store it in a memo box in M with each Product IDs separated with

Read More

Good Morning, News: ICE Boots Foreign Students, Breonna Taylor’s Family Sues, and Oregon Prison Sees COVID-19 Outbreak

Best Microsoft Access Programmer Portland OR


by Alex Zielinski

We need your help. The economic fallout of the coronavirus crisis is threatening our ability to keep producing the quality reporting you’ve come to love. If you’re able, please consider donating to the Mercury.

GettyImages-1223057715.jpg
Brandon Bell / Stringer

Good morning, Portland! Here are a few news bites to chomp on before starting your day.

Closed Borders Down Under: Australia is taking the drastic step to close the borders of Victoria, one of the country’s most populous states, to prevent the spread … Read More

Migrating Access to sharepoint and powerapps

Best Microsoft Access Programmer Portland OR

My agency uses Access databases on a shared drive. The data sources we use are imported text and excel files. We will no longer have access to the shared drive and have been told to migrate our data to sharepoint and use powerflow and powerapps. From what I have read we should not store the access databases on sharepoint.

Our tables are too large for sharepoint lists so we would have to export to excel or text and then upload to sharepoint. I don’t

Read More

Adding record to table via combobox and button

Best Microsoft Access Programmer Portland OR

Hello! I once again can’t seem to find the right answer via google, and I’m not sure if this can be done.

I have a form that has several sub forms etc. All of these are linked based on the EmployeeID that is currently selected for the main form, which is linked to the main Employee record table (tblEmployee).

I have a separate table of locations that the Employee has worked (tblLocations). What I would like to do is have a subform with either

Read More

Open form with multiple filters with a button

Best Microsoft Access Programmer Portland OR

So I have this vba code

Private Sub Command145_Click() DoCmd.OpenForm "FormOfTable1", acViewNormal, , "[AverageOfQuantity] < [SampleSuperstoreForm2]![articles]![AverageOfQuantityCBO]", acNormal DoCmd.SetOrderBy "AverageOfQuantity DESC" End Sub 

where I will open the form called “FormOfTable1” from the form “SampleSuperstoreForm2”, but before, I will be asked to filter it based on the AverageOfQuantity of each Customer with the help of the combo box called “AverageOfQuantityCBO”, and then AverageOfQuantity is ordered in a descending fashion.

How could I add two filters before opening the form, in order to filter based on

Read More

What is the proper way to clear out a report’s recordsource/filter/orderby properties so we can open it with different recordsets?

Best Microsoft Access Programmer Portland OR

Below is an example of what I’ve done.

 DoCmd.OpenReport "CI_Report", acViewReport Reports!CI_Report.Report.recordSource = "ITR_CI_Open" Reports!CI_Report.Report.Filter = getFilterFromITRForm Reports!CI_Report.Report.orderby = getSortFromITRForm Reports!CI_Report.Report.OrderByOn = True Reports!CI_Report.Report.filterOn = True 

In this example CI_Report was opened on a prior form with it’s own filter and query. But now when we try to open the report, occasionally the old filter will get “stuck” and pop a message box saying we’re missing a field. As a possible solution I tried to set the filter to an empty string and filterOn

Read More

Open form with multiple filters with a button

Best Microsoft Access Programmer Portland OR

So I have this vba code

Private Sub Command145_Click() DoCmd.OpenForm "FormOfTable1", acViewNormal, , "[AverageOfQuantity] < [SampleSuperstoreForm2]![articles]![AverageOfQuantityCBO]", acNormal DoCmd.SetOrderBy "AverageOfQuantity DESC" End Sub 

where I will open the form called “FormOfTable1” from the form “SampleSuperstoreForm2”, but before, I will be asked to filter it based on the AverageOfQuantity of each Customer with the help of the combo box called “AverageOfQuantityCBO”, and then AverageOfQuantity is ordered in a descending fashion.

How could I add two filters before opening the form, in order to filter based on

Read More
Page 1 of 724
1 2 3 724