Search results for query: *

Thanks guys. I will be working with 300 - 1000 records. I like each method for different reasons. I may end up just flipping a coin :-)

Skip, Would you say that there really isn't a performance hit going the Access route then? Thanks, Fred

Skip (or anyone else), With the holidays coming up, I'm going to have a bit of extra time to finally set up a common workbook that can then be queried by multiple workbooks that need the same "master" data. Reference the previous thread thread68-1376746 . Before I take the plunge and work on...

Thanks Skip. Had a bit of problems with MSQuery not letting go of certain objects in the past when I've tried to break connections. That's made me a bit nervous about using it again, but I respect your input and will give it a shot. Appreciate the quick response, Fred

Hi, I'd like to find out what poeple consider to be the best practice for using a common list of items across several workbooks. Currently I have a list in each workbook and would like to make a central repository for all of them to access. I know that I can do lookups between workbooks...

Thanks for responding Pascal, I was able to get around the problem by putting the code in an event fired by the view. Once the event fired, I knew which back end doc I wanted to modify, so I did it before creating the uidoc. Everything has worked great since. Thanks, Fred

Hi all, I hope I explain this correctly. We have a subform that has fields that are dynamically filled with items from another database when the form is loaded. I want the document to be locked in readonly mode during the entire process so noone can modify it. I can get everything working...

I'm not sure exactly what you are asking, but if you want a jump over to be added to a process pipeline, right click on the line and select "Format|Behavior|Connector|Line Jumps". From there you can select several different options for how a line will act when it crosses over another line...

dylanreid, You can use a make table query and add an additional field to the query that does not already exist in the table you are querying. The SQL looked like this for a table "Employees" that I added one field to called "New Field" SELECT Employee.dept, Employee.classcode, "" AS [New...

grande, I selected "new" while "table" was highlighted and then selected "import table". From there I selected the last option in the file type box, which is odbc. From there select "machine data sources", "new" and then either system or user data source. You will then be prompted to select...

We have an address book with everyone's name in it. I was able to set up an ODBC connection to the address book in Notes using the NotesSQL driver. From there I imported the information into a table. You can then set the combobox's source to the table. --Foundry

From there you go to this page: http://www14.software.ibm.com/webapp/download/search.jsp?v=11&lang=en&cc=us&realm=tnb&q=NotesSQL Select option 1. You have to be registered. I remember going around in circles when downloading it also. Somehow managed through. That was a few months back...

Yes, I use it almost every day. You can get it here: http://www.lotus.com/products/product4.nsf/wdocs/3243f3d81944584085256e20006db691?OpenDocument --Foundry

lespaul, Thanks for the suggestion. I put my code in the postopen and everything works now. Foundry

First off, I am using Formula Language for this: I have a default view that contains a command button. Once the button is pressed an @prompt requests a number. This number is then used to do a series of dblookups's. I also have the button compose a new document. I would like the results of...

esib, I don't have a lot of time to today, unfortunately. One thought that I had was if you take your idea for an array and couple it with a variable that you pass into the procedure that contains the amount of columns you want to sum, you may beable to redim the array to the proper size. I...

esib, This may not be the most efficient way, but I would do something like this Add a column right before the RC column. Add a formula to each cell in the pre-RC column that uses the "left(RC, 3)" function to get the first 3 letters of the value in each RC field. Continue this until you...

dbsquared, My apologies, I meant a search on the net, sorry. Another key word to use is "least squares". My search returned the following site that may be of interest. http://www.programmersheaven.com/zone28/cat1140/ Sorry I can't be of much help at the moment, I will be able to help more...

If your functions when graphed appear to follow a straight line, the linear regression is what you will want. You will need to compute the slope and the y-intercept of the best fit line from the data and then from there enter in the "next number". You could enter in any number and it would...

dbsquared, I'm not sure if this is what you are looking for, but you will want to do a search for "Linear Regression" if you are working with linear functions. From the formula that is generated from the regression, you can substitute in a future value for either the x or y variable and then...