Search results for query: *

Hi, Over a year ago I wrote an Add In for Access 97. I password protected the ASdd-In which I recorded. However, I can recall how to unlock the Add - In for editing. In the VBA Editor I double-click on the Add In which responds correctly with 'Project Unviewable'. Ithought this action...

Hi I am using the Common Dialog Controls: FileListBox, DriveListBox and DirListBox (es) to select and launch applications. Whilst the process of displaying all folder files in the FileListBox is straight forward I am having difficulty getting application files (Access .mdb) to launch when...

Hi I have completed an application using VB6 and DAO rather than ADO recordsets. There are various requirements to display the retrieved data on a Form (as in the Access Report Generator) for subsequent viewing and printing. I am having problems getting the report - named 'drSubscriptionsLog'...

Hi, I hope I phrased this post correctly, possibly not! Currently I have a dBGrid object which is data bound to a DAO recordset on the same form. The recordset datMembers' is linked to 'tblMembers' in the back end MSAccess98 database using a 'Dynaset' type recordset. All works fine! However...

Hi, I am having difficulties with what perhaps should be a simple VB programming task, using the ShowOpen Method of the Common control dialog box. I have looked at many beginner books and have reduced the coding to the following to help debug the code. I have attempted to use a filter to open...

Hi, Is it possible to use a text box (list box?)to provide an on-screen 'real-time' record of data samples produced by my application. An A-D convertor is sampled every 0.5 sec and I would like to record the 'normalised' 8 bit binary data I have converted to decimal with a system 'time stamp'...

Hi Can you help with the following timer code. I am using it to introduce a delay in my USB interface application which makes write 'calls' to a hardware USB digital/analogue interface via a DLL (supplied with the hardware. The code will introduce delays (i will need to experiment here)...

Hi, I just installed a Samsung 250Gb HDD (Slave) into my PC. The maximum address range which appears in the Computer Management Console is only 128Gb. The PC's BIOS correctly reports the products capacity as 250Gb at start up. I have not formatted or partitioned the drive yet - I was going to...

Hi, I am unsuccessfully trying to delete all underlying records in a 'back-end' Access 97 database table (Stock) using the SQL 'DELETE' command. I have the following code attached to the click event of a command button on a VB Stock Data Entry / Modification Form: datstockReorder.RecordSource =...

Hi, The following code is called up on the click event of a 'spellcheck' button and relates to one of three text frames on a Data Entry/Validation User Form. Problem is, it will correctly identify a spelling error but is incapable of highlighting actual spelling error(s) in the frame in focus...

Hi, Is there a simple way of determining whether a spreadsheet worksheet contains no data values, labels etc (ie Is literally BLANK!). I suspect you could test a specific cell or a range of cells, but is there a more elegant way in Excel' s object model to achieve this, I have tried using...

Hi I have created a User Form as an xla Add In. I want the form and some features to execute via a custom menu (show User GUI etc). The code below returns ' Error 91: Object Variable or With Block Variable Not Set'when xla is loaded at line '***'. The subroutine is launched by the...

Hi, I have created a Microsoft Excel xla add-in to provide portability of a GUI Interface developed using Excel' s VBA 'User Forms'. The problem is the form loads automatically when the workbook loads, however if the form is closed (unloaded)in current session there appears to be no means of...

Hi I have written a VBA application using a single Form object in excel and want to re use the same form in other, separate Excel files. The Form is basically a GUI viewer used to input, validate and view data for each 'record', but does have other more complex functionality and presentational...

Hi Can anyone help me resolve this problem. I have configured a simple peer-peer nework using OS Win Xp Pro SP2. Having resolved issues relating to ICS with the help of Tek-Tip collegues, I now find (problem is UNRELATED - this requirement is an extension of network capability) that the host...

Hi I have a simple 2 computer peer-peer Win Xp Pro network in my home. The 'primary' PC connects to ISP via Broadband router fine to my ISP using IE 6. The network also works fine locally - file sharing etc. I can successfully ping in either direction between 'Primary PC' and 'client'. Fixed...

Hi Is it possible to enable the properties of the right mouse click in a user-form text box in Excel. This feature is enabled in VB(6) but does not appear to be available with VBA text box objects. This simple (Copy/Paste) feature will enable users to easily move text between Excel and a 3rd...

Hi I am having difficult programatically accessing - and therefore being able to change the properties of this type of object - and objects placed on each of two 'pages'within it. For example, frmCommentsTargets is the UserForm: frCommentTargets is a frame on the form. The multipage object...

Hi I am trying to re-use VBA project code that I have now successfully created to implement a common data entry/validation environment for all workbooks. I have attempted to use the following approach to importing the module and user form files ino the current workbook from the common 'master'...

Hi, Ive programmed an existing spreadsheet application to use an Excel User Formform as a means of user friendly data access (like Forms in MS Access)with good data validation across a range of data types. The forms works fine and I can successfully add/delete/amend undeling 'Field' data...