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 TouchToneTommy 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: lanm
  • Content: Threads
  • Order by date
  1. lanm

    Trying to cache dataset for 10 dropdownlists

    Here's my code. I can't get the ddls to populate when the pages loads. I've only got two built in the code so far, but we want to be able to support 5-10 when the code goes live. I know the sprocs work, since since I tried using cache for the datasets, the ddls wouldn't populate. The...
  2. lanm

    Last Name parameter allow all data on first run

    I have a query that uses a parameter for a person's last name in the where clause. I'd like to figure out how to get the report to pull all names the first time the report is run, then allow the user to specify specific records afterwards. I can't get the default values right, or I'm missing...
  3. lanm

    Trying to add row to dataset

    Below is the code for the Page_load and button click event. When the button is clicked, I get: Object reference not set to an instance of an object. ..which happens @: Line 80: rowNew = dsContacts.Contacts.NewContactsRow Dim adptContacts As SqlDataAdapter Dim dsContacts As dsContacts...
  4. lanm

    Caching DataSet and DataAdapters

    I'm working through the MCAD training, and can't seems to get a dropdownlist to populate from a cached dataset: ********** Here's the code on the first page: Private Sub Page_Load(....) If Not IsPostBack Then AddtoCache("adptCalls", DA1) AddtoCache("adptContactTypes"...
  5. lanm

    Security on Folder for machine widely used

    One of our admin people uses a machine that others can get to. There is a folder on the hard drive she'd like to protect. I know I can create another user to log onto the machnine, but my questions are: 1. Can I password protect each account icon on the desktop (or just the admin's icon) 2...
  6. lanm

    Updatecommand with Datagrid problem

    I'm using the first data column's EditItem Template to allow the user to edit 6 fields. This has allowed us to get the datagrid to expand vertically and increase the font size too. I'm using an HTML table control to hold the text boxes and dropdownlists so it's structured, but now...on the...
  7. lanm

    Hide cells on Editcommand

    I'm using the first data cell (index 2 since I use the Edit and Delete columns) template column to place all data edits in the first data column in order to have the datagrid expand vertically. What I'd like to do is hide the other cells in the row, as I only need this one column (index 2)...
  8. lanm

    Build 10 dropdownlists from DataSet?

    I need to populate 10 dropdown lists with the same SQL query. I've already tried to build three w/in the same routine, but only the first ddl is getting built. Any suggestions are welcome! Thanks!
  9. lanm

    Book for Custom Datagrid Control in VB

    I'd like to do something along the lines of: http://www.tedit.net/sampleviewer/srcview.aspx?path=masterdetail.src&file=MasterDetailSample.aspx ...where when you click the "Edit" command button, the datagrid expands vertically. Any book suggestions on how to create custom datagrid controls...
  10. lanm

    E-mail documents page design

    I'm new to PHP, and am assigned a project to allow users to click checkboxes for which documents they want e-mailed to them monthly. There are five documents they can choose from, and I was thinking the database would be 6 columns: 1. E-mail address as PK 2. 5 other columns representing the 5...
  11. lanm

    Group Footer to alternate color

    I'm trying to get every other group footer to be a different color, and can't seem to get the distinctcount() function to work. I also tried the count() function, but that's always giving me 1. Any suggestions are welcome! Thanks!
  12. lanm

    Datagrid Edit Command to cause vertical expansion

    I have a datagrid that has about 10 fields in it. The font size is a bit small, and when the user edits a row, it's a bit tough with the sizing....especially with the dropdownlist have field concatenation upon editing. We'd like to implement a datagrid that upon the Edit command, it expands...
  13. lanm

    Dropdownlist doesn't show with Mozilla browser

    We access an Exchange Account for e-mail via the web. I'm using IE and can see a dropdownlist on a pop-up window for addresses. The problem is a user with FireFox doesn't see this control at all. Is this a setting issue with FireFox? Thanks!
  14. lanm

    Pop-Up Window from If Else Statement

    I'm a bit new to the java script side of things. I want to have a pop-up window come up under a conditional statement like: If variable > 1 then Pop-up window Else other code I know when I've used java script with my other code, it's been with button click events and no conditional...
  15. lanm

    WIN Account Information

    I'm a newbie to Access programming. Can Access get to the user's WIN account information? Thanks!
  16. lanm

    Tool Tip for IMG from Javascript Newbie

    I have the following: onMouseOver="alert("This is an alert")" What I'd like to do, is rather than an alert it simply have a tool tip box come up...like "You've rolled over the image", and when the user onMouseOuts from the image, the tool tip goes away. Thanks!
  17. lanm

    mySQL monitor to generate SQL script to create table?

    Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table. I mis-posted this in the PHP forum, that's why I've got it here. Thanks!
  18. lanm

    .xls file as linked server

    I've setup, through DTS, my linked server as an .xls file. What I want to do is have a .aspx page which allows the user to upload a .xls file to the following database server directory: C:\TestSaving\ I've got the code to read the file once it's in the directory and select all the rows from...
  19. lanm

    What is an .htaccess script?

    What is an .htaccess script? Is it only in PHP for Apache servers? We're using an Exchange Hosting site, and they said we have to build our .htaccess script to limit users to a sub-domain. Thanks!
  20. lanm

    Conversion to Hashtable or other

    Here's my code: Shared offset As Integer Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer If reset offset = pagenumber - 1 End If Return pagenumber - offset End Function This is for a report page number reset on a new grouping value. Since the offset must...

Part and Inventory Search

Back
Top