Search results for query: *

Yes, the original format is MS Publisher and I tried to convert it to EPUB and the size of the converted file is bigger than the original. The reason I converted to pdf first was because the PDF file was smaller then the MS .pub file

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 convert it to epub format, it increases to almost double...

Great information. I’ll follow your advice. Thank you. comp2008

Yes I have. All the drives are connected. By the way, the computer's 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 Also, I have another computer with the same specifications and It...

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...

Ok, I’ll see what I can do. If you find something specific, please let me know. I really appreciate your help. Comp2008

Yes, you are right… I Added a field called CompletionDate and, I entered a value once, on only one record, for testing purpose. Regarding the new code you gave me, to test the code execution: I did it and there is no message box showing the coded question. It should be obvious to see it...

To answer your question roccorocks, Yes, I have one record per form. Dhookom, If It works when you tested, That means that I’m missing something that I don’t see it. Let me tell you what I do: (step by step) 1. Open the form with the record I want to lock 2. Change to Dedign view 3. Set the...

Ok, I’ll give you the whole picture. We have a Database (MS Access 2007) in a public folder. Some users are allowed to make changes and adjustments to the fields until accounting department decides that the whole transaction is completed. At that point adjustments are not supposed to exist...

I created a new field named CompletionDate as your example. Also, I added the code you gave me to the “On Current” event of my form, and I still not getting to set the AllowEdits=False to only one record based on the contents of the CompletionDate field in my form. On the other hand, when I...

Thank you dhookom for making it more understandable. Now pwise’s suggestion makes more sense. Thank you both very much. Comp2008

Pwise,

I have a Database (MS Access 2007) in a public folder; many people have access to it. Therefore, we encounter an inconvenience lately. When a record is filled out, I have no control over some other users to make changes after the deal is completed. In other words, once the deal is done, I...

So far so good, thank you. Now, what would it be if I want to get the Gross of Model “A” “B” and “C” in a query. Something like this would be the idea: Model……Gross……Gross A……Gross B……Gross C A…………150.00……..150……….…0……………..0 A………. 200.00………200………….0……………..0 B……….375.00………..0…………375……………..0...

Part of my Access Database has two fields that I want to work on: [Models] and [Gross] [Models] has a drop down list with ( “A”, “B”, “C”, etc,) options. And the [Gross] field has Currency as a data type. How can I get a breakdown of the total Gross of each individual model? An example of...

I’m sorry SkipVought for not answering before. I really appreciate your help. This is the expression that I was looking for. I change the approach a little bit and It works perfectly. Abs(Sum([BDC Info Table].[Pre-Owned or New]="New" And ([BDC Info Table].[Status]="Active" And ([BDC Info...

Give a little more time and I'll give more details

Both expressions run without any problem separately. The problem is when I Subtract (Expression 1) Minus (Expression 2) It doesn't give me the right answer Comp2008

Expression 1 (Code 1) Sums "CountNew" within 11/03/2008 and 12/01/2008 Expression 2 (Code 2) Sums "CountSoldNotSet" within 11/03/2008 and 12/01/2008 Now What I want to Sum is: (Expression 1) minus (Expression 2)

I have two expressions that I want to Subtract. Code 1: Abs(Sum([BDC Info Table].[Pre-Owned or New]="New" And ([BDC Info Table].[Sold Date]<=#12/1/2008#) And ([BDC Info Table].[Sold Date]>=#11/3/2008#))) AS [CountNew] And Code 2: Abs(Sum([BDC Info Table].[Status]="Sold Not Set" And ([BDC Info...