Recent content by zlovelife

why not store the location of the document and let all of the applications have access to it by filename and path. This way, How hard could it be for Word to figure out what's going on? Or for VB for that matter! Pete _____________ Real programs don't eat cache

have you tried reinstalling it? Not that I've ever had to install the same Microsoft package more than 12 times... but you just might want to try it one more time. yanno? If it doesn't work the next time... email me at zlovelife@aol.com and we'll see what we can come up with Pete...

I've had similar things happen if I forget to code doevents in a lengthy loop or if my app is using most of the available memory. Pete _____________ Real programs don't eat cache

You can do just about anything using the API. Take a look here. http://161.58.84.211/ref/index.html Pete _____________ Real programs don't eat cache

Here's a link that will show you how. http://msdn.microsoft.com/library/books/advnvb5/ch03_30.htm Pete Pete _____________ Real programs don't eat cache

Have you considered using crystal reports for your report? You can easily set the number of copies printed using the copiestoprinter property. Just a thought Pete _____________ Real programs don't eat cache

Or you can allow the user to select the number or reports at runtime using datareport1.printreport true and letting them print from the print dialog box which includes copies. Pete _____________ Real programs don't eat cache

Try this Private Sub Command1_Click() On Error Resume Next Dim AnhCost As Currency, AnhRate As Integer AnhCost = InputBox$("Enter the cost of ahydrous.", "Anhydrous Cost") AnhRate = InputBox$("Enter the rate of anhydrous per acre.") Text1.Text =...

how about something like this SELECT Int(Rnd()*9+1) & Int(Rnd()*9+1) & Int(Rnd()*9+1) & Int(Rnd()*9+1) & Int(Rnd()*9+1)& Int(Rnd()*9+1)& Int(Rnd()*9+1)& Int(Rnd()*9+1)& Int(Rnd()*9+1)& Int(Rnd()*9+1) AS Expr1 FROM someTable where criteria Pete _____________ Real programs don't eat cache

I'm sure this has been asked a million times but.... I can't seem to find an answer so I'll ask it for the millionth and oneth time. I want to do a floating combobox over a datagrid to allow my users to select data items from a list. I understand the concept well enough but I haven't used...

There's a DLL at this site that creates PDF files from regular files. Then instead of printing. Just write a flat file formatted the way you want it. http://www.programmersheaven.com/zone1/cat247/16720.htm Hope this helps, Pete _____________ Real programs don't eat cache

Try the UpdateControls Method check it out in MSDN. Sounds like it will do what you want. Hope this helps Pete Hope this helps, Pete _____________ Real programs don't eat cache

If days_booked is defined as numeric in the database you need to lose the quotes around Intbook as Chiph said. Hope this helps, Pete _____________ Real programs don't eat cache

This basically sets a recordset pointer to the child recordset allowing you to work with the child like you would with any other recordset. Private Sub mysub() Dim rs As New ADODB.Recordset With adoPrimaryRS Set rs = .Fields("ChildCMD").Value rs.AddNew...

Seems like this intBook = Val(Trim(Mid$(srchCriteria, 2, Len(srchCriteria)))) should start in position 3 not 2 ie intBook = Val(Trim(Mid$(srchCriteria, 3, Len(srchCriteria)))) so I think when you have a two position operator such a >= and you paste it all together you get >== because...