Recent content by foundryqa

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