Microsoft Access Form Design

Joseph S
Joseph S used Ask the Experts™
on
I need help with updating my form coding on Microsoft Access to make sure everything works properly. I would prefer if someone remotely connects to my computer.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You could start with describing your problem(s).

Author

Commented:
Are you online right?

Author

Commented:
i figured out the problem, but need help resolving the problem. I have data associated with another table, and in my query when add that table it multiples to 1 million. I need help making this data it doesn't use much memory.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Distinguished Expert 2017

Commented:
When you use multiple tables or queries in a query, you must use proper joins between them otherwise you end up with a Cartesian Product which is every row of table1 multiplied (joined to) every row of table2.  So if table1 has 100 rows and table 2 has 50 rows, your resultset would contain 50 * 100 or 5,000 rows and that seems to be what you are experiencing.

Is there a column or set of columns that will allow you to join the two tables so that the resultset would make sense.
Ryan ChongSoftware Team Lead

Commented:
I would prefer if someone remotely connects to my computer.
you can try to engage with an Expert via the Live service.

https://www.experts-exchange.com/live/?headerLink=contribute_realTime
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Yes, I am live, but in the UTC+01:00 timezone.

You could list your query. Pat and others have vast experience in SQL.
Distinguished Expert 2017

Commented:
I thought "Live" was dead.  

Joseph, if you post a database with the two tables and a query, we can help you fix the join if it is fixable.

Author

Commented:
I mainly need examples based off my information,

The page is getting its source from a query not tables. The first page I have cascading and requery setup. Where you select option one from a combo box 1 and filters the option in combo box 2. Then displays more results in a list box. The list box is important, because you select the available option it needs to remember that option for the rest of the entire 9 form (pages).

Page 2
Has a 1 combo box to make selection based off the information that you selected in the listbox.

The textbox will be used to filter data The text box suppose work for example, say there data population of 15 to 80.
if someone enters 20 is 20 >= 15? T or 20 <= 80? T
If someone enters 100 is 100 >= 15? T or is 100 <= 80? F

Then it will show all the data in those ranges.

Then there are check mark box to filter the data based on whether the particular species is yes/no option. If left unchecked it will show all related data in that particular field. If check then it will filter that species with yes. There is a about 7 yes/no option to choose from.

These filter criteria on page 2 will appear on page three in a list box.

For example pages the listbox on page 3
Name, Origin, Rate, and Population needs to filter based on the information selected from Page 1 and 2.


I just need a general example on how to write the code into vba based on the Information I provided.
Distinguished Expert 2017

Commented:
i figured out the problem, but need help resolving the problem. I have data associated with another table, and in my query when add that table it multiples to 1 million. I need help making this data it doesn't use much memory.
If this is your problem, you will need to start by posting the SQL and the table definitions.  The easiest way for us to figure this out is for you to post a database with the tables involved in the query and the query itself.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial