General :: Unified Same Tables For 3 Different MS Access File
Mar 31, 2015
I have 3 sets of MS Access File (NEDA, RDC,& Summid) built with the same sets of structures. Originally at MS Access 2007, but now I'm using the built in 2010 version for Lenovo Flex 2.The table consist of:
*Chart of Accounts
*Journal Entry Voucher Master File
*Journal Entry Number Master File
*Supplier Master File
Queries are the same (links, designed, etc...)
Forms are also the same (links, designed, etc...)
Reports are also the same (links, designed, etc...)
The difference for these three file is the Journal Entry Number because each file requires a different JEV format...Example:
-For NEDA it should be NEDA-Year-Month-Number Series
-For RDC it should be RDC-Year-Month-Number Seried
Laslty for summid it should be Summid-Year-month-Number Series and separate transaction listing for the purpose of calling data for the report, such as List of disbursements and trial balance.But for these three MS Access file, Chart of Accounts and Supplier Master File do have the same set of data. That's why whenever a data is not available I am encoding the said information in each MS Access file (inputting the data three times).Example:If an asset account such as Office Supplies is not available, I will input in the Chart of Account Form for NEDA, then RDC, then Summid.
Question
Is there a way where I can unified the Chart of Accounts and Supplier Master File into one but still can entry/edit the same in each MS Access forms. Also can still link to each queries, tables,and reports?So that I will encode data one time only and save space.
View Replies
ADVERTISEMENT
Mar 11, 2014
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
View 3 Replies
View Related
Mar 31, 2015
I have 3 sets of MS Access File (NEDA, RDC,& Summid) built with the same sets of structures. Originally at MS Access 2007, but now I'm using the built in 2010 version for Lenovo Flex 2.
The table consist of:
*Chart of Accounts
*Journal Entry Voucher Master File
*Journal Entry Number Master File
*Supplier Master File
Queries are the same (links, designed, etc...)
Forms are also the same (links, designed, etc...)
Reports are also the same (links, designed, etc...)
Problem : The difference for these three file is the Journal Entry Number because each file requires a different JEV format
Example:
For NEDA it should be NEDA-Year-Month-Number Series
For RDC it should be RDC-Year-Month-Number Seried
Laslty for summid it should be Summid-Year-month-Number Series
and separate transaction listing for the purpose of calling data for the report, such as List of disbursements and trial balance.
But for these three MS Access file, Chart of Accounts and Supplier Master File do have the same set of data. That's why whenever a data is not available I am encoding the said information in each MS Access file (inputting the data three times).
Example : If an asset account such as Office Supplies is not available, I will input in the Chart of Account Form for NEDA, then RDC, then Summid.
Is there a way where I can unified the Chart of Accounts and Supplier Master File into one but still can entry/edit the same in each MS Access forms. Also can still link to each queries, tables,and reports? So that I will encode data one time only and save space.
View 3 Replies
View Related
Jul 6, 2013
how could I store files such as PDF inside MS access.
View 1 Replies
View Related
May 2, 2013
I'm using access 2010. how should I share the access file I created that will be the best way?there are 20 users that need to add/edit/view the data.I read in some places that I need to do share on options and some said that I need to split the file to data and front file.
View 3 Replies
View Related
Feb 3, 2013
I have a large .dat file which is run through an Access macro to produce reports. After a recent system change at work the format of the .dat has changed and now includes an additional bit of data which disrupts the macro.
I tried changing the extension of the file from dat to mdb to see if I could remove the additional column in access. I also tried changing it to a csv file as well but the file has a few hundred thousand lines and the csv file cuts most of it out.
Are there any other ways I can open this file in Access to remove this additional column of data?
View 3 Replies
View Related
Nov 15, 2012
Any issues with using Access 2010 to edit an mdb file..I know there are backward incompatibility issues with 2007 and 2010, but these are both accdb formats.
View 1 Replies
View Related
Oct 18, 2014
I use below simple command line to start a macro in my Access database. Usually all works well. I start my bat file, command is executed and macro does its job.
However it always fails if I have a session of Access already opened even if it is a completely different database. If I use below then it opens another sessions of Access but does not execute the macro. I need to go into the second session and run macro manually. It works fine then.
Code:
"C:UsersMeDocumentsDatabas1.accdb" /X Macro
View 1 Replies
View Related
Jun 28, 2012
I was successfully using a front end and back end setup for the past two years. Today I needed to push through some changes and "deactivate" the previous back end database and setup a new back end database. The new back end database has been sent; however the front end is not recognizing the back end database anymore. I need to re-link the existing front end to the back end database - I cannot import the front end into a "fresh" file because I put a password on the VBA Editor.
View 14 Replies
View Related
Feb 24, 2014
Is it possible (using the menu or VBA code) to find out the size of the objects in an Access database file?For example if the .accdb file is 300Mb, is there any way of comparing the size of the numerous tables/forms/reports/queries etc, that make up the database?(I know that if I created a new access file and imported the objects from the working database that could give an indication but that would be quite a repetitive process).
View 4 Replies
View Related
Aug 26, 2012
Attachment File Name as it appears in email attachment box
{F54EBDF9-B9B6-4EA1-B56D35DEC50D0F69}.dat (257KB)
When you select open it does retreive the file in PDF.However, our customers are not very likely to open it because of its File Name.I do send the document to PDF file 1st.I am a carpenter by trade just trying to make my business more easier to run from the office and keeping up with the times.I receive emails from Vendors all the time,I am an avid user of Access since 2000, I barely understand VBA code and often copy from samples and/or researched code.
Here is my Code:
Private Sub Command198_Click()
Dim strToEmailAddress As String
[code]...
View 1 Replies
View Related
Nov 24, 2012
Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..
View 1 Replies
View Related
Apr 3, 2014
when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want.
View 2 Replies
View Related
Jan 25, 2013
I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?
View 8 Replies
View Related
Jun 10, 2013
I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the users cannot access the DB or Code.
View 2 Replies
View Related
Dec 20, 2012
Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.
(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).
View 3 Replies
View Related
Oct 21, 2013
How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.
The use of file is only in desktop.
View 3 Replies
View Related
Oct 19, 2014
I want to deploy an access database at a small office with 5 computers, small network. However I do not intend to create a server in order to have a domain etc. Operating system is win 8.1 pro. Should I use a homegroup or workgroup ? Would it require password in case of workgroup? Which is a recommended way to setup this and keep some security like a guest cant access these files?
View 14 Replies
View Related
Feb 25, 2015
I have an existing Access Database which has a lot data, new records get added every day and a few are modified as well.
I need to write a script/query/exe which will get modified records(since last execution of same script etc.) from Access and export them to a CSV file.
My problem is getting those modified records.. Is there any default timestamp field in Access which can be used? Or do I have to add a new timestamp column for every table?
View 1 Replies
View Related
Dec 9, 2012
I'm having difficulty getting my import to work... when i call on the original XML file I get too many tables... when i call on the XML file using the transform function of Access with the XSL file it gives me only two tables "body" and "tr". Body contains the value "Weather" and tr contains the value "Day".
Import the day as month/day/year into a field "Day" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the high section into the field "High" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the low section into the field "Low" in access table "WeatherSFCAL"
View 3 Replies
View Related
Apr 7, 2015
I am trying to import a non-delimited text file into access, but where there is a strict hierarchy to the records, i.e.
NAME:
AGE:
DOB:
etc. etc.
The field names are constant throughout the document but the pages are of variable length depending on what is in the fields.
View 1 Replies
View Related
Aug 13, 2013
How can I run an Access 2003 file automatically, after double click the Access 2003 Icon?
View 2 Replies
View Related
May 1, 2015
When exporting a table from Access as a text file, it keeps adding .00 to the end of the number format records that I am tying to export.
Why it is doing that and what I need to do to prevent that from happening?
View 3 Replies
View Related
Jun 3, 2013
Is it possible to play any kind of sound file from Access?
View 1 Replies
View Related
Apr 3, 2014
I am having difficulty importing a large txt file into my database, due to the first column containing a * prefix. normally i would just go through the document and delete it, but this file is quite large at over 100k records.
Is there anyway of importing this file in access 2010 and telling access to ignore the first column?
View 3 Replies
View Related
Jan 31, 2013
how to create file explorer like functionality in ms access.
1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory
I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----
The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.
View 5 Replies
View Related