Search results

I have a combo box that lists available parts. I want to select a part from the combo box and added to the next record on the continuous form. How do you reference the next record on a input form so the value is displayed?

summary After Update problem Obviously I need to try summerizing my problem again. I want the before update action of my combo box to activate code which takes the value from the combo box and performs an action before the value is updated to the new selection in the box. Is this the way...

Here is the code that runs from the cbo box. I have also inclued a screen shot. The text field is unbound because my cbobx recordset is distinct but my table is not. So I then enter file names in the txt box, I then update all occurances of the part in the table with the entry in the txt...

1. I have an unbound combo box to select a record 2. I select a record from the combo and code moves you to that record in the form. 3. The form is updated with details from the record. I then have an unbound text field that I enter additional information in to. 4. I then select the next...

I am trying to update a record with new information. When I select the next record in a combo box, I run code that updates the record. The problem is that, the record that gets updated in the table is the new record that was selected in the combo box instead of the previous record in the the...

Found solution The anchor address has to be the active cell. The solution is to scroll through the spreadsheet and making the cell active when you need to insert the hyperlink Row=2 Do loop until EOF Cells(Row,5).select HyperLinks.add Address= Selection, Hyperaddress= (File Location)...

In the end I ended up using code as follows: Row=2 Do loop Cells(Row,1)= variable Row= Row +1 Until EOF I tried using the activecell but it does not appear to work.

Solution? Did you ever figure out the solution to this problem. I just come across the same problem and now trying to figure out how to fix?

Below is two pieces of code. The excel code works which basically is the same as access but in the access code I have the osheet which is now what I think is causing me the problem. Not sure what else to try at this point. Portion of code from Access: Dim oSheet As Excel.Worksheet Set oSheet...

Simplied problem 'DOESN'T WORK Sub Macro1() Row = 7 Testanchor = "Range(" & Chr(34) & "A1" & Chr(34) & ").Offset(" & Row & ", 1)" Range("A1").Select ActiveSheet.Hyperlinks.Add _ Anchor:=Testanchor, _ Address:="D:\Documents and Settings\500928646\My Documents\Baglan Bay...

HyperAnchor = "oSheet.Range("A1").Offset(" & Row & ", 5)" I believe this is the problem code. As part of the correct formating of a range, the correct structure would be Range("A1"), but as a string, it recognizes the " as the end of string and not the "" around the range value? How do I...

Hyperlinks I am currently getting "Type Mismatch Error" This is the only part I need to close the loop on my design so could really use the help. Does anyone see the problem with what I have done

I am trying to export a recordset to excel. One of the values is also to be set as a hyperlink to a fill. The error message that comes up is "Type Mismatch". I include a bit more then just what I believe is the problem code so that you have a better understanding as to what is going on...

I am running a query in a combo box but for some reason the following SQL statement does not give me the result I am after. Which is to only displaying the distinct records. It continues to display the multiple occurrences of the records. I also tried distinctrow with no better results...