Results 1 to 12 of 12
  1. #1
    Tony McGuire's Avatar
    Tony McGuire is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2009
    Location
    Denmark
    Posts
    14

    Angry Adding columns that contain blanks.

    Hi
    I am a learner to databases but, an enthusiastc learner.
    I have a 'little' problem.g the following I am trying todevelop my own home budget system. I have, among other things a seperate sheet for each month which shows expenditures and income. I am trying to reflect each month ot a seperate 'Summary sheet' and by using the following code for each month am able to transfer the results from each month to this summary: for example Jauary-



    DoCmd.OpenForm "frm01januar", acNormal
    '
    [Forms]![frm2009]![Jan] = [Forms]![frm01januar]![Text16] (Expenses)
    [Forms]![frm2009]![janI] = [Forms]![frm01januar]![Text14] (Income)
    '
    [Forms]![frm01januar].Visible = False


    ------------------------------

    a similar code is used for each month. This is okay until I reach a month which we have not yet reached i.e. June 2009 (does that sound Irish?). The income and expenditure for that and all future months are empty. This presents a problem as I cannot add the columns up as after May they just show blank. I have tried using '0' as a standard value but this doesnt seem to help either.

    Can anyone xplain what I am doing wrong and how the correct code should read?

    Regards
    Tony (Denmark)

    [IMG]file:///C:/Users/Tony/AppData/Local/Temp/moz-screenshot.jpg[/IMG]

  2. #2
    Matrix's Avatar
    Matrix is offline Admin
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2005
    Posts
    517
    Tony: You need to upload your screenshot as an attachment. Click 'Go Advanced', then 'Manage Attachments'.

  3. #3
    Tony McGuire's Avatar
    Tony McGuire is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2009
    Location
    Denmark
    Posts
    14
    Hi Matrix
    I have tried uploading my database
    without luck. I notice that yor 'Manage Attachments' state that*mdb files should be up to 2mb. Mine fills aprox 5 mb- I end up gettng an 'Update Failed' Message each time! Am I doing something wrong?
    Tony McGuire

  4. #4
    Matrix's Avatar
    Matrix is offline Admin
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2005
    Posts
    517
    The reason seems obvious, your file is too big. Can you just keep some sample data?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would do a Compact and Repair and then zip up the mdb and see what size you have first.

  6. #6
    Tony McGuire's Avatar
    Tony McGuire is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2009
    Location
    Denmark
    Posts
    14
    Hi Rural Guy,
    Have tried your suggetion but I guess that my Db is too large and can't get it under 5 mb. Anyway thanks
    Tony

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Pictures take up an inordinately large amount of space in < ac2007. make a copy of the db and strip out some of the pictures and then Compact and Repair. You'll be surprised.

  8. #8
    Tony McGuire's Avatar
    Tony McGuire is offline Novice
    Windows Vista Access 2003
    Join Date
    May 2009
    Location
    Denmark
    Posts
    14
    Hi again RG
    My Db is a feeling that financial one and doesnt contain any pictures that I can remove. I have a feeling that if I can just hit on the correct vb code this will solve the problem but at the moment it is evading me! I am not giving up though and appreciate a ll the help I can get.
    Tony

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If you want, you can send it to Rural Guy at Wild Blue dot Net and I'll take a look at it.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Tony,
    Your email got here but the attachment did not. I would still zip it up in case there is some email filter somewhere.

  11. #11
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Darn Tony, the attachment got here but Outlook will not let me look at it. I didn't know it would do that. I would still appreciate a zipped version in case I can not convince Outlook to let go.

  12. #12
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Tony,
    Your attachment was just an .lnk (shortcut) anyway and Outlook will not let me look at it. Go with the .zip file.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Adding Two Columns
    By arthura in forum Queries
    Replies: 6
    Last Post: 05-01-2009, 08:38 PM
  2. Multiple Price Columns
    By kmwhitt in forum Access
    Replies: 0
    Last Post: 04-04-2009, 09:48 PM
  3. sub-reports and columns
    By blg in forum Reports
    Replies: 0
    Last Post: 02-21-2009, 11:11 PM
  4. Crosstab: Sum of Columns over Row
    By tommaccoy in forum Queries
    Replies: 0
    Last Post: 12-03-2008, 05:26 AM
  5. Add Columns to query
    By 4petessake in forum Access
    Replies: 0
    Last Post: 06-15-2007, 01:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums