Search results for query: *

Hello, I have attempted to find some previous thread on this, but was unsuccessful. My problem is that I am calculating a percentage in one query X time/Y time = z% Field name = gobbly% When I attempt to pull "gobbly%" into another query the expression does not calculate. When I...

ARG! I was hoping it was going to be something easy like a maximum capacity of the clipboard or something. Oh well. Thanks for your help!

Hi there just use "m" in place of "y"

Not protected, not merged. Nothing funny at all about ANY of it. Tried in several different spreadsheets and workbooks. Tried a reboot all to no avail. Here is what I put together to step through the process. This was after several attempts of right click copy/paste, drag down etc...

I am copying only one cell. The paste is sucessful for many of the rows and columns, just randomly decides to fail.

Hello, I am attempting to copy arrays across several rows and columns. And I am getting some VERY strange behavior. So say I select 200 rows and 10 columns to paste into, the application randomly ( as in sometimes does this and other times does not) selects a row in the selection and...

Hello, I am in a dire situation. The background bas and frm files have been lost for a vb project. The EXE remains. Is there a way to retrieve the code?????? N

Thanks all for the help. Yes the max is 32697, but with a little manuvering with the scale height/height and .max property I was able to get it to work. Thanks. Nina

Thanks for the tip, but how fast or slowly I scroll through is not the problem. The problem is that my MAX value automatically sets back to zero when asked to be set over 32750. My current frame that I need to scroll through is 49500. Therefore the vscroll is not allowing me to scroll...

Thanks for the quick reply. But this just makes me hit the maximum even quicker. Any other tips?

Hello, I have a very long form that I would like them to be able to scroll through. I have the scroll bar working however, it stops once it has reached its MAX property. I have attempted to change the MAX property both in the properties box and by declaring the MAX property upon load. Neither...

CCLINT, Thank you much, this worked great!

Hello, I have a listbox which is populated with two fields from a database. For example: list1.AddItem rs.Fields("ID") & " - " & rs.Fields("Name") So that the list in the listbox will look like this: 57-John Doe 89-Jane Doe 9447-Joe Smith Etc.... What I would like...

HI Herman, Thanks for your reply. But that will only allow me to read 254 characters right? I want to be able to read/replace ALL of the characters. This could be well over 255. Any other ideas? Nina

Excel 2000

Hi There, I have a simple find and replace macro that I would like to run. It does fine up until the text goes above 255 characters. I understand that 255 is the "magic" length. However as I understand it the Dim As STRING should allow MANY more than 255. Correct? Here is my code...

Hi Herman, Thx for your reply. Yes I do the same. We originally did so and that is how we got the find and replace piece of this code. I needed to add a bit in order to reference the excel spreadsheet instead of only the word doc. Otherwise this is just as it would be recorded in vba. Any...

Hi There, I am working on a small find and replace macro that references an excel spreadsheet for the "replace" portion. My problem is that when the "replace" portion in excel gets to be a bit long it errors out with "String Parameter too long". Which I do not...

Hello, I have an excel spreadsheet that I would like to distribute over a corporate network that would allow the user to send the records to a SQL server db. I currently have the spreadsheet sending to an .mdb, but I cannot seem to get it to connect to the .adp that I have stored on SQL...

this worked beautifully. Thank you both! :-)