I have a process that is automating our various payroll entries. Once this has been done, I am wanting to automatically update our checkbook register that is in excel. The excel spreadsheet already exists, i know how to open an existing workbook and find the appropriate month's worksheet...
I am working on designing a db that will manage our client maintenance and processing. It's slightly broader than that. There has been a much needed push to centralize info in our company. Except for being available for viewing on our website, it's not being utilized.
Needed info is located in...
I posted this Access Tables and Relationships. Thought it might be better suited here. Sorry for the cross posting.
Working in Access 2000
First attempt at using ADO instead of DAO. Currently I use dsn-less connections to create table links in code. I'd like to replicate that with ADO if...
First attempt at using ADO instead of DAO. Currently I use dsn-less connections to create table links in code. I'd like to replicate that with ADO if possible. The tables uses 3 different ODBC drivers.(Wavecrest CView, MySQL, and SQL Server. Wanting to use universal data links(UDL) to save...
I have created an invoice report. It is grouped by cltcode and billing category. The billing category header determines the caption in the category label. In the detail section the collection total, the percentage rate, and the charges per category are displayed. In the cltcode footer there...
I work a lot in Access using VBA and SQL. For whatever reason the reports sometimes throw me for a loop.
My current project is to automate our billing.
I am working in Access 2000. The reports are based a query. We bill based on income categories. I am grouping by categories. So far the...
I am working on an Access form. I was just about done with the design and started messing with the startup. There were some toolbars that were visible and causing some of my other controls to be only partially visible. Everything really works the way I want it to, except that I need to add a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.