Search results for query: *

Hi everyone. In Excel VBA this .Range("H" & iRow).Formula = "=G" & iRow & "- S" & iRow works fine and at line 2 results in H2:=G2-S2 and also this .Range("H" & iRow).Formula = "=G" & iRow & "- 0.77" returns the same result (where S2=0.77) When I change to this .Range("H" & iRow).Formula =...

Hi everyone. I'm trying to create an SSIS that reads a flat file into an SQL2005 table. The problem exists at a column of the flat file where a date is formatted like yyymmdd and should be going in a datetime field of the table. Is there an appropriate approach for that? TIA

Dear all It is now time for me to use this faq705-6533 and I would like some help on the parameters of the functions. HostName="ftp://xx.xxx.x.xx/" There, I need to upload and download a txt and an mdb file respectivly. LocalFileName=I quess should include path & file name RemoteFileName=Has to...

I have a report with 6 subReports to display data using the WhereCondition for one ID. Works fine. Now the goal is "Print this for all IDs." How can I keep the master/child relation together and print all of them? I don 't know what to group! Any suggestions?

I have an unbound main form (frmProjects) with a combo (cmbProject) to select a record showning in 5 subforms its details In subform frmMainData the recordsource is a query returning detail data for record selected in cmbProject SELECT NoEnumerators.* FROM NoEnumerators WHERE...

Does anyone use the Outlook Add-in from http://www.mapilab.com/outlook/security/ to bypass the annoying Outlook Object Model Guard [curse] From the link http://www.add-in-express.com/outlook-security/?mapilab in this code OlSecurityManager.DisableOOMWarnings = True On Error Goto Finally...

I 'm trying to execute this sql statement SELECT 'CIASF' As TableName, ASF_DATE As DateIn, Count(*) As Counted FROM dbo.CIASF GROUP BY 'CIASF', ASF_DATE ORDER BY 2; using an SQL Pass-Through query from MS-Access. Although for an MSAccess table that would be...

Hello TT I have a report that prints letters (A4 portrait) to clients, the lenght of which is varrying (2-3 pages) and always ends with a signature (image file). I do get a new page for every new client as desired, but the problem I face is that, in some cases, the letter 's last page...

Referencing Excel Interaction with Cognos: thread401-774314 Is there a nice lib for Cognos Impromptu, in order to add it to references in VB(A), to get the lovely Intellisense [dazed] and the object model [bluegreedy] (xlbo [ponder]) I tried in Cognos forum Impromptu Log On Info. Prompt the...

I 'm trying to automate an Impromptu (ver 7.3) imr to be saved as a ASCII file, through VB6. But I would like the user to input their log on UserClassID & UserClassPassword at the form that impromptu uses. Not using a form of mine! Like prompting for a connection. The rest is ready Sub...

Dear All! IT people have locked registry for all users, [including me [evil]] , after migrating from NT to XP. So, when I try to go to References, I get "Error accessing the system registry". Of course they could unlock my user account for all registry settings, but they asked which registry...

The function needed is to calculate the equal monthly installment of an amortized loan using actual days of month and 365 days in year! Payment is due on the end of each period.

Well the error message says it all. Running under NT4sp6, Excel 2000SR1, trying to open a file on a W2000 server. I hope there is something better than last file back up to restore!

I have a function retrieving the latest file on a w2000 server folder Function FileSearching(ByVal File_Name As String, ByVal Search_Folder As String) As String With Application.FileSearch .NewSearch .FileType = 1 'msoFileTypeAllFiles .Filename = File_Name & "*.txt" .LookIn =...

Couple of years, that question was answered in thread796-561274 in reverse order of my interest. So what I m looking for is: Can I install VB6 when I already have installed VB.NET on Windows XP? Should I be aware of anything not to be installed? Thanks in advance.

Hello World! This is my problem: I have an MS-Access 2000 using user-level security on NT machines over a network. Everything works fine and backup is daily. Both .mdb and .mdw files reside on a Windows 2000 server. Now I have a new user with Windows XP. They also installed Office XP. So I...

Hello everybody. Is there anything that I should be aware of? Bugs, methods not supported, "features"? Currently installed MDAC 2.1 & MDAC 2.6 & MDAC 2.7 to various users + VB 6.0 + VB applications using MAPI My question is mainly abbout MSAccess (Importing txt files), Word mail merge and...

Kalimera, I have a program that connects to mdb's, using user level security (with .mdw). I have created a menu for the MDI form. I want for a group of users, not to be able to use a part of the menu. Like File-->New, Open, Edit etc. How could I accomplish this?

Catastrophic failure ----> Catastrophic problem On a Pc with MDAC 2.1 and on another with MDAC 2.6, the following line produces this error. Currentproject.Connection.Execute "Insert Into Sbc1 Select Sbc.* From Sbc;", adExecuteNoRecords, adCmdText after a litle search around and based on what...

Hello World! How can I programmaticaly select, a specific user profile when opening Outlook with automation, if the user has more than one?