Search results

Hi, Need a little help with rounding up. In A2K I have a form with a textbox that displays a security deposit. Security deposit is calculated by rounding the payment to the next $25 increment, hence a payment of 324.53 should have a security deposity of $325.00, but a payment of $325.01...

Hello - I have a form with a txtbox that shows a date. I need the querry to refer to that date as selection criteria. I have the following in the criteria of the query: =[forms]![frmUpdatePayments]![txtDate]. I know the problem is I need # at the beginning and at the end of the date, but how...

Ok, problem solved. Even though all controls on the right side of the report were right alligned at the right margin, one pesky textbox was apparently taking up unseen real estate in the margin causing the 2nd page to show. Moving each control slightly to the left one at a time helped me find...

Hi - Trying to use report instead of Word Mail Merge. Have an 8 1/2 by 11 form that needs to get filled out by results of query. No problem with this except I get 1 record on a page, then a blank page, and then another record. How can I get rid of the blank page. I have no lines in the...

Wayne, I'm not sure what you mean here. Since I'm such a "wimp" with Access, could you elaborate? Thanks!

Wayne, Thank so much for your quick response. The continuous form is based on a query of unpaid invoices. Some times there are just a few, and sometimes there are a lot. I would like the user to be able to see all the unpaid invoices, but have the option of clicking the command button to...

I have a continuous form based on a query. In the form footer I have placed a text box and a command button. One of the text boxes on the continuous form is bound to the VIN field in the query. I would like the user to be able to place the last 8 digits of a particular VIN in the text box in...