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...

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

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...

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 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 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...

Hello , I currently have the amount of time in SECONDS and am looking for a way to convert it to HH:MM:SS. Either Excel or Access would work. Any ideas?