Search results for query: *

Hi all, I am trying to add a VBA check to a TextBox object to ensure that I don't end up with duplicate records in an existing Access97 database (I can't change "Indexed" property in the table to "Yes (No Duplicates)" because the table is linked). I have searched Tek-tips...

Hi all, I'm stepping out of the norm into API stuff that I know very little about. I need a macro to show me the Open Document Dialog box, select a Word file, copy all the data in the Word file, and paste the data into an Excel workbook. Please. I also need it to not paste the data all into one...

Hi all, I have a data type issue here with my code (according to the compiler) at line 7 (For colID = ...). Sub rcbTrim() Dim colIDArray Dim colID colIDArray = Array("B", "E", "G", "I", _ "K", "M&quot...

Hi all, Hope you can help, please. I need to COUNT and SUM items for specific dates, i.e: Col A Col B No. of Items Date 45 31/02/03 67 31/02/03 1 31/02/03 19 24/12/02 12 24/12/02 2 24/12/02 37...

Hi all, Please can someone me with 2 problems I'm having with macros in Excel 97. How can I input the items in the AutoFilter list into an a array so that I can manipulate the data grouped by the AutoFilter list. Basically, if I had a column with a few 1s, 5s, and 8s in it, then AutoFiltered...

Hi all, OK. I'm about to crack here. I have written an applet. Included the <applet> tag in my html file but the applet won't load. I know that my classpath, etc. is correct because when I use appletviewer it works. I am using 1.3.1 and I have the plugin installed. We are working on a NT...

Hi all, Please look at this code: jbtnAddVAT.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { double addOriginal = (Double.parseDouble(jtxtAddVAT.getText())); double addFinal = (addOriginal + (addOriginal * 17.5 / 100))...

Hi all, Please can you help with this &quot;simple&quot; problem. I need to open a JFrame from an JApplet with multiple components. The code I have so far is: JApplet: In constructor: jbtnAdd.addActionListener(this); In method: public void actionPerformed(ActionEvent ae) {...

Dear all, What am I doing wrong here. If I input, say, 1025 then I get 49 as my netCost. Why is the program changing my figure. This is driving me up the wall. I have the feeling, I'm making a very simple error, I just have no idea what it is Thank you in advance and Merry Festive Season...

Hi all, Please can someone help me. I need to create a series of JComboBoxes that are dynamic (the list in JComboBox2 must change depending on the sellection in JComboBox1). So, basically, if the value in JComboBox1 is &quot;A&quot;, JComboBox2 lists &quot;Apple&quot;, &quot;Orange&quot; and...

Hi all, Help please. I need to be able to call a function from within a function. Basically, I have a JavaScript menu, and I want one of the menu items to call a function that opens a special window (that will have a Web page inside). So far I have this: In &quot;menu.js&quot; I have the...

Hi all, Before you lynch me, I know that this may not be the right place to post this. But, I am coding an Intranet site for my company, and would like to have a chat room and a couple newsgroups. I am coding in DHTML and Java (the two languages I know). The problem is two fold. 1. The network...

Hi all, I am using Word 2000 and I need to be able to hide/unhide 3 tables using 3 radio buttons. i.e.: rb1 unhides tbl1 and hides tbl2 & tbl3, rb2 unhides tbl2 and hides tbl1 & tb3, etc. Can anyone please help me with this? Any help will be greatly appreciated. Thank you in...

Hi all, Up until now I have only developed in Java on a Win98 box, but now I have to complete a project on a WinNT network. My problem is that my html page &quot;cannot find class ****&quot;. I have no problem running the applet through Appletviewer or JDK Commander, but cannot run it directly...

Hi all, I am rewriting a database with Access 2002 that was originally written with Access 97. I get a &quot;User-defined type not defined&quot; error. Here's the code: ... Private Sub cbxClient_AfterUpdate() Dim strSQL As String, strRestrict As String Dim v As Variant, lngX As...

Hi all, On my site I have a javascript menu. With 1 of the links I'd like to open a remote window (for site searches). The menu item: menu[0][2] = new Item(' Dictionary', 'dictionary.htm', '', 60, 10, 0); I'd like to replace &quot;dictionary.htm&quot; with this script: function remote(){...

Hi all, I am designing a Web site for my company on their Intranet. I need to put a &quot;dictionary&quot; on the site so employees can look up technical terms. I can do this in Java, but is there another way. It has to be fast. No CGI or Perl. Everything must be internal (security). Any...

Hi all, I have a problem. I've designed a Web page in Dreamweaver 4. Everything looks good except that I have about 400 pixels of space at the bottom of the page, and I cannot (for life in me) get rid of it. Any ideas? Thanks in advance.[dazed] &quot;Finish what you started&quot;

Hi all, I have seen this done before, but have no idea how it's done (and now I cannot seem to find an example). How do you display a Excel Worksheet in a Web page? Thank you in advance. &quot;Finish what you started&quot;

Hi all, Is there a way to move a folder (or file) on my system using VBA (using the file system object). Help will be much appreciated. Thanks in advance.