Recent content by Mossoft

Why doesnt Sourcesafe appear on the list of remote Info|Access list in MX2004? As far as I can tell, the only requirement is to have Sourcesafe 6 installed, which it is. Even if it isnt on the list, can I still use SS by adding an extension?

You could try using the 'NET TIME' command in a dos window i.e. Shell to it, pipe the results to a text file then read the file. Call Shell("NET TIME \\WorkstationID > C:\RMT_TIME.TXT" ) Open "C:\RMT_TIME.TXT" for input as #1 etc... M :-)

Access 2000 uses the Office 2000 AutoCorrect facility. This enables ham-fisted users to carry on knowing that pre-defined errors will be corrected when they mis-type data in text boxes etc.. This facility can be turned off by setting the 'Allow AutoCorrect' property of the text boxes. The...

All menu items have a unique ID. This code will give you the ID for a given menu option: e.g. FindMenuID "&Paste" will display the ID 22. Sub FindMenuItemID(strCaption As String) Dim cb As CommandBar Dim cbc As CommandBarControl For Each cb In...

I have done a similar thing calling an Oracle SP from VB, but too much code to put here. It involved various calls to the ODBC.DLL library: SQLAllocStmt SQLPrepare Parameter binding using: SQLBindParameterString/Double/Long/Integer SQLExecute Get the output parameters (if any), then tidying...

I think what you need to do is: Create a recordset of the data in the database. For each record in a recordset, use VLOOKUP to try and find it in the first worksheet. If it isnt there, add it to the second worksheet. HTH M.

dbOpenDynamic only applies to a ODBCDirect workspace. You are using a Jet workspace. Use dbOpenDynaset instead. M *<:-)

Const Insert_Text = &quot;`&quot; With Selection .EndKey Unit:=wdStory Do .HomeKey Unit:=wdLine .TypeText Text:=Insert_Text .MoveUp Unit:=wdLine Loop Until .Information(wdFirstCharacterLineNumber) = 1...

The SQL cannot be applied because it contains a field name that does not exist in the table. So it is assumed that the unknown field is actually a parameter and will have been supplied. As Jebry says: Check the field names. M.

Text boxes are Shapes. Dim shp As Shape With ActiveDocument For Each shp In .Shapes shp.Select Selection.Collapse wdCollapseStart Debug.Print shp.Name & &quot; is on Page &quot; & Selection.Information(wdActiveEndPageNumber)...

Using dbOpenTable tells Access that your strSQL is the name of a table that it will try to open. It isn't!! Try using dbOpenDynaset or dbOpenSnapshot depending on whether you intend to amend the data or not. M.

You could hold ALL the text in a Word table, a cell for each precident. Create a userform, in Word, that has a number of check boxes on it, each relating to a particular cell of the Word table. The user would check or uncheck the necessary boxes then push the 'go' button. A macro could delete...

Set Rst1 = CustDb.OpenRecordset(&quot;SELECT firstName , secondname , a1 , a2 , customerid From dbo_tblcustomer&quot; & &quot; ORDER BY firstname&quot;, ,dbSeeChanges) dbSeechanges is an &quot;Options&quot; value not a &quot;Type&quot; value so has to be third parameter. Also probably need...

I have an issue where a query in Access 2000 Runtime runs differently to Access 2000 (development). In Access 2000, if a query has a parameter that has a function applied to it, the default order of events is: Access 2000 requests the parameter, then the function is applied to the parameter...

Set a reference to DAO 3.6 object library then use something like: Dim qry as DAO.QueryDef Set qry = Currentdb.QueryDefs(&quot;<query name>&quot;) With qry .SQL = &quot;SELECT blah blah&quot; <set other properties of query here> End With M.