Search results for query: *

Cannot show visual studio for applications editor. The variable cannot be found. There seems to be many posts on this topic that even suggest uninstalling and reinstalling Visual Studio or other extreme ideas only to find out that after all the effort, the package still didn't work. I got this...

I can't seem to get this simplest concept into SQL and work properly. All I want is to (pseudocode) SELECT WorkstationID Count(Product) From MyTable Where Count(Product > 1) AND Product NOT IN ('Product1','Product2', etc.) No matter what I write, I either get an error or I get the wrong results...

I have some complicated SQL Statements with Case statements, grouping, etc in the SQL. I want to know how to create a dataset for this SQL. Then, I would like to know the best way to use that query in Reporting Services to create a report. Do I leave the grouping, having, order by in the query...

I am new to reporting services and have a database named MHC. I used this as a datasource for some reports. I am getting confused now as I used MHC as a dataset as well, and I have an idea of the difference, but not a complete understanding. Could someone explain this to me? Is a dataset really...

I have reports served to a report server and some pdf subscriptions sent to different places on a network. In the interest of lowering network traffic, I thought about exporting these reports to some kind of format that would be readable by an RSS reader and deploying them in an RSS Feed so each...

Can anyone help me with this? The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Transactions.In_Out_Status". The conflict occurred in database "ComputerInventoryDCW", table "dbo.InOutStatus", column 'InOutID'. (#547) [Microsoft][SQL Native Client][SQL Server]. The statement...

I have created a pivot table successfully using the Excel object model from VBA in Access. I need 2 more copies of this pivot table on the SAME sheet with 2 different "pages" selected. So far, I have Dim xla as Excel.Application, xlw as Excel.Workbook, and xls as Excel.Worksheet and used these...

I have this query that has a bunch of customers who have logged in or not. There are only 3 customers who have signed in, but when I make this query as a left join, it puts "YES" for Signed_In_Yet for every one on the left side (over 1000) even though the second query it's based on only returns...

If I declare a module level variable (I think it's called that) on FormA and initialize it on the Load event, will it be visible to the after_update event on a combobox on SubformB or SubformC? I want to set this variable based on whether these fields have changed or not. I have 2 unbound...

I have several different controls on a form that refer to another form's combobox. I was setting it fresh in many different procedures and event procedures. I thought to, like private variables for the module to set them also once in the declaration section, and was able to Dim them, but I...

I have an object variable I was setting all over the place in different subs, etc of a form module. I decided to try to do it on a module wide basis, much like regular variables, but I got an error something like "Not valid outside of procedure" and the Set word was highlighted at compile time...

I have a problem that is really wearing me out. It seems like I'm chasing my tail all day. I solve one problem only to introduce another. I have a form that sets focus immediately to a subform control. It works fine. Then, I tab through, and after being finished entering data in the fields, the...

I know the email clients use some special coding to create emails. Is it possible to bypass the client altogether and send the email straight from Access using VBA? I don't know what client each user will have. or if they will have any at all. As long as they have an internet connection, it...