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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. kidvegas19

    OutputTo/TransferSpreadsheet to Excel a table with a column of links

    Thanks for the post kjv1611, I hope it will help somebody sometime. Like I say though, I can't mess with it via code this time, especially in Excel. That being said, I don't see why your code scheme would not work. If I get a chance I will give it a try. Thanks again!
  2. kidvegas19

    OutputTo/TransferSpreadsheet to Excel a table with a column of links

    Access/Excel 2003. I have a table of data I would like to export to Excel. For each record in this table there is a link designed to take the user to the location where the related folder (and thus the support documentation for the record) lives. This table field is of the type 'Hyperlink'...
  3. kidvegas19

    Getting a non-key dataset field value

    Thanks AlexCuse - works as advertised. Very much appreciated. KV
  4. kidvegas19

    Getting a non-key dataset field value

    Thanks Alex, The button is outside of the gridview, however, the query returns only 1 row. If I type in this code: Label1.Text = GridView1.Rows(e.RowIndex).colums("Lastname").value.tostring() e.RowIndex is blue underlined with the tool tip "RowIndex is not a member of System.EventsArgs" If I...
  5. kidvegas19

    Getting a non-key dataset field value

    VWD 2005 Express For the sake of this discussion, here is the set up: I have 1 web form. On that web form I have a label, a button, and I have a gridview control bound to an accessdatasource. When I load the form, the data displayed in the gridview is: Fieldname: Code (Primary Key) Data: 12...
  6. kidvegas19

    Updating a table field with a variable

    Seriously - is it impossible to do this?
  7. kidvegas19

    Updating a table field with a variable

    Greetings, I am working with Access tables via Web Developer. I have two tables each of which are datasources for dropdowns. When the user picks a choice from each dropdown, a code is created from the results. In other words, the first choice in the first table returns AAA and the first...
  8. kidvegas19

    Excel autofill w/variable range?

    Wow. Good stuff Mike, thanks. Besides this particular aspect of the overall project, I can use your latest information in other areas as well. Thanks for the good work. I researched the cells property but didn't put two and two together until you clarified it here. Thanks again, kv
  9. kidvegas19

    Excel autofill w/variable range?

    I got this to work for me. Range("AI2").Select Dim rangevar As Integer rangvar = 4 Set myrange = Range(ActiveCell, ActiveCell.Offset(4, rangvar)) Set startrange = Range(ActiveCell, ActiveCell.Offset(4, 0)) Set SourceRange = startrange Set fillRange = myrange SourceRange.AutoFill...
  10. kidvegas19

    Excel autofill w/variable range?

    Thanks for the info Mike. Some points of clarification. I thought that Range(ActiveCell, ActiveCell.Offset(4, 0)).Select Selection.AutoFill Destination:=Range(ActiveCell, ActiveCell(4, 4)), Type:=xlFillDefault would do the trick. But hey, what do I know? LOL! Second, I am not going in 2...
  11. kidvegas19

    Excel autofill w/variable range?

    Why does this work: Range(ActiveCell, ActiveCell.Offset(4, 4)).Select But this doesn't: Selection.AutoFill Destination:=Range(ActiveCell, ActiveCell.Offset(4, 4)), Type:=xlFillDefault Autofill method of range class failed ???? Objective: When I run this macro, I want to autofill from the...
  12. kidvegas19

    Query Parameters - Blank for All

    ...the reply PHV. Neither suggestion helped. I would blame pilot error though. Keeping the date criteria in the date field, I put Like NZ([Type], '*')in the TYPE field criteria cell. Same behavior as above. Keeping the date criteria in the date field, I put [Type]AND [DATE]in the TYPE...
  13. kidvegas19

    Query Parameters - Blank for All

    I can't seem to find an answer to this using a search, so I will post it (hopefully not 'again'). Created a parameter query that prompts for a date (for the date field of course) and prompts for a TYPE. The TYPE field can contain one of five letters, A,B,C,D,E. What I want to do is prompt for...
  14. kidvegas19

    Updating a table field from a form the 'Lazy' way

    Thanks pdl. It worked after I made some changes. Below is the code that worked. Private Sub Name_GotFocus(){Changed to GotFocus because I got error: You can't reference a property on a method for a control unless that control has focus.} Select Case Me!Number Case Is = 1 Me!Name = "Case 1"...
  15. kidvegas19

    Updating a table field from a form the 'Lazy' way

    The data source for the Name field would be the If/Then statement, like the one that works for my Points example. With that database I have one table. The two fields that are dependent are Finish and Point_Earned. When entering data using the form, the data for Points_Earned comes from an...
  16. kidvegas19

    Updating a table field from a form the 'Lazy' way

    Thanks for the replies. The customer name would come from an if/then statement. In another unrelated database I had an if/then statement in the form's BeforeUpdate event procedure that entered points. Example: If Finish = 1 then Points_Earned = 50 ElseIf Finish = 2 then Points_Earned = 45...
  17. kidvegas19

    Updating a table field from a form the 'Lazy' way

    One table with 2 fields - Number, Name What I want to do (by using a form) is when I enter a number in the number field the Name field is populated AND saved to the table. Example: Input the number 1 in the Number field of the form The Name field is automatically populated with "Customer 1"...
  18. kidvegas19

    My browser wont let me see some web pages!!!

    Hi JPirate - Glad to hear you've narrowed it down some. Now this laptop you got the download to work on, was it hooked into the same network you're non-working computer is on? The reason I bring this up is I had just solved a very similar problem for a client when I saw your original post...
  19. kidvegas19

    Computer Forensics?

    Anybody finding any information on the job demand/predictions for this field. I am sort of concerned because I can find all sorts of courses/seminars/boot camps/training on the subject all claiming it is a much needed service. However, can't find any job stats. If I could find a job...
  20. kidvegas19

    Computer Forensics?

    Thanks Blue. Appreciate it.

Part and Inventory Search

Back
Top