[Question] Modifying Lookup behavior based on another field item’s value

Best Microsoft Access Programmer Portland OR

Hello, I have a question regarding modifying Lookup behavior based on the value of another field item’s value.

Field 1, let’s call it “listX”, is a Lookup List consisting of two items; ‘x1’ and ‘x2’.

In a seperate table there are two more Lookup Lists; ‘x1_TRUE’ and ‘x2_TRUE’.

What I want to do is modify the Lookup source for the second field item based on the value of the first field item.

Basically the logic I want to execute is as follows:

if listX.ID

Read More

Take your Medicine.

Best Microsoft Access Programmer Portland OR

by Anonymous

Every time I hear someone tell me that they left Portland for greener pastures in the suburbs because the city is a cesspool I want to punch something. In so many ways, outlying communities export their social problems to the urban core, preferring to absolve themselves of the burden of actually addressing homelessness in their communities and instead push the needy and destitute inward toward the city where the status quo tells them those problems actually exist. I’m sure that in your … Read More

Access Help

Best Microsoft Access Programmer Portland OR

I have not really done any projects with access and in fact the person who was teaching me the course said it is becoming irrelevant. I know there are a few ways to compose tables given different fields; however, I believe I am overthinking an example and just confusing myself even further. Here is the scenario given these fields:

CustomerID, CustomerName, DateofBirth, Address, TransactionID, ItemBoughtID, ItemBought, AmountSpent, BusinessID, BusinessName, BusinessAddress, TransactionDateTime, ItemPrice

How many tables would I compile? First I thought only three tables,

Read More

Access Help

Best Microsoft Access Programmer Portland OR

I have not really done any projects with access and in fact the person who was teaching me the course said it is becoming irrelevant. I know there are a few ways to compose tables given different fields; however, I believe I am overthinking an example and just confusing myself even further. Here is the scenario given these fields:

CustomerID, CustomerName, DateofBirth, Address, TransactionID, ItemBoughtID, ItemBought, AmountSpent, BusinessID, BusinessName, BusinessAddress, TransactionDateTime, ItemPrice

How many tables would I compile? First I thought only three tables,

Read More

form that passes parameter to query

Best Microsoft Access Programmer Portland OR

form that passes parameter to query

I have a form with an unbound combo box pulling information from a table field. This combo box works. I have a simple query that correctly pulls information when the criteria lines are empty. When I attempt to like the query to the combo box, I use the builder function and enter the combo box into the criteria field on the query. I have tried it just adding the combo box and also with a like * statement to see if I

Read More
Page 1 of 470
1 2 3 470