Search results for query: *

Hi, I need to put a new header on each page of an Excel spreadsheet, but I can't use the "rows to repeat at top" option because it doesn't suit the client's needs (too many alternative rows to repeat). Anyway, without having to keep count of the rows, I was wondering if anybody knew...

Hi, I'm going to start teaching myself C++ in a few days. As a VB6 programmer, I have a basic way of going about making my programs. I know that it's going to be totally different in C++. I was wondering if there are some basic steps to putting together a program in C++ that should always be...

Hi, Visual Basic 6 has a boolean variable. I'm using VB to transfer some data via DDE from one machine to the SQL database, and I was wondering if binary was the same as boolean, i.e. true or false, off or on, 1 or 0. Kind of a stupid question, but my help files for SQL aren't responding...

Hi, This might be off topic, but I was hoping some of the math majors out there would know it. We have to average SCC counts per farm at this plant. When I take an average of all SCC counts for a given set of criteria, the number is 268. But the department that I'm writing the program for is...

Hi, I've been programming in VB6 for about a year and a half now, and I've come to the point where I think there's a better way of doing things but I'm not sure how to go about doing it. I'm curious about class modules and user controls in particular. Included with the VB6 package are example...

Hi, I've got a few programs that are sending e-mail. We're using Office XP. A warning box appears every time that the program tries to send an e-mail. Since there is not always somebody sitting at that particular computer to click "Yes" three times to allow the e-mail to be made...

Hi, I had this one, but we installed Office XP over our old Office Win2K and now my macro has died an gone to macro heaven. I've seen the code posted here a few times before. Does anyone have a copy of it? It loops through unread e-mails and saves attachments to external directories, not to...

Hi, Does anybody know the command like the one in parantheses below: .End(xlToLeft).Select that will take the focus to the first column on the sheet, for the row? Thanks ----- The death of dogma is the birth of reason.

Hi, We recently installed "Script Logic" at our plant, and for some reason my VB e-mail programs are blowing up when I try to resolve the recipient. I get this error: -2147024891: Collaboration Data Objects - E_ACCESSDENIED(800700S) Does this ring any bells? Is there anything I...

All right, now it's blowing up on the objOneRecip.Resolve line. Could it be because the default "MS Exchange Settings" isn't linked to the global address list? ----- The death of dogma is the birth of reason.

Hi, I've got a program that needs to e-mail attachments to various people once a day. Used to work like a charm, all of a sudden it's not. It's blowing up here: Set objSession = CreateObject("mapi.session") 'Create the Session Object objSession.Logon...

Hi, I've got a report form that's got about five seconds of processing before it shows the resulting graphics form. In the interim, I'd like to show a "Please Wait" form that will appear until the processing is done. For some reason, the "Please Wait" form won't show...

I have a program that's blowing up now and then and giving that error number...-2147467259...to the users. When we try to recreate the problem, the data is processed and loaded over the network to the SQL db, no problem. It's a hit-and-miss thing that just started happening today. Sound...

Hi, How would one select a database in Access? For instance, in Excel, to select a sheet, you would write: XLApp.Sheets("Sheet 1").Select I might be going about this bass-ackwards. I need to dump selected data from an Access database called "history", which is in in an...

Hi, I've noticed that the recordset object has a "moveprevious" method, but every time I've tried to use it, it wouldn't work. Is there a setting I'm not using right? There are ways around it, but it would be really handy to scroll back one recordset in some cases, especially...

Any ideas? If txtBox1 = "" Then txtBox1.SetFocus: Exit Sub If txtBox2 = "" Then txtBox2.SetFocus: Exit Sub If txtBox3 = "" Then txtBox3.SetFocus: Exit Sub For some reason, when I use this logic, the program ignores the first line and sets the focus to txtBox2...

Hi, For instance, if somebody clicks Item #2 on the form, then Column #2 is highlighted, then when they click Item #5, Col #2 is deselected and Col #5 is selected. Been looking through the FAQs and can't seem to find it. Thanks. ----- The death of dogma is the birth of reason.

Hi, I think I have a virus that makes my mouse randomly double-click. It's driving me nuts. I can't figure out how to fix it. Any suggestions? Thanks ----- The death of dogma is the birth of reason.

Hi, I think I have a virus on my computer but can't find it. It's causing my mouse to randomly double-click. It's driving me crazy. Any suggestions? Thanks. ----- The death of dogma is the birth of reason.

Hi, Was wondering if anybody knew the syntax for moving an e-mail to another folder in a macro. I've got a macro that strips the attachments and puts them in folders on various network drives, then it marks the file as read, and after than, I want to move it to a folder called...