Search results for query: *

I am currently having a problem with Access 2000 And MS Graph. Whenever I print or print preview a graph on a report in landscape format, the right side of the graph gets clipped if the PC is using an 800x600 screen resolution. Once you change the resolution to 1024x768, the graph prints/print...

Hi, My table looks similar to this: DOWNTIMES ( Date (PK), Shift (PK), Machine (PK), DowntimeCode (PK), SequenceNo (PK), TotalTime ) I need to obtain, for a specific period of time (From/To) the top 15 downtimes (in terms of time consumed) FOR EACH MACHINE. The...

Hi, Please don't tell me to search keywords for the answer. I have already done that but I couldn't find anything to help me solve my problem. I have dedicated one full day of work to finding a solution for this problem with ZERO success. I have some graphs embedded into MS Access reports...

Hi, Where I work, all computers run MS Office with network installations, that is, all Office applications run from a network drive (T:). For performance issues, I want to install the runtime version of MS Access to the (C:) drive of every computer. I created the setup job using MS ODE tools...

Hello, I have 2 procedures: Proc1 Proc2 I want Proc1 to call Proc2. Proc2 will generate a temporary table and return the results to Proc1 for further processing. Is this possible? If not, what alternatives do I have? Thank you, Alfredo

Is it possible to know with code if the user used the Shift key to bypass the startup settings on my application? I need (for security pursposes) some code to only be run if the application was started properly. Any info you can provide is very helpful. Thank you. Alfred

Is it possible to vary the width of a label depending on its text width? I want my labels to look like hyperlinks but the text inside those labels will vary sometimes and I want the MouseOver effect to only run when the mouse is over the visible part of the label. I am using Access 97.

The subject tells it all... Is it possible? Thanks... Alfred

I want to have a splash screen with a label that displays the loading status (this process might take a while). e.g. I want the label to cycle through the following values: "Deleting temporary data" "Checking security" etc... The problem is that the form won't show until...

Here's what I do: 1. The user enters the Primary Key of a record and clicks on a "search" button. 2. I search for the details of that record using a recordset that will only return that specific record (using the WHERE clause in the SELECT statement). I need to know the...

I was suggested tu use Application Roles for the security of my SQL/Access97 App. Is this possible? Where can I find information on how to implement this type of security with these 2 tools? Thanks

I'm using SQL Server with MS Access 97 as a front end. I used a lot of bound forms (to SQL linked tables) in my application. From what I've read in this forum, that's a mistake : ( The application is currently at advanced stages of development so I can't do some major tweaking (i.e...

Is it possible to verify if the user has rights to open a report (or form) before attempting to open it? I have some reports that require the execution of very long procedures before opening the report. I don't want to make the user wait for the long procedure to finish executing and then tell...

Well, the subject speaks for itself. I want to format a field so that it shows the "+" sign when the number is positive and the "-" sign when the number is negative. Is this possible without converting the number to a string?

I have 3 Subs... let's call them Parent, Child1, Child2. I want the Child2 sub to be able to read the values that Child1 assigned without declaring the variables in the general section. Child2 prints wrong values. What am I doing wrong? It looks something like this: Private Sub Parent()...

Hello, I'm totally new at Oracle and I'm in desperate need of help. It's for a project for the university. I have Oracle 8i Personal Edition running on Windows 98 and Developer 6. Whenever I try to connect to Oracle through the Form Builder I get an error that tells me something about TNS or...

Hello, I'm totally new at Oracle and I'm in desperate need of help. It's for a project for the university. I have Oracle 8i Personal Edition running on Windows 98 and Developer 6. Whenever I try to connect to Oracle through the Form Builder I get an error that tells me something about TNS or...