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

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

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

Hello, Could anyone provide a code or macro to spellcheck a text or memo field? Thanks, Javier.

Hello everyone, I'm in the process of creating a table but I can't save any changes as I receive an error message "Too Many Fields Defined." Does anyone have any suggestions? I'm being careful about limiting the field size, and ensuring I categorize it as a date field, text, memo...