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 bkrike 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
  • Content: Threads
  • 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 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...
  3. 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...
  4. 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...
  5. 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?
  6. 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...
  7. 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...
  8. 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
  9. 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...
  10. 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?
  11. 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...
  12. jmodo

    check form label in another database

    I am opening a connection to another database and I need to check the text in one of the labels on form X. I'm not sure how to go about getting a hold of the label object to check the text. Can I do this via connection properties, or do I have to open the form to get to the property? How would...
  13. jmodo

    Tools->Startup->Application_Title code reference

    I am trying to access this reference via code. also- File->Database_Properties->(Summary_Tab)->Title if someone knows how? Thanks! -J
  14. jmodo

    Open another access database

    Inside database A, I need to open datbase B to run SQL statements. Where can I find references for this?
  15. jmodo

    Change datatype to BIT yes/no

    I am trying to change the datatype of a column to yes/no. All I can find is the change to BIT(ALTER TABLE t column c BIT;), is there a yes/no property to add on. I can't find anything. Thanks, -J
  16. jmodo

    Code to drop primary key constraint

    I'm trying to drop the primary key of my field "id". I need something like: ALTER TABLE t DROP CONSTRAINT id? I don't know what the name of the constraint is. Wish I was in oracle! Thanks, -J
  17. jmodo

    Code to drop autonumber

    I need to drop the autonumber on one of my fields via code. Thanks -J
  18. jmodo

    add column with autonumber type

    I'd like to add a column with the autonumber type. I can't figure it out. I have a couple other columns with autonumber already, so I hope this doesn't cause a problem. thanks! J
  19. jmodo

    ALTER TABLE t RENAME COLUMN a to b;

    I can't get this to work. Is there a way to rename a column through sql in Access? Thanks, J.
  20. jmodo

    Screen.ActiveForm.mySubForm.Form.myComboBox invalid reference

    in one of my access databases, this call works, but in another I can't get it to work. They are both the same version, and contain the same code. One is a test version, the other release. Screen.ActiveForm.mySubForm.Form.myComboBox I need to get the value from the comboBox. Thanks! J

Part and Inventory Search

Back
Top