Search results for query: *

Good day to all. (Posted yesterday in the wrong forum, put a note to refer here). I have studied thread181-51747: Is calculating BUSINESS HOURS possible...?, thread705-1207464: Calculate business hours between two times, FAQ181-261: Calculate working days between two dates and anything related...

Anyone has had an issue with the patch 3 just released my Microsoft? My combo box does not show data anymore.. weird.

I have looked at many possible solutions in this forum however I am missing something. I am not very experienced so I am sorry if this is not clear. table : main Key field : contract Other fields: Client name, date entered, table : sub linked field : contract Other fields: message, The...

Is it possible to label the contents of a cell in a Word table with 2 colums as a 'heading'? So far, all my attemps resulted in the contents of the 2 cells being labelled as a 'heading'. If the answer is Yes, I'll look and learn some more.. Thanks

In my work, I handle dozen of different projects. For each project, there are e-mail exchanged that I need to keep and there are files (doc, txt, xls, etcc_) that I need to update locally and save. My problem is that I have a similar 'tree' for my e-mail and hard disk adn I often dont remember...

Good day all, I have a spreadsheet with 16 columns of which 4 have data validation dropo downs. The spreadsheet is to be used by several staff to log several entries entries on their projects. Each project has a name and number thus in order to quickly identify their project, the auto filter...

This is a functionnality that a good soul posted on this board a while ago.. I would like to amend the code to provide for either/or BegDate = DateValue(BegDate)EndDate = DateValue(EndDate) to be nil/void and not come up with an error, just a blank field.. . I tried if statements without...

in Word 2003, how can I insert a comment (in a table) without havind the reviewer's initals or name being displayed? Is this possible? Thanks

I need to round UP numbers (years) to a whole number coming from this formula Abs(DateDiff("m",[active_date],Now()))/12 Examples of the goal of the query: Date diff is 4.1, then result is 5 Date diff is 4.9, then result is 5 At this time, the rounding shows 4 when the date diff is 4.1. If I...

The error occurs when I try to make a table from a query The source is a simple table and the output is also simple however there is 53,0000 output lines with over 15 fields IF teh output of the same query is 'Select query' there is no problem, however when the output is make table, then the...

Other than vertical or horizontal, is there a way to specify, in a protected worksheet, the sequence of cells accessed with the TAB key? Example. Cell A2 B3 A4 B5 are unprotected for the user to enter data, the rest of the spreadsheet is protected. In an horizontal mode, the TAB sequence will...

In the Report footer section, I have =Sum([CountOfApp Count])... In the detail section, I would like to have the calculation [CountOfApp Count]/(Sum([CountOfApp Count])) to give me a percent of each line compared to the total.. The formula gives me an error but Sum([CountOfApp Count]) is...

Access 2000: I create a pivot table from a table (no parameters) and get the error 'Problems obtaining data' in Excel...It reads up to a certain numebr of ercords (11,000-12,000 or so) then stops... I m used to do tables iup to 50,000 lines with no problems... Look at MIcrosoft Knowledge base...

I have a query totalling, counting and averaging several fields which produces a report. So far so good. In this query, I need to add a Between [] And [] criteria to a DateIn field and these criterias to populate the title of the report. The problem I am encountering si that since this is a...

I created a macro that opens a query, which updates a table from which the data of a Pivot Table Form is taken. I can have the 'openform' macro command work but I need the macro to: Open the pivot table in Excel (double click on the form?) Close the access pivot table form.. I cannot figure it...

I have been looking for a while to get the query criterias to print in a pivot table header created from a Access Form.. I can get it for a normal report but a pivot table in Excel?... Someone has an idea? (This post is also in the Form forum).. sorry for the duplication) Thanks

I have been looking for a while to get the query criterias to print in a pivot table header created from a Access Form.. I can get it for a normal report but a pivot table in Excel?... Someone has an idea? Thanks

In order to use the 'Between' criteria in a query, I had to change the long format of a date field into a short one in order to capture the last day of the query with Input Date: CDate(Format([EB_Query_Two]![DATE ENTERED],"Short Date")) This comes from a very helpfull post in this forum... It...

Our IT department sends me a data dump of our operating system for reporting purpose and the data needs cleaning up. I queried the fields I needed for my reports and made another table. Fields are : application_no, reporting_one, Unit, Process_Status, Decision, Sales_rep, Lease_No and...

I started a small reporting utility 2 years ago for the business units' special needs, which takes data from our main operating system. All very simple (as are my skills or lack thereof).. Now, the number of reports available has grown considerably for each business units and I cannot fit all...