Recent content by taber13

Thanks , Works Great

I have a select box that stores the selected value in a textbox comma delimited. This select box also stores the numeric value (price) in another textbox comma delimited. I would like to know how to Sum all the values in a textbox that has only numeric values comma delimited.

I have some code that looks like this: If stDocName Like "*" & ".pdf" Then RetVal = Shell("C:\Program Files\Adobe\Acrobat 4.0\Reader\AcroRd32 /p/h/n, C:\Configurator\Lit\tbd620.pdf", 0) Else GoTo 20 I would like to make C:\Configurator\Lit\tbd620.pdf a variable value but haven't had any luck.

Can I mail merge a memo field?

I am trying to find an Active-X control to view word documents in a form!!!!

Try using OR in your SQL statement WHERE criteria1 = "pleasework" or null or "X" in above, if null doesen't work make "X" your default value for Criteria1. Hope this Helps

use this code on clickevent to automatically print a word doc and close form. if you just want to open it leave out the print part Dim WordObj As Object Set WordObj = CreateObject("word.Application") WordObj.Documents.Open "c:\document.doc" ' or use (Me![documentpath]) for...

If all of your fields are being Sumed in one txtbox, you might try adding a After Update Event that will do the following! After_Update_Event 'Update the Total based on which Value you modified stDocName = "txtboxthatsumsall" DoCmd.Requery stDocName

Never Mind I figured It Out Added a Event to On Current. Sorry For The Fuss!! If anyone needs any more detail on what this was about E-mail me. Private Sub Form_Current() If Me!Accessories = "Null" Then Me!accessorieslist.Selected(0) = False Else: Me!accessorieslist.Selected(0) = True If...

I am tring to find a way to select a particular row or index of a select box based on a seperate text box value. I have a select box on a form which when a item is selected it populates two different HIDDEN text boxes with certian values. when use the navigate buttons to toggle through the...

I have a application which prints documentation dependent on many different selections. I have currently automated the printing of all RTF or DOC files, but haven't seen anything on Printing PDF files. Does anyone know anything about this, or a way to accomplish this? Thanks!