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!

  • Congratulations strongm 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: *

  • Users: jmodo
  • Order by date
  1. jmodo

    doClick in html calling applet button

    I am trying to call an applet button from html. I'm calling the doClick() on the applet button. I can see the button pressed in when calling, but the action is not called. I get the error: "java.security.AccessControlException: access denied (java.util.PropertyPermission user.language write)"...
  2. jmodo

    Inner Join with another table

    I'm just adding the answer here that I found. My problem has been solved: DELETE FROM MainTable mtMaster WHERE EXISTS (SELECT * FROM MainTable mtImport IN 'C:\Table2.mdb' WHERE mtMaster.troubleCall = mtImport.troubleCall) Access likes the subquery as opposed to the inner join. Thanks for your...
  3. jmodo

    Inner Join with another table

    No luck. I was using []'s around the path ,but i switched them to ''. I am executing this within MS Access, if that helps. Thanks, J
  4. jmodo

    Inner Join with another table

    I am using this word for word, and I get a "Syntax error in FROM clause. Am I missing something? Thanks! J
  5. jmodo

    Inner Join with another table

    I am trying to replace records in one database with records in another database, where the records in both databases share a key. DELETE * FROM [MainTable] AS mtMaster INNER JOIN [C:\Table2.mdb].MainTable AS mtImport ON mtMaster.troubleCall = mtImport.troubleCall I am getting "Specify the...
  6. jmodo

    Sort Table of Contents numbering from MS Word

    Thanks! Worked great. I need to look into how the sorting algorithms work a little more later to fully understand this. Cheers! J
  7. jmodo

    Sort Table of Contents numbering from MS Word

    I'm dynamically creating a html table of contents out of multiple html files that I have. Their filenames follow the numbering scheme used by microsoft word. (i.e.: 1 Title 1.1 Title 1.2 Title 1.2.1 Title) Currently I'm sorting the numbers by $a cmp $b, but when the numbers get above 10, 10...
  8. jmodo

    Union member in a struct

    I am using the keyword union. Sorry that 'Union' was a typo.
  9. jmodo

    Union member in a struct

    I have the following code which doesn't compile(solaris). "The Union is not accessible from the struct". When I move the Union to be public, it compiles. Can anyone explain this? I'd like to keep both private if possible. Thanks! private: Union MyUnion { UObject* uobject; //other...
  10. jmodo

    free()

    Do these 2 statements do the same thing. I mean, can I reuse the variable m after calling free? I assume that I can't use n after calling delete. Thanks!!! MyObject* m; m = something; free(m); m=somethingElse; MyObject* n; n = new MyObject(); delete(m); n=something?
  11. jmodo

    Excel sum unique entries

    I'm just not sure how to add in the other condition where value=4 into the code above.
  12. jmodo

    Excel sum unique entries

    I have titles that have associated values such as Col A Col B MyTitles MyValues ____________________ Title1 4 Title2 1 Title1 3 Title1 2 Title3 4 Title3 4 I need to get the number of unique titles with value =4 Answer: 2 <- this is what I need here...
  13. jmodo

    Excel sum unique entries

    I am trying to do a unique sum of records using this code: SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1)) It works great, BUT I want to add in one more condition to see that the unique records have a matching field C=4 in the...
  14. jmodo

    returning structure instead of class::structure

    I have a couple classes. Class A and Class B. class A has a structure aStruct class B has a function that is: A::astruct myfunction(); What is the difference if I put the A structure in the B class so that the function looks like astruct myfunction(); does this not return an instance of a...
  15. jmodo

    making count a boolean

    (Select Count(*) from [A] where idA = [A].idA and [A].idB=[B].idB) I would like this to return true/false, instead of a number. All I can figure out is how to format it. Thanks, J
  16. jmodo

    Multiple Counts

    I have a few tables. A,B,C. All 1 to many relationships. A->B->C. I am trying to get the counts of how many B records there are for each A record, and how many C records for each A record. 1 record is returned for each A record. I need something like Select A.idA, Sum(Case When B.idA = A.idA...
  17. jmodo

    Form.AllowEdits

    I need the code to include subforms within subforms. I tried replicating the code to include the sub-subforms, but I can't get it to work. Can you help me a little further? Thanks!
  18. jmodo

    making a form read only

    I am trying to make a form read-only, and all of its subforms(many of them on different tabs). Is there a way to make everything read only with a single command, having the child forms inherit the parent form property?
  19. jmodo

    Form.AllowEdits

    I am trying to set this property programmatically. When I set the property manually in the form, it propogates down to all of the sub-forms, just like I want. When I set the property programmatically, it doesn't propogate down to the subforms. Is there a way to call Form.AllowEdits...
  20. jmodo

    check form label in another database

    I'm still trying to get the handle on the caption of the label. I need more than just the form reference. the frm.Label does not return a correct reference. C-D2 - there are a few versions out of a small database, and people decided to leave some of the old versions blank, so this is the only...

Part and Inventory Search

Back
Top