Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. simian336

    DoCmd.ApplyFilter Question

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

    DoCmd.ApplyFilter Question

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

    Backup/Restore DB from SQL issues

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

    I'm saying mostly goodbye

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

    MS Access to Excel: Processing of Original Data

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

    The expression On Click you entered as the event property setting produced the following error: ..

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

    Additiona colum in excel download

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

    Access 2010 is crashing after Windows 2010 1809 update in Lan

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

    Unable to Import data in .csv file using 'SQL Server Import & Export Wizard'

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

    Extract data in blocks of 15,000 from outside server to my SQL database

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

    writing sql script to update fields

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

    SQL View Help

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

    SQL View Help

    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 =...
  14. simian336

    Using the same scripts over and over again

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

    UPDATE SQL - shows updating more then required record?

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

    Reference subform on parent form with command button

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

    Append and update SQL table (is this an SSIS task or VBA) within MS Access?

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

    Query Problem

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

    Assembling Multiple Values from a Cross Join into a single field.

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

    Query Problem

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

Part and Inventory Search

Back
Top