Search results

I get the path to the image working ok. It is just that I am worried about how it will work when I send it packaged to another user.

What is sagekey? Is it an alternative to the access developers kit?

I am using the access developers kit. I have to link to the image using a filepath. Are you suggesting using just C:\image.jpg for the directory?

I have a database which fills in a 3 different forms, consisting of 2, 3 or 4 pages respectively. I am using a watermark or background image for the reports produced (i.e. the reports are copies of standard forms). My problems are: a) The reports take too long to load if the images are...

Thanks, that is handy. Is it possible to assign the path to the current directory, without specifically giving the path, because I wouldn't know which directory my users would be putting the .mdb file. Geoff

I have a report with a background image (watermark). I have made it a linked image as it makes the report very large. I would like to make the link to the image relative to the current location of the database, rather than an absolute location link. Is this possible? This would enable...

Thanks very much. I can't believe I overlooked that!

I have looked at the other threads on this but haven't come across exactly the same problem. It is driving me nuts. Here is the code that I am using to select fields in a list box and put them into an unbound textbox: For x = 0 To lstProcName.ListCount - 1 If...

I have used similar code to try and select a number of fields, but for some reason, the selected field is not picked up, i.e. the loop is never entered, as if nothing was selected. This is my code: Dim vntIndex As Variant 'Loop through each item selected in the list box, 'storing...

Did you ever have any success with finding a more reliable method?

the report tries to squeeze the 2 pages into one if I put the 2 pages into one jpg, even if I put a page break in the middle of the picture. I guess that makes some kind of sense, but I still can't get my 2 pages into 2 pages of report.

I tried that and the 2nd picture went into both pages. Maybe I did something wrong, but I am experimenting with combining the 2 pages into one jpg.

I have a form which covers 2 pages, which I want to reproduce in a report. I can do the first page fine. I scanned the first page and used it as a background (with the problem of field alignment noted in another thread). Does anyone know how to put in the scanned picture of the 2nd page onto the...

That worked. Fantastic. You saved me hours. I have to revisit all that stuff about text and numbers pronto.

I am trying to get a report, based on a query, to open on the current record in the form I am currently in. I have a command control which when clicked issues the following: stDocName = "rptQuinnClaim" sSQL = "[tblQuinn.MemberNumber] = " & Me.MemberNumber & " And [tblQuinn.Date] = " &...

I did a bar graph which had 3 columns, 3 fields, one for each day. It was bit cramped so I edited it by double-clicking on the graph, and deleted a column, and also changed the legend. Now there are 2 columns in the graph and the legend is correct in design mode, but when I run the report, it...

I eventually sorted it out by taking the repair option on my Microsoft Office 03 CD. It works fine now!

I just deleted and recreated the form and it went away. One thing I noticed was that the first time I created the form I tried to run it before I had saved it and the system objected. I wonder if this created the problem?

I got this problem when I added a menu form. It has 3 command boxes; one to close the form and 2 to preview reports. One minute it was working and the next it gave the above error. Seems hopeless.

I have figured something out by following some of your principles actually. I stuck the SQL into the row source and included a condition that the tools in stock must not be zero. This seems to be working a whole lot better. I must set about debugging the rest now, Thanks very much for your...