Search results for query: *

Oops.. I found it. You can use a query as a filet. Thanks Simi

Ok, so I am looking at someone else's code. They have used a filter on a form. But the filter is like DoCmd.ApplyFilter "NameOfaQuery" I don't see any documentation that you can use a name of a query as a filter. I assume it is just taking the criteria from the query and applying it to the...

Hopefully you know the SA password. You would try to login with username:SA and that password. Simi

Skip, Thanks for all the help, you're a legend. Simian

Done correctly, it is always better to work with a smaller dataset. Query just what you need and then bring it over to Excel. Simi

Comment out the On Error statement, then run the code. It should show you the error and you will see where the code breaks. Simian

Looks like it might be the cell border. You will have to check the cells both left and right of the line. Highlight a cell. Right click the cell choose FORMAT CELLS. Click the BORDER tab at the top. Look in the Border diagram box on the bottom right side and see if there is a dotted line...

We have had tons of problems with Win 10 1809. We had started a company wide upgrade to Win 10 with 1809. It failed and we had to drop back to 1803. We had not experienced any Access problems but tons of Excel problems. Simian

The error indicates that one or more of the columns you created are not long enough to store the data that would be imported into the field. Make you Columns longer and that may fix the problem. Simian

A couple of questions here to help nail down what your look for. You posted this in Microsoft SQL Server: Integration Services (SSIS) Forum so I am guessing you are planning on using SSIS? 15k at a time with some time interval in between? Is there another column like ID that numbered? Is...

The above code would work if email is blank or not. However you can just updated it with the new email.... update payee set email = 'user@domain.com', email_summary = 'Y' where id IN (select id from drs_payee where factoring_company_id = 'OTRCCHIL') Simi

I have done it both ways. I had a project where the user was shown all there records in a table view so I just did what you are doing here and inserted a record a the bottom with the totals. However that was many records. Simi

Try This... SELECT TOP (100) PERCENT GBL_ADMIN.dbo.ASSET_TYPES.ACCOUNTING_ENTITY, SUM(dbo.ASSET_INFO_DETAILS.VALUE) AS TOTAL_VALUE FROM dbo.OWNERS INNER JOIN dbo.ASSET_OWNERSHIP ON dbo.OWNERS.OWNER_ID = dbo.ASSET_OWNERSHIP.OWNER_ID INNER JOIN dbo.ASSETS ON dbo.ASSET_OWNERSHIP.ASSET_ID =...

Yes, In SSMS look at TOOLS > Code Snippets Manager. Simi

so how many records do you get if you run this... select T1.price, T1.TrDate, T2.price, T2.EffectiveDate from TransactionTbl T1 INNER JOIN PriceTbl T2 on T1.ProductId = T2.ProductId where T1.TrDate > = T2.EffectiveDate Simi

This might be what you are looking for... Forms("ParentForm").Form.Controls("FieldOnTheParentForm").Value = Me.Controls("FieldOnTheSubForm").Value Simi

I would say that if you are comfortable programming in Access, I would keep it there in Access. I would not bring in a third component unless I had too. Simi

You want a sum of all of them or by dbo.Product.ProductID or dbo.Product.ProductCode? Simi

Hey, Do a google search on "FOR XML PATH" examples... It will let you combine them. I have to do them for people that have multiple phone numbers. Simi

Off topic, but a few little style changes would make your code so much easier to read.... SELECT dbo.Product.ProductID, dbo.Product.ProductCode , dbo.Stock.StockActual, dbo.ProductPack.TotalVolume , dbo.ProductPack.PackStatus, dbo.ProductPack.Deleted FROM dbo.ProductPack INNER JOIN dbo.Stock...