Search results for query: *

Hi everyone, I currently have a form bound to a table. I have created a save button, because I need to set a flag when I save a dataset. To be more precise I need to add the user to a column of the dataset. So I want to disable the automatic save procedure of saving in a bound form. I tried to...

HI Guys, I'm getting a connection problem when I try to open an adodb.connection to SQL-Server Run-time error 2147217805(80040e73) Format of the initialization string does not conform to the OLE DB specification I get the error on the con.open statement. Here is my code: Private Sub...

Hi Guys, I have the next part of my riddle:) I have a table like this : with the select below I can obtain my desired result: select distinct artikelnr, calender_week, imputed_calender_week from ( select distinct artikelnr , datum , calender_week , first_value(menge) over...

Hi everyone, I have the following table below: artikelnr dates a b c 1 01.01.2020 10 7 1 1 02.01.2020 null 5 2 1 03.01.2020 null 4 3 1 04.01.2020 null 9 4 2 01.01.2020 20 10 4 2 02.01.2020 30 20 3 2 03.01.2020 null 15 2 I would...

Hi guys, I have a list with this command: categories.loc[0,:] which reads 0 related-1 1 request-0 2 offer-0 3 aid_related-0 Now I would like to append a Dataframe "categories" with these contents, except I don't want...

Hi guys, since its so quiet here ,let me throw in another easy one. The problem is, that I'm so used toSQL and using "Where"..So here goes.. df['artist'].value_counts().reset_index() gives me a select count... now how I can add a condition to only list those above a certain number, say 3? I...

Hi, just an easy question here from a beginner:) How do I find out the value_count of X which has a condition? For example df['Drinks'].contains("diet").value_counts() Thanks in advance

Hi Guys, I need your help regarding Tables in Database, in general. Its been a while since I was here, and had a Database problem since I haven'*t been working with DBs at all..So bear wih me:) I have a table structured with the columns Contract, Section, Amount 2014, Amount 2015, Amount 2016...

Hi Every1, In MS Access, is there a way of creating an SQL to show data in a table which isn't in another? For example, Table A has one column called "Digits". Table B has the same column. In Table A the Datasets in "Digits" reads {1,3,6,7,8} In Table B the datasets in "Digits" reads...

Hi, since I create several sheets and on each a pivot table dynamically, how do I find out the name of a pivottable on a particular sheet. Say the sheet is 'active'?

Hi, I'd like to add a sheet, whereby I delete the sheet before if it exists. Simple, I would have thought:) strSheetName="XYZ" On Error Resume Next Sheets(strSheetName).Delete On Error GoTo 0 Sheets.Add after:=(strSheetName) however I get the error message...

Hello again, I am usind a cube-datasource on a pivot table. due to the complication of one of the field, I am having to remove it from the pivottable and inserting it again, using "cubefields". 'remove field p.CubeFields("[ReCube Date Dimension].[Booking...

Hi, I get this message: "Runtime Error'1004': Method 'range' Of Object'_global'failed " when I run through the last bit of the code below , which is supposed to merely add a page item to my pivot. Dim s As Worksheet Dim p As PivotTable Dim i As PivotItem For Each s In...

Hi, I have a problem saving a stored procedure which contains 4 sql-statements. The procedure contains, an alter table to a table, which adds a column.This is followed by an Insert statement, and then an update satement relying on the added column, and concluded by an alter table which removes...

Hi, with this following small code, I have the problem of having a string apostrophe in my SQL Statement,aswell as the usual apostrophe for the string @str. I tried using speech marks in my SQL statement, but for some reason it sees my desired string to be filled in the columns as a column...

Hi everyone, I have a function in VBA, which I would like to convert into Stored procedure in SQL -Server. I think I have most of it covered..Its just a For NExt loop which is completely wrong in my stored procedure. In fact I am not sure I can convert it like I am trying. I am a complete...

Hi, I have a table with, say, 10 Columns, the primary key of the table defines itself by the first 3 columns(A,B & C,say). I would like to add datasets to the table incrementing the values of columns A,B and C. Now, with Oracle, I would use the Create Sequence command. How do I get around...

Hi everyone, I have a table looking like the one below: X Y Z ------------------------------- A ALPHA 1 A BETA 4 B DELTA 2 C ALPHA 1 C BETA 2 C DELTA...

Hi, I have an Access Report linked with a query, which gives me figuers several columns. All I would like in addition are the summations of the columns in my report aswell. How do I do that?? I am working with Access2003. Thanks in advance. Kingsley

Hi, I know with some SQL it is possible to find the top 5 from a list via the function 'top'. How can find the top 5 results ,say, using SQL-SERVER 2000?? ie SELECT TOP5(X) FROM TABLE_A ????????? thanks for any help. Kingz