Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 11 of 11
Search took 0.01 seconds.
Search: Posts Made By: canmex
Forum: Access November 18th, 2006, 11:59 AM
Replies: 1
Views: 8,234
Posted By canmex
Row colors in listbox

not to sure this can be done. would like two different row colors in a listbox, I have a list box with multiple rows and one colum of 6 that is true/false, if true, the text in that row is green, if...
Forum: Access March 7th, 2006, 03:07 AM
Replies: 14
Views: 2,364
Posted By canmex
Mike, first off I would like to say thanks for...

Mike, first off I would like to say thanks for all your help. I am impressed with your prompt responces.

I got it working using a dynamically generated query.

Here is my late night code that...
Forum: Access March 7th, 2006, 01:50 AM
Replies: 14
Views: 2,364
Posted By canmex
Not really much sensitive, allot of invoices. The...

Not really much sensitive, allot of invoices. The front end and back end of this DB is about 70 megs. I could delete a bunch of records in the backend to get the size down. Zip would reduce it a...
Forum: Access March 7th, 2006, 01:26 AM
Replies: 14
Views: 2,364
Posted By canmex
Not yet, no discount is applied to anyhting not...

Not yet, no discount is applied to anyhting not even the recods with the 537 or 536 codes,

Do you have a big gun. not for my head but for my computer.

PriceUSDCode:...
Forum: Access March 7th, 2006, 12:43 AM
Replies: 14
Views: 2,364
Posted By canmex
Once again, thanks for your help I may be...

Once again, thanks for your help

I may be wrong or just dumb but, I think we are not on the same page. My objective is not to have any hard coded conditions in the IIF statement other than the...
Forum: Access March 6th, 2006, 10:39 PM
Replies: 14
Views: 2,364
Posted By canmex
Mike, Sorry to say but it does not work. Here...

Mike,
Sorry to say but it does not work. Here is my complete SQL.

SELECT InvoiceBody.Code, IIf([forms]![menu]![PriceDiscount],([PriceUSD]*0.8),[PriceUSD]) AS PriceUSDCode, [sorprifix] & "-" &...
Forum: Access March 6th, 2006, 07:34 PM
Replies: 14
Views: 2,364
Posted By canmex
Mike, I have tried that in my query ...

Mike, I have tried that in my query

PriceUSDCode: IIf(forms![menu]![PriceDiscountString],([PriceUSD]*0.8),[PriceUSD])
What happens is the query applies the discount to every record.

My text...
Forum: Access March 4th, 2006, 08:46 PM
Replies: 14
Views: 2,364
Posted By canmex
In a query

In a query
Forum: Access March 4th, 2006, 04:58 PM
Replies: 14
Views: 2,364
Posted By canmex
Query with IIF

Basically what I am trying to do is replace the evaluation part of the IIF with a Text String.

Normal SQL that works.
PriceUSDCode: IIf([Invoicebody].[code]="536" Or...
Forum: Access October 7th, 2003, 01:25 PM
Replies: 2
Views: 2,703
Posted By canmex
I have an invoice data base. One DB is the...

I have an invoice data base. One DB is the invoice itself and the other is the details of the invoice. Eg qty, description, unit price, accounting code. When we have to cancel and reissue an invoice...
Forum: Access October 6th, 2003, 06:57 PM
Replies: 2
Views: 2,703
Posted By canmex
Copy and append paste

Could someone help me with a small problem I have. I want to copy and paste a few records using VB. I am using this to copyand paste 1 record but when I have more than 1 i need to copy copy all and...
Showing results 1 to 11 of 11

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.