Accounting program with ms access with VBA code (open source)
prepare (journals, trial balance,balance sheet,Cash flow
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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...
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
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?
Should I be adding something here to make the Access table maintained in the link?
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
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
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.