Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JerryKlmns
  • Content: Threads
  • Order by date
  1. JerryKlmns

    Excel VBA formula using a changing cell 's value and a constant

    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 =...
  2. JerryKlmns

    Data Convertion for Date Column

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

    Help on faq705-6533 How do I FTP files in MS Access part 2

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

    Report subReport keep together on ID

    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?
  5. JerryKlmns

    subForms text box not editable

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

    MAPILab Advanced Security for Outlook

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

    Dummy field and GROUP BY

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

    Force a Page Brake when Only 1 Line in 2nd Page

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

    VB(A) Interaction with Cognos

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

    Impromptu Log On Info. Prompt the user

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

    Adding a Reference to a Library

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

    Excel Interest Calulation Function

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

    Excel "Too Many Different Shell Formats"

    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!
  14. JerryKlmns

    Application.FileSearch wrong result

    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 =...
  15. JerryKlmns

    .NET installed with VB6

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

    Join Workgroup file :Access denied

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

    From Office2000+NT4sp6 To OfficeXP+WindowsXP

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

    Limit menu selections on MDI form, for a group of users

    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?
  19. JerryKlmns

    Catastrophic failure Run-time error '-2147418113'

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

    Selecting an Outlook User Profile

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

Part and Inventory Search

Back
Top