Search results

I am having trouble understanding what parameters are being passed from my query to my report. Currently I have the field name in a report title set to a field name (account type) from my query. The proper name appears based on the user input that I created in the query Criteria area. The only...

I have a macro in Access that should update my worksheet called "Sum". However instead of updating the sheet it creates a new worksheet called "Sum1". In Access I am using the TransferSpreadsheet operation for the Macro. Any clue as to why it will not update the existing "Sum" worksheet but...

I am going through an excel sheet and deleting a whole row of cells using the following code: Do While Not IsEmpty(Cells(r, 21)) Cells(r, 21).Select Selection.ClearContents Cells(r, 22).Select Selection.ClearContents r = r + 1 Loop However...

I have a nested function: =IF(AND(NOT(ISERR(FIND("CH",K2))),MONTH(B2)=3),S2+Spread!E$12,IF(AND(NOT(ISERR(FIND("CK",K2))),MONTH(B2)=5),S2+Spread!E$13,IF(AND(NOT(ISERR(FIND("CN",K2))),MONTH(B2)=7),S2+Spread!E$14,IF(AND(NOT(ISERR(FIND("CU",K2))),MONTH(B2)=9),S2+Spread!E$15...

I have dates in my excel sheet that originally were put in in the mm/dd/yyyy format. However I right clicked on it, did "Format Cell" and changed it to the "Jan-01" format. However when I do a comparison statement in VB it still compares the cells to the original format of mm/dd/yyyy and it...

The code below works fine as far as putting the right things in each cell. However the code just continues to loop and never exits. Is the first line in my code correct? Do While Cells(i, 1).value = "Chicago" Cells(i, 4).Select Selection.Copy...

I have a worksheet in excel that contains data that can go in either 5 worksheets depending on location. Once I figure out the specific worksheet to paste the particular cell in, I then have to figure out under which year and month to place the text. So pretty much I have 3 conditions that must...

I have a macro that I run in Access. It runs through some appends and deletes and finally opens a report showing some sums. What is the best way to take each sum for a location and export it to a specific row in an excel sheet?

When I save my XLS as a Comma Delimited file and open it in Notepad, after about the first 15 records I am missing commas between the last two empty fields. Example: Let's say I have 5 fields, ID num, name, Address, Salary, Birthdate. My Salary and Birthdate fields are empty so I should get...

I have an Access Report where any where where I have a duplicate contract number that whole record is hidden. What is confusing is that the underlying query shows the duplicates how I want. I checked the properties and "Hide Duplicates" is off. Unfortunately it still hides the duplicates on the...

I have a query that pulls data just like I want in SQL Server 2000. However I need to add a header and trailer row so that it appears as: HEADER (contains various name information, but also a time stamp) Detail1 Detail2 Detail3 Detail4 TRAILER (should just show the amount of detail records)...

I have a report that is created based off a form. For some reason the first line of the report is has some blank spots where data should be. When I click to go into design view, then click again to come back to print view the data that was blank now appears. Not sure why this happens...its...

I have a query that works in SQL Server. However when I try to put it in a scheduled job using the BCP function I cannot get it to work. I want the output of my query to be written to an excel file (.csv file is fine). SET QUOTED_IDENTIFIER OFF SELECT EMP.EMPCODE, EMP.LASTNAME, EMP.FIRSTNAME...

I have an If statement in a text box that does a calculation. This IF statement is enclosed in the IsError function. However whenever there is an Error as opposed to displaying a "1" it says #Div/0 or #Num. Shouldn't it say "1"? When there is no error is says "0".

In my report I have some code that hides rows that meet a certain criteria. However I do NOT want to include the hidden data in the Sum. Nevertheless it is still calculated in. I am using a text box with a running sum as my SUM. Any clue on how to ONLY include the visible rows?

I have a report that contains a text box in the 'Detail' section that has a running sum over the group. In the group footer section I have another text box that is suppose to display the final sum of that running sum. However the total continues to be off. In the 'Detail' section when it reaches...

I have a pivot table that pulls from a data worksheet. Everything looks correct except one columns sum is 1 off. The sum should be 30 but it states 29. Based on the the data is is 30. Also when I look at each subentry it adds up to 30. However the sum shows 29. This is the sum of a column btw...

I am getting an unsual problem. I have two groups in a column...one is rails and the others are trucks. The unsual thing is that I get the right number of rails when they are summed at the bottom of the group. However I do not get the correct number of trucks. When I calcuate the total for both...

I have a query that has three columns: months, weights and locations. In a report I want the format to be where the months are the column header across the top, the locations are the row headers on the side and the data filled in is the weight. However when I do this I get constant repeats of...

I have two strWhere statements in some VB code, each representing a list box. Individually they work but when I try to combine them I get either #Error when I make a selection from both list boxes or a syntax error 3075 when only one list box is selected. Currently I tried combining the two...