Search results for query: *

Hi there, Here is my problem: SQL Server 2008 R2. MS Access Project(adp) application connected to the server. SQL Server Authentication. If dbo logs in, first application query starts in 2-3 seconds If regular user logs in, first query starts after 30 seconds. After that, everything is fine...

Hi all, I recently came across an interesting issue and haven't yet found a solution: A continuous report needs to be printed in such a way that each report page is printed twice on the same sheet. For an one-page report it's not a problem, as I can place two subreports with the same source...

Hello All, Anybody knows how to setup a linked server to a password protected Access database? BOL has instructions for Access databases with user-level security enforced, but nothing about database password. Password removal is not an option at this moment. Environment: SQL Server 2005, MS...

Hello All, Is there any reason that the debugger in QA is disabled? I'm trying to use it, all the buttons show up, but only 'Go', 'Toggle breakpoint' and 'Remove All Breakpoints' are active. 'Step Into', 'Step Over', 'Step Out' and 'Run to Cursor' are disabled. Any suggestions are highly...

Hi everyone. I have the following code: strReportName = rptActiveReport.Name DoCmd.OpenReport strReportName, acViewNormal rptActiveReport is a Report variable that refers to an open report The code is supposed to print the report and it does. However, after printing the report opens in...

Hi guys, Is there anyone that knows how to determine (in code) if a field from a table (in a remote database, of course!) is a damn lookup field and if yes, what its source is? Thanks for your help (if I figure it out myself, I'll post back) [pipe] Daniel Vlas Systems Consultant...

Hello all, I have to set up a BlackBerry solution for the company I work for. However, till now we used QMail on a Linux server, which worked very well, and now we need to migrate everything to Exchange, because BlackBerry does not like Linux. As anyone can imagine, it's a difficult task, with...

Hi everyone, I have set up my Nokia 6230 phone to receive and send mails. Server: IMAP 4, same account settings both for incoming and outgoing messages. Receive works fine, no problem. Sending: SMTP server requires authentication (activated in the phone). When I first try to send an email, it...

Hey everybody, Can anyone tell me why the following piece of code generates an error 54- Bad File Mode in line 'Print #1...'? Open "C:\FileName.txt" For Output As #1 For i = 0 To n Print #1, arrInfo(i) Next Close #1 Win XP, SP2, Access 2003, Administrator permissions. It used to work...

Hi all, I have come across one interesting issue with one OSL contract with Microsoft: 80 computers to run the latest OS version (now Win XP). 80 computers to run the latest Office version 2 Win Server 2003 80 client access licenses for Win Server 2003 2 SQL Servers licensed per processor (no...

Hi guys, I always pointed users to: http://office.microsoft.com/downloads/2000/Snpvw90.aspx to download Snapshot Viewer as a standalone application. I have recently learned that the link was 'gracefully' removed by Microsoft. I'd like to know if I'd be breaking some law if I placed the file...

Hello all, Setup: Employees (one)->(many)EmployeeCourses(many)<-(one)Courses I've made a multiselect listbox (based on table Courses) on a form displaying all courses. I need to create a query to list employees that have taken ALL selected courses. No matter what I do, I can only list...

Hi, I've been searching for some API function to check if a particular page exists on a web server. Anyone knows of such a thing? Thanks in advance [pipe] Daniel Vlas Systems Consultant http://www.geocities.com/danvlas/AutoMail.html

Hey guys, May be trivial, but how do I find the path of the currently used workgroup file from within an Access application? I know I can pass it with /cmd argument from a shortcut and get it through Command function after that, but is there any other solution? Any Access version from 97 to...

Hi guys, Is there any way to draw a vertical line from the intersection point of two lines to the X axis in an Excel chart? I'm really buried in a mountain of papers and I really hope someone will give me an answer until I finish them all... Thank you in advance [pipe] Daniel Vlas Systems...

What I want to do is to remove automatically the attachments from all the messages stored in Sent Items. For this purpose I wrote the following code and, when run step by step, it reports that the attachments have been removed. However, they remain in place and I can't figure what is wrong...

Has anyone any idea of how to use (or convert) an array as a recordset? I need to populate a form with the lines from an array. The problem is that the array is dinamically ReDimmed and there is no known limit of its upper size, so I can't just hide/display used controls. At this moment, I'm...