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!

Register Log in
  • Congratulations Rhinorhino 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: jalbao
  • Content: Threads
  • Order by date
  1. jalbao

    Change File Attributes On the Fly

    It's been a while since I used ColdFusion - I have forgotten many concepts :( How, if possible, can I script ColdFusion to change the file attributes (MODE) of a specific file located in CF Server's root directory(running on Linux)? For example: I have a file named "myfile.txt" located in the...
  2. jalbao

    Extract divisors from an expression

    I'm having difficulty coming up with an algorithm that will extract all the divisors of a given expression. For example... Input: X * 5 + (Y / ((10 / T) + 15 / W - 20) / 25 Output: divisor 1 -> ((10 / T) + 15 / W - 20) divisor 2 -> T divisor 3 -> W divisor 4 -> 25 It may be worth noting that...
  3. jalbao

    FTP WAN Access On Port <> 21

    I've setup an IIS FTP Server on Win2k. I want to have the FTP site accessible from the LAN and WAN on a port other than 21 - let's say port 1234. I have defined the listening port in the FTP settings and have opened up my router to forward port 1234 requests to the LAN IP of the FTP Server...
  4. jalbao

    onChange Dropdown Content

    I have two drop-down fields - 1) Project 2) Version. Note that each Project will have one or more Versions associated with it. The values of each drop-down are driven by a database. After the call to the database has been made, the Project drop-down will look similar to this: <select...
  5. jalbao

    ColumnHeader Height

    How can I set the height of a ColumnHeader in a ListView?
  6. jalbao

    IsError Function

    I am confused on how the IsError function works (or doesn't work for that matter). I have a SELECT statement that includes an expression: SELECT (A.foo/B.bar) AS Expr1 FROM A INNER JOIN B... Notice that if B.bar is a "zero" value, division by zero occurs. So I implemented the IIF and...
  7. jalbao

    Add Text To RichTextBox

    How do I insert text at a specific location in a RichTextBox? For example: The text in my RTB is "The fox". I would like to insert the string "quick brown " at index 5 of the existing string "The fox" so that the result will be "The quick brown fox". Thanks
  8. jalbao

    Search String for Items in Array

    What is the most efficient way to loop thru each char of a string and check to see if the char in scope is in an array? It would be cool if I could do something like the code below: Dim MyString As String = "The quick brown fox" Dim FindTheseChars() As String = {"q","x","w"} For i as integer...
  9. jalbao

    Change font within one Label

    Is is possible to change the font for certain text within one Label? If so, how? For example: I have a Label that contains the following string: "Foo + bar - 34" I would like the "+" and "-" operators to be bold and all other text to remain as is.
  10. jalbao

    Calcualations on fields

    I have a table that as a similar schema to the following: tblData - table lTestDataID - autonumber (pk) lTestData - float dtAdded - datetime lTestID - integer (foreign key of another table) I need to run mathematical operations on the lTestData field where the dtAdded values match. For...
  11. jalbao

    Set time in DateTimePicker

    I've built a user control that contains two DataTimePicker controls. The purpose of the user control is to allow the user to select a "start date" and and "end date". These two dates will be used to allow the user to create reports within a datespan. My problem is, the user simply is selected...
  12. jalbao

    OT: Allow Zero Length

    Using MS Access 2000 What is the sql statement for setting a field to "Allow Zero Length"? I need to alter a table using a sql query (not the GUI). You listening r937? :)
  13. jalbao

    Allow Zero Length

    Using MS Access 2000 What is the sql statement for setting a field to "Allow Zero Length"? I need to alter a table using a sql query (not the GUI).
  14. jalbao

    Retrieve Identity After Delete

    In my db I have a couple of tables that look similar to the following: Table1 fooID -> Primary Key Identity barID -> Foreign Key of Table2 Table2 barID -> Primary Key Identity If I were to run a DELETE statement on Table1 as in: DELETE FROM Table1 WHERE barID = 33 Is there a sql function...
  15. jalbao

    Global ImageList

    Fishing for some advice/comments on the "best practice" for creating an ImageList (actually, I will be creating 3 ImageLists to support sizes 48, 32, and 16) that can be used over my entire application. I'm thinking that I should create an Icons.dll that encapsulates the ImageList at which...
  16. jalbao

    Rename Column

    I am using an Access 2000 database and I'm trying to figure out how (if possible) to rename a field using a SQL statement. From what I can tell, the SQL92 "Rename Column" function is not supported in Access 2000. Any tips/work-arounds etc? tia
  17. jalbao

    References Not Updating

    I have a solution that contains two projects - proj1 and proj2. proj1 references proj2. Both projects build into the same directory - so in MyDir1 I have proj1.dll and proj2.dll. Furthermore, both projects' reference paths point to MyDir1. Here's my problem/confusion/frustration: If I make an...
  18. jalbao

    Finding Next Date

    I am trying to build a function that will receive a DateTime and an Integer and then return a new DateTime: Function GetNextDate(ByVal myDate As DateTime,ByVal myInt As Integer) As DateTime The scenerio is, I'm working with daily schedule recurrences. A daily schedule recurrence will look...
  19. jalbao

    Importing Mass Data

    I have a local file that can have up to 30,000 records that will need to be imported into an MS Access 2k database. I've never dealt with a db situation where I needed to insert mass amounts of data. I'm thinking that looping thru each record and executing the command will incur a lot of...
  20. jalbao

    Text Field Cursor Focus

    How to a programatically move the "blinking cursor" to a specific text box? When the user opens up a form, I would like the blinking cursor to default to a specific text box so the user does not have to manually move the cursor via his/her mouse and/or tab button. tia

Part and Inventory Search

Back
Top