Search results

I’ve been working with some very large databases, which are taking a long time to run I am hoping I can get some advice on how I might be able to increase the performance of my queries? Should I (examples) 1.Request to have more data archived or smaller amounts of data in the database...

I have two computers at my desk. Both have MS Access and connect to Oracle. Both say that they connected successfully when I do a “Test Connection)” but the problem I’m having is that one of the computers can take over an hour to run one query when it only take the anther computer 5 minutes...

Hello everyone. The company I’m working for is looking to convert my MS database into a Oracle database. Can anyone tell me the advantages and disadvantages of a Oracle back-end with a MS-Access 2003 client front-end Thanks Corey

Hello everyone Can anyone help me convert the sql statement below to a statement I can put into Microsoft access, or help me brake this down so I can put it into access. Thanks Corey Code: select 'FOX' PLATFORM ,dsd.site_id store_id ,dsd.locale --, x.site_name...

Hello everyone. I'm looking for ways that I can speed up my database, mostly the queries that I download from the Oracle ODBC. Thank you Corey

I’ve recently been introduced to the Quest Software “TOAD” Now I’m just trying to gather some resources of were I can go and get feedback to questions I know I’ll have down the road. For starters, is this a good forum to get help and post questions? Thanks for your time and knowledge Corey

Hello again I’m trying to understand why I’m getting the message below and how I can fix it. This happens when ever I try to run a larger qry, and it pops up within a minute. Any help would be very much appreciated OBDC –call failed [Oracle][ODBC][Ora][ORA-01013: user requested cancel of...

Hello everyone, I’m looking for some help on creating a Database that can analyze and determine a company’s future financial income by using key automated analytical tools that I would be able to incorporate within Microsoft access. If anyone has any ideas as to where I can find an example of...

Hello everyone, I’m looking for a template or an example of a Microsoft Access “Forecast Database” If you have one or know where I can find one, please let me know. Corey

Hello again. If anyone can help me it would be greatly appreciated. I’m not sure shy I’m having so much trouble with this, but I’m sure that this will be a great learning opportunity for me. I’ll explain it two different ways, and that way hopefully it will make sense First off I’m trying...

I'm trying to compile a number of IIF statements. I have 6 IIF statements, but would like to put them all in to one IIF statement. Could anyone help me with this one? OrderTrack: IIf([O_SRC_CD]="2005WMDT","Web","Phone") OrderTrack: IIf([O_SRC_CD]="2005WMKE","Internet","Phone") OrderTrack...

Hi again everyone, I'm stumped again. I have two tables that my query is looking at. 1. tblProgramActByDay And the other is: 2. tblProgramByProductByDay I’m trying to tell the query to A: Look in the Program ID Field B: if the Program ID Field = 1667100 C: Go to the table...

Hi again everyone, I'm stumped again. I have two reports that my query is looking at. One is: 1. ProgramActByDay And the other is: 2. ProgramByProductByDay What I'm trying to make it do is is to find a cretin program ID then look at a different report and use criteria to populate the sales...

Help, I'm trying to understand a how to fix this error, Microsoft says to do the below, but it's not working. Can anyone expand this better? Method 1 1. Import the spreadsheet into a new table named tblTemp. 2. Create an append query to append the data in the tblTemp table to your existing...

Hi All, Could someone please look at the attached database and help me understand why my Union Query is not matching up correctly with the Program ID? See attached Thank you for all your help

Hello everyone, I’m trying to build a form that uses three dropdown combo boxes. The first one would show you all of the Managers in the company. The second drop down would show all of the supervisors that report directly to the Managers you picked in the first combo box. And if you don’t...

Hello everyone, I’m looking for some help with a “nested query” I have four fields that typically have a quantity amount in them. I also have a field with a date. I would like to say something like this If fielda = 0 and fieldb = 0 and field = 0 and fieldd = 0 and in the date field, the...

Dropdown Filter Forms I’m working on building a form that has the ability to create and print a report based on the filter’s you pick. Example: Say you have a form with five dropdown boxes Dropdown 1: VP’s Name Dropdown 2: Manage <-at this drop down you will only see the Managers who...

Hello everyone. I’m looking for some advice on the best way to automate a database to do two things. 1. A very quick repair, just to make sure everything is in line. 2. An automatic Compact and Repair. 3. Make backups within a created folder “example (My Documents) Ultimately I would like it...

I’m looking for a Microsoft Access Database that is made to work very good with Microsoft Outlook. The main reason for this database will be for customer contact information and day to day communication with the customer. I know Microsoft access has a very simple temple like this but I was...