Search results for query: *

I am running the following SQL's and am getting a 3706 error with the subject description. 1 create table temporaryDB.ao_test1 as ( select chapter_id from warhouse.chapter group by 1 ) with data; 2 create table temporaryDB.ao_test2 as( select chapter_id ,substr (chapter_id,1,2) as first_two...

I'm using a form where in my Initialize sub I adding items to the various listboxes that are on the form but it appears that I've gone beyond the allowable space. Is there some way to call a function or a sub-routine and pass it the listbox object so that I can fill the list in there? Or some...

I'm using a form where in my Initialize sub I adding items to the various listboxes that are on the form but I guess I've gone beyond the allowable space. Is there some way to call a function or a sub-routine and pass it the listbox object so that I can fill the list in there? Or some other way...

I have a spreadsheet that opens to a form which has buttons on it (a dashboard). The buttons have the following logic: Private Sub CommandButton2_Click() Worksheets("Issue Tracking Log").Select UserForm5_dash.Hide End Sub Private Sub CommandButton5_Click() Worksheets("Open Due in...

I've tried searching for this topic with no avail. Is there a way to have code fire when a worksheet opens and where can I put it. I have a macro that changes the color of some fields based on the value of another but I don't want to have to click anything for it to happen. Thank you much in...

Without the sub select I can use this query to get my result of group op ID with a Max eff date: select b.group_id, MAX(a.eff_dte) from iw_table1 a ,iw_table2 b where a.client_id = b.group_client_id and b.carrier_id = ('2368') Group by 1 However I need to see this product code but...

This is probably incredibly easy but it is evading my thought process. I need to select an entire row in exce BUT with variables. It will work with: Rows("13:13").Select but the "13" need to be a variable. I have thried the following but it has not worked: Rows(Cells(x5, x5), Cells(x5...

I have googled and searched thru various posts but have found nothing on "goto" logic or syntax for ASP. Does anybody know if ASP incorporates this type of logic and what the syntax would be. Or would know how to work what I'm trying to do differently. Purpose: I need to add a "<BR>" after...

I have spent he last 2 days looking for this info in a past thread but couldn't find anything. I have a recordset that has a field that has nothing it in. I have tried the following to verify but it is not working. Please advise. if rsMemInfo("picks") = " " then Response.Write("NO selections...

Sorry if I should've asked this elsewhere but b/c it's on my ASP page I'm starting here. This works: "INSERT INTO meltingPot(uname,fname,lname,email,password)" & _ "Values('" & (Request.Form("uname")) & "'," & _ "'" & (Request.Form("fname")) & "'," & _ "'" & (Request.Form("lname")) &...

On my page 1 I have 5 checkboxes. 2 and 4 are checked/disabled based on data from the database. User checks off checkbox 5 and clicks submit. on page 2 I want to use request.form to see the newly checked checkbox BUT I also need to keep track of the already checked checkboxes for an if...

I tried to do some research on this but haven't been able to find a thing on it. Perhaps someone has a idea. Page 1 has 5 checkboxes. Boxes 2 and 3 are "checked" and "disabled"(grayed out). User checks off box 5 and clicks submit. On page 2 I am using the code: Response.Write...

This may be a conceptual issue. Overview: Form has checkboxes. Click submit and get to this page to process. As this code checks the checkboxes I need a value of "SOLD" to be held in it's own variable associated to it's checkbox(of which 1 and 3 are currently checked and checkbox names are...

I have this query to upate a table from my ASP page. The table has 10 rows and 11 cols (RowNum, col1 thru col10 Query = "UPDATE poolTB SET RowNum=1, col1=A1, col2=A1, col3=A1, col4=A1, col5=A1, col6=A1, col7=A1, col8=A1, col9=A1, col10=A1 WHERE RowNum=" & rowCount I've taken a look at it by...

Conn and Rec Sets are fine and pulling data. What I need to do tho is when I query the DB if the field has a certain value let say "YES" I want to then put an image in the cell of my table. Any help would be greatly appreciated. In this sample code Row 1 will give me the word "MATCH". When I...

Can somebody please assist me with this sql. I can't seem to get the WHERE clause to work for me. Thank you in advance. sl = Request.Form("recID") sql = "UPDATE AdviceDataStore SET SeekerName ='"&Request.Form("SeekerNametxt")&"',"&_ "SeekerDataEntry =...

I have an asp page which lists data from a db thru a loop. With each row 2 links are created to the left(update/delete). Example: (row1) Update/Delete - Sentence1 - Sentence2. (row2) Update/Delete - Sentence3 - Sentence4. (row3) Update/Delete - Sentence5 - Sentence6. I want to be able to click...

I was under the impression that excel had a colum limit of ZZ. Can someone verify that for me please. I am getting problems trying to add columns after IV. Thank you in advance, Allan

I have placed this coding in the formula bar: =IF(C2="Card",B18,"") which works fine. The problem is that I need to evaluate more than 1 value such as: =IF(C2="Card" & D17=5,B18,"") But this does NOT work. If I remove C2 or D17 it works but together it does not. Can someone please suggest...

This should be soooo simple but I can't find it!?!? I loaded flash 5 on 2 pc's. On 1 it works and looks fine. HOWEVER on the 2nd 1, laptop, all the font on the tabs of each of the panels are so blocky that it's almost impossible to read. The words in the title bar and menu bar look fine so it's...