Search results

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

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

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?

I have 2 tables with data that need to be joined. One table has hourly information and another table has daily information. I need to have the table with daily information broken out into hourly information. For each date range i.e. 10/19/06 21:51 - 10/20/06 6:19, I need to have the minutes...

I would like to call a query that is stored in my database from inside a module that runs on database start up. Can someone please give me the syntax?

I have an array that holds data that I need to report on. I need the syntax to dump that data into a table. Thanks!