Accounting program with ms access with VBA code (open source)
Design change of Form / SubForm
Looking for wisdom on how to proceed with making a change in the db in such that I have an Accounting Table with a PK and an FK to the Products table.
I have an FK in the Accounting Table but I feel uncomfortable in it's usage. If I am in the Products Form and I switch to the Accounting Form I thought the Accounting Form would automatically display the records associated with the Products Form.
However, since sometimes accounting information does not exist at the time of access the Accounting form and sometimesnew accounting information needs to be added as a new line for the Product, It seems like it should not show anything unless you tell it to cycle to a related record...
Integration with Quickbooks or some other billing program.
Has anyone built any integration between Access (OR SQL) and Quickbooks or any other Accounting Software?. I have an .ADP application using an SQL 2005 backend that I'd like to add ACCOUNTING support to.
Is there anyone who has an accounting template or a link that they work like to share that outlines the set-up of a retail accounting template in access.
I have been using the Northwinds Traders Template as a reference but have found while it is very helpful on the order side of the retail equation it to be somewhat lacking on the financial accounting side such as accounts payable, accounts recievable, general ledger, invoicing, and statements.
Trying to excute a batch file from VBA code
I am using MS Access 2007 and I am trying, from my VBA code, to execute (or run) a Batch file. Now the batch foile works, but not from my code.
I used to be able to just do this --> Call Shell("S:\Accounting\AP\Tex Files\File List Generator.cmd ", 1)
ANd it would runit. But using this I get a message telling me that it is an invalid procedure call. So upon looking around on the net I found tha ton place said that with MS Access 2007 you need to do this:
Call Shell(Environ$("COMSPEC") & " /c S:\Accounting\AP\1099 ITEMS\W9 Folder\Corrected 2011 W9\File List Generator.cmd ", vbNormalFocus)
But while it does not error out it dooes noting eitheer. What the batch file does, when it works, is produces a list of all the file names in a folder
Questions about splitting a 2010 Access database
I have read through some of the other threads on this subject and I am more confused than ever.
I have split an Access 2010 database with the tables being in the backend. Some of these tables were originally imported from an Accounting database. Before I split the database, I had aseries of macros that would delete these "Accounting tables" and then import the latest version of these tables from the accounting database.
I need to continue to update those tables on an on-going basis. As a result, I created a startup form that had a control to backup the database and another control to run the macros to update the accounting tables.
I then opened the front end and relinked all of the tables in the back end to the front end.
From what I have read, I believe that I should not have done that (I.e. the backend should contain tables only- no macros, forms, etc.). If that is correct, what is the proper way to deal with these tables that need to be replaced on an ongoing basis? I know I can link the accounting tables from the accounting database to tables in the backend (rather than import them) but Iwould rather not do that for a variety of reasons.
can I use VBA or macros or something in the front end to do these updates at a click of a button?
OPen Wrod merge doc from Access vba
I have a Word merge document that is linked to an Access table. If I open the Word document through Word (File, Open) the data source is linked. However, when I open using code in Access the data source is not linked.
Should I be adding something here to make the Access table maintained in the link?
Cannot open VBA code
A few days ago my database suddenly started pumping out this error message:
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code form modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
This message appears every time a form with VBA code is opened, and every time I try to open the VBA editor. Of course I have a backup, however I rather not be forced to redo about 6 hours of work.
Looking across the internet it seams like quite a few people have had this problem, but no solutions. As far is I can tell, something in the VBA code has caused the database to become corrupted.
So my question is this, is there any way I could possibly recover at least some of the code? Could I somehow force Access to show me the code, even if a part of it is corrupt?
Double entry accounting
I have been searching the web for some examples of a double entry accounting systems made with MS Access. I havent found any that I can open. examine the tables, queries, relationships and everything else. Not that I am planning on spending a year or two building one But I want to know how to. So if anyone knows of any good examples please post the links for me
Open Navigation Pane Programmatically
I have a program that I am mildly modifying (I did not write it) and everything is gravy except they want to be able to see the navigation pane only while a certain form is open.
I was pretty easily able to hide the pane via VBA when the program starts and when the maint. form closes, but I can't for the life of me figure out how to open it again.
I know you can just hit F11 to get it open but I'd much rather be able to do it in code and disable that method if it's possible
How to halt vba code while a form is open
Access 2010. Here is an extract of vba code
The idea is to have the code halt while form FRMLatefEEManage is open. The form needs to be usable.
When form is closed, the code can continue. The form opens but isn't full size and doesn't behave as it normally does. Is acDialog the only method to have the code halted while the form is open ??
Unable to open code window
With both Access 2007 and 2010 I am unable to open the VBA code editor. In each, I click Create >> Module or VBA Code and Access goes into a non-responding loop.
Where can I find AES sample sourcecode for VBA?
I am trying to add block cipher functionality to a series of VBA modules in an Excel environment. I also want to learn more about this encryption algorithm. Since it is an open standard, I should be able to get this right? But I cannot find sample source code for VBA or even VB.NET
Removing non Alpha Numeric Characters
They are creating duplicate entries in our accounting program and I would like our database to be able to pull out blank spaces, commas, dashes, etc. They have a habit of entering an invoice number as INV-123 or INV 123 and the accounting system isn't catching it because of the non-alpha numeric characters.
What would be the most efficient way of accomplishing this?
Introduction to MS Access and PHP
Not so long ago developers would have said that it is near impossible to use an open source programming language with a Microsoft Access database. But these days it is possible. Thanks to ODBC. Open DataBase Connectivity(ODBC) is an Application Programming Interface (API) that allows a programmer to abstract a program from a particular database type or technology. What this means is that you do not have to write separate code for every type of database that you wanted to interact with. All that you do is to write code that uses the ODBC API and it will be sufficient to communicate with as many different databases as needed. In this article we will create a guestbook with a MS Access database backend.
Hide VBA code from users
If your database contains Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Windows applications and is included with several Microsoft applications.) code, you can hide that code by saving your Microsoft Office Access database (database: A collection of data related to a particular subject or purpose. Within a database, information about a particular entity, such as an employee or order, is categorized into tables, records, and fields.) in the .accde file format. Saving a database as an .accde file compiles all VBA code modules, removes all editable source code, and compacts the destination database. Your VBA code retains its functionality, but the code cannot be viewed or edited. In general, the database will continue to function as usual - you can still update data and run reports.
In this article you'll learn: Create an .accde file, Functionality that is changed in an .accde file, Issues with modifying forms, reports, or modules, Restrictions on saving a database as an .accde file, How references work with .accde files.
mdb save problems with Access 2010
We've got both Access 2007 and 2010 running as front ends for our SQL db on several computers at work. I've got a small Autoexec VBA program toautomatically update the Access database that is loaded on everyone's desktop:
Specific error is that the switchboard form on the db does not load using Access 2010 after the update. Everything else seems to work. Also impossible to manually open or design form after the update, since Access says it now cannot recognize data in that form ?! 2007 Access works perfectly, no problems.
I've already turned off everything obvious in the Trust Center, as well as designated my source location as a trusted location.
Does Anyone have the code to connect to the localDB from within VBA in ACCESS. ADODB
I've got Access 2007, and I am trying to connect to the DB that the VBA is running in (The local DB) how is this accomplished. or is there a prefered method to work with Recordsets from within the ACCESS program.
I am only familiar with connecting to remote objects, and Databases with code, not looking into the database I am "on".
see who has program open
Is there any way to see who currently has my access application open. Either something built into Access or something I have to create with code. I already have people log in using a user name to get their settings and all that but now how can I use that to see if they have it open
Open Exclusive Code
I want to do that when I open my file without going through the opening procedure. I.E. when i double click on the icon for the program, I want it to run as exclusive (lock everyone else out) without opening through the file browser and setting that property.
I tried Accesss Options-Advanced - (checked)Open Exclusive
and no change, still lets any other user open and use the program.
I don't want to check for a lock file.
Is there any code to just set the database to exclusive on open?
Handling Excel files from VBA in Access
Now I came to the point of needing to manipulate Excel workbooks via VBA code runing in Access. Although I am not a program writer, I am VBAing Access for 15+ years, but unfortunately have no clue about Excel objects/classes.
I have serached the Internet for tutorials and sample codes but only found VBA codes running in Excel handling the current workbook. I could not find tutorials or samples for handling Excel workbooks via VBA code that runs outside the file being handled