Recent content by psu_1995

ok, thanks for your help. I figured out how to test for a null. Not sure if what I did is the best way to code this solution, but I'm posting my code below for the benefit of others who might read this post. Set rst2 = dbs.OpenRecordset(table15, dbOpenDynaset) handle_null: rst2.MoveFirst...

I have a DAO recordset query which I am running against a table that a user can change. The query looks at one particular column in the table and if a field is blank, it pulls data into that field from another table. This all works fine except when a user deletes data from that column. The...

Thanks Paul! I don't know why I didn't see the "On Current" field before in the Form properties box. It works beautifully now.

I've been trying unsuccessfully to find a way to have some VB code run when ever the user presses the arrow buttons at the bottom of a form to move to the next (or previous) records. All I have been able to implement is something that runs when the user moves the mouse over the detail space or...

Exactly what I ended up doing. Thanks for the feedback and for helping me get out of the Excel mode of thinking! Rob

Thanks for the SQL. I've used what you wrote and notice that there's no way to add that to my existing query since by doing so expands all the orders onto multiple lines making the sum do nothing. It appears I'll have to create another query and have the results of this sum query feed back...

Sure - understood. My make-table query exports the new table to excel for the end-user whenever they execute my VBA code (on an as needed basis). I simply want to reduce the amount of excel work they're doing. What then is the best way to calculate that "as needed" in Access then?

I'm trying to add a column to my make-table query that will give me the sum total of all rows in the source table which have a matching property. For example all my orders have multiple lines and I'd like to have this column search the entire table for all the matching orders and then put the...

DCrake, Thanks for the suggestion! I'm going to tackle this code next week so I'll probably incorporate a bit of what you've suggested. Rob

Wayne, My bad - I tried your code on a different database and the code worked as advertised. I do need to build something that will compare two tables within a database, and your automation has given me some ideas - thanks for that! Rob

Well about a month has passed and I've written a ton of VBA Access code and automated almost my entire process, so I think I'm ready to tackle this more complicated issue. Thanks for the feedback and the book suggestions. I now own three books, each complimenting the others. Wayne - I noticed...

Thanks for the reply - I think I follow what you're suggesting. I do have to do this every week on large amounts of data, so I guess I'll be using VBA to automate it. I'm quite proficient in Excel VBA, but am new to Access. I guess I'll be heading to the nearest bookstore now to grab a Access...

I also have a need to compare two data tables. The unmatched query wizard is fine if you're trying to pull out extra records from one table as it only allows one comparison. However, I need a query which will compare every column in a record (a record does have an identical key in both tables)...