Recent content by coynesj

Is there a way of summing a row of assorted numbers in excel that will omit the lowest two?? Thanks in advance.

I have a series of tables that cascade down from each other. I want to insert a calcuted field that multiplies two numbers in the same table and one that is entered at the previous table. Unfortunately, the calculated function will only let me multiply the two numbers in the same table...

Cheers.... What do you mean run it in a shell?? I have limited VB coding experience, would this be easy enough to do... I import images into the data base relatively easily by using a file path and connecting that to an image box. Is there no similar way of doing that with the PDF's??

Cheers, The pdf file contains a drawing on A4 that I want to insert into my report with ease. There are multiple drawings so it has to be done by linking the file and an image box using a file path... If it's possible to make the conversion from pdf to jpeg I need it to happen within my...

Hi Guys, This is literally the last bit of functionality I need to complete my database. How can I import a PDF file to show up in a report. If I have to convert to jpeg, that's not a problem, just need to know how to do it? Any suggestions will be greatly appreciated. Thanks

That's it exactly what was needed.... I decided to try the control source after posting the original error.

Scratch that, I got it working... Thanks again

Thanks James, it makes perfect sense what you're saying but unfortunately I am still getting an error (#Name?) Any suggestions??

I have a field in a form for the user to enter the name of a file. The fie will already be created in a specific location (C:\Desktop\) and be a specific file type (pdf) I want to take this file name and devlop it into a set file path e.g. after the user enters "filename", somewhere in the...

Can I do a lookup in a report from data in a form?? If so, how do I format it, cause I just can't it to work, I keep getting #Name? which leaves me thinking that I am just making some sort of syntax error... Thanks in advance...

Sorry, you're confusing me a bit... I am not storing the images in the database, they are in a completely seperate folder on my server.... The only connection to them is their file path that IS stored in the database... I just need to know how to pull this link into my report as I can't get a...

Create the form first with a name (REPORT NAME) and create a button in your form. Go to the button in design view, right click and click on Build. Type the following between the private sub and end sub: DoCmd.OpenReport "REPORT NAME", acViewPreview, , "[PRIMARY KEY] = " & Me.PRIMARY_KEY

Thanks for getting back to me... When I say that I created a form from the table, I mean that after creating a table, I generated a form with all the elements of that table in it. I then created a relationship between that table and another containing images. These images are stored on my...

Hi guys, Having an ongoing problem at the moment. I have created a form for one table. It contains a combo box linked to another table. This second table has a primary key that is the name of an image and another field which contains the file path to that image. The combo box shows the...