Search results

Hi Everyone, I have a form, named MyParent, that contains an Add/Edit and a Cancel button on it. The form also contains a subform, named MySubForm. In the MySubForm Form_BeforeUpdate event, I have added a few edit checks which launch a MessageBox that contains the appropriate error message. I...

After further debugging, I realized that my code was not being executed in the order that I expected it to. I had other code in the BeforeUpdate event that was being executed before the Exit event which prevented the above posted code from being executed. Thanks, CRhodus

I have a subForm with a default view of DataSheet. In this subform, I have a field named txtCourse_Date. If the user enters a year that is less than the current year minus two (YEAR(NOW()) - 2), then I want to tell the user to correct the data. The problem that I'm having is that if they...

Thanks for giving me the .value piece of code that I'm missing and telling me about thehe extra bracket. Crhodus

I have a text box that I've added to my report. I would like to be able to have the value entered into a text box on a form written to the text box that I've added to my report. How can I go about doing this? I've tried adding =IIF(IsNull( Forms![frmOnlinePaymentRptOptions]![txtFromDate])...

Is there a way to execute two statements in one query in access? I tried the following but received the following: "Characters found at the end of the SQL statment". Here is what I have in my qryUpdateRecords file: "UPDATE dbo_CE, tblCE_Details SET tblCE_Details.LIC_NUMBER =...

Thanks for the suggestion! CRhodus

I've added a SubForm to my main form. I don't want the user to be able to add records to the table that populates the SubForm, but I do want them to be able to edit a record if it is displayed in the SubForm. I changed the SubForm's "Allow Additions" property to False to prevent users from...

Thanks! It looks like that's what I needed to check.

I have added a SubForm to my main form. The SubForm view has been set to DataSheet. I have modified the SubForm so that the AllowAdditions and DataEntry have been set to False. On my main form, I have added an "Add/Edit" button, a "Save Record" button, and a "Cancel" button. When the...

Thanks for the info. I didn't think to use SubForms but that seems to make for the easiest solution. Crhodus

Hello Everyone, We've been asked to add an additional tab to a form for one of our customers so that data can added to a new table in the database. Currently, if a user adds or edits a field, the form saves the data to the database as soon as that item looses focus. We want to make minimal...

Thanks GolfProRM! That's exactly what I need. CRhodus

Is there a way to write the properties of a table out to a text file or excel sheet? I'd like to be able to get the Field Name, Data Type, Field Size, and format for each field in my table. Thanks, CRhodus

Thanks for your help. When testing my query, I did not have my Group By correct. Thanks again! CR Junk

I'm having problems figuring out how to "Combine" two different queries. I have the following two queries that I've written: SELECT DISTINCT RecordType, InvoiceNumber, DeviceNumber, ChargeCode FROM tblDetail ORDER BY DeviceNumber, ChargeCode; Select COUNT(CallDesc), SUM(TtlCallChgs) AS...

One of our clients bought new computers with Vista and Access 2007 on it. Their application is not wanting to run a certain piece of code. I can't test with this setup. (Windows activation for Vista is screwed up on the test box we setup.) When the button is clicked, nothing happens. Has...

Thanks for the info. I might have to go this route. Crjunk

Is there a way to add/edit/view records in an access database using Excel 2003? Everything that I'm coming across when searching is going in the opposite direction. Thanks, CRhodus

Thanks! That did it. Crhodus