Search results for query: *

Hi experts, Here is a code snippet that i am using from within an Access 2000 module to copy the end-30 columns of a spreadsheet into the next 30 empty cols: objExcelSheet.Range _ (strExistingBegColHeader & "1" & _ ":" & strExistingBegColHeader &...

Hi experts, This is part 2 of my dilemma (and I apologize for the long post). I had previously posted that the solution(s) I was given worked, but they did not. I am trying to update the 5 series in an existing chart in an XL spreadsheet. Internally (when I look in the excel's VB editor), the...

Hi experts, I am trying to update the 5 series in an existing chart in an XL spreadsheet. Internally (when I look in the excel's VB editor), the chart is referred to as "Chart2" Here is the snippet of code that continues to return this error: "1004 - Unable to set the values...

I am using this code: http://www.codeguru.com/vb/articles/1854.shtml to progammatically zip files (the code works perfect). However, several of the files I will need to zip need to be split into the smallest chunks possible. Winzip 8.1 has an option called "Split" where the user...

I am using this code: http://www.codeguru.com/vb/articles/1854.shtml to progammatically zip files (the code works perfect). However, several of the files I will need to zip need to be split into the smallest chunks possible. Winzip 8.1 has an option called "Split" where the user...

I am creating my first ADP application. All is well, and I am referencing "Professional SQL programming with Access 2000" (xlnt WROX book). But now I need to create a continuious from based on a table. In fact, just for testing, I simply want to create a test table with 3 fields...

Hello SQL Server experts, This is round 2 of my SQL server newbie questions. I am trying to run a nightly DTS job to import 5 tables from MAS90 into my SQL 2000 database. Thanks to the last tek-tip expert, I have secured a connections string (DSN=SOTAMAS90;UID=XXX|YYY;PWD =...

I am new to using DTS and SQL Server 2000. I need to schedule a nightly import from MAS90 into my SQL 2K backend. However, anytime MAS90 is accessed, the login/pw screen comes up. So, while creating a DTS scheduled job is easy, I cant get around the dang login popup. I need a way around this so...

I am using the control array workaround in my Access 2002 apps in multiple forms. me("txtSomeControl_" & x) What I want to do is take the code and functionality that doesnt belong in the forms and move the code to modules. So, I try to do this with a call: s_SomeSubroutine me...

I have a VB6 app with an MSFlexgrid control. The first row (index 0) is a fixedrow and I use it for column headers. However, when I dbl click on that physical first row (a fixed row - index 0)) on any column, grid.row always returns "1" rather than "0". When I click ON the...

I have a VB6 app. that utilizes an MSFLexgrid control. The first 2 columns are fixed, as is the first row which contains the column headings. This is a sales forecasting app. There are a total of 73 columns, which include 6 columns for each month of the year (i.e., prior year forecasted amt...

C++ experts, I am a VBA programmer asked to convert an existing Visual Studio version 5 C++ project to Visual Studio 6 C++ At GREAT risk of asking the unbeleivable dumbest question(s) of the century, how involved will this be? Will VS6 do the work and ask questions as it proceeds, or? Has...

I have an Access 2000 split db, with both the front end and back end replicated. In the design master (and replica of course) of the front end, I have been attempting to use the following code with no luck: Public Function fRefreshLinks() As Boolean Dim dbCurrent As Database...

Bear with me while I describe my problem. And if you read all this, boy, you have my appreciation. I have 2 Access 2K databases, I will call Access 1 and Access 2. Both are split, both are replicated (front end only). I need to insert or update data that is in Access (backend)1 to Access...

I have an Acces 2000 dataase set up with an ADO connection to another Access 2000 database. I am trying to get a very simply SQL statement to work: m_objCon.Execute "UPDATE tblControl " & _ " SET Match = False WHERE ControlID = " & varCIDarray(x) Each time I run it...

Hi experts, Within my Acess 2000 application, I need to check for an instance of Outlook running. If it is running, I need to minimize it. I have found some code that finds a window handle, but I would not necessarly know what the handle is as it is what displays in the bottom task bar. That...

Hi, I have an Access 97 form that uses a query (made up of two tables) as its record source. I am using the following code within an after update event to populate the form with the correct record after a user enters a social security njumber: varResult = DLookup("[ipkT801ID]&quot...

Hi experts, I am new to Outlook forms and am creating my first. I need to populate a dropdown on the Outlook form with a recordset that is the result of a query found in an Access 2K db. In Access, I could just go: cboDropDown.RowSource = GetSQL() But something like that is a no-go in...

Hi, I am using/calling DoCmd.RunCommand acCmdPrint in a function called by a macro. The call can be initiated in several portions of my Access 97 database when the user clicks on a custom toolbar. My queston: How can I tell WHAT is being printed? I know I can use IsLoaded to find out if...

I would like to know how, if possible, to right justify data in a list view control. Would anyone know if this is even possible? Thanks in advance, JBG