Search results

Hello! I have a set of code to generate at pivot chart based on the information entered by the user on a form. The data populates fine however if it is the first time that the dates are being viewed on the chart they are collapsed. I want these dates to open expanded showing the hours...

I have a database that populates the Digital Signature has been tampered with... warning everytime I open it after I have run the code. I have done some reserch and have discovered that this will occur if you have and action query that is modified by code. Is there any work around for this...

I am about to go bonkers on this one. I have a form with 3 combo boxes. It is set up so the 1st is auto populated with the departements. second(Jobs) has none, and 3rd has employee names. I have no issues getting the drill down to work from select dept and it populates correct Jobs, select the...

Not sure if this is even possible in Access or Excel Pivot charts for that matter but I would like the ability to look at the overall average of a group of data and compare it to an individuals average for the same time period on the same chart. I have not seen anything when searching google or...

I am importing Excel data into Access. I have code already writen that pulls the sheet names from user selected excel files, populates a form with the sheet names(opens files to get names and closes), allows the user to chose with Sheets to import, and then imports those sheets(opens and...

Hello all. I have been unable to solve this and need some help. I have a large amount of data that needs to be looked at from a number of angles and am having a problem with getting it all to show. running the individual querys I obtain the information I need but I need to combine these into...

I am haveing to create a report from scratch in VBA. Yes I know its not the easiet or effective way to do it but for this task it is what I have to do. The issue I am having is getting the report header to show so I may access it. The best I can gather form hours of searching is that this...