Search results

Is it possible to search for objects that are not used in a database? or even a way to count every time a object is used?

Is it possible to get PDFs in reports? I have managed to get them appear in forms using both the adobe pdf activex and foxit activex, but they won't appear when I put them in a report.

It is ok I have now found the solution, use transfertext to export as txt and rename it using: Name "C:\Exports\MyFile.txt" As "C:\Export\MyFile.rpd"

Hello, I'm trying to export my query to a file called filename.rpd (this extension is needed for the program I want to import the data to) It works when I use the extension .CSV, but is it possible to export a file with any file extension? Thanks!

Thanks vbaInet, I have been trying to resolve this for a long time and now it works after reading the section about Enabling Graphic Filters, I downloaded the FileFormatConverters pack and IT WORKS!! :)

The file extension .tif are the images not being displayed, but the images that are being displayed are also .tif. Can't see any pattern at the moment, going to look through them and see if I can spot anything, have looked at about 10 so far and not found anything.

They are not stored in the db. I have inserted a Image Control on the report and have set the Control Source of the Image as the Path of where the Image is stored. This is the what I've done...

Roughly about 50% don't appear on the Print Preview. Layout View and Report View you can see all the images.

Hello, I have put an image control on my report and linked to the data source, when I view this report in Report View I can see all the images, however when I change this to Print View most of the images disappear. Anyone know how I can fix this? Regards, Phil

I'm trying to do this also... have found this... http://access.mvps.org/access/forms/frm0007.htm I have not figured out yet where to put the code so that I can select it in my criteria...

Hello, I have looked everywhere for this and can't find anything that helps me. I have inserted the crystal reports viewer activex in to a form and I can't find anything on how to make this open one of my reports I've created, the data the report is using is from oracle. Thanks in advance.

Gkirkup, did you get the answer, i need the same thing.

Thanks much appreciated!

Hello, I have a date field that I need to be able to do the following, if it is dated between thurs-tues then the date should be the previous Wednesday.

I no longer need help, just needed to add a line to the macro to close the form after adding.

Hello, I have created a Macro with three setvalues. I have added this Macro to the event for onclick on a Tickbox but when I tick this box on the form it overwrites the record in the over form rather than Adding a new record. What would cause this? the Data Mode is Add...

I don't have the option restructuring the data unfortunately. I am using this to give me a Minimum and I was wondering if this could be changed to do a count, not sure how I'd do it thought: Function Minimum(ParamArray FieldArray() As Variant) ' Declare the two local variables. Dim I As...

Hello, Can someone help me with a VBA to count how many fields have a value. I've had a search but can't find what I am after. In crystal reports I can do it using count(myarray(field1,field2,field3) but not sure how I'd do this in Access. Thanks.

I am also a beginner with access and want to create an MRP system. BOM is where i'm stuck, every book i've read so far has nothing on this. Any sharing would be appreciated.

Sorry! I should have read what I typed before posting. Stopher was right I need the output: Field A____Sum Field B 1___________12 2___________13 And not Sum of field Field A = 12 and sum of Field B = 13 (which makes no sense)