Search results

Thanks! This attachment appears in another thread (122244 & in this one), I got it from there earlier. Thanks again for your help!

Where would this attachment you speak of be?????

This Db was created back in 1995 and the $ sign being added was not any of my doing. I just started maintaining it about 3 months ago. Whats done is done, need to fix it. My plan is to go back and take out all the $ signs and that was not the only thing that was entered into the fields, I...

I think I have figured out the what is making me have a run time error. I have a query that is extracting a dollar amount out of a field. The query looks for the $ sign, well if there is no $ sign, it results in an error, which in the report, it is try to do calculations on text. Once I went...

Default printer is installed, still no luck. I have also ran the report on a few other computer and there is no abnormal problems. Also checked the computers for there processor and RAM, all are equally matched. I did a performance analysis and corrected any issues, still getting a runtime...

I am having a Runtime Error 3071 in a report, but only on certain computers. It seems to be on the older/slower computers. On the newer/faster computers, the report will preview, but does take a little time to get to the preview. On the older/slower computers, when I preview the report, I get...

I am having the same problem and have come to the conclusion it is the && making the problem. Here is what you see in the label when in design mode: Three sets of plant operations and maintenance instruction (O&&M) manuals assembled by F&&C/Construction Manager and transmitted to Engineering...

Niniel, Create a Macro with these actions GoToControl is the field that you want to set the value to The FindRecord is where the value is coming from Note: If you want the value to populate a field on another form, you will have to use the OpenForm action first. These button(s) and fields...

Hey Boblarson, I got it to work, in the function (see below), the code has a if-then statement that if there is no "\" it thinks the file name is relative and tries to put something in there and therefore, you get your error. I just made that part of the code "comments", took out the "error...

Thanks for the help, but not sure where your code will go? Do I take out the existing error code? Option Compare Database Option Explicit Public Function DisplayImage(ctlImageControl As Control, strImagePath As Variant) As String On Error GoTo Err_DisplayImage Dim strResult As String Dim...

I used the code from microsoft Adding Images. The images are LINKED.

I am getting a Run-time error (2220)-Microsoft Office Access can't open the file (then state path) on a form when a user attmpts to add an image and "Cancels" out of the file dialog box. I do not have any problems if the user continues to add the image. Any ideas, would be helpful

I am trying to get this Audit Trail to work, I am using the code from this thread. I have a quick find combobox on my form, when I filter the form to just show what is selected in the quickfind box, I get this error (see attached). When I debug, it takes me to the highlight code. If anyone...

What ever happen to this? Any success in eliminating the error?

Thanks, it works fine. Sometimes you get so involved in the coding, the basics evade you.......Thanks again!

I am trying to get a form to set itself to a certain record based on a search form result. Not sure how to get my search forms result populate another form.

That would be correct. I know its not a good thing, but for right now, it is what I am working with. I plan to change it to be separate fields. EX: name1, name3, name5

I am trying to get the OrderBy to recognize wildcards (or to that effect). A scenario would be I would have more than one name in a field, EX: Name2, 4, 6. How do I use wildcards in the OrderBy and they are recognized. ORDER BY (Table.Field)="Name1", (Table.Field)="Name2"...

In a report I need to sort some records by a value in the field, but want to keep the rest of the records there. Ex: I have a DB with projects in them, need to sort the project managers so there report reflects there project(s) first but still shows all the projects from the entire...

Is there a way to create or access a history file of all events in a database?