Search results for query: *

I am trying to use the Indirect function to handle the formula below (not my actual formula, but a simplified version): =IF(F10=0, "Correct", "Incorrect") When I type in the following formula to use the indirect function I get a #Value error: =Indirect("=IF(F10=0, " & """" & "Correct" & """"...

Below is a query that I put in the SQL view and appears to work perfectly when I view it in design view then open it. If I try to open it directly or reference it in another query it does not work. Any ideas? SELECT F.Project_Number FROM tblSpending AS F LEFT JOIN [SELECT Project_Number FROM...

I was seeing if there was an easy way to write a single query to compare records within a table to find ones with different values. As an example, I have a table with two fields (it has more, but this will simplify things): Project Name and Spending Type. Neither is a primary key. To...

I have a query based off a crosstab query and every month, another month gets added to the crosstab query. I am trying to force the secondary query to always pick all the fields from the crosstab query based on the name of the field. I only want to show the fields that begin with "2010" (this...

I am moving an excel spreadsheet over from Excel 2000 to Excel 2007 and I am having a problem with my Macro Buttons. In Excel 2000, I had multiple buttons on the button toolbar to help the users move from one tab to another (users are not very proficient with Excel and do not use the...

I am in the process of building a new computer and I need some advice. My goal is to build a solid system for around $1,200 that will run Vista and will enable me to run MS Office and games (FPS and MMORPGs). I am looking to start from scratch and based on some articles that I have read, I...

A colleague has developed the following code, but I wanted to adapt it to pull a little different information. I wanted to be able to input a directory name (instead of the user group) and get all the users who have access to that directory. An additional plus would be to also select the type...

I have a table that I would like in another format and I believe that it can be done with a query, I just dont know how to do it. Here is the information that I have: UniqueID ObjectName1 ObjectName2 ObjectName3 1 ABC ATR BPI 2...

I have recently been having computer issues (presumably hardware) and have been trying to fix them. I have purchased a new power supply (went from 350 to 400) and swapped out my cpu (Fry's said it was dead). After doing this, I now turn on my computer and my motherboard blinks/beeps. Nothing...

I have a ton of excel files that I want to copy and paste into an Access table, but I wanted to stay away from looping through each line in excel to copy and paste into the table. I know how to open the excel file through access, select the rows that I want, and copy them into the clipboard...

I have a ton of excel files that I want to copy and paste into an Access table, but I wanted to stay away from looping through each line in excel to copy and paste into the table. I know how to open the excel file through access, select the rows that I want, and copy them into the clipboard...

I have a table with the following fields: [ControlID] - Primary Key [LocationID] - Primary Key [ControlPerformance] The table contains information like this: [Control ID] [Location ID] [ControlPerformance] 1 1 Fully Met 1 2...

I have a string similar to this: "Hello" & chr(13) & "How are you?" in a field within a table. Now I am transfering this information into a field within excel (using access) and I would like the field within excel to look like this: Hello How are you? But instead it...

I was wondering if it was possible to Capture or Copy the line of code that caused the error and use it in the error handler? As an example, here is what I want to do: An error occurs on a line of code. The error handler is triggered and somehow captures the line of code that caused the...

I am currently adding new functionality to a database that is currently in production. Everytime I add new functionality or fix bugs/errors, I find myself copying all the table data from the production database to the new version. I was wondering if it was possible (and if so, how) to...

I have an access database that is creating an excel based questionnaire. I have no problems with this process, but I had a new request from the client that will require me to write code within Access that will, when run, write a module within excel. Is this possible? If anyone has encountered...

How can I run a sub located in Form1 from Form2? I have Form2 (a modal form) open and Form1 is also open in the background (without focus). I need to run a sub within Form1 from Form2's code before I close Form2. What is the correct syntax to run this sub (Named Sub1)? Thanks ahead of time...

I am having a problem getting rid of a small resizing flicker when I open new forms. Basically, as the form is opening, my menu/tool bar reduces from 2 rows to 1 row and then back to 2 rows and it causes the screen to resize/flicker twice. Has anyone encountered this and if so, how can I get...

I am trying to accomplish the following, but can not get the code to work: I have a set of comboboxes on a form named as follows: cboTestYN cboJunkYN cboProcessYN I want to set up a function that will take a variable as part of the name of the combo box I want to use and set the control or...

I am trying to accomplish the following, but can not get the code to work: I have a set of comboboxes on a form named as follows: cboTestYN cboJunkYN cboProcessYN I want to set up a function that will take a variable as part of the name of the combo box I want to use and set the control or...