Search results for query: *

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...

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...

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...

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...

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

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

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

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...

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...

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

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

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...

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...

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...

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

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...

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

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

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

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...