Search results for query: *

I am having a problem with a query I am trying to run in VBA. When I run the query, it will work with Access 97. But when I put the same SQL code into VBA, it will return nothing. I am baffled by this. Here is a piece of the code below. Some of the stuff was censored. Dim rstWOAM As...

I am trying to convert a text field to a number field. We have a data warehouse, and the table in the warehouse stores number values as text (Why?! no clue!). How can i change the value type on the fly in an Access SQL query? I've tried the CDbl function since the values have 2 decimal place...

I want to import a query from access into excel, and I keep getting the error "Too few parameters. Expected 1". The thing I don't understand is the query will run flawlessly in access, but for some reason does not work when wanting to import it into Excel. Suggestions?

My company has a small access 97 DB that takes raw data from a linked excel file. In Access we can use this as a normal table to join in particular queries. But when I try to run an SQL using ADODB (Recordset,Connection,Etc.), it will say that it cannot find the linked excel table... Is there...

I am trying to get a NIC card to work on a computer at work. The type of card is an Accton Cheetah PCI FastEthernet. The Computer automatically recognizes the card, but it will not work. It will not send or receive any packets from the network. I've tried using a 3com Card and the same...

I am trying to use the Packaging and Deployment wizard for a crystal reports VB6 program that I am developing. When I get to the end of the wizard and click finish, it will give me the error of "Unexpected error number 80010108 has occured: Automation error The object invoked has...

What I am trying to do, is take text from a WebBrowser component in VB and then place it into a text box. If anyone knows how to do this, please let me know. Thanks.

When I try to format a date to get the Year, it will have 2/3/1997 turn into 1,997.00. How do I get rid of the Decimal and also the comma format so when I use the formula it will just have 1997?