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 sorry for any confustion. I placed this thread here by mistake but then couldn't delete it. It was handled in the VBA site. Please disregard this one. Thank you.

My apologies, I didn't post any solution because I thought it was just a knuckle head oversight on my behalf. It turns out that I didn't have to pass the listbox at all. I simply made the call to a sub from the initialize sub like this: Private Sub UserForm_Initialize() Call filllist1thru5...

My apologies, I didn't post any solution because I thought it was just a knuckle head oversight on my behalf. It turns out that I didn't have to pass the listbox at all. I simply made the call to the other sub from initialize sub like this: Private Sub UserForm_Initialize() Call...

Please disregard as I have figured out how to set up the sub routine.

My apologies, I fill the list boxes with code like this: ListBox1.AddItem ("value1") ListBox1.AddItem ("value2") . . ListBox2.AddItem ("value1") ListBox2.AddItem ("value2") . . and on and on for various listboxes all throughout the form. All this code is leading to procedure too long. can I...

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...

It did not work. Now I get the error message of: Run-time error '1004': Method 'Worksheets' of object '_Application' failed It works fine if I open excel by itself but in this case it is being opened via the IE browswer and gives me the message. I've tested them side by side. Any suggestions...

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...

I'm still getting a spool space issue. Am I not optimizing my joins well? select b.group_id, a.retro_product_type_cde, a.eff_dte from iw_table1 a ,iw_table2 b, (select d.group_id, MAX(c.eff_dte) as Maxdate from iw_table1 c ,iw_table2 d where c.client_id = d.group_client_id group by...

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...

That did it!! thank you and thank he who helped you .. potentially DotNetGnat!

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...

I apologize. I is 5 cols when it works in the 1st Insert but has 6 cols in the 2 Insert where it does NOT work. thank you.

Access DB.

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")) &...