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

    SQL Server to control MS Access?

    Have come up empty in searches so far. Does anyone know if there is a way to instantiate and control an MS ACCDB from SQL Server (2016 in this case)? I was thinking maybe APIs, command shell, etc.? This is not my area of expertise. The request is to automate some end-user ACCDBs that have...
  2. genomon

    ComboBox in VB from Access DB

    As far as I know you cannot show "a table", but you can show its fields in a CBO. Beir bua agus beannacht!
  3. genomon

    Application-defined or object-defined error

    Have you tried setting oProgress = Nothing between instantiations? Beir bua agus beannacht!
  4. genomon

    Opening access 2003 .mdb file

    Or there could be an .ldb associated that needs deletion. Beir bua agus beannacht!
  5. genomon

    cannot connect to sql view

    Agree. Use underscore, or alias the column name in the view to something that follows syntax rules. Beir bua agus beannacht!
  6. genomon

    One Subreport and Many Subreports in One Report

    Try grouping the report by manager, and linking the subreport to the (group header) manager in the detail section. Beir bua agus beannacht!
  7. genomon

    Enumerate Grouped Records in a Query

    Post the SQL behind the query - specifically the ORDER BY clause... Beir bua agus beannacht!
  8. genomon

    Paid travel

    We pay a per-mile traveled standard rate. Beir bua agus beannacht!
  9. genomon

    Take photo from Access form

    Might be some help here? https://social.msdn.microsoft.com/Forums/en-US/9c110f5e-ce8c-40cc-9baa-436956e26e45/capturing-photos-in-ms-access-using-vbvba?forum=isvvba Beir bua agus beannacht!
  10. genomon

    customising icons

    Is this what you are after? C:\Program Files\Microsoft Office\Office12\FORMS\1033 then look for .ico file extensions. Beir bua agus beannacht!
  11. genomon

    Application server can't be accessed any more

    Have you tried this? http://www.mydigitallife.info/how-to-flush-and-reset-dns-cache/ Beir bua agus beannacht!
  12. genomon

    Query Help

    Does Master ID1 mean the same thing as Master ID2? Beir bua agus beannacht!
  13. genomon

    64-bit\Updated VB6 Project

    Interesting. Thanks for sharing! Beir bua agus beannacht!
  14. genomon

    Append query doesn't work but no errors are generated

    I don't see where the parameters are declared. Any help here? https://msdn.microsoft.com/en-us/library/office/ff193967.aspx Beir bua agus beannacht!
  15. genomon

    Pivot Table Seems to get corrupted when updating the pagefields with VBA

    Could it be a refresh issue? There are settings and VBA to look at here: http://www.ozgrid.com/VBA/pivot-table-refresh.htm Beir bua agus beannacht!
  16. genomon

    Will VB6 Run on Windows 10

    There are some results posted here: https://social.technet.microsoft.com/Forums/en-US/cb13744c-0763-42fb-8a65-81e600e25643/vb6-com-support-in-windows-10?forum=WinPreview2014General Beir bua agus beannacht!
  17. genomon

    How to search entire DB for 16 digit string

    Regarding this specifically, have a look at the Replace() function to eliminate spaces and hyphens in your search criteria. Beir bua agus beannacht!
  18. genomon

    Problems assigning a NULL value to a variable

    Or Nz(!ast_desc_2, "") ?? Beir bua agus beannacht!
  19. genomon

    Is There Any Way to Retrieve an Embedded Picture on an Access Report?

    Can you back up the report, open in design view, remove the table fields, then copy and paste the image into a new blank report? Or paste into a Word doc and save that? Beir bua agus beannacht!
  20. genomon

    Preview report with copy and paste ability

    Have you tried publishing the report with Word and then copying? Pretty sure this cannot be done from Access. Beir bua agus beannacht!

Part and Inventory Search

Back
Top