I need to work out how to take 'ordered product' records from an Access database and import it into Sage L50 Financial Controller as a Sales Order, so that we can use the same method of handli...
I have a query in MS Access that I need to export to an Excel template. The "TransferTo" function doesn't work because the first row of the Excel Template contains my column heading. So I wa...
I have a form that is bound to a table. I set it up so that if my user exits the form prior to filling in the required information, the form will not save a record. I want to stop the warnin...
This should be fairly straight forward.
I would just like to know how to reference records of a corresponding selected record on a form.
ie,
the form is showing record 9, how do I get ...
I have a VB 6 program that I wrote at the office. I backed it up and put it on my pc at home. It works fine at the office but I am getting the error "ActiveX component can't create object 42...
How can I do a bitwise shift-right (no rotation) in VBA ??
MS Access 2003; when an error occurs a Debug box will appear. The Debug allows the end user to see the programming code. How do I turn this function off.
I'm trying to write some cdo code that will allow for sending emails through an Access db. My email server requires authentication to send
outbound but when I attempt to send the email, I rec...
Hello Sir,
In VB 6, I am calling a Sql server2k SP, It is working fine when i run from the Code. but when i am calling that SP using EXe with command line parameters, It is giving the Error ...
How do I create a table with a autonumber as one of the fields using adox. I have tried the following code.
Set oCat = New ADOX.Catalog
oCat.ActiveConnection = _
"...
I have a report in crystal report. It is a invoice report. It has a grouping on invoice number and a detail section where the "products" are listed.
Of different reasons I have to use a variab...
I was trying to take out my busted DVD drive on my dell dimension 4600 today but after i took the front panel off it looked like i had to take the 2 side panels off as well which i could not f...
I created ODBC DSN for an SQL2000 Database. In VB I am using ADO 2.5. I created a connection object using the dsn with server side cursor. after opening few recordsets using the connection usi...
I am having issues setting a cell validation when I need to dynamically create the Formula.
strValid = "=Enumerations!B332:B340"
I have tried to put the "=" before strValid in the formula to...
Hi,
I have a VB6 application which connects to an Access2007 Db.
I can send SQL commands through ADO however I was wondering if it is possible to send an
INSERT or UPDATE statement where ...
I have a sql query I am trying to run in Excel VB. However I receive a Run Time 1004 Syntax Error message. Below is my code any help would be greatly appreciated.
Sub RunHours()
'
' Cod...
I'm able to export fields from an Access table and add a comma between each field, but I also need to add quotes around the one of the fields I'm exporting, the 6th field. This field contains ...
Hi,
I am getting a lot of Row Cannot be Located for Updating in a VB60 Pro project. When this project is run against other databases it works fine, but against one Oracle database it fails...
Hi Experts, I don't know if I posted this question in the correct category, but here I go any way.....
I have a sql server with a couple of databases on it, all the datebases have exactely th...
Has anyone come across following problem.
Mail merge with Word 2002 (XP) causes error 509.
This happens (perhaps) when the database in the datasource is already open in the code.
This f...
I'm using an access database with VB6. My program has been working well until now. I get the message 'Unrecognized database format' and then the path. I presume that I have a corrupt database ...
When attempting to open a form with a FlexGrid on it I get this error...
Run-time error 30010 Invalid column value
This only occurs on the user machines, not my development machine. Here...
Within GridView, how to validate data before updating in database.
Hello-
I have a recordset with rows that I am pulling into a VB6 app from SQL Server 2000 via ADO, and one of the fields is giving me only nulls.
r.Fields("Name").Value is how I am acce...
Hi,
The following snippet of code results in error "Rowset does not support fetching backward", in particular the .MoveLast line.
Does anybody see why?
The 2 key elements I am after...
