Search results

Yes, that worked perfectly. Thank you! Robert

Is it possible to have an image in Access (say a photograph) that can be copied and pasted, into Word for example? I have photographs on forms, but I can't copy them. Robert

I have a report on which two controls are not to be visible if the Yes/No field STOCKDISC is false. I have tried the second code routine in report open, the report does not print. I then tried the same routine in report activate. The report ran, but the two controls still appeared when...

I have an image that is displayed by an image control on a form. A combo box allows the user to select an image, which is then displayed on the form. I have been asked if there is any way that the users can copy and paste from that image. Is there a way to do that? Robert

Gina: So if Hasdata is false, I can just say Cancel = True? Would that cancel the entire report? Robert

Gina: This is an unattended report - it prints to a printer in another building as part of a process. So I definitely need the report to not print, not to give a message. Robert

There will always be header information on the main report. When there is no data on the subreport, then I don't want to print the report. Robert

Delikedi: That solved it. I now have 3,400 photo names in my table, and it works great! Thanks so much for your help. Robert

Delikedi: That looks great! However, on trying it I get a 'Compile Error: Expected: End of Statement' on the line strSQL = "INSERT INTO - on the word INTO. I set up a table PhotoNames and of course used PhotoNames in the SQL statement. Any suggestions? Robert

Delikedi: Thank you. I am sure that is the problem. My preferred approach would be to use something like your code to load the file names into a table. Once I have the file names in a table, I should have no trouble. Any ideas on how I can load the file names into a table? Robert

Delikedi: This is my code, in the On Open area of my form: Private Sub Form_Open(Cancel As Integer) Dim strFotoPath As String Dim fsoObject As Object Dim objFolder As Object Dim objFiles As Object Dim objFile As Object Set fsoObject =...

Delikedi: Thank you. You sample code looks like just what I need. I like the idea of a combo box that will autocomplete. I have a combo box with Value List as source type. Now what is the row source? I am not clear where I would put your code, to be used by the combo box. This is my first...

I want to display a photograph on a form. But not embed the photograph on the form. What I want is a control where you enter a part number, and a photograph of that part displays. (The part number is the file name of the photograph of course.) There are thousands of photographs. Any...

I have a report with a subreport. Sometimes the subreport has no data, in which case I don't want the report to print at all. How do I do that? Do I put a DoCmd.Close into the On No Data area of the main report, or the subreport? Or do I need to do something else? Robert

Jdraw: Thanks. But I found a better way to send emails. I now use DoCmd.SendObject and it works every time. It also only gives you one pop up warning message. Robert

I am sending an email using SendObject. Sometimes it works, and sometimes it makes the computer freeze up with no error message. I have tried this with Outlook running or not running, seems to make no difference. 'The sub procedure below sends e-mail in response to a click on the Send...

I never solved that problem. But I got around it by copying a label that worked correctly, and then copying all of the text and controls to that label. That was a good work around. I have had problems with page setup. Sometimes margins that I set change on their own. Robert

I have a report object which prints a big label on a laser printer, about 4" x 6". But only half the width of the label is printing (the left half). Then there is a form feed, then the right half of the label prints. I have tried various options in Page Setup. The paper size is 'letter'...

My mistake. The report object was linked to an old table. I took that out and it worked OK. Robert

I have a form which creates a simple label. Then a button on the form does a DoCmd.Openreport to print a report object with the fields from the label. That works OK, except that it would print hundreds of pages if I didn't quickly cancel it. How do I make it print just one label? There are...