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!
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'...
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...
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...
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...
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
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...
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...
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...
Thanks for 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...
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...
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"...
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...
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...
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"...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.