Search results for query: *

I have a portable air conditioner in a server room that I need to restart after a power failure occurs. I understand many of the new models have an auto restart function built in but I'd rather not purchase a new AC unit. That being said, can anyone recommend an alternative solution to cause...

I've developed a variety of reports using 2005 MSS Reporting Services and searching for a visually appealing method to list the reports to the consumers. Initially, I created a simple list report with the individual rows of the list report hyperlinked to the actual Reporting Services reports...

About a year ago, I designed some code to print .pdf reports in Access 2003 using PDF Writer (Adobe Acrobat version 5.0). The code would print multiple .pdf files, based on an Access report, and save them to a specific location with a specific name that I specify within the VB code...

While running a report in ReportNet, I receive the following error: An error occurred while performing operation 'sqlScrollBulkFetch' status='-55'. Original Error: QE-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-55'. UDA-SQL-0175 The operation "fetch" has...

Am in need of any information in regards to improving ReportNet performance. Using SQL Server 2000 db as the data source. Have one view as a fact table and several additional dimension tables (star schema design). Any tips on how to improve performance is greatly appreciated...Thank you!

I have a form with multiple individual buttons that each run a seperate report. In each button's OnCLick event I have specific code that calls each report, assigns variables, etc. I would like to include a additional button on the form that executes all the individual buttons when clicked. Is...

Does anyone know how to format the Text inside of a message box? I'd like the second line of text to be centered MsgBox("You are about to delete Claims Transaction Summary Report records"&Chr(13)&Chr(13)&"Click Yes to continue", vbYesNo, "Delete Claims Transaction Summary Report records?")...

I have been struggling to find an easy solution to open a report and assigning varaiables depending on a user's form criteria. For example, I have a single report named "RcrvOhio". The report is based on a stored procedure which accepts two parameters: @REPORTDATE and @NAIC. THe @REPORTDATE...

I am having trouble pasing a variable from a form to a stored procedure, running the stored procedeure and returning the result set to the screen. I am able to pass the variable from the form to a vb variable, but cannot figure out how to call the stored procedure using the variable?? The code...

I have a stored procedure that I created in SQL which takes about 90 seconds to run. When I initially ran the SP in my Access Project application, it would not run and returned a "timeout expired" error. After changing the OLE/DDE timeout option for the Access Project application to 0, the...

Are conflicts evident when having Microsoft SQL Server 2000 and Pervasive running on the same machine....? I have a server which is running SQL Server 2000 locally. I'm interested in installing the CLIENT version of Pervasive SQL which will connect to a seperate server running the Pervasive...

Is it possible to run a query in a Microsoft Access Project database that resides in a seperate Microsoft Access database (.mdb)? Thanks in advance for any assistance.

Are conflicts evident when having Microsoft SQL Server 2000 and Pervasive running on the same machine....? I have a server which is running SQL Server 2000 locally. I'm interested in installing the CLIENT version of Pervasive SQL which will connect to a seperate server running the Pervasive...

I have created a Access Project file and am intersted in creating a Switchboard for the DB. I have noticed that this option is unavailable in Project. I have read this thread: http://www.tek-tips.com/viewthread.cfm?qid=774208, and am interested in giving this custom switchboard a shot but the...

I currently have a form which allows the user to input a date parameter in an unbound text box; I’ll refer to this unbound text box as unbDate. I am attempting to use the DLookup function in the ValidationRule property of the unbDate object to determine whether the date value entered into the...

Am new to Microsoft Access project...please bear with me... I'm attempting to reference a form object in a query that's used in determining a data set for a subform. I understand that using the Forms!MyForm!MyCotrol syntax will not work since sql does not recognize this format. From reading a...