Search results for query: *

Hi All, Anyone heard of this before? A user is generating a excel spreadsheet from a query using the Tools>Office Links> Analyze with MS Excel function in Access. She manipulates the file a little, then attempts to save. Excel crashes and auto-recovers the file, then she can save as...

Thanks!

Is there some way to make the "enter" key produce a carriage return in a text box, rather than advance to a new record? I'd like this to happen in a text box or memo field. I'm also concerned about truncating the memo field to 255... is a carriage return formatting? Thanks so much for your...

Dammit what a nub. Thanks all!

Huh. That worked, but I don't understand why. Does it count columns from right to left?

Hi All, I'm trying to open a report chosen from a combo box when the user clicks a button. I have a table with 2 columns, the display name for a report, and the actual name. I created a combo box with this info, set the column property for column 2 (actual report name) to 0, and made a...

Yeah, It was an accidental triple post, actually. I kept getting connection reset errors, and assumed it didn't post. So I figured it out, apologies for such an annoying thread.

Hi All, I've got a quick-add form for employee info. Using a button onclick event, I do a little validation before I refresh and add the info to the table, then show a button that takes them to the full reccord. The validation works, but it keeps breaking on the refresh command. Can someone...

So in the table where I save the path string, I should put # surrounding the actual pdf name? Like: C:\Payroll Programs\Help\#SkillComp.pdf# Ok, I'm going to try this pound thing with the various ways I've used followhyperlink before... Thanks for the suggestion, and I'd love to know how you...

No pound signs. Should I have them somewhere? I have a table with the address as a string, and when the user picks a doc name, it uses the string to open the document. Like so: FollowHyperlink Me!pickname.Column(2) Where would the pound signs go?

Ok, so I take it to mean that followhyperlink can't be used to open pdfs?

I'm sure there's a fancier way, but I'd do it like this: Make a new query for each form based on that main table. Then filter the query by the formtype that matches the data you want to see. Then set the datasource for each form to the corresponding query. HTH K

Yep. I can open a PDF manually, no problem.

Hey all, I'm having trouble opening PDFs using followhyperlink. Does it not work for PDFs? FollowHyperlink Me!pickname.Column(2) This worked for word docs, not when the documents were changed to pdfs of the exact same name. There aren't any spaces in there or anything. Acrobat reader...

PHV, I solved this using a different method, then came back to this. Gets a name from a combo box, then opens the corresponding file. Application.FollowHyperlink Me!pickname.Column(2) Worked fine when it was opening word docs, then after I changed them to .pdfs, it doesn't work anymore...

Thanks Paul. Can't find it, but I'll keep looking. Kate

Can someone tell me what "Call passthroughrecordset" is doing here? I've never seen this before, and I can't find any references or anything. I'm trying to figure out how this button does what it does. Which the end result is that it places a new record in a table, based on the customerid of...

YES!!! That works! AceMan, you are the Acey-est of them all. Thank you too, genomon for pointing me in the correct direction! I was tearing my hair out! For the record, the path name is in the 2nd column of the combo box. I set that column width to 0 (in the control properties) so it...

It must be my code, because when I try that, and I click the button, and nothing happens. No error, no nothing. Private Sub Command0_Click() Dim HWordDoc As Object Dim oApp As Object HWordDoc = [pickname] If Dir(HWordDoc) = "" Then MsgBox "Document Not Found"...

This is driving me nuts! I have a button that opens a MS word doc, but I have to enter the string, like so. Private Sub Command0_Click() Dim HWordDoc As String Dim oApp As Object HWordDoc = "C:\Whatever.doc" If Dir(HWordDoc) = "" Then MsgBox "Document Not...