Search results

I hope I am explaining this well. Before I try to spend a lot of time beating my head against a wall, I was wondering if there was any direction someone wanted to point me. I have a couple of VBA modules that I have set up to create a Query that will join 5, 10, 0r 15 Variables. These are...

Oh.. def... although sometimes it's nice to get it handed to you on a silver plate, most of the time I prefer just being pushed in the right direction. I'll remember it better this way. Appreciate your help immensely.

Thank you very very much. With a little tweaking, I brought the GetGST function into the main function, and was able to get it to loop through the recordsets that way. Works perfectly. Again, thank you very very much. Just the nudge in the right direction was all I needed.

I guess that's really part of my problem. I'm not really sure where I should be looping anything, or if I should take those two functions and run them through another module... I'm really jumping past my knowledge on this... so I very much appreciate anyone's help on what should be done here.

That code was taken from somewhere else, while I was trying to figure out how to pull the data from a table. I Could absolutely combine those two functions together if need be. That is the table that the Variable VN comes from, and would be the information I need for the loop of the other 4 queries.

VBAINet - duh :) Thanks. Well, the first function in the list is GetGST() which is where the Variable VN comes from (naming convention there is off). Then, in the CreateSVTable() Function is a series of 4 queries that need to run to do what I need. (Could be bulky because I am still new at...

VBAInet - I appreciate the help, but I've been unable to find anything in the Help files that is showing examples of multiple recordsets. Sorry. Doing a search for Recordset Object gives a lot of examples, but none using multiple(that I can find).

I will def do that next time. Thank you.

I'll look up the Recordset Object, but I'm not sure what you mean by code tags. Thank you for answering.

Okay, I am unable to find an answer for this, so if it's already been answered, I apologize. Any help being nudged in the right direction here would be very appreciated. What I am trying to do is run a series of SQL Queries looped based on a Variable. The Variable in question is VN, and it's...

Thank you Paul. I've been searching for that all morning, but wasn't using the right keywords.

Ah.. okay. I've been getting around this to keep my end users from modifying it by turning off those menu's and hiding the navigation tab, etc... But I thought I was doing something wrong. Thank you for the clarification.

Hello, I converted a database to accde, but when I pull up the accde an then run the query it still allows me to get to the design level, and make changes. I thought that wasn't possible in accde. Am I doing something wrong?

Dave, Thank you very much. It all finally clicked with your last post, and I was able to get it to do what I wanted it to do. I was just missing the "logic" of how it should work. Something you said made me see it. Thank you very very much. It is now working exactly how I want it to.

it does make sense. thank you. But I guess I am not sure how you get the function to pull the lat and long I need? Is that just a variable that I need to declare before running the query? Eventually Ill be needing this to find everything in a certain radius, which I understand is possible with...

oops. looks like I missed saying some of my steps so far. Thank you for replying. I have a database set up that has the zipe codes and their longitude and latitude. I now have these functions.But I am not sure how to call them in a query.

Okay, I feel like an idiot. But I am not a programmer. I found the below VBA function, and I bet it will do exactly what I need it to do. But I'm not sure how to actually use it. I want to use a Query to display the results. But I'm not sure how to do this with the code. Any help? Private...

Brian Thanks again. I was able to finally do this using a Pivot table... the reason it wasn't working before was that the Value field(pulled from the DB) was a Memo, and not a number. Chose to add a step to make a temp table with the column as a number.. then used a query to pull the data...

Was able to get this to work as I needed it to, using the Pivot table. The problem was that one of the fields was a "Memo" field, which made the Export to Excel not work. So... thanks for everyone that looked at this.

or, even better.... get it to create the field names based on the range.