theberner
Last Activity: Sep 30 '14, 08:18 PM
Joined: Jan 30 '13
Location:
-
theberner replied to How can I have Excel record file names from a folder and count the rows within?in Visual BasicHelps alot. bare with me. I last tried to do this in 2008. i think some of the things that worked then are differnet now. But you did help me recall the intent of that version, versus what I am trying to do this time. In that version the task was to list all the file names and then to have the program read that name and search for it in the folder and record the counts. I think i mixed that portion in with this attempt where I was hoping to... -
theberner replied to How can I have Excel record file names from a folder and count the rows within?in Visual Basicok. Not sure if i can reply to one where i picked a solution, but just in case. I made some updates and also found part of the old stuff i had. It does not work exactly and i when i step through the process i think it's the way i define the folder path. I want the excel to look in the same folder it is in. Just seems easier that way. But my setup seems to be missing something.
...Code:Option Compare Text Sub Checker2()
Leave a comment:
-
theberner replied to How can I have Excel record file names from a folder and count the rows within?in Visual BasicThank you. I will give it a try and see if I can get it to wor.Leave a comment:
-
theberner started a topic How can I have Excel record file names from a folder and count the rows within?in Visual BasicHow can I have Excel record file names from a folder and count the rows within?
I had this code ages ago and saved it someplace safe. So safe, I lost it, and now I cannot recall how I did it. I went accross the internet to find similar code and did find this code, which is pretty much almost where I am trying to get to. Basically, the code attached will tell me how many records are in the file I tell it, through an alert box. What I would like to do is have the program look in a folder I designate and find each file, record... -
theberner replied to Macro or Code to Export Filtered Report for all Unique Instances of a Specific Fieldin AccessNeoPa, I understand your point and I apologize if I used the forum incorrectly. It was not intentional. I thought from other posts that my post would be ok even though I had no code. Now I know, and I will keep this in mind going forward. Thank you for your understanding of my situation.Leave a comment:
-
theberner replied to Macro or Code to Export Filtered Report for all Unique Instances of a Specific Fieldin AccessADezii, this works perfectly. Thank you so much for taking the time out to show me how this goes.Leave a comment:
-
theberner replied to Macro or Code to Export Filtered Report for all Unique Instances of a Specific Fieldin AccessPerhaps I mispoke. I do not have any code because the code I find does not fit my situation and any manipulation I do is basedon cluelessnes. So sending you code to fix would probably confuse me more as that code was manipulated from something that may have worked into the garbage that I thought would work. So really, i have nothing.
My issue is with everything because I have no idea how to go about the macro or code. At best, I can create...Leave a comment:
-
theberner started a topic Macro or Code to Export Filtered Report for all Unique Instances of a Specific Fieldin AccessMacro or Code to Export Filtered Report for all Unique Instances of a Specific Field
I have a report, Report A, that pulls data from a Table, Table A. Table A, has a field, Field A, where I am to export Report A for each Unique Entery in Field A. Currently I have to do this manually, but Ideally I am looking to find a code that can do the following.
For Uniqe each value of Field A in Table A
Filter Table A
Run Report
Export Report as PDF with naming convention of "value of Field A + YYYYMMDD"...
No activity results to display
Leave a comment: