Search results for query: *

I have an Excel 2010 spreadsheet that uses 3 other spreadsheets as data sources which are used in many (a few hundred) VLookup formulas in the main spreadsheet. Since the main spreadsheet has been copied down from a shared network directory, when I call the main spreadsheet up on my Windows 7...

Looking for a best practice answer for this example: Let's say I have a main table that has 10 fields that can hold the value of a state code. For example, birth_state, current_residence_state, hs_education_state, etc. (this example is just used for ease of explanation). And the database has...

This is probably a simple question, but I haven't figured it out yet... I've developed an ADP that is linked to a copy of the SQL database on our development server. I now want to deploy a copy of that ADP to a copy of our SQL database on our test SQL server. What is the easiest/best way to...

In the On_Open Event of a Report, I have code that only applies to a report when it has been launched to be previewed (acViewPreview). However, the code creates an error when a user selects the report to be printed directly (acViewNormal). Outside of passing a variable either globally or...

I would like to create a customized button with the MS Access 2002/2003 report icon (you know...the green report icon we see to the left of all reports in the Reports section of the Database window). I basically am looking for that .ico file. I can take a screen capture and create a bitmap to...

I'm using SQL Server 2000 on a Windows 2000 Server. I'm trying to run a simple xp_cmdshell command in query analyzer: EXEC master..xp_cmdshell 'dir *.exe' And it generates the following error: ODBC: Msg 0, Level 16, State 1 Cannot load the DLL xplog70.dll, or one of the DLLs it references...

I have an Access 2003 application which I've distributed as an MDE that utilizes custom menus/toolbars. For all reports, I have a custom reports menu bar that has a File menu with Close, Save As, Print, and Send To menu items. These all display and work fine in my source MDB. They also all...

I've just created an extremely useful and relatively simple form that displays like a 35-box (7-days Sun-Sat across by 5 weeks down) wall calendar. You could easily customize it to be a 42-box calendar if desired. In the 35-box calendar, for 30 and 31-day months where the first day of the month...

I would like to have a command button displays both an icon and text on it. For example, a rectangular print button would have a printer icon and the word Print next to it. I can create the bitmap image of the printer and the word "Print" easily enough in MS Paint, but the problem is that I...

I'm writing a proc in one database that will find all tables in a different database that have an Identity column (and then ultimately reseed the Identity). I can determine if a table has an Identity column by running the following within the current db... select...

I have an Access 2000 application utilizing customized menu and toolbars. I have a Main Switchboard form with its own customized menu bar. When I open another form via the Main Switchboard, that form's customized menu bar appears; however, the Main Switchboard benu bar remains open as well. I...

I have an Access 2002 db that has ODBC-linked tables to an Oracle 8i database. When I link tables that have an index on Oracle, the indexes are mimicked in the Access linked tables. This provides the users the ability to add and update rows to Oracle via the linked table. How can I remove (or...

In my package, I have an ActiveX Script Task set up that essentially checks for records in a table. Within the ActiveX Script, if the records exist, I set Main = DTSTaskExecResult_Success If there are no records, I set Main = DTSTaskExecResult_Failure I've set up the DTS workflow...

I have several ActiveX scripts as part of various packages I run. Within these scripts I set a connection to the local server that's running the DTS packages. For example: Dim conMyCon Dim strConnection Set conMyCon = CreateObject("ADODB.Connection") strConnection =...

My Win2K server was infected with NIMDA. I ran the virus updates to remove the virus and protect the server. I've also applied all the latest Microsoft updates. However, I can't seem to delete the TFTP files in the inetpub/scripts folder. Nor can I delete the admin.dll files from the root...

I have a stored procedure that essentially takes data from a denormalized datawarehouse table and plugs certain data elements into a normalized table. This requires running 84 INSERT statements for each denormalized record. Rather than manually creating 84 insert statements in my sp, I'm...

I have PWS loaded on NT Workstation and I want to be able to develop and test ASP pages as painlessly as possible. I'm obviously doing something wrong. Issue 1: Is it true that the only (or the most common) way to test an ASP page is by typing in the URL in the browser? I know you can also...

I have 2 subreports that I've placed on a main report. Both subreports use date range parameters for filtering data. The main report has no data source. I'm just using the main report as a shell for displaying the results of the 2 subreports. When I run the subreports individually, the data...

I'm using the Crystal ActiveX Report Viewer in VB. When I run a report with 2 parameters (passed through VB code), the report displays data from the last time I ran the report. After I click on the Refresh button, the updated records appear. What is the command for refreshing the data...

In Access, when you write a query having a field that calculates values you can refer to that same field by its name elsewhere in the query without having to repeat the calculation. For example, in the query below, in order to calculate the Taxable Amount, I can refer to the "Total&quot...