Search results for query: *

It sounds like to you want to base your report on a query that has both tables and uses the time field from the second table. Hope this helps.

I have the code working with no security. I am in the 'hunt and peck' process of applying/removing security to try and find the right combination. I was hoping someone could spare me some trial and error. Thanks!

I am using SQL pass-through queries in MS Access 97 to run reports against Oracle databases. The user enters a date range in a form (and potentially other criteria) and clicks a button to preview a report. The button runs a macro that deletes the query and runs code that rebuilds the query...

Currently we are using Access 2.0 and the default SYSTEM.MDA has been setup with multiple user ID's. However that is not written in stone. If it would work better to update to Access 97 or 2000, not a problem. We could also use a custom security file (and probably should for many reasons)...

We have a new directive from above to implement password aging on several of our systems. One of them in written in MS Access 2.0. It is used by our entire company to enter their timesheets. Does anyone know of anyway to implement password aging in MS Access - any version. We've put off...

About 3 years ago we gave everyone in the company MS Access a few classes and turned them loose. 3 years later, all nightmares have been realized and now we are trying to get some control. In the next few months, we will be taking all MDBs back under IS control. We want to secure all these...

I have fought the battle of compacting MDBs since version 2. As others have stated, it the nature of the beast to need user cleanup. However yours does seem to be growing uncommonly fast. I have had success with creating an icon to do the compact and giving it to a specific user as part of...

In MS Access, I can run this SQL in about 9 minutes.  I am trying to convert it to an Oracle view so that users can link to the results instead of having to export it from Access and import it into other applications that don't support SQL.  I am having difficulty with...

Make sure each technical person gets the training and experience they need to grow in technical skills.&nbsp;&nbsp;Both the company and the employee benefit from this.&nbsp;&nbsp;<br><br>Also, scheduling blocks of 'do not disturb' time when critical projects are being worked on.&nbsp;&nbsp;That...

Thanks carp.&nbsp;&nbsp;That join worked.&nbsp;&nbsp;The problem (which I failed to mention originally) is that I want to append this data to an Access table for temporary processing.&nbsp;&nbsp;Eventually I will be pulling information from 4 or 5 tables into one data set for...

You have to have delete permissions on the table that you are trying to delete records from.&nbsp;&nbsp;Can you delete the records using SQL Plus?&nbsp;&nbsp;If not, it is probably a permissions problem.&nbsp;&nbsp;Otherwise, check the query properties in Access.&nbsp;&nbsp;Make sure it is...

I work with Oracle views in MS Access frequently.&nbsp;&nbsp;We first create the view in Oracle, then attach to it in MS Access the same as any Oracle table.&nbsp;&nbsp;The view needs to have permissions, etc. the same as any new table.&nbsp;&nbsp;The basic syntax for creating an Oracle view...

What is the best way to join 2 tables: 1) hours worked, 2) employees - to get employee information (name, supervisor, etc.) for employees who recorded hours worked in a date range (the dates will be in the hours table.)?<br>I don't want to see employees who did not work in that date range.<br>I...