ADO Connection to MaxDb
Using VBA (Excel 2007) I am trying to connect to MaxDb using the following connection string sapconn.Open “DRIVER={MaxDB};” _ & “SERVER=sapdevsrv_DEV_00;” _ & “DATABASE=200;” _ & “UID=AMJAD_PBL;” _ & “PWD= ;” But it’s generating an error saying [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified For your convenience the system [...]

Answer Question   |  March 31, 2010  1:15 PM
ADO Connection, VBA, VBA: ADO Connection to MaxDB

Creation of array for input of data
Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ‘;’. There would be a maximum number of 10 entries [...]

Answer Question   |  March 29, 2010  1:08 AM
Array, LOOP statement, Update records, VBA

.DAT file of unknown structure
I have been given a series of .dat files of which I do not have the file structure. They are produced by a system that tracks elctrical consumption. All I know is the brand “iPT”, and that the owner connects to it via HyperTerminal in order to get the data. I work mostly with VB/VBA, [...]

Answer Question   |  April 7, 2010  8:43 PM
VB, VBA

Subtraction using Excel VBA
Hi, I’m creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I’m selling, and another column for the number of these items that I have in stock. Next to each of the item, I’d like to create a button. So here is my question: [...]

Answer Question   |  April 24, 2010  6:53 AM
excel, VBA

VBA Copying rows where a range has the same value as another
I have a problem where there is a large list of names in excel and a large number of other columns with data about them. One of the columns contains the section name they come under. There are 60+ different section names and these names change name a lot. I have been tasked with writing [...]

Answer Question   |  March 17, 2010  8:20 PM
copy, Unique Values, VBA

VBA – Mail Merge Automation via Access
Hi, I’m not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter [...]

Answer Question   |  March 3, 2010  8:35 PM
MS Access, MS Word, VBA

Need loop to cut rows that meet criteria and paste to another sheet.
I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

Answer Question   |  March 3, 2010  9:55 PM
Excel 2003, Excel macros, Microsoft Excel, VBA, VBA/VB

vba loop help
i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 [...]

Answer Question   |  February 19, 2010  4:14 PM
Excel 2003, Excel VBA, Microsoft Excel, VBA

Access VBA Code stops at Midnight
Why do all my Access VBA scipts stop at Midnight?

Answer Question   |  July 23, 2010  6:56 PM
Microsoft Access, VBA

Initiate Lotus Notes agent from VB/VBA
We have a Lotus Notes database with a button to create a new document. The button runs some LotusScript and sets fields in the document. I would like to be able to “press the button” from VB/VBA

Answer Question   |  February 5, 2010  10:11 PM
lotus notes agent, LotusScript, VB, VBA

Edit a text file with VBA
Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

Answer Question   |  August 26, 2010  3:18 AM
Access 2007, Text manipulation, VB, VBA

Accessing an Access DB from Outlook via VBA
Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and [...]

Answer Question   |  December 22, 2009  2:23 PM
Access, Outlook 2003, SQL, VBA

Calculating OD from weight and/or metres in VBA
Hi there, Have a problem trying to convert weight and/or metres to OD, I work in the flexible packaging industry coordinating all the trials for the UK & Europe. I can calculate from an exsisting OD to weight & Metres using the following VBA statement; RNEW = (PI * ((((NEWI(1) / 1000) / 2) ^ [...]

Answer Question   |  December 4, 2009  10:41 AM
VBA, VBA macro, Visual Basic

Issue with a sub procedure and its arguments.
I’m trying to build a sub procedure to create a list for a combobox.  Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build [...]

Answer Question   |  November 20, 2009  4:24 PM
Access 2003 forms, arguments, byRef variables, ComboBox, sub procedure, VBA

VBA Looping In Access
I have a report in Access which pulls from one table in an Access databse.  In the table there is one record for each “Region” and when I run my Access report it then creates one big pdf file containing a one page report for each region.  How can I write a peice of VBA code that [...]

Answer Question   |  October 19, 2009  4:10 PM
Access, Looping, VBA

Trouble with Unload statement in VBA
What am I missing? I have written code with an Unload Userform statement that doesn’t seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the value now equals True. The form [...]

Answer Question   |  September 17, 2009  7:47 PM
default settings, Excel 2003, unload statement, userforms, VBA

Issue viewing “additional controls” for toolbox in VBE
I am unable to view the dialogue box when I select the “additional controls” option from the VBE menu bar, or when right clicking on the toolbox itself.  The project I created on one computer includes several forms, one of which includes a few DTPicker(s).  Some internal office issues have forced me to work on [...]

Answer Question   |  September 17, 2009  5:48 PM
ActiveX Controls, Additional Controls, Excel 2003, library, References, Runtime Errors, Toolbox, VBA, VBE

Working with Login Userforms
I’ve been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs “password”, receives an invalid password message, then reenters their password.) As the code [...]

Answer Question   |  August 21, 2009  8:52 PM
Excel 2003, Microsoft Excel, VBA

Storing a ComboBox selection as a variable
I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which will then be used as the variable [...]

Answer Question   |  September 16, 2009  9:18 PM
ComboBox, Excel 2003, VBA

Using Lotus Domino Objects
Is it still possible to use Lotus Domino Objects (domobj.tlb) in programs other than Notes? A few versions back I was able to use the reference from VB6 and VBA. Now when I try to use the object from MS Office VBA I get an automation error. I’d really like to read some messages in [...]

Answer Question   |  August 6, 2009  3:20 PM
Lotus Domino Objects, Lotus Notes, Lotus version 8.0.1, VB6, VBA