Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DreamerZ
  • Content: Threads
  • Order by date
  1. DreamerZ

    Excel query success

    I have had a database connection running for the last few years and everything has seemed to go smoothly. Recently, however, the users have noticed that for some days the query locks up and isn't run. The only change has been the database the query is connecting to. Essentially, the set...
  2. DreamerZ

    Multidimensional array issue

    I have a multidimensional array. When I try to extract values from the array, the first array, 3 deep (0, bolded) gets skipped everytime. Here's a sampling of the array: Array ( [1104566400] => Array ( [sat] => 1104566400 [strSat] => 01/01/2005...
  3. DreamerZ

    Combining array question

    I have an multidimensional array where if 3 values are the same, I want to combine them and add other values together. Here's the array: Array ( [0] => Array ( [date] => 1127977200 [strDate] => 09/29/2005 [shift] => Day [title] =>...
  4. DreamerZ

    Connecting to a network drive via Access VBA

    I have an Access form that runs some Excel Code that pulls data from a DB on another network drive protected by a user name and password (the reasons for this setup are very convoluted and silly, but be secure in the knowledge that I cannot do anything about it. It's big company logic!). I...
  5. DreamerZ

    Opening a MSWord doc

    I've searched through several pages of posts after searching keywords like, "converting Word document to HTML php." I've read the htmlentities and html_entity_decode functions on php.net as well as the COM information. I've even tried some of the functions listed in the posts for those...
  6. DreamerZ

    Session Basics

    I am trying to create a user login with different sites for various users. The site selected is what's important as it determines what screen and options the user will see. A session variable is seemingly the best way to keep this site variable across all the pages. After reading php.net and...
  7. DreamerZ

    Inline media type

    I'm using a JS function to create a menu that uses a "style=..." tag in the <DIV> to format the menu. document.write('<DIV ID="base" style="visibility:visible;Position : Absolute ;Left : 40% ;Top : '+YOffset+'px;Z-Index : 20;width:'+(menuWidth+barWidth+10)+'px">'); The code works fine. What...
  8. DreamerZ

    Repeating a Row at top of printed page

    Is there a CSS way to repeat a row at the top of every printed page without repeating it on the screen? I'm open to other suggestions if CSS can't do it. I'm using PHP and JS to create the pages. Thanks, DreamerZ
  9. DreamerZ

    #Name? error multiple page reports

    I have reports that get data from forms (button click opens the form, user selects the criteria, and user clicks a button to generate the report). The form data is used in the query for the report. The report works fine. I have a label in the page header of the report to display the date...
  10. DreamerZ

    Parameter Query using Excel Variable

    I posted this to the Access Query SQL Jet forum too. Thought it might be good here as well. -------------------------- I have a simple select query in Access with no parameters. I have recorded the following code to automatically get the desired data from the Access query: Dim strDate As...
  11. DreamerZ

    Using Mailto to mail page link

    I have read a few of the posts here on using mailto and am familiar with the formatting. What I'm having difficulty with is the location string itself. Here's the code: window.location='mailto:$ra_Mgr?subject=Open Rework...
  12. DreamerZ

    Set Value - Macro Error

    A user upgraded to MS Office Pro 2003 and proceeded to open a MS 2000 DB. The DB uses a macro to open the report with a form asking for data before running the query and displaying the report. It's the standard macro to do this task. I have an "Open Form" action that's called in the On Open...
  13. DreamerZ

    Opening a window and printing the contents

    I am trying to open a window dynamically, filling it with data from a table on another window and then printing the new window. The window.print() and self.print() do nothing. Here's my code: function dailyPrint() { var entry =...
  14. DreamerZ

    Sorting

    I have looked at the information regarding array sorting on the PHP.net site, but I'm not sure that's what I want to or can even do in this case. I have a flat file(.txt) where each line is a separate piece of data like below: Name^Date^Time^Code Currently, the data MUST be entered in DATE...
  15. DreamerZ

    Shading Table Rows

    The code below is a table and script that shades the selected row a different color when the checkbox is checked. The first 2 columns are spanned across the total rows, in this case 2 and the data rows are separate. When I check the checkbox, only the FIRST row of data is shaded (the code...
  16. DreamerZ

    Multi-Dimensional Arrays

    Okay, I'm lost. Here's what I have: I have a list of values in a text file. What I need to do is combine like values on an HTML page. For example (text file data): Line 1 = a^12^Yes^6/21/04 Line 2 = b^1^No^5/14/04 Line 3 = a^5^No^6/1/04 I want the output to be like: A 12,5 Yes,No...
  17. DreamerZ

    Adding text form field on button click

    I'm fairly new to JS so any help would be appreciated. I need to add 2 new text objects to an existing form when the user presses a button ("Add Fields"). First, is using the document.write(text field HTML) the correct way to go about this? And, how can I set the name of each subsequent...
  18. DreamerZ

    PHP and ActiveX Calendar Control

    I've added the ActiveX Calendar Control to a web page form. Currently, I just want to report on the variable (display it at Submit). Putting the name of the variable ($WR_StartDate) displays nothing. What else is involved in displaying this date from the ActiveX Calendar Control on form...
  19. DreamerZ

    Updating table field

    Really stupid, newbie question, but I can't for the life of me remember how to do this: I have a date check against a table field (Now() vs. date in table). Table has 1 record. I want to update the table field based on whether that data is equal to Now() or not. Simple, right? No form...
  20. DreamerZ

    Add Items to List Box Problem

    I have a user form in Excel with a list box that I fill with data based on visible rows on a sheet. This form is opened based on data from another form. I have to do it this way because it's possible there will be multiple rows found from the data entered in the first form. So, in form 1 data...

Part and Inventory Search

Back
Top