Search results

How do you remove the "Page 1" message from a Pivot Chart page printed by Access?

1st of November - D11012007 11th of January - D01112007

I have a field of user inputed data. The data are dates. The standardized way we'd like dates entered is DMMDDYYYY. The first D is inconsequential, it just needs to be present, whereas M means month, the D means day, and the Y means year. I would like to filter my results to ONLY see the data...

Okay, that actually shouldn't be a problem because I just changed the format to match it. So it shouldn't have difficulty reading it. I've tried min and first in the total field under the start date column with no success...

Okay, so I found a site about parsing dates. Problem is, I've never used code in access. How would one apply the code that is offered at this link? http://www.codeguru.com/forum/showthread.php?t=373173

I couldn't tell you why, but for some reason that doesn't work. I found this website as well and done everything without any luck: http://office.microsoft.com/en-us/access/HA010345581033.aspx#13 I think the problem could be that the date format is not standard. It is: MM/DD/YYYY HH:MM:SS So...

I have a list of projects and am creating a query that tells me their duration based on beginning and ending dates. These beginning and ending dates can be edited by the user, and frequently, there are multiple beginning dates. When I query the projects, instead of getting unique project numbers...

Without getting into too much detail, you can right click on the Field Row in Design View and if you look towards the bottom, and option called "Build . . ." will be present. Click on it. You are now in the expression builder. If you are familiar with Excel, this should be similar for you...

Perhaps I misunderstood your question, but I would just hit the "Insert" button on your keyboard.

SOLVED IT (well, my manager solved it) It couldn't import the data from Access to Excel because there were a ton of null values that, I guess, "tripped" the computer up. In other words, it didn't know exactly what to do with them. So, I created a new column in access that changed the null...

Alright, did a little more trouble shooting. The only problem that exists is the projected hours column. I can get the other columns to import just fine. I even tried to import JUST projected hours without any joints to other tables or queries without success. I don't know why this particular...

Fair enough, should have thought of that myself. I just assumed someone would "google" me the answer based on the error message (which I had no success doing so this makes sense) . . . The data I am trying to import into my Excel sheet is on a shared drive. I would detail the process I go...

I have a query I want to import into Excel. I can run it just fun in Access 2003, but when I try to import into the spreasheet, it gives me this message: [Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error. Any ideas?