Recent content by Gerilee

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