Search results for query: *

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

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.

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

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

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

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

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

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.

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

...strTable As String On Error GoTo Error_Trap DoCmd.SetWarnings False strTable = "TEMP_ApplicationPerWeek" DoCmd.RunSQL "DELETE * FROM TEMP_ApplicationPerWeek;" strTable = "TEMP_AverageTimeToClose" DoCmd.RunSQL "DELETE * FROM TEMP_AverageTimeToClose;" strTable =...

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

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.

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

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

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

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

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

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

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

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?