Search results

Office 2010, merging address lines from Excel into a Word document. Some, not all address lines of an address come in as Os. The Excel cells contain text and are formatted as text. I am really puzzled. Can anyone help, please !!

I have now got the original code working, embarrissingly it was errorring because of a typo ! Thanks mtn, that is really neat! David C: Thanks for your input as well but having sorted my spelling the code is working. MaxD: True/False is the correct syntax Thanks to all responders. peter

Thanks again for your help with this. The form is a subform and the image control and this code is on it. In the On Current event With CodeContextObject FullPath = "Z:\Database\2000\Returns\images\" & Trim(Str(return_no)) & ".jpg" Debug.Print FullPath If Dir([FullPath]) <> Empty Then...

I am afraid I cannot get the code to work ! peter

It is falling over on the .Visible lines ??

Sorry David I did not read your post properly :( No it does not load if there is an image there, and has the same error.

Sorry for duplicate, I thought the first entry did not post ?? David: Yes it does

If only I could remember everything I read in this forum ! :rolleyes: Thanks for the explanations I have tried the code within the OnCurrent of my form substituting the name of my image With CodeContextObject FullPath = "Z:\Database\2000\Returns\images\" & Trim(Str(return_no)) & ".jpg"...

I wish I could remember all I read in this Forum !! :rolleyes: Thanks both of you, I will experiment. In searching for a solution I found this long thread on another forum. It seems to require a photo for every record or a dummy. http://http://www.tek-tips.com/viewthread.cfm?qid=289543 peter

Simon, that looks exactly what I want, thanks. I am not familiar with "CodeContextObject" and reading the help file was not that clear. My interpretation is, whereas Me represents the object that currently has focus, CodeContextObject is the object in which that code resides. Is that correct? peter

Yes a bit of a catchall as the error is "Error 13 data mismatch" !

Thanks for replying That is exactly what I have but it errors if there is no image. Not all records have associated images. It is the checking code I am after ! Then I can make a button visible and that will open a form with the image on it.

I have searched the forum but not found something that matches my requirement. I have FE BE networked db using A2003 Images are stored by users in a specific folder which is one level below the BE db. They name them with the reference number asociated with the item. For example DA2345. They are...

Thanks vba that worked fine when I added a setfocus line to provide a destination for the cursor.

Thanks but that does not answer my question. I want the movement to require no special knowledge of keystrokes.

I have a Form with a subform. The subform can have several records relating to the form but usually has only one. I want to stop the subform allways rolling onto the next blank record when the user tabs out of the last field, the cycle setting should do that. I built a short message box and if...

Thanks for your reply. This is happening for one user, consequtive SELECT INTO statements ??

Sometime ago I wrote a report that was based on a linked table in a Foxpro database. Briefly the code does the following: Makes a new table of the linked table locally, using just the columns required. Generates a report built on this new table with Count and Sum of values for the final page...

I changed the source of the Form/Subform to a query that included both tables and now all is well! Thanks for your help.

Vba my last last post crossed with your first. I believe the FilterName in OpenForm has to refer to a Query, I need it to be able to open different records according to the current SerialNo record displayed. Vba your second post. I think as GalaxH' was saying that because [goods_aserial] is not...