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 Chriss Miller 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: *

  1. JKDeveloper0718

    Data insert to DB2 slow

    With the Microsoft OLE DB Provider for DB2 driver we are finding that the OLE DB Destination Data Access mode does not have a choice for a Fast Load.
  2. JKDeveloper0718

    Data insert to DB2 slow

    We are doing a normal insert and the Data Access mode is set to Fast Load.
  3. JKDeveloper0718

    Data insert to DB2 slow

    We are having an issue with data inserting into DB2 using SSIS. We are using the Microsoft OLE DB Provider for DB2 and we are reading from a DB2 staging table to a DB2 destination table that is the exact copy of the staging table. The following are some of the specifics as to what our problem...
  4. JKDeveloper0718

    SendObject Report parameters

    The latest request is for the user to be able to email a report via snapshotviewer format. My main issue is the fact that the report needs to be emailed with the proper filter. In my investigation of this element I came across sendobject which seemed like a nice function. So My question is how...
  5. JKDeveloper0718

    Parse Field for Primary/Foreign key relational elements

    this works fine select * from dbo.fn_MVParam ('9,3,4,6',',') but there is a table called Alerts select * from dbo.fn_MVParam ((Select NetObjects from Alerts),',') NetObjects is the field in the alerts table that is a text field. this field contains the string (,12,13,45,46,) the following...
  6. JKDeveloper0718

    Parse Field for Primary/Foreign key relational elements

    ...function like ',0,12,23, it works fine in parsing the string but when I try to add the select statement like below it will not run at all select * from dbo.fn_MVParam ((select top 1 node from yournode table),',') my sample command is select * from dbo.fn_MVParam ((select top 1 NetObjects...
  7. JKDeveloper0718

    Parse Field for Primary/Foreign key relational elements

    We are running some third party software at our NOC and we need to produce a report of alerts and the specific nodes associated to that alert. Well you would think that the alert and the node table would have a nice relational element that could make that happen. Well I found that there is a...
  8. JKDeveloper0718

    Update table String (vba)

    ...updates a table as follows: Private Sub PostSecurityDeposit(Bnum As Integer) Dim rsSD As Recordset Set rsSD = CurrentDb.OpenRecordset("SELECT * FROM tblRCSecurityDepositData WHERE BatchNumber = " & Bnum) While Not rsSD.EOF If rsSD!TransCodeId = 5 Then CurrentDb.Execute ("Update...
  9. JKDeveloper0718

    Update Muliple records from query

    Thanks guys they worked fine.
  10. JKDeveloper0718

    Update Muliple records from query

    I have a query that has an ID and 3 fields as follows: SELECT tblUnitApartment.HouseholdId, tblUnitApartment.UASecurityDeposit, tblUnitApartment.UASecurityDepositPet, tblUnitApartment.UASecurityDepositPetAd FROM tblUnitApartment; I have a table that has these same 3 fields and a HouseholdId...
  11. JKDeveloper0718

    Counter field in query

    I need a counter field created like a calculated field in an access query such that it will just put a unique value starting at 1 til the query ends. What Im trying to accomplish is I need a automatically generated number per record to insert into an SQL table to give it a unique identity...
  12. JKDeveloper0718

    Currentdb.execute sql update string problem

    Hello I been attempting to update a table called tblMTCSBasic that has 3 important fields as follows: HouseholdId Number EffectiveDateofAction Text RentAnnualUpdate Text The idea is Im grabbing a field from the form called Effective date and Set the Rent Annual Update to one year later...
  13. JKDeveloper0718

    passing variables form to subform

    Just wondering if anyone has ever passed variables to a subform from a main form and then been about to manipulate in the form_current subroutine without losing the variable values. Any suggestions at all for this.
  14. JKDeveloper0718

    passing variables form to subform

    Well what exactly are you refering to the variable is actually an invisible text box but its also an integer variable. Dim num as Integer num = 1233 Or ApplicationID (is the invisible field that is populated by a table) in the main form so when I pass this variable to the subform which is in...
  15. JKDeveloper0718

    passing variables form to subform

    I have a variable within the vba background in the form_open subroutine that I would like to pass from the main form (frmApplication) to a subform (sfrmFamilyMemebers) that is located on this main form. the variable is an integer called lappid that needs to be passed to the subform and used as...
  16. JKDeveloper0718

    Cascaded Delete with multiple tables

    ...would appreciate a little help to construct this delete statement and I know that it will be a very nested type of sql. For Example this: delete * from Nodes where EngineID = 3 This is some of the logic but will only delete just the from Nodes table in the process if I run this the other...
  17. JKDeveloper0718

    Drop down filter Select Distinct not working

    I have a dropdown in a form that then populates textboxes within that form. My problem is the information is comming from a table called tblVerfifyInfo which has the following fields VerifyFamilyInfoId(autonumber), VFICompany, VFIAddress1, VFIAddress2, VFICity, VFIState, VFIZip With this in...
  18. JKDeveloper0718

    Pass value from main form to subform for filtering

    Actually its the Text680 from the Main Form the subform that calls this is on top of the mainform in a tab. So everything in on the same form just subform on top inside a tab control. So Text680 is not in the subform.
  19. JKDeveloper0718

    Pass value from main form to subform for filtering

    no it is a Dao recordset from a table by the value from the textbox but has nothing to do with filtering the subform its just an event happening in the background of the subform
  20. JKDeveloper0718

    Pass value from main form to subform for filtering

    My problem is that I have a form frmApplication and it has a text box called Text680 that has the given value I need. then I have a tab control called tabApplication with a subform called sfrmFamilyMembers. According to an event load I would like to call a dao recordset with the filter coming...

Part and Inventory Search

Back
Top