Search results for query: *

I am still stuck. I ahve provided the entrie code below. My last issues is that I want to change the refence to "Output1" and "Output2" after each pass through the calculator, so that the anser are written to O2:P2, the O3:P3, then O4:P4, and so on. Thansk to your help, I am close, but not...

I have worked out the code to write the values as described above, but now I am stuck with the answers. I need to write a value to a range ("Output1"), then change the location of "Output1" by one row (down). Thus my code can write the new value to "Output1", one row lower. I tried...

Quick Question - how do I run the code to change the value in a named range on multiple named ranges. I tried the code below ( and other variations) with no luck). Sub Dim v1 As Range Dim v2 As Range For Each v1 In Range("B3:B14") [Input1] = v1.Value For Each...

thanks... that get's me going... :)

I have code which sets the value of range "Input1" to the vlaue in "B2". I would like to add code which will change the value of range "Input1" to the contents of "B3", call/run another macro, then change the value of range "Input1" to the contents of "B4" run the macro, and so on until there...

I am looking for a piece of code that will change the value in a range in Excel VBA. For example I have a range named "Input1" which contains the vlaue in cell "B2". I am looking for code which will change the value of "Input1" to the vlaue in the cell "B3", then "B4", "B5", etc. Any thoughts...

I could not provide a link, as the problem occurs inside a web application. I could forward a screen shot if needed.

When I open a pop-up dialog box in IE 6.0, sometimes the content is not all available (the screen is not full-sized, nor are there scroll bars to navigate). Any thoughts as to why this occurs? Any settings in IE or XP which are preventing me from seeing the entire box? Thank you ina advance...

Thought this one was dead! Glad to help... Based on the path I followed, it would depend on the type of action query you use. An update query makes global changes to a group of records in one or more tables. It will point to the tables you assign in the design mode. An append query adds a...

Thanks for looking for me, I had already done the same. I have an old license of Office 2000, but I also found Office XP Developer on some discount software web sites for about $450. So this looks like the way to go. As a heads up, the MS sales person told me SQL Server Developer has the MSDE...

Thanks. Since I already have Office XP, it seems wrong to have to buy Excel, Word, Access in another package just to get the Developer Tools. $800 to buy software I already have - ouch. Maybe if I was smarter.....

I have an Access db that I need to run on workstations that do not have Access installed. I am told that I can package and deploy the db, but I need software to do so. I have Access 2002. I called MS and was told that I could use Visual Basic.net. I called back to ask a few questions, and was...

This worked. I looked but could not find a source to explain the syntax for this field in the update qery in Access. Your direction did the trick. Thanks

Thanks for the reply. I tried the update query, but it wrote data over top of the data in the fields in the master file. I used the syntax: [tablename]![fieldname] Is there other syntax I shoudl use. I have the update query written, it just didn't work the way I need it to.

I have two tables that users have been entering data into. Both tables have the same records, but the fields come from differnt sources, so users are entering data into fields in each table. I need to join (merge? append?) the two tables so that I have all the data in one table. I would like...

Thanks. This was helpful in getting me headed in the right direction.

I have a MS Access table containing loan data. We are collecting pieces of data from various sources, all of which end-up in Excel spreadsheets. I would like to be able to populate fields in the table, based on the data in the spreadhseets. For example, in the db, each record now has a...