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 derfloh 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. onefootout

    VBA Generated Excel File Crash?

    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...
  2. onefootout

    Carriage Return

    Thanks!
  3. onefootout

    Carriage Return

    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...
  4. onefootout

    Open report w/ combo box

    Dammit what a nub. Thanks all!
  5. onefootout

    Open report w/ combo box

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

    Open report w/ combo box

    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...
  7. onefootout

    Me.Refresh Issue

    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.
  8. onefootout

    Me.Refresh Issue

    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...
  9. onefootout

    PDF Opening

    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...
  10. onefootout

    PDF Opening

    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?
  11. onefootout

    PDF Opening

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

    Viewing data entered via Forms

    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
  13. onefootout

    PDF Opening

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

    PDF Opening

    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...
  15. onefootout

    Open Word Help Docs

    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...
  16. onefootout

    Call passthroughrecordset?

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

    Call passthroughrecordset?

    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...
  18. onefootout

    Dynamic Path Name

    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...
  19. onefootout

    Dynamic Path Name

    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"...
  20. onefootout

    Dynamic Path Name

    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...

Part and Inventory Search

Back
Top