Search results for query: *

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

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

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

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

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

I have a subform inside my main form that is populated from table with the record source as follows SELECT tblMember.* FROM tblMember WHERE (((tblMember.ApplicationId)=ApplID)) ORDER BY tblMember.MemberNumber; the problem I have is it populates the information fine for each record in the main...

I have a report that is giving me this error which is comming from a query as follows: At Most one record can be returned by this subquery I have the SQL that causes it and its a very complicated statement that I did not write but am expected to fix here it is: SELECT a.UnitStatusHistoryId...