Recent content by agc1976

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

Thanks for your support. I went with the cursor. I initially didn't want to use a cursor because of performance issues, but I guess there is no other solution to my knowledge. Using the [IN] clause would work on most cases, but what would happen if I have two downtimes that add up to exactly...

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

Arrowhouse, I missed your post. Thanks for your suggestion, but my subquery is way too complex (involves a lot of logical decisions) and I needed a procedure to evaluate some stuff. Anyways, my problem is solved : )

Thanks to everyone, I used vechalapu's suggestoin ... it worked without step 2. Step 2 returned an error but without it I could still access the table previously created in ProcA

But that global table will be available to multiple users, right? I will have multiple users executing the procedure and I want each to have his own temporary table. Any other suggestion?

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

Thanks, I'll give that a look...

Well, let me explain my situation as a whole... I am using Access 97 and SQL Server. Security is managed as follow: 1. Users are not granted any permissions to the SQL tables. 2. I have an Application Role on SQL with all the permissions for the tables 3. When the user enters the application...

Hi, thanks for the quick response... That solution would still let the user run the code manually by double clicking on the macro. I don't want the code to be available if the user bypassed using the shift key... any ideas? Thanks...

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.

Hello, I'm trying that exact thing. I tried the code on the mvps site but It didn't work (maybe I don't understand it). Can someone explain me how to use that code? All I want to do is change the cursor to a hand on mouse over (label) and turn it back to the pointer on mouse off. I already...