Search results

Mark Thanks.. I may have mis understood your original reply. I'm going back over to my datasets to see if I can make this work!

not a VBA sorta guy! LOL and seperating month/year is going to make the graphing portion even more difficult.

I've got a huge list of information I need to sum into months and then chart. Here's a sample of the data: It goes on for 5+ years ReportDate Count Identified Count Sent Count Responded Count Flapper Count NTF Count Cleared 09-Oct-17 9 2 06-Oct-17 6 2 05-Oct-17 7 2 2 04-Oct-17 9 4 1...

Yes, query works in access. Never caught on to ADO; but when I click 'get data' 'from database' 'from access database' then choose the dbase with the query a new window opens up called "navigator". I scroll down to the query I want and the right side shows the column names, but also shows...

I'm getting to the point I really dislike Office2016 products. Things that used to work for me or be easy to do have become nightmares.... I built a query in Access that I want to graph. I have always hated Access graphing (probably just inexperience) so I use Excel. I opened a new Excel...

I may try this!?! The tablename is OutFileReport_ImportErrors So would this be DoCmd.RunSQL "Drop Table OutFileReportImportErrors" Including quotes? And I was sure I clicked on 'Show All Actions' but I re-opened the dbase and clicked it again and now DeleteObject is showing! I need a new...

According to Microsoft (probably my first error in trusting them) DeleteObject is still available in Access2016. I'm not sure why, but I'm not seeing it or I can't even type it in. Honestly I ran into the same problem when I was using the ImportExport Text command in the macro. Only reason I...

Marking this thread as solved. While I still haven't tried to essentially 'rotate' the data like I wanted, Pbaldy's suggestion for normalizing the final table made importing things a breeze. Since I'll still be able to pull historical information in this format I am going to go this route with...

Sorry - no; can't do that. More for what's contained in the text file than anything else.

Pbaldy; I understand what you are saying now. That would make importing into a table MUCH easier........

plog ignore field6; while it's needed for another issue; it's not relevant to this. Pbaldy i'm confused then. You say storing data horizontally isn't normalized? I thought that was normal... storing my data like this isn't normalized? (date)......(B)...(T)...(F)...(I)...(Z)...

FYI Here is the actual table data after I import it: I know it looks like garbage; but row 210-218 contain the data I need to keep. Field2 Field4 Field6 T O DAY AYS AY pro ___ ___ PR ___ ___ --- 0 ___ ___ ___ ___ ---...

The data comes out like: (date) ... 9/29/2017 (B)...1 (T)...0 (F)...18 (I)...101 (Z)...82 Phog; The issue is a data manipulation issue. Above is my table. Column headings are Exception and Data. The table itself is meaningless; in the fact that it is a temporary table that is overwritten...

Sorry for the delay getting back here. Was a crazy weekend and I wasn't able to work on this at all. Plog: The data I am showing is after stripping it from the text file. The date itself goes with each record; like my second example. The data is error codes from nightly processing. I...

Probably something simple here but I can't seem to get it figured out. I've imported a huge text file and have pulled out the relivant data I need to store using a query. The data comes out like: (date) ... 9/29/2017 (B)...1 (T)...0 (F)...18 (I)...101 (Z)...82 But I need to put this into a...

Thanks Moke... I also found reference to that "Me.SubFormName.Requery" statement That was a couple days ago (took yesterday off) and I know I had to play around a little bit, but it did end up working for me. I just need to reformat this subform to make it a little more 'readable' for the end...

Update.... Got it semi to work. Knew I was missing something stupid. Didn't need the VB code part (I don't think. That may change here later). Was an issue between my query and the combo box. That's all straightened out. So issue now becomes updating my form once the selection is made in...

Okay. Trying to do some reading as well as follow what you are saying here... Do I have a control called Text31 - I think I would say the answer is no. If I understand 'unbound' correctly - then I would say my combobox is unbound. I tried to put 'text31' into the control source property...

My subform is getting data from this query: SELECT TechWorkHistorical.* FROM TechWorkHistorical WHERE (((TechWorkHistorical.[Account Number])=[forms]![TechWorkHistorical_Display Select]![text31])); Not sure if it would help, but thought I would include it here just in case.

Okay.. Here is where I show how bad of a database guy I am. I'm great with queries and tables, etc. pretty okay with reports and forms. But I absolutely am terrible with VB. I was able to get my old database to work - but it's been a few years back and I am not 100% sure what I did to make...