Search results for query: *

Following is the message I get when I try open my database which has been working fine until now: The Microsoft Jet database engine does not recognize ‘[qry_Cost_All_Modes_1].[Ocean]’ as a valid field name or express. Can someone please explain what maybe causing this? Thanks, JCM

HI, I have two date fields: 1) Date Issued, 2) Effective Date I would like a code that will automatically populate the Effective Date field with a plus 30 days after the dated entered on the "Date Issued" field. I thank you in advance for any help with this matter. Best regards, Javier.

Hi, I have been trying to create a validation rule for a date field in the following format: dd-mmm-yy I have been unsuccessful. Any ideas for the validation rule? Thank you in advance.

Hi, On a particular date field I have a date input mask which is a medium date (ex: 01-Jan-05). This is the format I want for the field. It works fine but when the format is not followed MS Access give its own error message. How would I go about creating a Validation Rule for the format I...

Hi, I have a command button on a form, that when clicked an "appointment" form should appear. All the form is for is to enter information pertinent to an appointment and it sends it to MS Outlook Calendar. It was working fine yesterday, I did not change the code. I have other forms with the...

Hi, It worked. Thank for all your help!! JCM

Following is the line highlighted: .To = Me.EmailAddress

Hi, Yes, the name and control source is "EmailAddress". I am getting "Run-time error '94': Invalid Use of Null. Thanks for help!

Under the Control Source property, the name is "EmailAddress

Yes, the form has a filed with a control source EmailAddress.

Hi PHV, The line that is highlighted when I try to Debug is: .To = Me.EmailAddress I tried .To = Me.txtEmailAddress and I am still getting an error. In essence when I click the email command button all I want is the capability to send an email via MS Outlook. Thanks for you help, JCM

Hi, I have a command button that when clicked I want to be able to send an eamil. Following is the code I have for the "on click" event procedure: Private Sub email_Click() Dim myOlApp As Object Dim myEmail As Outlook.MailItem Set myOlApp = CreateObject("Outlook.Application")...

I have a main form, in which I have a subfrmAppointments that has a control button that is suppose to send the actual appointment to Outlook but I get the following message: "user defined type not defined" and the following is the code line highlighted. Dim objOutlookApplication As...

Hello John, I briefly created 4 forms, using fields from one table, and used the "save as" feature, and when I filled out one form all the data entered appears on the other forms that have the same specific fields that I am using. I don't want this to happen. Yes, the forms are very similar...

Hi, If I create one form with the various fields that I need, and I need to create other forms with the same fields (from the same tables)and I would like to save the existing form with another name, will the entries made on one form be viewable on the other form? I like the format on the...

I created a form from a query. The query only has four fields and these fields were used for the form. The Record Source I have in the Form Properties is that of the query "qryActions" and the form can not be viewed in "Form View". When I change the Record Source to any other Table or Query...

Is there an available feature that would enable an end-user to conduct a keyword search through an Access Database? Best regards, JM

Thanks for your feedback! It's greatly appreciated. Javier.

Ok, So once I create a query, then I create the form. The fields used to build the from would be brougth in from the query or I extract them from the table? Thanks again, JM

Hello, I am a new to MS Access and wanted to know the following: 1. My tables have been completed, and I need to know what needs to be done 1st, the Queries or Forms? 2. Also, if the Queries are done first, for each of the Queries do I need to create a form replicating the Queries...