Search results for query: *

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

There was a time in Tek-Tips that I used to e-mail other members with solutions. I guess that policy has changed because I don't see how to e-mail other users and the site's privacy policy discourages posting e-mail addresses. That's a shame because sometimes describing a solution and providing...

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

Jim, Ideally I guess I'd like the icon to be created with transparency (I probably need to use Photo Shop or something), but your suggestion worked like a charm and I'll be using it. Thanks! Rick

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

why won't this work"... Because I didn't think of it. It didn't even occur to me that I should've used dynamic SQL to set the database connection. Thanks for the suggestion...it works like a charm! Regards, Rick