Search results

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", "")

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

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

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

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

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

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?

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

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

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?

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

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.

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

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.

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

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.

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.

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.

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.

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