Search results

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

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

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

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