Recent content by plog

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

Never use FIRST, LAST, DFirst() or DLast(). They just don't work like you think they do. You're post drowned me in code and irrelevant details, so I am not clear how to help you specifically, so I will in general. In general, instead of LAST in a query, you should build a subquery using MAX...

My advice is dive in. Seems like you have a good enough grasp of things to get started. Open up Access and set up the tables and fields you think you will need. Then complete the Relationship Tool in Access, expand all tables in it so you can see all the fields, take a screenshot of it and...

It sounds like you know vacancies and then you assign candidates. So I would stick with the main form being based on (one record from) Vacancies and the subform based on (many records from) Candidates...

What's your real world workflow? 1. How do vacancies come about being entered in the database? A bunch at a time or just one every so often? 2. How do candidates come about being entered in the database? A bunch at a time or just one every so often? 3. Who enters vacancies and candidates...

Yes, sort of. Broad strokes--I don't do this once-- I build a process to do this and make that process airtight. Once the process is built it, I run it one final time and have full confidence the data will migrate succesfully because I have worked out the kinks and fixed all the data. That...