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 Chriss Miller 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. trevil620

    SoThink DHTML Menu Conversion

    I'm helping to repair issues with a website. The owner used SoThink DHTML Menu program to create all of his menu's, but there are now a number of broken links, etc. I cloned his website, then downloaded the latest version (9.8) of SoThink DHTML Menu.... If I look at his Java Script file, his...
  2. trevil620

    New Coder Trying to upload a file from MS Access to sFTP server using Putty(unix commands)

    Comparing your code to the example shown in the link below, I see a couple of differences: 1. pHost = "xxxxx" looks wrong. 2. strCommand = ... " -scp.. vs: " -sftp... http://stackoverflow.com/questions/3754928/sftp-upload-with-vba When all else fails, manipulate the data.
  3. trevil620

    Open a password protected database where the Display Navigation Pane has been disabled

    I can't remember if you need to hold down the SHIFT key AFTER entering the password WHILE pressing the ENTER key. Anyway, take a look at the following two links and see it they help: http://www.techonthenet.com/access/database/display_navigation_pane2007.php...
  4. trevil620

    How to search entire DB for 16 digit string

    How good are you with VBA? You could write a Function that spins through all tables (or a subset that you define), then spin through all fields that could contain the pattern (can skip Boolean, Dates, etc.). I assume you may need to search for xxxxxxxxxxxxxxxx as well as xxxx-xxxx-xxxx-xxxx as...
  5. trevil620

    Access 2010 reports

    Add a new line, after 'Option Compare...' with 'Option Explicit' When all else fails, manipulate the data.
  6. trevil620

    Access 2010 reports

    Make sure all your modules have 'Option Explicit' at the top, then COMPILE to make sure there are no errors. Do you see any warning messages displayed when Access opens? Holding down the shift key was designed to allow you to bypass startup options. Than means either a setting or macro or code...
  7. trevil620

    Access 2010 reports

    What are your 'Trust Center' settings? Check those first. When all else fails, manipulate the data.
  8. trevil620

    Append more then once into temp table

    In the 'On Click' event, just add some VBA code similar to the following: Dim i as integer Dim strSQL as string For i = 1 to Me.Pieces strSQL = "...your sql..." Docmd.RunSQL strSQL Next i When all else fails, manipulate the data.
  9. trevil620

    Why can't I delete from my table?

    Having just looked at your posts again, I see "So the scenario here is that I have to run the same report for multiple criteria, which I do in a loop." Could we see the code in that loop? Specifically, how you are running the report, and other code in that loop... When all else fails...
  10. trevil620

    Why can't I delete from my table?

    In your query, is 'StoredData_Packages' a table, or is that a query? In 'DeleteTempTables' why not put an error trap, then write the error to a log so you will know exactly which table is failing? I.e. the following code: Public Sub DeleteTempTables() Dim strTable As String On...
  11. trevil620

    Excel 2007 VBA - Set Column Widths All Worksheets in Workbook plus

    The following should work... Option Explicit Sub Select_Each_Sheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Sheets If ws.Visible Then ws.Select (False) If ws.Name <> "Master" Then 'Would also like to add a line here that will add a row to all...
  12. trevil620

    Why can't I delete from my table?

    Where is your code to delete located... I see you are running a report? Does that report use that table? When all else fails, manipulate the data.
  13. trevil620

    Why can't I delete from my table?

    So, this scheduled task is on a server, and you have Office (or at least Access) installed ther, correct? First guess is check the file to see if somehow it is set as Read-Only. Second guess is does the account under which the task runs have permissions to the file and folder? Does any of the...
  14. trevil620

    Optimizing this join query

    How about adding a 'first-stage' query that selects the simple things - like "p1.type !='package'" and also "a1.cached_product_in_store=1 AND a1.block_search!=1 AND a1.type='VitalBook'". You don't mention how many records are in your tables, but if you can limit the scope of the 'like' and 'not...
  15. trevil620

    Deleted and relinked ODBC table but Access still wants old ODBC table.

    Hi John, sorry for delay - was working out instructions & removing components not associated with 'Adding Error Traps & Inserting Line Numbers in VBA Code' Here is a link to Dropbox where you will find a document explaining how to use, and an .mdb file with all of the code; there is also the...
  16. trevil620

    Deleted and relinked ODBC table but Access still wants old ODBC table.

    Yes, I can send you the program. I want to make sure it will function correctly in your environment (ADO vs DAO), so I am doing some testing. Re converting to SQL Server, I went thru the same process years ago -- so again I wrote code that would convert all the DAO stuff to ADO, plus all the...
  17. trevil620

    Runtime Error 438 - Works on one form and not another

    Here is a quick idea (gotta run an errand): pass the date as an OpenArg, then in the Form Load event, set txtDate. Short term maybe a solution; longer term you can try to figure out original problem... Back in an hour... DoCmd.OpenForm "frmBookInOut", acNormal, , , , , Format(Now()...
  18. trevil620

    Runtime Error 438 - Works on one form and not another

    What section is txtDate located in? Header, Detail, etc.? Is the field bound? Does the opened form have a RecordSource? Re "...it now fails on the next line down." what is the next line? Another Date setting? I just tried your code, but no problem..... The speculative judgment of the quality...
  19. trevil620

    Runtime Error 438 - Works on one form and not another

    I have seen issues where due to timing, the form may not be 'ready' when you try to set the txtDate field. Does the problem ALWAYS happen under certain circumstances, or SOMETIMES? If Always, I would put a breakpoint where you set the date, pause a second, then resume. Also, does the form being...
  20. trevil620

    after delete trigger

    You need to fire the trigger BEFORE the delete: Check this: http://stackoverflow.com/questions/14018982/insert-deleted-values-into-a-table-before-delete-with-a-delete-trigger The speculative judgment of the quality of an answer is based directly on … what was the question again?

Part and Inventory Search

Back
Top