Recent content by WSC

I have ODBC connections to multiple Oracle databases. I tried doing the link tables with save password which works great on my PC, but doesnt work on other user's PCs. So, now I am trying to code in the "on open" of the database that it logs into the Oracle databases automatically. I have a...

Yes! Let me put the same logic in the real database and see if it works. Thank you so much!

i have attached a sample of the data, please let me know if you have any questions. my issues are with Query2, it is bringing in extra sets of the data as soon as I try to add fields from 2 different tables. I need to have the total amount grouped by the Category field by the org id.

The info is confidental so i cant post it. anything I can try to troubleshoot it?

This is my From Clause and I am getting an "Invalid procedure call" error. FROM [Bill Info] Inner Join [PJMBPRD_V_RES_MONTHLY_BILL] On [Bill Info].[Description]= left([PJMBPRD_V_RES_MONTHLY_BILL].[ITEM],(instr([PJMBPRD_V_RES_MONTHLY_BILL].[ITEM]," -")-1))

yes, text.

Access table info... Description = Operating Reserves Category = Reserves Charge/Credit = Charge Oracle table info... Item = Operating Reserves - April 2007 Amount = $10 Item = Operating Reserves - May 2007 Amount = $50 I want a query that pulls in both Items from the Oracle table based on the...

I have 2 tables, an Oracle source table and an Access table. The data in the Oracle table has Item names, however they tend to end with month and date and other misc info. I set up the Access table with the cleaned up versions of the Item names (took out the excess crap) to be able to set up a...

If the query returns no results, like it should, but I want to force a row with zeroes in it, can that be done? how? i have tried an if statment in all the fields to fill something in if the field is null but that didnt work. i tried using nz but that didnt work. any suggestions would be...

I am writing to a table within VBA code. The fields I need to write to are labeled 1 through 24 (for the hours of the day). I have a loop that returns a value per hour and I want to write the value for that hour to the proper hour column. Any suggestions?

I would like to write records to a table from VBA code. Any suggestions? I am looping through data in a table in my code and I would like the output of that to be written to a table. I am struggling with the syntax. Source is PPEW_Data and the destination is Output. thanks

I did that, I set warnings to False, ran the two delete queries I needed to run, and immediately after that set the warnings to true. Thanks!

I have code I am executing in VBA through the onclick of a button on a form. I want to open a query, count the records, and step through the records one by one and pull out data to dump in to a table. I have the open query and record count working. When I try to pull a field of the record and...

Thanks Thank you SO much! That worked, and it is so simple!

I am creating an Event Procedure on the click of a form button that is going to execute a Delete Action Query. When I click the button, it works properly but prompts for you to OK the deletion. Is there a way in VBA in the event procedure that I can set the prompts to always be accepted?