Recent content by charityg

  1. C

    Setting a reminder in Access onto a shared Outlook calendar

    Make sure you have permissions on the folder to create items.
  2. C

    I just cant get it.....

    Can you post the db that you have so far? I'm having a difficult time understanding what you are trying to do. I *think* what you need is two more tables. One to the store the TourneyDivision info and another to store the DivisionMember. Here's what I would do (if this is what you are trying to...
  3. C

    Attach linked files

    The only way of doing this that I know of is to use the Outlook Application object, which basically means that you build the actual Outlook email including recipients, subject, attachments, message, etc. with code and then send. This is the basic framework for utilizing the Outlook object...
  4. C

    Convert an Access form to HTML

    Unfortunately, No. Access 2000 and XP have this functionality. If you want to put the form in a blank database and post it, I'd be more than happy to save it as an html file for you.
  5. C

    Convert an Access form to HTML

    Try File ->Save As ->Data Access Page.
  6. C

    Convert an Access form to HTML

    You can, but it probably won't look the way you want. Open the form and choose file->export then select html as the file type. Enter a name and click Export All. No need to select a template. Use default coding.
  7. C

    Can This possible

    Is the form named merge_inst_type open?
  8. C

    Saving Filtered Query

    When viewing the results of your filter. Select Records->Filter->Advanced Filter/Sort. In that window make sure View->Toolbars->Filter/Sort is selected. Then click on the Save as Query button (looks like a floppy disk with a funnel on it) and enter a query name. Hope this helps!
  9. C

    Accessing Hyperlink Base property from Visual Basic

    Add this function to your db Function GetSummaryInfo(strPropName As String, Optional varFileName As Variant) As String ' Comments: Get "Summary" properties of Database. Taken ' from Access97 help file. ' Parameters: strPropName = Name of property ' Return: "None" is returned...
  10. C

    Open form based on table authentication - How?

    I've attached a sample. The way it works is this. For each user, store the form name for the form you would like to open for each user. In the Login button click, first open a recordset to select that particular user's record. If found, pass the Form name to the open form command. Let me know...
  11. C

    Reverse engineer?

    Beat to the punch! :) I've gotta start refreshing before I post!
  12. C

    Reverse engineer?

    Try Tools->Analyzer->Document If that doesn't give you enough depth, a free trial of Total Access Analyzer will give you more information than you'll probably know what to do with. http://www.fmsinc.com/free/demos/index.html#Analyzer
  13. C

    Print report from VB

    Off the top of my head, a quick fix would be to create a "front-end" database that contains the report object with links to the tables in the db that you are using as your datasource. Then use the front-end database path in the opencurrentdatabase function to print the report. The code I posted...
  14. C

    SendKeys Mouse Click?

    Private Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, _ ByVal cButtons As Long, ByVal dwExtraInfo As Long) Private Declare Function GetMessageExtraInfo Lib "user32" () As Long Const MOUSEEVENTF_LEFTDOWN = &H2 Const MOUSEEVENTF_LEFTUP = &H4...
  15. C

    Password protecting a single form

    I just wanted to post that this type of functionality IS possible with an input box, though hardly worth the coding efforts when you can just create a security form. ================== Some Form Button code ================== Private Sub Command0_Click() Dim pResponse As String Dim...
See more
Top Bottom