Recent content by lehcarrodan

Thanks, you guys are awesome. I will be working on this Monday but I think you've given me a pretty good idea.

Thought it would be easy with the query wizard.. Not so much. So I have a whole lot of customers in tblCustomers Problem is I imported from our old database so some data is duplicated so to start clean I want to delete duplicates. BUT I want to store the CustomerNotes field of the duplicate...

IF the field is set to decimal (single or double) it will hold a lot of decimals, tho you may only see a few. format() is the answer to view more. I have set the field to double.. It now seems to be rounding up the value 9.975 to 9.98 and then showing more decimals 9.98000 Really not getting...

Hi I have a Dlookup in my vba code that goes to my tblTaxes and puts the number into a text box on my form (it works! Sort of..). Problem is, in the table it shows the proper value 9.975% and in the text box it cuts the last decimal. Why's this happening?/@^@&!!! Even when I tell it to show more...

Hi, so I have a button click that I want to open a report that you can then choose to save a pdf or print. If I open as below it prints automatically but when I try to open in acPreview or normal it gives an open report action was cancelled error message. I think there's an issue because there's...

Hi, I have tables for orders, order details and customers that are all related and functional. I'm wondering how to process a returned item. Each order has a status but I'm thinking that each order detail would need to have a status for returns. Is this correct? Is a return still counted as a...

Did you figure this out? I am looking to do something similar. Paypal gives us our orders and I want to append these to my orders table but need some of the info to go to order details table and my customers table. Any more light you can shed on this would be great!

Having trouble getting the WHERE part to work. I know everything else's right because if I remove the WHERE section it updates all the qryPayments Paid field to true. I have a text box on a continuous form called txtStillOwing and I want when txtStillOwing=0 to make paid=true it's a currency...

Okay prefect! Just so I understand what's happening.. There's an automatic error in this case 2501 that occurs when there's no data returned? And instead of displaying that message I'm putting my own?

Thank you, thank you! I will make a form for input. However what do you mean trap for 2501 error? How do I do that.

I'd like to open a report that requires parameter input but only open the report if the query returns values. (It's a sales report) So I know I can use If DCount("*", "qryWhatever") > 0 Then ... but then it seems I need to input the parameters twice? Can I have this check done by the query...