Recent content by rickj65

Hoaokapohaku, I believe your suspicion regarding named ranges was correct since I recall performing copy & paste processes that overwrote previous named ranges. That certainly could have had detrimental effects on the relinking process. Rather than trying to troubleshoot specifically which...

Yeah, I tried this, but I get an error message stating "A formula in this worksheet contains one or more invalid references." It doesn't allow me to proceed with the REPLACE. :-(

I probably didn't explain it very well...it is actually a very common procedure in Excel. The main spreadsheet that I am using was downloaded from a network drive. Within that main spreadsheet, there are 3 data sources (connections to other Excel spreadsheets) that are used in formulas within...

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

I believe if you set up a string variable and pass the dynamic SQL statement (EXEC proc statement) with all the parameters, this should do what you are looking for. DECLARE @strSQL varchar(500) SET @strSQL = 'exec ' + @ProcName + ' ' + CONVERT(varchar(3), @DataCheck) EXEC(@strSQL)

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

That's definitely how it's done. Thanks for the assistance.

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

Lt Thanks for answering my message. I'm using iconfilter 2.0 and I get something else as an icon for #8. It looks like a black pause icon in the upper lefthand corner. In any event, I resorted to creating my own icon based on a bitmap screen capture. Thanks, Rick

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

Bocker - The form is similar in concept to the one you linked. The calendar I created is not for entering data, just displaying it, but in concept you can create either.

OK, here is how you set up the calendar form: I linked to the Northwinds Customers, Orders and Employees tables for this example. I set up the form (frmCalendar) as follows: 1. In the header put a dropdown list box (cboMonth) containing two columns for the numerical and text values for all...