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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: dpaulson
  • Content: Threads
  • Order by date
  1. dpaulson

    Command object with MySQL

    I want to modify my accounting app to use MySQL database instead of an Access database. Below is how I write my command and parameters for an access db. strSQL = strSQL & "FROM AR_Invoice_Detail INNER JOIN (Invoices LEFT JOIN AcctsReceivable ON Invoices.CustID = AcctsReceivable.CustID) ON...
  2. dpaulson

    Object variable or with block not set

    Hi, I have the following code in a module Public Function CallingForm(ByVal hWnd As Long) As Form 'Return the Form that launched the given Window Dim lHwnd As Long Dim oForm As Form 'get the Handle of the Window that Loaded this Window lHwnd = GetNextWindow(hWnd...
  3. dpaulson

    Scanning with WIA

    I can scan and put the acquired image into a picture box with Set wiaCDL = New WIA.CommonDialog Set Picture1.picture = wiaCDL.ShowAcquireImage.FileData.picture but the picture is huge. Only the top left corner can be viewed. Also when I print the image to a print, only the top...
  4. dpaulson

    WIA

    I am doing some experimenting with scanning documents using WIA. At my work computer I have vb6 installed on a winxp machine which WIA works good. At home I have vb6 on a vista machine and my program errors when I try to install the WIA commondialog control on the form.I get system error...
  5. dpaulson

    listview

    Is there a way to 'move the scroll bar automatically' as to keep items that are added to a listview visible ? David Paulson
  6. dpaulson

    Electronic Signature

    Has anyone here ever used an electronic signature capture pad made by Topaz Systems Inc. They have some examples fo using the pad with VB, but I cannot figure out how to print the signature image to a printer using VB code. David Paulson
  7. dpaulson

    SELECT INTO

    Can the Select Into statement be used to insert data from one table to another table that already exists? I can insert data into a new table, but not into one that already exists. David Paulson
  8. dpaulson

    Recordset and command object

    What kind of recordset is created when set to a command.execute statement? Set cmdGSTSalesAmount = New ADODB.command cmdGSTSalesAmount.ActiveConnection = cnAccounting cmdGSTSalesAmount.CommandText = "SELECT sum(TotalGSTSales) as MonthTotalGSTSales,sum(TotalNonGSTSales) as...
  9. dpaulson

    Dates and ADODB.Command

    I have a problem that I can't seem to correct. I have the following code Dim cmdGSTSalesAmount As ADODB.command Dim prm As ADODB.Parameter Dim rsGSTAmount as ADODB.recordset Dim StartDate As Date Dim EndDate As Date and then Set cmdGSTSalesAmount = New ADODB.command...
  10. dpaulson

    sql

    I am stuck on creating a sql for an access database. I have a table named GLTransactions. It has a couple of fields named GLAmount and GLTransDate. What would the sql that I would use to get the value of GLAmount from the transaction that has latest GLTransDate. David Paulson
  11. dpaulson

    Update Query

    Is there a way to issue an update query that can do simple arithmetic to a value that is in the database? For example strSQL = "UPDATE Table SET Field = Field + 1" David Paulson
  12. dpaulson

    SQL

    I have a table called Invoices. I need to create an SQL that will sum up all field data (DebitTotal) to create Balance, sum of field data (DebitTotal) that is less than 1 month old (InvoiceDate) to create PeriodOne , and so on to PeriodThree. Can anyone give me a hint as to how this SQL...
  13. dpaulson

    Dates in an Acess DB

    I have a app that I've written in VB6 which uses an access db. In a table in the database I have a field as a date/time. When looking at this field with visdata it looks like is stored in a m/d/y format for the first 12 days of the month and d/m/y format for the rest of the month. What do I...
  14. dpaulson

    SQL

    I have two tables. One is Vendors and the other PurchaseOrder. They both have a common field VendorId. The VendorID in the Vendor table is unique, but there can be many instances of the same VendorID in the PurchaseOrder table. I need to return all the fields of each Vendor (only once) that...
  15. dpaulson

    VB and Crystal 4.5

    Is it posible and how can I get crystal to print the contents of a variable in a vb form. David Paulson
  16. dpaulson

    Dates and SQL

    I'm having trouble using dates with an access database. The field in the database is type date/time. These dates are stored as dd/MM/yyyy format. When I use a date in my SQL which has a date for example "...<=#12/02/2006#... " (Feb. 12/2006) it returns records which include records whose...
  17. dpaulson

    default drawing template

    When autocad2006 is started, it opens up a new drawing using acadiso.dwt. How can I get it to default to another template. David Paulson
  18. dpaulson

    Send to dropdown list

    Hi When you right click on a file, a drop down list appears. One of the selections is 'Send to'. Is there a way to install 'Flash Disk (F:)' into the sendto list. Thanks David Paulson
  19. dpaulson

    VPN Server

    Can win 2000 pro be used as a vpn server. If so does anyone have a link showing directions. I've set up nt4 workstation as a server before, but having trouble with win2000. thanks David Paulson
  20. dpaulson

    I have set up a nt on my network to

    I have set up a nt on my network to act as a vpn server. The rest of the machines are win98. I have printers set up on these win98 machines. I can browse the network fine and see these printers. I install them on the nt, but when I print a test page and error pops up 'Filename, directory...

Part and Inventory Search

Back
Top