Search results for query: *

I have the following passthrough: SELECT S_EVT_ACT."ROW_ID", S_EVT_ACT."SRC_ID", 01BaseSRC_ID.SamplingSourceCode, FROM "SIEBEL"."S_EVT_ACT" S_EVT_ACT, 01BaseSRC_ID WHERE S_EVT_ACT."SRC_ID" = 01BaseSRC_ID."ROW_ID" The data from s_evt_act is on an Oracle server. The data from...

I wouldn't expect that to be the source of the problem but I'll give that a try.

I have a query that returns 118 records. I hit the "Merge With Word Document" button and select the word document. When I merge only 2 of the 118 records merge into the Word doc. For some reason Word or DDE does not recognize the remaining 116 records. Has anyone ran across this...

I'm using a query as a data source for a word merge. The query returns 118 records but word merges only 2 records. What's happening? Is it possible that the data ia corrupt?

Thank You! This is exactly what I'm looking for!

In CR 7 I have a set of detail record values that looks like this: AZ TX NM OH And I want to display all of these values as one record horizontally like this for a given group: AZ, TX, NM, OH Any ideas on how would I go about doing this? I've tried doing this with the next() formatting but...

Thanks a million!

How do I convert a string to an integer?

I have created a .qry file (it works) and want to use it in a report. When I create a new report and specify the Query option, I am prompted for the .qry file. When I select the .qry I want, another dialog box opens prompting me to "Choose New Location". If I choose a new location or...

In a form I have a SQL string that is dynamically created, and I'm trying to pass that to the record source of a report. The procedure to create the string resides in a private event button click procedure. I have set up a public variable in another module and I can not pass that value to the...

I have written an Access SQL Pass Through Query to an Oracle table and I get the ORA 00936 Missing Error Expression message. I know there is some offending element in the SQL statement, but I'm at a loss as to what it is. Any suggestions? Here is my code: INSERT INTO MASTER_SALES ( PI_BU_ID...

I have written an Access SQL Pass Through Query to an Oracle table and I get the ORA 00936 Missing Error Expression message. I know there is some offending element in the SQL statement, but I'm at a loss as to what it is. Any suggestions? Here is my code: INSERT INTO MASTER_SALES ( PI_BU_ID...

Thanks for the response I'm a newbie to VB and consequently I'm muddling through this. I'll try the debug.print and see if I can find anything there. I've never worked with the SQL Property in VB. Could you provide me with an example of how this would work in this case?

I have created an event procedure in a form on access 2000 and it works. I have sent the DB to another Access 2000 user and the code does not execute -- nothing happens. I have checked the references on her machine and they match mine. Here is a sample of the code. Please help! Private Sub...

I understand normalization. The project calls for denormailzation of the data and I can't change that requirement. Any suggestions?

I have a table that looks like this: product code sub product code sub product title 1223 890809 Access: A Primer 1223 780812 Office: A Primer 1223 78891X Zagat Survey 122B 987721...