Search results

  1. D

    Creating Multiple Appointments from one form

    Yes I am trying to refer to a table. The DLookup worked great. Thank you very much Roku. I put it in like this:.Subject = DLookup("[EmailSubject]", "tblEmail", "")
  2. D

    Creating Multiple Appointments from one form

    I think that solved that error, but I am getting a run time error 424 on this line... .Subject = Nz(tblEmail.EmailSubject) I'm trying to reference one field in a table, because it is not on my form. I want it to pull the subject I have writing in that field of my table as it is. I looked all...
  3. D

    Creating Multiple Appointments from one form

    I'm trying to have access automatically setup alerts/appts in Outlook based on four date fields in my form when they press a button. I had an error at those lines originally so I changed If isAppThere("Outlook.Application") = False Then that was origanlly there to match If fIsOutlookRunning =...
  4. D

    Creating Multiple Appointments from one form

    I'm trying to incorporate this code into my db but im having a few issues. The latest is a run-time error 91. the line that highlights is in red. I don't have a checkbox so i just commented that out. But any help would be much appreciated. Private Sub cmdCreateAppt_Click() Me.Dirty =...
  5. D

    Outlook Focus

    Your first part of the code for email has been quite helpful. But as i'm not too good with code, i'm not sure how to incorporate the SetUpBody code. I understand it should be in my button code and that you have a list of fields to include from the form if i'm reading that correctly. But how...
  6. D

    Outlook Focus

    I think I was misreading the screen the other one that was checked is Microsoft Access 14.0 Object Library. I did find Microsoft Outlook. And my email button does work. Many thanks for your help with that. Do you know anything about attaching the current record from the form your looking at...
  7. D

    Outlook Focus

    Ok change that I found another instance of the Library to check farther down. How do I get it to automatically attach the form I am on?
  8. D

    Outlook Focus

    The Microsoft Outlook 14.0 Object Library is already checked. Any thing else you can think of? :(
  9. D

    Outlook Focus

    I keep getting this compiler error. I copied all of it exactly as it is on the screen in the code boxes.
  10. D

    Outlook Focus

    This looks like what I'm looking for to use for email in my database. Where would I incorporate this code to make it work for me?
  11. D

    ODBC Database Tables

    I was able to come to a work around for the ODBC queries. They are only usable on Client Forms not Web Forms. So I created a client form in the same format as my web form. The only catch is that for someone to use the forms full function they have to click "Options" and "Open In Access" while...
  12. D

    Date Field to AutoPopulate other date fields to futrue date

    Sorry it took me so long to get back, i had a four day weekend. I just tried that code and it worked perfectly Thank you very much Paul and Linq.
  13. D

    Date Field to AutoPopulate other date fields to futrue date

    I'm not very good at coding. And I'm having issues figuring out the right code to use. I'm trying to get my "IncidentDate" field to autopopulate two other date fields to a few days from the "IncidentDate". The other two date fields are "ContainDueDate" and "RootDueDate". I'm trying to...
  14. D

    How to change ComboBox drop down menu from displaying checkboxes for multiple values

    I do believe when I changed my data types from lookup to another data type, I had to delete the original combo box off of my form and readd that field from the Add Existing Fields list.
  15. D

    Security Warning

    Microsoft offers free runtime versions of Microsoft Access: Access 2013 Runtime, Access 2010 Runtime, Access 2007 Runtime, which allow users to run an Access desktop application without needing to purchase or install a full version of Microsoft Access. This allows Access developers to create...
  16. D

    How to change ComboBox drop down menu from displaying checkboxes for multiple values

    Did you create your data type using a lookup wizard at table level? If so the lookup wizard gives you an option to select "Allow Multiple Values" which will give your combobox the checkboxes in your dropdown list. I'm not sure about other ways of doing it but thats what I did at one point in my db.
  17. D

    ODBC Database Tables

    I was able to get the Pass-Through Query to run using the code below. SELECT [CustID], [Name] FROM [dbo].[vCustomer]; But I am still unable to see the queries as an option in the Row source Show Table pop up.
  18. D

    ODBC Database Tables

    None of the queries I have made show in the Show Table pop up. And I still can't get a Pass-Through query to run.
  19. D

    ODBC Database Tables

    What kind of Query do I need to do so I can use it as the Row Source for a field? So far I have been able to create a Query that I can even see in the Show Table pop up when I select the query builder button on the Row Source.
  20. D

    ODBC Database Tables

    So your saying change the table name to "dbo." instead of "dbo_" And then make the change to the code as well?
Back
Top Bottom