Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Kleinen

    Access mail merge

    You can turn the warnings off and with this command: objWord.DisplayAlerts = wdAlertsNone After the mail merge you can turn the warnings on with the following command: objWord.DisplayAlerts = wdAlertsAll Hope this helps
  2. Kleinen

    Dr Watson error

    Our application is used on different PC's. On 1 PC however the user receives the error "MyApp.exe .exe has generated errors and will now exit ..." and the application crashes. When I check the event log this is the errormessage: The application, , generated an application error The error...
  3. Kleinen

    End satement not working

    If you want to close the form you should use Unload Me or DoCmd.Close
  4. Kleinen

    adding a record to a sql table through access

    Since the table is a linked access table to an SQL database, the recordset that you have created by using select is a read only recordset. You better insert a new record by using Insert into tbl (col1, col2, col3) values ("a", "b", "c")
  5. Kleinen

    SEND SMS FROM MICROSOFT ACCESS

    You will have to contact your local mobile phone company. They can give you the necessary information and software and they will also tell you how much it will cost to send an SMS.
  6. Kleinen

    Paperbin

    Hello everybody, I am writing a program where the user can choose the paperbin to print a Word document. The problem is that sometimes the printer uses the right paperbin and sometimes the printer uses another paperbin. The printer is a Xerox 440st Here is the code that does the printing...
  7. Kleinen

    Sub or Function not defined error.

    It should be: If strTray <> rst1Up!field3 Then GoTo Even_Tray_Break
  8. Kleinen

    Out of stack error

    Problem solved. I changed the code a little so that the recursive part of the filling of the treeview is less extended. Thanks for the suggestions
  9. Kleinen

    Out of stack error

    yes I am using recursion to fill the three
  10. Kleinen

    Out of stack error

    I have a program that at startup must fill a treeview. However one branch of the treeview is getting very huge. In fact so huge that I get an "Out of stack" error. Is there some way in VB that I can change the stack size? TIA
  11. Kleinen

    How to write a trigger

    First link your SQL table in your Access Database. Then make an update query to add the new info in your Access table.
  12. Kleinen

    Replacing comma with OR

    Dim strText As String Dim intLastPos As Integer, intPos As Integer strText = &quot;cats,dogs,house,mouse&quot; 'The InStr function returns an integer stating the start of the string 'you where looking for in another string 'First argument: the place in the string where to start looking 'Second...
  13. Kleinen

    Replacing comma with OR

    This should work in Access 97 Dim strText As String Dim intLastPos As Integer, intPos As Integer intPos = InStr(1, strText, Chr(44), vbTextCompare) Do While intPos <> 0 strText = Left(strText, intPos - 1) & &quot;* or *&quot; & Mid(strText, intPos + 1, Len(strText) - intPos)...

Part and Inventory Search

Back
Top