Search results

Howdy, I've been teaching myself VBA and I have a question about what I do with an Object after the Sub. I'm wondering if I should always set the Object to Nothing. Below are my two examples. Thanks for any help Public Sub MakeFormIconsListView() Dim lstview As ListView Dim strSQL As...

Yep think I took care of that just wondering what you meant by "Also you are declaring the recordset as a DAO but not the CurrentDb". Thanks for the reply

Thanks for the info guys! DCrake, I'm not sure what you mean by not declaring the CurrentDb. Again I'm self taught so my appologies for beeing ignorant on this. I still haven't reseached the unique index Banana was refering to but I'll look into it. Below is what I have after making some of...

Thanks guys. I'll have to do some research as I'm not 100% sure what's being said but I'll look into it. :D

Howdy, I'm self taught here so if I'm asking a dumb question I apologize. I've created an Access FE with a MSSQL BE. I don't want to have to create an ODBC connection for all the users (lazy I guess) so I found some code on the web that will allow me to not have to have odbc linked tables...

True but you'll need ThisWorkBook.Name here ".CreatePivotTable TableDestination:="[4RobBergmann.xls]Data!R3C1", "

Call Me Sam, Not a problem. The only reason I created this was because some individuals at my site have limited knowledge on pivot tables and since the code does everything for them they'll actually use the tool. I've made a few other minor changes to the code like using Thisworkbook.Name for...

Hey Call_Me_Sam thx again for the reply! I have solved my problem by creating a query of the query and it works great! As far as the data type being a string an not numeric. That's the way Access was handling the Week Number. Since I'm not doing any math with the week number it's all good...

Thx for the reply Call_Me_Sam, I have the week number as as string because that's how it's formatted in my MS Access db. It looks something like Format([Dat Entered],"ww") AS WeekNum in my Query. There are just a few weeks that aren't getting into my pivot table for selection. I guess my...

Howdy to anyone who reads this. I have a pivot table pulling information out of MS Access that is created using VBA. There is a form the user will use to select the first week then the pivot table will be populated with that week plus the 3 previous weeks. My problem is it only works up to...

Sorry about taking so long Bob, I didn't get the email notification. I'll work on sending you a .zip file with one of my listviews. Thanks again. :D

No need for apologies Bob it's all good. The problem (what I need help with) is I can loop through the control and find the index of each column; not a problem. The problem is, after the columns get rearranged the index of the columns remain the same. It's almost like it's read only. In...

Hey Bob, thanks again for the reply. If I were using a list box then your answer would apply but I'm not using a list box I'm using a List View which is an Active X Control. This control allows the columns to be rearranged so it's more flexible than the standard list box control. Thanks again

Hey Bob thanks for the reply! I can create a table to store the user's preferences but I'm not sure what values I'm poplulating them with when it comes to the List View control. My thought was to have a check box or command bar saying "save user's settings". Then, after the user rearranges...

Hello all I have been trying to find information on how I can save the changes made to a List View control after the user reaarranges the column headings to his/her liking. Below was my first unsuccessful attempt and was wondering if someone could help by pointing me in the right direction...

Hello All, This is my first post so after you read this you'll know what my knowledge level is (LOW). I have created an Access database and pretty comfortable with the data entry/update system. Now I'm moving on to creating the reports. I would love to have "drillable" charts and actually...