Search results

  1. EdFred

    Solved Very odd caret and text box behavior

    I have a form with 2 Combo and 1 text box. It sometimes requires repetitive mostly-but-not-quite-duplicate entries so I wrote some vba code so I don't have to manually key in the same info over and over (sometimes up to 10 times, but often it's 1 and done) When I manually key in certain...
  2. EdFred

    SelStart being overridden by full text selection when...

    ...I resize a field. Access2007 (yep, still works, and not going to 365) Win10x64 I have a SubForm (continuous) that I am logging conversations we have with customers: custID, convoDate, EmployeeID, Contact, Conversation. The conversation notes could get rather long, but I only want the...
  3. EdFred

    Suspending Code Until Outside Application Finished

    I have a Subroutine that is using CutePDF writer to create a PDF from a report, then attach it to a new message in outlook. The problem is the code runs too fast and it's looking for the file to attach before the file is created. I'm getting Run-time error '-2147024894 (80070002)': Cannot...
  4. EdFred

    Formula not working in query.

    So, I did a search on here and found what *should* work but does not. First - the code Public Function GetCustID() As String strCustWebID = "" If CurrentProject.AllForms("Customer History Form").IsLoaded Then strCustWebID = [Forms]![Customer...
  5. EdFred

    "Quiet" Code?

    I've recently "upgraded" to 2007, and here is something that is REALLY ticking me off as it did not do it in the previous version I used. When I get open up my database it checks to the last time I ran a series of reports. If it hasn't been done yet today it runs the report and publishes it to...
  6. EdFred

    Last day of month - how do you do it?

    I need to return the last date of the month not for this month, but 6 months down the road. When the FAA says 6 calendar months from a certain date it would mean go 6 months forward and then to the end of the month. So with today being April 11th, I would count 6 months forward to October, and...
  7. EdFred

    Access Printing Woes.

    Here's a weird problem I've had develop in the past couple months, before I upgraded to 2007, and now since I upgraded to 2007. I've had the same Access database since 1997, and just recently upgraded it to Access2007, but as I said the problem occurred before and after the changeover. I...
  8. EdFred

    You know you need a life when in your spare time...

    ...you do this: There was question asked on the forum a couple weeks ago about setting an event reminder that always triggered at a certain time period. Then I got to thinking about it, because I never use the timer function in Access. So I started experimenting, at first it started out with...
  9. EdFred

    Non-Alphanumerics and sorting.

    I had been using previous versions of Access, and just recently "upgraded" to 2007. I used the search function, and didn't see exactly what I was looking for, so hopefully I don't get flamed too bad if I missed an obvious thread, but here's my situation: In the previous versions of Access that...
Top Bottom