Search results for query: *

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.

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

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

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

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

I have the function implemented and if I add a string to this 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...

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

I have a form that Im processing batches of transactions and I have a button that posts the transaction. With that there is a subroutine that updates a table as follows: Private Sub PostSecurityDeposit(Bnum As Integer) Dim rsSD As Recordset Set rsSD = CurrentDb.OpenRecordset("SELECT * FROM...

Thanks guys they worked fine.

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

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

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

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.

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

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

I have a 3 tables for example Nodes, Engine, Events and they are no relationships set but each has a primary key and in some way related by a primary and foreign relationship just not established in SQL. I did not design this its another vendor back-end build. Anyways heres a little better look...

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

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.

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

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