Search results for query: *

Greetings Fellow Tek-Tippers, I have a (hopefully) simple question of the group concerning Worksheet Protection and Control Objects. I have developed a calculator of sorts for our staff to use, where a driver Combo-Box will set the Visibility, Link Cell, Cell Link Range of other Combo-Boxes...

Greetings Fellow Tek-Tippers, I have a (hopefully) simple question of the group concerning Worksheet Protection and Control Objects. I have developed a calculator of sorts for our staff to use, where a driver Combo-Box will set the Visibility, Link Cell, Cell Link Range of other Combo-Boxes...

BigDaddyE, Just a quick idea... what about having the default value of StringVar message being "No" instead of ""? (if you still need empty space for the "No"s, you could conditionally supress the "No"s) Hope this helps! Mike --------------------------------------------------------------- "To...

Greetings Fellow Tek-Tippers! I have a theoretical question to ask fo the group, hoping someone may know if I can speed up a function I have developed. I have a two-phase macro set up, the first step generates a very large table (1.1M+ records), the second step analyses the first to generate a...

Greetings All, I am trying to develop a means of "filling" in missing data from a table, and would like some guidance as to the best approach to take. I have thought of a few differing approaches, and do not know how to implement or which method is most effective for the data structured as...

Hi Everyone, I am posting this here as the code is VB, but as code-behind for an ASP.NET website. What I am trying to achieve is the retrieval of information about the current user from Active Directory via an LDAP query string. In testing on my development machine, the site worked flawlessly...

Hi Everyone, I feel foolish even asking, but my mind refuses to co-operate this morning, so here goes my question: I have 3 tables (in this scenario) tbl_BudgetItem ~~item_financetype ~~item_financesub tbl_FinanceType ~~fint_id tbl_FinanceSubType ~~fints_id ~~fints_type ~~fints_fint_id I...

Hi All, I have been developing an online library for our HR department, and all works just fine on my (development) machine, but I am getting a runtime error after moving it to the IIS server. Any basic page (just textual information) works just fine, but the pages that utilize a...

Hi All, A question was posed to me regarding the ability to change the order the sections a report are printed. Now, before you laugh, I know that you can re-order sections within groups and such to change order, but my issue lies within that the data generated relies on several shared...

Hi Everyone, I have an SQL question regarding the maintenance of a "rolling" database. At any given time, I would like to thave 1 year of transaction history held in my database. Data is downloaded from the system at monthend and placed into SQL. The month end updates only have 2.5 months of...

Hi Everyone, I am using Visual Studio to develop a web page which has to interact with an SQL server database. The problem I am running into is that when I am trying to UPDATE (or INSERT) a date, it is showing up in the database as "1/1/1900" when i enter a date in this field manually on the...

Hi Everyone, I am building a webpage using Visual Studio, ASP pages, VB code behind. I tested the pages by connecting to a MS Access DB, and now I am using a new ConnectionString to the SQL data and get the following error: This error occurs on this line of VB Code: SqlDataSource1.Update() I...

Hi Everyone, A co-worker raised a question regarding duplex printing a large document. What was requested was that the document be printed Duplex, but that the beginning of each Appendices always begin on the "front" of a page. Any advice or direction is greatly appreciated. Thanks, Mike...

Hi Everyone, I am working on a formula to calculate the time (Term) in months it will take to pay off a loan. I am getting a data overflow error on 1 record in my test sample, is there a way to work around this? The formula is as follows: {@Term_Curr_Pmt}...

Hi Everyone, I am not sure if this is the correct forum, but here goes. Software Involved: - Microsoft SQL Server 2000 Background: - Currently utilizing 3 SQL Databases for 1 Crystal Report. - Have to use Subreports (about 20) in order to link (via Formula Fields) all the Data together (there...

Hi Everyone, I am looking at taking the BOCP-CR at some point this year. Up until now I have worked exclusively with Crystal Reports 10, but the certification testing is all based on Crystal Reports 11. Are there any significant differences that would impede my understanding of testing...

Hi Everyone, I have encountered an issue that has come up before and I cannot remember how I fixed it previously. I have a Crystal Report loaded on to Crystal Enterprise that runs off of 3 SQL Databases. It is giving me the "Database Logon" prompt for 2 of the 3 DB's (These two are newly...

Hi Everyone, I am having some trouble with launching a web site. I do not know wherein the issue lie, but here is the situation. The project itself is very simple: 1 page, display a profiling report I have developed in CR10. I am getting "Page Not Found" errors when going to the default...

Hi Everyone, I am building an Assets/Liability section on a client profile report. The database houses these two sections in multiple tables each. For example: Assets is made up of Real Estate, Serial Numbered Goods, Investments, Inventory, etc etc etc. What I am wondering is if I can set...

Hi Everyone, I am developing a CRM report using Crystal Reports 10 & Multiple SQL Databases. The entirety of the report is driven by a Customer Number Parameter field: {?CIF_Number}. This field is set to accept discrete values only, but also multiple discrete values. The report successfully...