Recent content by bill crumpton

I am using the DateDiff command to calculate the difference in two dates, but I am receiving a negative number when I need a positive number. Can anyone please guide me in the right way? Thanks. :D

I have created a form that can contain multiple records. On the form I have an unbound image field that contains the path to a stored picture on my server. Everything works fine unless I have I have two or more records on the form. Example: I direct the path to Jon Smith's picture on one...

Thanks Brian. Help me out on how to do the RST please. New to me. BAC

I have a form that shows the results of a parameter query. The properties set to Continuous. One of the result fields is an ole image box that shows the picture of a person. I have the following code in the 'On Current' property of the Form: Private Sub Form_Current() On Error Resume Next...

Pat, Thanks for the response I will check it out. BAC

I have 3 fields on a form. the first is the area code for a phone number, i.e. (000), the second is the prefix for a phone number and the third is the suffix of the phone number. I need to know how to automatically set the focus to the second field after the user enters the three numbers for...

i have a phone number control on a form with the format of (000) 000-0000. However if I create an unbound text field on a report and want to concatenante the phone number field into some text then I loose the format of the field. For example: the phone looks like this in the...

Thanks Pat, I'll try it. BAC

Thanks Jack that worked perfectly. BAC

I have a form that contains a yes/no control that when checked will make the subform visible and when unchecked make the subform invisible. The problem I am having is that when I check the control the subform will not appear unless I close the form and enter into it again. I have tried requery...

I have a report that prints from data entered into a form. The page numbers fine on the report, however there are times when I have to attach other pieces of paper to the printed report and number them consecutively with the Access report so now the page numbers do not match. Is there a way in...

JJT, Just add the following code to the "Add New Record" command button: me.yourfieldname.setfocus This will work for you. BAC

Thanks Carol!!

Carol, I have thought of that and have created a nice bitmap file to view when no person ohoto is available. I guess the problem I am having is setting it as the default value for thr image control on the form. I do not have a OLE control instead I am usins a text box to hold the path to the...

Thanks Al, That is exactly the way my db is set up. My problem is when I enter a path for one picture, that same picture remains the default picture for evry record. I am trying to see if there is a way for the picture to remain only with the record it is assigned to as opposed to every...