Recent content by islu0102

Thank you, all! It works great, now.

I think I solved it...If I change the file to an xlsb file, I can do all of the exporting like I used to with xls. that's good, in case I need to add macros to the Excel file later. Here is the original code, anyway - in case I need to use xlsx, again: Option Compare Database Option Explicit...

I am having a very frustrating time working with exports to Excel since my company upgraded from Office 2003 to Office 2010. My current issue is as follows: I have an Excel workbook with two worksheets. One of the worksheets contains conditional formatting. I import the other worksheet into...

Well, I can't figure out how to fix my issue, so I created a work around that involved creating a table for the field I was needing and appending it 60 times to add all of the data in the correct format for me to extract it. Whew! Fun. Anyhow - if anyone runs across a solution in the future...

A valid point, but as I haven't created anything yet, the information provided is theoretical, and I just made up names for the fields and tables. I haven't actually constructed anything yet. Of course I will work to see that everything is normalized. I'm not really at liberty to post a...

I'm not exactly sure how to ask this, but here goes. I have two tables that are joined - called A and B. A has two fields, "PLACE" and "RAND" and is joined to B via field "RAND". Other than "RAND", B has several fields named 01 TOTAL, 02 TOTAL, 03 TOTAL, etc...for about 60 fields. The "PLACE"...

oops. wCnt instead of wtCnt was a typo in this thread, but thank you for pointing it out! :) I'll try to test this behind a button. Thanks for the tip. :)

I am attempting to piece together my first true VBA project, but I have hit a snag. I have entered the following code into the immediate window: dim sCnt as Integer dim wCnt as Integer dim suDif as Integer sCnt = DLookup("[Number_of_Su]", "Su_Profile", "[Su_Num] = 9") wtCnt =...

Fantastic! This solution worked perfectly! Thank you, Plog, for the work you put into that code.

I'm needing to write an expression that calculates the week number for any date for the month it's in, given that all weeks begin on Monday and all months begin on the first Monday of the month. In other words, the 5th week of October, 2011 would begin on 10/31/11 and end on 11/06/11. The...

Holy moly - that's exactly what I need the macro to do. I can't thank you enough! Of course, you're right. I really do need to learn VBA. I use the program too much to not know how to use its most powerful features. Thank you again!

Ah, well. That's what i was afraid of! :) I'm not a coder at all. I suppose it's time to learn. Thanks for your help.

Thank you for your reply your reply, HGMonaro, but your response will not help me to automate the queries. I know how to handle this situation manually. What I need to do is have a series of macros that run without my interaction. I am building a minor application that uses a series of macros...

Maybe I'm not understanding the explanations (not a surprise, given my experience level! :)). Here is a real-world example. Let's say I wanted to compile a list of the top 10 pitchers from 1971 in the AL. I have chosen ERA as the only criteria (for the sake of simplicity). To make matters more...

Ok, but if there are 8 Alvins the query as stated will not return any Bobs at all, and the final result must return all of the Bobs, and be filled in, up to 8, with the rest.