Search results

The report is opened through a macro which runs the queries first (asking for the input criteria) then opens the report.

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

You are right MailMan...I did that and it all works out now. Thanks!

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

Luckily I found a way around it. This is what I ended up using: =IF(AND(Spread!$F$12 = LEFT($K2,2),MONTH($B2)=3),S2+Spread!$E$12, IF(AND(Spread!$F$13 = LEFT($K2,2),MONTH($B2)=5),S2+Spread!$E$13, IF(AND(Spread!$F$14 = LEFT($K2,2),MONTH($B2)=7),S2+Spread!$E$14, IF(AND(Spread!$F$15 =...

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

Ohhhhh...I got ya. Yeah for my case I needed what was being displayed only, not the literal value. Good looking out though Bob!

Really? Why is that? Also .Value did not work for me. It would still return the full date as opposed to just the Month and the Year.

I was able to get that date in VBA by doing: Cells(i,j).Text Adding the .Text works.

Gotcha...thanks!

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

That looks to have solved the problem. I just took off the ".value" off of Cells(i, 1). Thanks!

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

Sums are done at the report level but I was able to modify it to take place in the query. Nevertheless I still am unsure as to how I can export the results and have them placed in the appropriate row in excel. They have to be placed based on it being the same location and same time.

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?

Thanks for the link, chergh! I need to check if I can do the imports without the commas, but if not I will be adding in a character.

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

LOL...I hear ya...that one was definitely on me to find. Thanks for your help though!