Search results

Yes

This is part of the the problem I had in this post https://www.access-programmers.co.uk/forums/threads/how-to-make-an-upsert-query-using-another-query-as-the-source.326564/#post-1864528 ItemsSql is read only but wanted to update and/or append tblITEMS. The filtered recordset will capture the...

Thanks, that did it. Is this the correct way to filter a recordset in vba?

I'm now trying to learn Recordsets so bear with me. Dim db As DAO.Database Dim PrimaryTRS As DAO.Recordset Dim ItemsRS As DAO.Recordset Dim NewItemsRS As DAO.Recordset Dim ItemsSql As String Set db = CurrentDb Set PrimaryTRS = db.OpenRecordset("tblItem", dbOpenDynaset) ItemsSql = "SELECT...

I use Sage as my accounting software but NEVER do data entry in it. I have all the employees use Access or Excel (depending on their experience) to do Data Entry then run some queries to filter out errors and trust me you will get errors when people who are not too familiar with spreadsheets are...

You all have some pretty impressive resumes. To all the members, is Access your go-to solution for database user interface and/or management? I think nothing can beat MS Access connected to an SQL Server. I've used a couple of accounting, inventory and payroll software but nothing can beat MS...

Hope cancel culture don't loose their mind over this statement but I always thought that @Pat Hartman was a guy 🤯🤯🤯. Ma'am you are very versed and know your stuff. Hats off to you 🙌

Just wanted to provide additional information on the Overflow Error. In addition to making sure your joins are properly done, whenever Aggregating Queries ALWAYS remember to filter out Nulls and Errors from the field being Aggregated. In your table design, if you are certain that a field will...

Sorry about that. Point 2 answered the question I should have asked initially. "Where should the Action Query exist?"

Hi everyone. Just wanted to get an idea of everyone's development style. Action Queries, do you all (the more seasoned developers) prefer to type out the SQL in VBA or create the query GUI and refer to it and why?

I'm kinda lost on the thread but for the OP which is normalizing the tables, why do you have a Products table and a ProductDetail table? I would have a Products Table set up like in post #18 capturing all the Product Identifier(s), A Purchase Table to capture the Product Cost and a Price Table...

You should be able to filter the calculated field providing the formula is sound. What type of results is the Calculated field? Numeric? Text?

Can you explain a little more?

Calculated fields are Read Only. Also, I don't recommend data entry directly to the table. To achieve what you want you may need to use forms.

Poor Accounting practice. (Using multiple cheque books at the same time that is.) So @Pat Hartman, once you open the recordset within a loop it remains open until the loop is finished? As I said before, I don't fully understand recordsets as yet.

Just wanted to share the code I added to my database (all credit to @arnelgp) for finding missing numbers in a sequence. Dim rs As DAO.Recordset Dim db As DAO.Database Dim MAXCHQ As Long Dim i As Long MAXCHQ = DMax("CHQNUM", "CHQREGISTER") ' get the max cheque...

This is perfect @arnelgp Thank You.

@arnelgp that was along the lines of what I'm thinking to do. I know it can't be done with a query so I was thinking something along the lines of this in VBA. Instead of creating the tables..... Step 1 - DMax the cheque register to get the largest Cheque Number Step 2 - Create a Recordset from...

Hello all, I am trying to make a query to get numbers missing in a sequence. So far I've used this SELECT CHQREGISTER.CHQNUM, (SELECT TOP 1 T1.CHQNUM FROM CHQREGISTER AS T1 WHERE T1.CHQNUM = CHQREGISTER.CHQNUM+1 ORDER BY T1.CHQNUM ASC) AS SEQ...

Ah, I see. Ok, understood. It will be impossible to get AVGITEMCOST editable, well because you've seen the design. Because of the variations of Items produced, AVGITEMCOST is being used to categorize it. Then again, thinking about it, I can put all the tables into one and eliminate the union...