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...
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...
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...
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...
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?
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...
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...
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
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?
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.
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...
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...
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?
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
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?
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.
?
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.