Recent content by jwruble

I'm trying to automate some Cognos Impromptu tasks using .NET. When I try to reference the Impromptu Client Type Library, I get a "System.ExecutionEngineException" exception in the TypeLibraryWrapper and the .NET IDE crashes. I've been able to reference the library through VBA inside Excel...

Is it possible to create a make-table query with one of it's columns being generated as a unique id for each row? Thanks for any help.

Thanks Martin! That was exactly what I was looking for. I appreciate the input.

I have a form that is used as a sort of question and answer system, where the question is listed at the top in a textbox and the answer is entered in another text box. My current problem is that sometimes the questions are very long, and therefore the user must scroll down to view it all...

I am using a TreeView to display a list of questions from a database. Some of the questions are very long, and I would like to be able to somehow insert line break or format the tree nodes with a word wrap so that the user can see all of the text without having to scroll. Does anybody know if...

Yep, very good call. I had added all of the resume next statements because for some reason I could only get the first table to be deleted (and of course I was wrong). I don't know for sure, but I think the problem was that some of the tables were still linked to open recordsets. It seems to...

Wow, quite a number of great solutions. Thanks to all of you. As of now, I'm using the short snippet of code posted by JerryKlmns, since I just want the table deleted and don't really care whether the table exists or not. I'm actually deleting several tables at the same time, so I just simply...

As a part of my application, I need to delete a table from an Access database. I have no problem doing that with the following code: DoCmd.RunSQL "DROP TABLE myTable;" However, depending on how far into the application the user is, that table may or may not exist. If it doesn't, the above...

Just in case anybody else was having this problem, this is how I finally disabled label editing: TreeView1.LabelEdit = lvwManual Simple enough...

I've got a TreeView in my form that gets populated with image names for the individual in the database. When you click on the image names, a preview window displays a thumbnail of the image. Unfortunately when you hold the mouse over the image names in the TreeView, the node goes into the...

I'm creating a query for a report that displays information about different surveys of a site. Important info includes when each survey was completed and who did the survey. In the database, the "who" is stored as a number, which can then be linked to an employee table to see their...

On the frontend of my database, there is a form where you select what community a member lives in. The community is then stored in the database as a code, not the name of the community. So now on another section of the form, I am trying to display the community the member is assigned to. This...

Ok, it still doesn't work. In the design view of the query, I have two columns set up (one for each combo box). In the criteria section I have the following: Criteria: [Forms]![Form Name]![Field1] Or: [Forms]![Form Name]![Field1] Is Null When I enter the "OR" line, it...

I have created reports that get their data from a query. The query gets two requirements (criteria) from a form consisting of two list boxes. So the user selects their desired output from the two pull-down boxes. That part works fine, but I would like for the user to be able to leave the...

I have created reports that get their data from a query. The query gets two requirements (criteria) from a form consisting of two list boxes. So the user selects their desired output from the two pull-down boxes. That part works fine, but I would like for the user to be able to leave the...