Search results

  1. A

    Max 6 fields per chart?

    This is a nice clever observation. Reminds me something like: You dump guys and I am clever. So there is a situation: I need a chart for 12 criteria. Not like I need, - anyone in Department need the chart to look at any day, by click of the button. Forget Pivot tables they are gone long ago...
  2. A

    Query question

    Still 5 persons 14 records a day = 90 records a day. 90*365 = 32850 records a year. would it be a concern for 1 table
  3. A

    Query question

    I can copy the recordsets in to a table during data enter. Will not be a problem. Love the outcome. Thanks for the advice.
  4. A

    Query question

    I already seen what it does on a my sample. Can not deny the results. I have to sleep on perfection a bit but I see where all it heading.
  5. A

    Query question

    At the time the idea looked well and it did well generating reports needed. But I had a bad feeling from the beginning. I am considering a new table based on advice. So what will crosstab will give me? I am new to this future.
  6. A

    Query question

    tblPersonName1 (Design view): Same tblPerson2, and so on ActivityDate Date -date format Activity1 Number - hours User select nr of hours Activity2 Number - hours Activity3 Number - hours The structure is very simple What I need: Table (Normal...
  7. A

    Query question

    There could be idea of structure of all data collecting corrected or rewritten just for that purpose, but I can not see how to fit column of Activities in the Table1, unless change the table. Thanks for replay by the way.
  8. A

    Query question

    Table1: Needs correction in the post. It is not clear. Table1 ActivityName1 and below the hours spent; Activity2 and below the hours. ActivityName column heading. I have 14 activities and 5 persons. Each person records a table - Table1. Date on which Activities performed and hours against every...
  9. A

    Query question

    Could not solve a probably a very easy task. Looks like simple situation: table1: [PersonName], [Time spent on activity], [Record date] table2: [ActivityName] I would like to build a table (and this is a task) Column1 - [PersonName] and names down (Name1, 2...N]; Column2 - [ActivityName1] and...
  10. A

    cannot convert null/blank to numeric 0

    Hi, I am having the same problem in very simple situation. Running query Based on table Customer Complains. The aim is to create monthly report where I can count complaints every month. Report based on the Query. So I Count the complaints with Month([ComplaintRegisterDate]) and Criteria =1 for...
  11. A

    Convert Report or Form from Access to Excel in VBA

    Hi anyone having the same problem. Even though I had my Report in colours, nice and neat in Access, my boss (it is always a boss) needed to see it in Excel. I looked at numerous forums and articles looking for solution for the problem. I can certainly say - if you are looking for one line of VB...
  12. A

    Export Query to Excel Keeping Formatting

    Thanks for response, The project suppose to be launched this week, last week was symbolic presentation. So it is no data on the table and I use Test database with symbolic data. Literately I do noit understand why it is not working. All books and web say it does. there is an example in the...
  13. A

    Export Query to Excel Keeping Formatting

    I would be more then happy to send a database, but Do not know how to make an attachment to my post
  14. A

    Export Query to Excel Keeping Formatting

    Hi Dx, It appiers that now with a bit MoveLast even without selection of the table column [CCNo] strSQLMonthlyRpt = "SELECT * FROM tblCCMain;" caunts all 7 records. When that bit removed it counts 1. And I tryed to merge results with excel. No luck. I guess I will wait when you got a minute. If...
  15. A

    Export Query to Excel Keeping Formatting

    Hi Rx I did not include anything. SQL as simple as it is. There are so many questions. First The SQL statement to me missing something. If you try to Run Query with statement "FROM tblCCQualityMain" the error would be: "There has to be at least one parameter selected". So for the sake of...
  16. A

    Export Query to Excel Keeping Formatting

    Dear Dx, I did not take a holiday and was working hard on the subject when I had time. Now the record in Immediate window is: The Error is The Error is record count is0 From what I understand, there is something with recordset which I am not able to set open. I went to numerous sources fell...
  17. A

    Export Query to Excel Keeping Formatting

    Hi Dx, I run out of ideas. The SQL statement OK. it works: On Click Event, after breaking point- Debug.Print, Copy to SQL query window, run, and I see the record. But when it comes to Function: nothing happens after click it is just like in your comment: No Records - No Report a.k.a. no...
  18. A

    Export Query to Excel Keeping Formatting

    And Yes the Line Failed
  19. A

    Export Query to Excel Keeping Formatting

    Hi Rx I though I am getting somewhere, but now I thing I am not. I did put breaking point and did run a code OnClick copied it to SQL and it came up with Data Type mismatch. Can not see a Different type of variables with strSQLMonthlyRpt. And I fell in to abyss of doubts and questions. Firstly...
  20. A

    Export Query to Excel Keeping Formatting

    Dear Dx, I will investigate the code and will follow your advice. Just in case will mention that I did put SQL from SELECT to WHERE in a new query design SQL window (picked up the idea from some lessons on the net. and comments on mistakes ARE meaningful). The aim was to see if the query runs...
Back
Top Bottom