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 TouchToneTommy 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: cranebill
  • Content: Threads
  • Order by date
  1. cranebill

    Vista intall taking forever

    hi. i rebuilt my machine a few months ago. installed a legit full copy of vista. ran fine til yesterday. I went to play a game and the machine froze. This is the first time is has frozen in quite a while. I rebooted yesterday and it would not reboot. Tried last known config, safe mode...
  2. cranebill

    Help with Substr

    I have the following function: substr(MSG_TEST_X,1,index(MSG_TEST_X,'-') - 2) If I change the "- 2" to "+ 2" it works, it just does not seem to work with subtracting. I have also tried the position function and the same result happens. How can i get this to work subtracting 2 positions...
  3. cranebill

    Word Forms "Group Spacing"

    Ok I have built a form. On this form there are several places for test to be entered as well as yes/no check boxes. What I am looking to do is when a large amount of text is entered into a textbox and it shifts the content below this text box down the page (as it should) it doesnt split...
  4. cranebill

    Column Width?

    This works to test if a row is hidden... Public Function IsHiddenRow(par1 As Range) As Boolean IsHiddenRow = False If par1.Cells(1, 1).Rows.Height = 0 Then IsHiddenRow = True End Function However this does not work for Columns... Public Function IsHiddenRow(par1 As Range) As Boolean...
  5. cranebill

    Vlookup on two columns not using concatenate

    I have 2 spreadsheets. Sheet 1 is a user entered sheet. Sheet B is a lookup sheet linked to a DB backend. I need to use column A and B From Sheet 1 and compare to column A and B From Sheet 2 and populate column C through whatever on sheet 1. How does one accomplish this?
  6. cranebill

    Cell Calculation

    Not sure if Im putting this in the right forum, however im pretty sure I will need this accomplished with vba. I have several check boxes which upon checking them hides columns on a report. By hiding these columns the user does not wish to see these programs which the columns represent. Now...
  7. cranebill

    Oracle vs Teradata

    I would post this in Teradata section however it is kinda dead over there. I am more oracle driven and have been asked to work on/with Teradata. Do you know a site that has oracle functions and their teradata counterparts or vice versa? any help appreciated as I cannot seem to find anything...
  8. cranebill

    Excel Question

    I have a spreadsheet with approx 20k records. I have one column that is a region and the other columns are basically dollar amounts for different aspects of incoming and outgoing income. How can I do an sheet to sum up the different columns per region instead of manually doing this? Thanks
  9. cranebill

    VBA set cell rangs values to 0

    I have a statement that clears the contents of cells... Range("I7:I8").ClearContents How would I write something that would populate each cell in the range with a zero?
  10. cranebill

    Check cell for null

    Is there a way to check a cell for null without using vb? ie: =if(isnull(a1),"Null","Not Null") something like this... I know syntax is incorrect but you get the idea.
  11. cranebill

    Locking excel

    Is there a way to lock the wookbook so that a person cannot see the vba coding?
  12. cranebill

    Populating cells from Oracle in Excel

    I found a snippet of code that will pull data from oracle and populate cells supposedly... however I cannot get it to work here is the code 'Defining variables Dim cnOra As ADODB.Connection Dim rsOra As ADODB.Recordset Dim db_name As String Dim UserName As String Dim Password As String Set...
  13. cranebill

    Network Printer

    Is there a device or something I can use to make a no network printer networked? What I mean is, would there be a device that i can buy that will plug into my network as well as the usb or parallel port on my printer that will make it a stand alone printer so I can put it in a more central...
  14. cranebill

    Macro to move subfolder outlook

    I need a macro thet will move the highlighted folder to a different specified folder. I am manually moving them and since I cannot select more than one folder building a macro seems key... any ideas?
  15. cranebill

    SQL with Variable

    I am getting an error saying that "SQL command not properly ended", this is my first attempt at VB so any help appreciated: here is my code: SQL_Tasks = "select * from qa.status_report_final where name = " & User
  16. cranebill

    Command button exprt to excel

    I have a report that I run to view status multiple times a day, however this wastes alot of paper. Is there a way to hit a button that will export query results into excel and open there?
  17. cranebill

    Seperate Pages

    I have a report. The report was created with the wizard. It works fine however I have it grouped by team lead then team member. How can I separate it so that a new team lead starts a new page. ?
  18. cranebill

    Last week....

    trying to get data from last week. this is what I have in my where clause: where Format([update_date],"ww") = Format([now()],"ww") - 1; it is erroring on now(), any idea how to use now in criteria?
  19. cranebill

    Loop... help

    I have the following code, it is written by someone else, I am trying to modify it for my needs. I cannot get it to connect to the query... this is what I have: for ($list_day = 1; $list_day <= $daysinmonth; $list_day++) { $tm = date("U", mktime(0, 0, 0, $month, $list_day, $year)) - 86400...
  20. cranebill

    Requery form?

    I have a form set up that pulls records that need to be followed up on. When I click a command button it shoots out an email and updates a followup date in the table. Now what I want to do is have the fields in the form that are bound update and stay on the same record... For instance if I am...

Part and Inventory Search

Back
Top