Recent content by plog

There's really no general help for this, it's gonna have to be specific to your instance. That means we need details. Preferably a sample of your database and a mock up of what you expect your dashboard to look like when finished.

Yes. No append query needed,this can all be done via forms. You should build a form with combo boxes that show the user text but store the id. You would have a main form that displays 1 property. It's information would be at the top of the form and at the bottom would be a continuous subform...

Actually two sets of sample data is best: A. Starting data from your tables. Include table/field names and enough data to cover all cases. B. Expected results of A. Show us what data you expect your query to return based on the data you provide in A. Again, 2 sets of data--starting and...

Those are two different things. You absolutely can ask for the maximum value of a field: SELECT MAX(YouriD) AS MaxID FROM Your table Now if you want the rest of that record's data, you would use that query I posted as the basis of another query joined to Your table to get that record's...

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...