Recent content by plog

The form. When you use a bound form, Access does all that behind the scenes and saves you from a ton of work. You won't find the SQL anywhere, it's just inherent in what a bound form does.

No tool, needed, just a query: SELECT MAX(LEN(FieldName1)) AS FieldName1MaxLength MAX(LEN(FieldName2)) AS FieldName2MaxLength MAX(LEN(FieldName3)) AS FieldName3MaxLength ... FROM YourTableName

Best first post ever

My gut and my experience compels me to first want to know the details of this query chain and your table structure. I've come across complex query systems like this before and have always found inefficiencies. Can you post a sample database with the necessary queries and tables to feed them...

Here's what we need to help you: 1. A simple explanation of what your organization does. Pretend its career day at an elementary school and tell us what you do. Use simple terms and no database jargon . 2. Very high level explanation of what this database does for you. Use very little...

Tables: 2024 Voucher Log 2025 Voucher Log 2026 Voucher Log Just with the table names I can tell you haven't set up your tables properly. You will need to work on your table structure before you move onto forms. Post the screenshot tvanstiphout requested so we can help you with that.

Check the users post history. Been coming here for years with this database and starting threads asking for hacks to issues that exist because of the improper table structure. First couple responses are how to properly structure the tables and correctly use foreign and primary keys. Then...

1. Does it need to be like that when you enter data? Why not have a form that closer mimics your table (each row has it's own month and year) so that data just goes in and then use a report on the pivoted data when you need to present the data? 2. An unbound form and a lot of VBA...

Me again, you did a few things wrong, so I need to add more: 1. To reference a control on a form (which is a variable) you do it like this: Me.ControlName 2. Building that string you want is even more difficult when its ultimately used in a string comparison. You must surround the value in...

You are trying to build a literal string with variable parts. You can't just cram the variable inside quote marks and hope the computer knows what you are talking about. "This is a literal string because it is all inside quote marks. This is the value inside YourVariable: YourVariable" The...

First, do you need to use Access? A lot can be accomplished with Pivot Tables in Excel. Why structure a database, build APPEND/INSERT queries to populate your tables, build SELECT queries to feed reports and then build reports if you can build a much simpler process in Excel? What do your...

Apology and thanks accepted. When you want to hardcode SQL inside VBA you should first get your SQL correct by using the query designer. That's the tool to use to debug your SQL. Once it works you can extract the SQL and paste it into your VBA code.

1. You make it so much harder to debug SQL when you have it in VBA. It's like a game of telephone you have to play to get to the SQL. What exactly is the SQL in sQry? 2. Why is there an alias in that thing? That makes it even more harder too. If there's only one datasource in the FROM...

Ugh.

Big picture--the thing you are doing wrong is you are treating Access like it's a spreadsheet. Here's your fields: That's not how databases work. In that 1 screenshot I see 2 huge errors: 1. If you are going to add/subtract fields together (like you do to all those _Disbursement and...