User Profile

Collapse

Profile Sidebar

Collapse
plaguna
plaguna
Last Activity: May 22 '12, 06:45 PM
Joined: May 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • plaguna
    started a topic convert pdf to epub

    convert pdf to epub

    I'm trying to publish an ebook at Barnes and Noble. I have the book on pdf format and using Calibre it's converted to epub. The problem I have is that B&N allows only 20 MB file to publish an ebook. My pdf file is 19 MB but every time I converter to epub format, it increases to almost double the size.
    Please if you have any idea how to maintain the same size doing the convertion, or perhaps another method.
    Any suggestion is greatly...
    See more | Go to post

  • It was slower opening the file when I dbl click, and when changing some data, especially in Excel.
    What I did though, after you mentioned the Anti-Virus; I disabled the office plug-in once I have the Anti-Virus Norton. And, the speed improved tremendously.
    Thank you for your input.

    plaguna
    See more | Go to post

    Leave a comment:


  • The specifications are:
    Dell Optiplex GX280
    Windows XP Pro version 2002
    Service Pack 2
    Pentium(R) 4 CPU 3.00GHz
    2.99 GHz 0.99 GB RAM
    Microsoft Office 2007
    By the way,I have anotther computer with the same specifications and It doesn’t have this problem

    Plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    started a topic Slow when running some Windows applications

    Slow when running some Windows applications

    My computer is very slow when some Windows applications are running. I defragmented and fixed bad sectors of the C: drive, I deleted open and running applications through regedit, I removed all the unnecessary programs, cookies, temp files, scanned and fix antivirus. It is slow only with Windows applications, especially with Microsoft Word and Excel. Other applications and Internet browsers run with a reasonable speed. Do you know anything else...
    See more | Go to post

  • plaguna
    replied to Change a Record to Read Only
    Good site but, it is not exactly what I am looking for. Thank you anyway.
    plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    replied to Change a Record to Read Only
    Please Tell me if I’m doing something wrong, because no matter what the code in the On Current event is, I’m still allowed to edit.
    These are the steps:
    1. Open the form with the record I want to lock
    2. Change to Dedign view
    3. Set the AllowEdits property on the form to Yes. (from Property Sheet, Data tab)
    4. Set the On Current property (Event tab) of the form to the following event procedure:...
    See more | Go to post

    Leave a comment:


  • plaguna
    replied to Change a Record to Read Only
    Great information. Thank you.
    Therefore, When I set the AllowEdits property to “No” It sets to all records of the Form, and my intension is to AllowEdits=No to only a specific Record. Also, I Added this code to the On Current event of my Form in order to set the AllowEdits Property based on the contents of the CompletionDate field in my form:

    That way if the field has a value, then set the AllowEdits property to...
    See more | Go to post

    Leave a comment:


  • plaguna
    started a topic Change a Record to Read Only

    Change a Record to Read Only

    How can I change a record to Read Only? I have a Database (MS Access 2007) in a public folder, which many people have access to it and, we have no control over some of them to make unnecessary changes to fields or records. I was reading about setting the “Allow Edits” Property to False from a Form to avoid changes, but but I can’t find a way how to do it. Can anyone tell me if this is the best options and/or what the steps would be? ...
    See more | Go to post

  • Megalog
    Something inspected happened at work that I couldn’t reply your answer. Sorry about that.
    Thank you for helping with the code you sent me. I’ll try it….. I’m sure It’ll work.
    Thanks again

    plaguna
    See more | Go to post

    Leave a comment:


  • I tried your code and, yes it works for Model "A" . Now I'm going to try adding Model "B" and "C" and .... I don't know the syntax but, I'll give it a try. Thank you

    plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    started a topic Sum a Total Dollar amount within a specific group

    Sum a Total Dollar amount within a specific group

    Part of my Access Database has two fields that I want to work on: [Model] and [Gross]
    [Model] has a drop down list with ( "A", "B", "C", etc,) options.

    When I use the following expression, (in this case for Model “A”)
    Code.
    Abs(Sum([Table].[Gross] And ([Table].[Model]="A"))) AS [Total A Gross]

    I get the count of the number of records that the Model "A" has,...
    See more | Go to post

  • Sum a Total Dollar amount within a specific group

    This is a duplicate thread. Deleted by Plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    started a topic Sum a Total Dollar amount within a specific group

    Sum a Total Dollar amount within a specific group

    Sorry, this is a duplicate. Please reply the other one

    Part of my Access Database has two fields that I want to work on: [Model] and [Gross]
    [Model] has a drop down list with ( "A", "B", "C", etc,) options.

    When I use the following expression, (in this case for Model “A”)
    Code.
    Abs(Sum([Table].[Gross] And ([Table].[Model]="A"))) AS [Total A Gross]
    ...
    See more | Go to post
    Last edited by plaguna; Jan 19 '09, 10:39 PM. Reason: Duplicate

  • plaguna
    replied to Count two fields based on Date in a Query
    Actually I want to retrieve [Status ]=“Sold not Set” when [Sold Date] is >=11/01/2008.
    I found that Count will count all non-null values. That’s why I didn’t get the right data.
    What do you think about this expression.
    Code:

    Code:
    Abs(Sum([BDC Info Table].[Status]="Sold Not Set" And [BDC Info Table].[Sold Date]<#11/1/2008#)) AS [CountOfSold Not Set]
    plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    started a topic Count two fields based on Date in a Query

    Count two fields based on Date in a Query

    I'm trying to Count data in a Query Combining two different fields based on the "Date" the product was sold, and for some reason I get a wrong data. When I use only this expression, It works fine:
    Code:
    Count(IIf([BDC Info Table].[Sold Date]>=#11/1/2008#,0)) AS [CountNovSold]

    But when I want to Count another field based on the same Date.
    Code:
    Count(IIf([BDC Info Table].[Status]="Sold...
    See more | Go to post

  • plaguna
    started a topic Count and Group By two fields in a Query

    Count and Group By two fields in a Query

    How can I Count the number of Customers that a Sales Person had in a City X? The idea is to Group By [Location Name] and Sub Group By [Sales Person], and then Count the rest of the fields. This is the scenario:

    [Location Name]……[Sales Person]…….[CountOfCustomer s]…..etc

    ………CITY1
    ………………………...... .Steve K………………………..25
    …………………………….Joh n...
    See more | Go to post

  • plaguna
    replied to Count and percentage of specific records
    I recreated this database file from scratch. The first one had too many inconsistencies and, was hard to follow when errors occurred.
    I read about DCount () and, found that this function is to return the number of records specified, but it is good to use it in Queries. It is not recommended to use DCount() in a Report if you want to calculate from records in your report or report section.
    Instead, I got this expression which works...
    See more | Go to post

    Leave a comment:


  • plaguna
    replied to Count and percentage of specific records
    You guys are right. I reviewed all the previous posts, and I see some inconsistencies from my part. I agree with Stewart saying “Words are very important to us - all we have to go on is what you tell us”. I’m sorry that I fixed errors and made some changes along the way after the suggestions you tell me to do, and I didn’t let you know the updates. Now I understand that this way, you can get crazy trying to figure it out what is going...
    See more | Go to post

    Leave a comment:


  • plaguna
    replied to Count and percentage of specific records
    Please let me rephrase the last part of my last post. The expression I got from ADezii and Stewart Ross Inverness does count only in the Report Footer. In fact, It works beautifully, which is great. But, when I try it in the Group Footer, It gives Grand totals. (the same output as the Report Footer) How can I get the total for each group?

    Thank you
    plaguna
    See more | Go to post

    Leave a comment:


  • plaguna
    replied to Count and percentage of specific records
    You are right, It was a miss spelled. Instead of “BDC Info Table” It was “DBC Info Table” and of course It couldn’t fine It. Now I don’t have a #Error message anymore, but the output is not correct. It doesn’t count correctly when the report is by groups. Even if the expression is in the Report Footer.

    plaguna
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...