Search results

Thanks Spike, I apologize if it sounded as if I wanted somebody to provide me with something for nothing....that was definitely not what I wanted. It's just that I have spent many many hours trying to figure this issue out by Googling, searching numerous forums and trying to figure it out...

I have this same issue...what's FixIt?

Come on guys.....I need some help...don't let me down...

Hi guys I'm a newbie and have been maintaining and enhancing an existing database in Access 2007. I need to "link" an Outlook Inbox to a table so that I can search and find emails belonging to a specific customer when required. I cannot use the "External Data" functionality as I keep getting...

Thanks Paul, If I remove the ""'s from $0.00 and save the query, Access puts them back! Anyway, I can now go through my tables and fix this issue once and for all....thanks again for your help and patience. Regards Greg

Hi Pbaldy, Thanks for looking into this. I'm sorry about the confusion regarding the number fields being "double"...I'm a newbie and didn't understand exactly... I pretty sure that the "$0.00" needs to stay as is otherwise it does not show what it needs to show. I changed the "Quantity"...

Ok, here is a sample database demonstrating the error. You should be able to simple run it and see the pop up form with the $0.00 Amount Owing. If you click the $0.00 you will see the funny amount.... There is just a single form called "fAll Valid Workorders Owing Money". I'm curious to know...

Hi JHB, I'll put together a sample database later today..... Regards Greg

Ok, I have check the 3 Text Boxes that I am using called "Total Payments", "Parts Total" and "Amount Owing" and they are all "Currency". The "Total Payments" is fed by a query as it totals up all of the records in the "Payments" table belonging to an invoice, The "Parts Total" is also fed by...

Yep. I'll check everything again when I get home in a few hours.

I'll get some more screen shots and info as I can't explain why all other invoices are working fine and only this one is acting weird.

Hi Guys From what I can tell, all fields are Currency. CJ, I tried your suggestion and although it got rid of the weird numbers, the invoice is still being showed even though it has $0.00 outstanding.

Hi guys I have a database that generates invoices and allows the user to record payments...it works really well. I decided to create a form that would display all invoices that either had not had any payments made (the total of the invoice was still outstanding) or they had some payments made...

Hi mate I just figured that out...thanks again for your help.

Thanks but I can't see anywhere where it tells me how to set the default date to a specific date such as "01/01/2013.. This is what I current have set in the Default of the Properties: =Date()-1000

Hi guys I want to set the default start date for the Datepicker (access 2007) to be 01/01/2013.... I've been trying to figure this out can't. Can somebody please tell me how? Thanks Regards Greg

Hi Minty, I figured it out! Works great! Thanks again for your help! Regards Greg

Thanks Minty, Where do I put Format(NZ(Sum(Payments.PaymentAmount),0),"Currency ") ? This is what I currently have: SELECT DISTINCTROW Payments.WorkorderID, NZ(Sum(Payments.PaymentAmount),0) AS [Total Payments] FROM Payments GROUP BY Payments.WorkorderID;

Hi Minty, I just noticed the format has changed from "Currency" and I can't change it back....any ideas?

Hi Minty, I just tried your suggestion and it works great! Thanks! Spikepl, somebody else created this database and I'm just trying to maintain it...