User Profile

Collapse

Profile Sidebar

Collapse
jmprescott
jmprescott
Last Activity: Dec 4 '09, 04:22 PM
Joined: Jul 14 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jmprescott
    replied to DetailsView
    Actually, I figured out the first question. I had to convert the fields to TemplateFields, then I was able to modify the EditItemTemplat e property.

    Still looking for an answer to the second part :)
    See more | Go to post

    Leave a comment:


  • jmprescott
    started a topic DetailsView

    DetailsView

    Hi all, I've been trying to teach myself about ASP, and I can't find a lot of information on certain things. One being the DetailsView. What I'm trying to do is put it into Edit mode, but be able to have more than just text boxes. Some of the fields need to be dropdown, etc. Is there a way to change this around? Or would I have to completely change the way I'm doing it.

    Also, I'm linking to the page that my DetailsView is on from a...
    See more | Go to post

  • jmprescott
    started a topic DataGrid Sizing

    DataGrid Sizing

    I have a stupid easy question (I hope).

    I have a paging DataGrid, and I'm trying to keep the row height the same throughout all the pages. I tried setting the height for the rows, which seemed to do nothing.

    I turned off word wrap, which did the trick, but it's still sizing the fields to fit everything in it, so the table is way too wide now. Changing the width doesn't seem to do anything.

    Is there a way...
    See more | Go to post

  • jmprescott
    replied to +1 in each row of query
    Can you just add an autonumber field to the table? That would do it for you. Or did I misunderstand?
    See more | Go to post

    Leave a comment:


  • jmprescott
    started a topic Ghost records

    Ghost records

    I'm having an odd issue and have no idea what could be causing it.

    I am running a process that will take 25 records from a table and put them into an assignment table. When they records are in the assignment table, workers can go in the form and work on their 25 records (I hope this is making sense). When they're out of records, they'll be prompted to get 25 more.

    That part works fine. The issue is that sometimes when...
    See more | Go to post

  • Worked like a charm! thanks!
    See more | Go to post

    Leave a comment:


  • First append your field:

    Code:
    INSERT INTO Table (TO_EQP)
    SELECT DISTINCT FROM_EQP
    FROM Table;
    Then you can do something like:
    Code:
    Dim sqlstr as String
    sqlstr = "SELECT DISTINCT TO_EQP FROM Query"
    ComboBox.ControlSource = sqlstr
    I'm pretty new too, but I think that's something close to what you're looking for
    See more | Go to post

    Leave a comment:


  • Duplicate entries such as duplicates within the TO/FROM fields or where TO and FROM are the same? Or both?
    See more | Go to post

    Leave a comment:


  • Oh, that's great! Thanks a bunch.
    See more | Go to post

    Leave a comment:


  • jmprescott
    replied to Multi-part identifier error
    Inserting, :(

    Figured it out, thanks
    See more | Go to post

    Leave a comment:


  • Using stored procedures in Access (From SQL Server)

    I created a stored procedure in MS SQL Server 2005.

    Is it possible to execute that in Access? If so, how?
    I searched around a bit and couldn't find anything valuable.

    Thank you.
    See more | Go to post

  • jmprescott
    started a topic Multi-part identifier error

    Multi-part identifier error

    Clearly, I don't really know what I'm doing here, but I'm trying to create a stored procedure to grab the top 20 URLs from one table and plug it into another table (along with some other info)

    I'm getting an error:

    Msg 4104, Level 16, State 1, Procedure GETASSIGNMENTS, Line 2
    The multi-part identifier "ArmyRootURLPag es.DateReviewed " could not be bound.

    Code:
    CREATE PROCEDURE GETASSIGNMENTS AS
    ...
    See more | Go to post

  • jmprescott
    replied to UPDATE/SET execution in VBA
    Issue resolved, thanks!
    See more | Go to post

    Leave a comment:


  • jmprescott
    replied to UPDATE/SET execution in VBA
    Oh geez, quotes lol

    tyvm
    See more | Go to post

    Leave a comment:


  • jmprescott
    started a topic UPDATE/SET execution in VBA

    UPDATE/SET execution in VBA

    I'm trying to transition from .net to VBA and hating life!

    I'm getting an error when I try this: Too few parameters. Expected 1.
    Does anyone know what I'm doing wrong?

    Code:
    If Status = "Closed" Then
            If GeneralThoughts = Null Then
                MsgBox ("Enter reason for closing concern")
                Exit Sub
            End If
            
            db.Execute
    ...
    See more | Go to post

  • jmprescott
    replied to Drop down lists
    Okay, figured it out.

    I guess it didn't like a blank item. When I took that out, it worked fine.

    I played around with it a bit and found that

    <asp:ListItem Value="Blank" Text=""/>

    is acceptable.
    See more | Go to post

    Leave a comment:


  • jmprescott
    replied to Drop down lists
    Thanks for the replies, and yes, I am trying to access server side.

    Here's the code I'm playing with:

    Code:
    Status: 
                    <asp:DropDownList ID="ddStatus" runat="server" Height="22px" Width="128px">
                        <asp:ListItem Selected="True"></asp:ListItem>
                        <asp:ListItem Value="Closed"
    ...
    See more | Go to post

    Leave a comment:


  • jmprescott
    started a topic Drop down lists

    Drop down lists

    I feel like an idiot, but I can't figure out how to get the text from my drop down list.

    I've tried all sorts of things like:

    ddStatus.Select edValue
    ddStatus.Select edItem
    ddStatus.Select edItem.Value
    ddStatus.Select edValue.ToStrin g()

    nothing seems to work.

    Am I doing something wrong?
    See more | Go to post

  • jmprescott
    replied to Ahhh! DataSource help
    I was once told never to touch the designer code. lol.

    I did it. I was careful. It worked.

    Thank you!
    See more | Go to post

    Leave a comment:


  • jmprescott
    started a topic Ahhh! DataSource help

    Ahhh! DataSource help

    So I just trashed my project, and of course I didn't save a backup.

    I needed to change the path for my database I was referencing, and before I figured out the right way to do it, I just deleted all of the references in the solution explorer and re-added a new one.

    Now it seems like it's still linking to the old one that doesn't exist anymore, and I can't find a way to completely wipe the datasource references and start...
    See more | Go to post
No activity results to display
Show More
Working...