Search results

Yeah if you could throw out some sample code that would really help.

No worries. And i've just started learning VBA over the past few weeks so im fairly new to it. Had a little experience with java tho

Yes, we have Access 2003.

Haha sorry i'm pretty new to access, the majority of that was a little over my head

Hey everyone. I am writing a program which generates a report based off a combo box. The combo box is in the format show below Color Width Thickness Length Hardness Elasticity Item1 Item2 Item3 Item4 The database has around 50 items. Right now I am able to sort...

Hmm think I actually just figured it out. I had the table it was reading the value for that column in the combo box off saved as a hyperlink. I just changed the type to text and it works now. It seems like the followhyperlink code only works on text formats Thanks for your help though, i...

Thank you for the quick reply. When i try those two lines of code you suggested, the path it shows seems to be correct. When I try to actually run the code I get runtime error 7971 saying it cant follow the hyperlink in the given path (the same exact path that works as a plane combo button...

I could not find the Immediate Window to save the life of me. I did however get the code Application.FollowHyperlink Me.Combo46.Column(10) to work, but only for documents saved on my desktop or my documents. For some reason if i search on other drives I get the error "Benchmark database...

Yeah I got the column thing right I think, but when I activate the command button it says Access Database cannot follow the hyperlink to #filepath#

Hey everyone, I am currently using Access in order to filter through items in a large database using a combo box. Each item will have a hyperlink value stored in the combo box query that will open a more detailed powerpoint report. My question is, what would the code look like to have a...