Search results

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

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

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

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

I have a text field in a person table that holds the path to a photo of a person. The photo is stored in a separate folder on my hard drive. Everything works great except this case: I have a form that contains 4 records, each record holds a picture of a different person. I have no problem...

I have a one field text form that has no record source that a user enters a case number. once the case number is entered the user presses enter and another form pops up for the user to enter personal info. If the case number is already in that table then existing info will already be there...

I have a image control on a form thats source points to the path of the folder where the picture is stored. This works fine. However I have a report that also needs to show that picture and I am unable to create an image control that will show that picture. Any help is greatly appreciated. BAC

I have a image control on a form thats source points to the path of the folder where the picture is stored. This works fine. However I have a report that also needs to show that picture and I am unable to create an image control that will show that picture. Any help is greatly appreciated. BAC

I have an OLE field that holds a picture of a person. I have approx. 15,000 records and definitely do not want to put that many photos in an access table. Is there a away to refere the picture of a person to a separate folder on the hard drive? If so how would I relate the photo to the...

I have a memo field on a form and when I use the [F7] key to spell check I get the message that the spell check is complete but there are still mispelled words present. The spell check is not catching the mispelled words. Any help is greatly appreciated.

I have a database that stores pic of subjects. I would like to store the pics in a separate folder and not in Access. How do I tell Access to link to the picture that is stored on the same drive but different folder? I would like Access to automatically link to the picture that I would name...

I have 5 subreports that contain one field each that I need to total on the main report. I cannot get the control to calculate the five fields. Any help is greatly appreciated. BAC

I am doing a long division in an unbound field and would like a certain unbound field to show only the remainder of the division not the whole number. For example, if unbound field [Text 2] is dividing 327 by 11 I want unbound field [Text 4] to show only the .8 remainder of that division...

I have 17 unbound fields on a form which stores 1 character in which the user will enter a number or a letter. I have 17 more unbound fields that I need to translate the number or letter that the user inputs into a certain predetermined number. For example, "A" = 1, "B"=2 and so forth. Any...

I have a check box (yes/no) on a form that I have included in a query. I would like to count the check box and display how many times the check box is checked and display this info on a report. Any help is greatly appreciated. Thanks. BAC

I have a report based on a query. The report sums values from the query. However, when a certain value is "0" the field on the report is blank. I would like for there to be a "0" in the field instead of a blank. Any help is greatly appreciated. BAC

I understand the purpose of many to many relationships and in the DB I have designed I need them. However I am having difficulty understanding how to use them. I have created intersect table that hold the primary key of one "tbl A" and the primary key of "tbl B". How do I get the table to...