Search results

I encounted this before with other MS Office programs. On some PC's a certain aspect of the default printer prevents the ability to view or print MS Access reports. I have solved this in the past by changing the default printer. Is there a definitive answer to the cause of this? It occurs only...

I create a temporay table which I want to export to Excel where I will do some complex calculations that I can't get done in Access (multiple references to previous records - tried 100's of ways to accomplish in Access - couldn't do it!) I have created macros that transfer data (from...

I am trying to get/calculate a previous balance in a query (based on a table named File) that gets its criteria (an Account No) from a form to create the record set. I have to do calculations on the interest to be paid for the duration of the time between transactions. My record set is...

I have a table for workorders(WO). The workorder ID is unique. Each WO can have one or more labor/repair operations (e.g. oil change, clutch, radiator etc.) which I have named WOItemNo. I would like the tech to be able to enter multiple repair items and have them start at item 1 (by default...

I have a client that gave me a group of Delphi files (filename.DTA). How can I read those files in Access?? The client no longer has Delphi on their computers and neither do I.. HELP!!!

I want to create a db that tracks a group (25) of limited partners' share value. Each partner contributes a certain amount (original balance), receives interest payments/income payments (interest/income can be paid back to contributor or re-deposited as additional contributions), contributes...

I have numerous reports and forms based upon paramenter queries. Can I have the parameters that are entered (e.g. begin Date and End Date) appear in the form or report??? These dates are based on a Between ... And Parameters in a subquery from a maxdate/time value. Is it still possible? HERE...

1. Whew, my brain is dead!! I generate one large report that gives the teacher's name and e-mail address as the form/report page header and a list of their students and student grades as the body/detail of the page. So each teacher gets one page of the 1000 plus page report. Since I have the...

I am creating a database that tracks tech's time spent waiting for parts, waiting for customer approval, working, idle and not on the clock (lunch, personal, end of day). I set up a table and form for each tech (the form uses command buttons for each task to enter the start time and task...

I am trying to get my form to add all the product info when I select the product # from the list. All the info I want to enter shows with the product #, how do I get all the other info to post with the product #? I get the product info from products table and trying to update sales table with a...