Search results for query: *

Thanks for all of the responses. I'm not using DateDiff as I have my own code. What I am having a problem with is not the actual code but where to place the code because the controls on the report were not being recognized when I was calculating the age from the on format event of the section...

rjoubert, Thanks so much for your quick response. If you would be so kind as to provide me some clarification. I am opening the report from a command button on a form (the form is used to enter some criteria). The command that is executed when the command button is executed is --...

I have searched in the forums and the FAQ's for this answer and can't seem to find what I need so if I've missed something, my apologies. I have the code to calculate age using a date of birth. I want to display it on a report in a textbox named txtage. The report uses a query as it's record...

Hi jebry, This definitely helped me to realize that I was on the right track. The tables are linked by SSN which I am not allowing the user to change to I thought that I may be able to "catch" the update before actual focus went to the subform. I had already put some code in the Enter event...

I have a main form and a subform. The main form has a SAVE command button as I do not allow automatic updates on it. But, when I tab or click in the subform, any changes that I made to the main form are automatically saved. I tried to handle this by putting some code in an event that would be...

CharlieT302, I created the toolbars by right-clicking in the menu/toolbar area and picking Customize. Yes, the properties reflect the correct toolbar. After I submitted this question, I continued to research and found something about the way the shortcut on the desktop calls the application...

I have an application in Access 2003 with several input forms and a report run from a form after the user inputs a date. I created toolbars for the forms and the report page. Examples of names for the toolbars that I use are MainForm Toolbar, History Toolbar, and Report Toolbar. The MainForm...

Hello, I have an unbound OleObj (object frame) in a form that I link to a Word Document. The Word Document is several pages long. I can only get the first page of the document to display. I have changed the size mode to Zoom and experimented with some of the other properties but can't seem...

PHV, Thanks! That works great!

PHV, Thanks for the response but could you clarify that a little? I'm not sure what you mean. Thanks!

I have an Access report with a calculated field called txtrptage. It is calculated using the DateDiff function in the Control Source property of txtrptage. If it calculates to a number less than zero, I want it to display **** instead of the negative number. I put the following code in the...

Hi Golom, Thanks so much for your help. Your answers were very helpful and easy to understand!

Hi Golom, Thanks so much for the sanity check! I will definitely give them a more user friendly message. I am intrigued by your suggestion about giving them all of the available container numbers for that year. Could you expand on that a little further? Thanks much.

Hi all, I'm hoping someone out there can help as I have been reading all morning so now I need some advice. I have a table where I have defined the primary key as a combination of 2 fields in one table -- the year and a container number(contno). The table holds 4 years of data. A container...

Hi all. Is there a way to make the cursor automatically go to the next field when using an Access form to enter data? In other words, if I am entereing data into a field with a length of 3 and I enter 3 characters, how do I make it go the next field in the tab order without pressing enter or...

In the Before Update property of my form, I am using With and For Each along with Case and a value in the Tag property to validate all of the required fields on my form. I've got it working to display the control name/field name in the error message by using the Name property. This displays...

I wanted to clarify what I had to do to make this solution work. Along with setting Required = No and Allow Zero Length = Yes in the table, I also had to put the following code in the After Update property of Fld2 -- If IsNull(Me.Fld2) Then Me.Fld2 = " " End If

stix4t2, How would I do that? That's what I was thinking when I put the validation on the control's Change event but the date was transposed by Access before my validation started. Am I missing something? Thanks.

PHV, Thanks for the quick response. It works like a charm.

I have a primary key in a table comprised of 2 fields. Fld1 by itself can be a duplicate and Fld2 by itself can be a duplicate but together they must be unique. Fld1 must have a value entered but Fld2 does not always need a value entered. Is this possible? I can't seem to get it to work. I...