Search results for query: *

What I am trying to do seems like it should be easy but its making me crazy. I have a form created in Word 97. I want the users to be able to add a row in a table (three cells, first one with an input box, second and third with a check box) Is there a way I can create a macro that will copy...

Windows Second Edition 4.10.2222 A is able to open a file (pdf xls doc) but then freezes to the point ctrl-alt-del doesnt even appear. I have tried the same file on a Win98 First Edition and found it works fine, as it does on Win95 and Windows 2000 so it seems localized to Windows 98 SE. If I...

Is there anyway to have it so the user can automatically either click a button or do something in one step (besides going to the menu bar clicking add cells selecting rows etc.) to add a duplicate row in a table with check boxes if necessary included? We are using Word 2000 and trying to create...

I am using VB 6.0 and I am trying to run a Package & Deployment Wizard generated installation. I have checked the answers previously and the Expsvr.dll file is included in this package. The operating system is Windows 2000. The exact error message is : The Jet VBA file (VBAJet.dll for 16-bit...

I am wondering how I can double click a field and then bring up another form that asks for one piece of information as well as using the value that was selected to basically be there "where" part of a SQL statement and populate a form with queried data. so if I have a field deptcode I...

I have a time sheet form that allows user to enter past dates and retrieve their old timesheets. The problem occurs is that after the users enter in the two dates and hit return it submits an empty form clearing out all the old data. I do have to allow them to be able to enter blank fields so...

I have a loop that I use in my standard module that clears a forms text boxes. It works fine in other programs I have deployed. But at the company I work with now I am getting error 458 Automation not supported in VB. Is there a way to late bind the controls to do what I want it to do...

I have been getting an error 458 - Variable uses an Automation type not support in VB. I have checked numerous places and I do not use rich text which is one of the causes of this error. I went and explictly defined all my variables with the only cause of Uer Defined Type I can see that would...

I have moved up from an Error 429 - ActiveX Component cannot be created to Error 458 - Variable uses an Automation Type not supported in VB when trying to run a recently packaged EXE developed in VB6. I have Option explicit on so there are no undeclared Variables ... I changed all variables...

I have read all the FAQ's and re-registered my dll's, added the mdactyp_exe to the installation package and still I get this error. I have had no problems before with the Package and Deployment wizard but I now have three applications that only I can run. Any one have any other suggestions on...

I connect to my database using : Set DbsNew = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\LegalTracking") yet doing this exactly the same way on anothe rproject and calling a recordset exactly the same way yields a "runtime error 13" at the sql statement. Public...

I am getting this weird error where it wont recognize .edit as a method of my recordset which I have defined above. Any suggestions on what may be the problem .. the .addnew no problem. Joanne

I am exporting to an Excel spreadsheet and have never done it before nor have I played much more than the basics of a spreadsheet. It would be nice if VB (like it does for most everything else) listed some properties after I typed. For example: objResultsSheet.Cells(Y, 1).????? would...

I am exporting to an Excel spreadsheet and have never done it before nor have I played much more than the basics of a spreadsheet. It would be nice if VB (like it does for most everything else) listed some properties after I typed. For example: objResultsSheet.Cells(Y, 1).????? would...

Is there a way to change the alignment of a cell through VB? I need to center the total lines. Also I have to sum on a range of cells and I know the x and y corordinates but examples I have seen of adding formulas are more along the lines of .Cells("B17").Formula =...

Sorry if this confuses anyone, I am doing time sheets where data is taken in through ASP and stored in an Access database. There is then a VB app which takes the data from access manipulates it and puts it in a templated Excel Spreadsheet. My problem is in exporting to Excel I have a list of...

If I have two columns in a table COL 1 Col 2 3 d4 4 f3 4 f3 3 d2 4 s3 3 d2 I would like to order by col 1 ... and also col 2 so that I can loop through my recordset and weed out duplicates I would like to end up...

I have this SQl String that has worked on other ocassions but for some reason is giving me "Error 13 Type mismatch" I have checked the database to make sure all variables i am handing in are same as database .. any clues? Dim LastDay As Date Dim FirstDay As Date Dim rsAdmin As...

Anyone know if there is an easy way to calculate the number of weeks in a month. For example in June 1-2 was a Friday and Saturday making up week 1 then the 4 weeks after leaving 5 months for June. Basically same for July .. I would like to be able to call on week 1 instead of June 1 - June...

I have been struggling with getting an ASP page to do what I want it to WHEN I want it to. Because I am querying a database I have basically Three states: 1. user just gets to page and enters all information (an obvious Insert SQL no reloading of page and just submit - works fine) 2...