Search results for query: *

I wanted to record this tip for histories sake. It's an issue I struggled with for years, but finally happened upon a discussion between Paul Mazaika and Dan Jinks occurring late September, 2001, at Codehound.com, which answered the issue I'd been experiencing all along. Basically, I'm...

We've made a simple Access 2000 help desk database on a shared drive: user's call, a form is filled in, and tech's enter the details into the call-tracking form. What's happening is on occasion the calls the techs enter into the database disappear, even after printing the call sheet. The...

I've seen a lot of folks asking about the error 429 occurring while trying to create the first instance of an ActiveX component, but I am receiving this error during the processing of specific workbooks created through Excel automation with VB6, while many others, using the same code, work fine...

I'm encountering a problem that I thought I never would. I've used VB6 to create and make adjustments to Excel 2000 workbooks for budgetting purposes. At this point, I've been asked to sort items on the Summary sheet to a specific order. The routine I use to do this works for some sections...

Hi All, I'm trying to figure out why, after saving a document with a "Normal" view in Word 2000, it's not possible to change this behavior. Each time I open the document after that point, it always opens up in Normal view, even after saving it repeatedly in a different view. What...

Hi All, I'm trying to perform a VB6 Insert to an Access database of text data, but have run up against a snag. Some of the data has embedded commas, and SQL is getting consufed by them. The executed SQL is like this: INSERT INTO tbl_TCLEASES (status, bldgid, leasid, occpname, contname...

Hi All, I've got a strange problem I'm trying to trouble-shoot, and it's making me nuts. We are working on a shared A97 database, and associated pivot-table, and I have a user who can only access the app. and pt when all others are off it. When I sign onto her machine, I can share logging...

Hi All, I'm trying to set up multiple summary footers using the skeleton of the dynamic crosstab report from the solutions.mdb. I've succeeded in adding one group footer to the data, but when I try to add a second footer, the first starts misbehaving, it thinks that every record is it's own...

Hi All, I'm trying to use the WORKSHEET_CHANGE event to detect a user's alteration of a range in a worksheet, and prevent the saving or selection of a different row until a condition is met. Trying to do this is getting to be a real pain; after moving the focus back to a cell after the...

(VBA, Excel 97) This has been buggin me in some code I was given to work on, and I'm at a loss to find details on the error in the MSDN site. Does this just mean to close the old recordset before starting a new one, or is there some deeper significance? It only happens occasionally, and once I...

I'd like to add a conditional to the On_Activate event to examine what view a report is opening in, and bring up the print dialogue if the rpeort is opening in acViewNormal.&nbsp;&nbsp;Is there an easy way to do this?<br><br>TIA,<br>Drew

I am trying to figure out how to show the print dialog before sending a report to print.&nbsp;&nbsp;After an hour, I'm sending out for pizza and help.&nbsp;&nbsp;Is there a simple way to do this?<br><br>TY,<br>Drew

Hiya everyone,<br><br>(Win98SE, Acc97)<br><br>I am struggling with trying to set a form-based progress bar to the same value as the status bar.&nbsp;&nbsp;Does anyone have a suggestion to point me in the right direction?<br><br>Thanx,<br>Drew

I'm trying to make sure joe-user can't wander over to the database window and wreck havoc with the objects.&nbsp;&nbsp;What I've done to try to accomplish this are the following:<br><br>Used the startup option for no full menus, no default shortcut menus, no toolbar/menu changes, no special...

Hi all,<br><br>I've been stuggling with combining these 3 functions in one form.&nbsp;&nbsp;It would be great to get them to work together, but it doesn't seem to be happening yet.<br><br>On open, search the available drives and populate combo1's list<br><br>Combo 1:<br>all MS Access associated...