General :: How To Unify Same Tables For 3 Different 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...)
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 Replies
ADVERTISEMENT
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 3 Replies
View Related
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
Oct 5, 2014
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
View 4 Replies
View Related
Sep 10, 2012
How do I make an accdr file out of an accde file?
View 9 Replies
View Related
Sep 6, 2012
Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
View 3 Replies
View Related
Aug 28, 2012
I use a batch file to distribute the front end of a database application. Currently, everytime the user clicks the shortcut on her desktop, the batch file executes and copies the front end from a network location to user's local machine. The FE is updated like every couple of days. The users run the database more frequently.
I would like to modify the batch file so that it checks some attribute of the FE file to decide whether it needs to be updated. I can't rely on file size, since the FE includes temporary tables. I essentially need something like the "tag" property of form controls, only for files. It would be ideal if it was me who sets this property, like "version number". Except it has read without opening the file itself.
View 14 Replies
View Related
Aug 8, 2013
I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !
View 1 Replies
View Related
Apr 25, 2014
I have created a copy of an access file to make some changes to tables, forms and etc. Some of them are deleted, new ones created or the codes are changed.
Is there a way that I can apply all the changes to the original file?
View 3 Replies
View Related
Jan 10, 2013
I replied to post of Exporting to the same XLS file on 1/4, but didn't receive a reply. I need to export out from one table to Excel grouped by client ID to each worksheet. The Excel report will have approximately 15-20 worksheets. The DoCmd.Output exports each client to their own worksheet. Is it possible for this command to export one report with multiple worksheets (one for each client)? If so, will the DoCmd.Output work and how will the group by client criteria be implemented in the code?
View 3 Replies
View Related
Oct 13, 2013
I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option.
View 5 Replies
View Related
May 31, 2013
I am trying to copy a pdf file between 2 directories. I am using xCopy, When I build my copy statement based upon various parameters, it looks something like this:
xCopy C:PDF995OUTPUT*.* P:Billing1297344137.pdf /y
I might note that there is only one file in C:PDF995OUTPUT at a time. So I copy what is there, delete it and it is empty until the next usage.when it executes the statement, I get a DOS message asking whether what is being copied is a File or a Directory.How can I identify that without needing to respond to a message?
View 5 Replies
View Related
May 8, 2015
Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!
View 4 Replies
View Related
Oct 26, 2012
I have a file called CAPTURE.BUF. I am trying to convert it to text. Here is what I ahve done, but I get the message box ever time.
Public Function copyFile()
Dim SourceFile As String
Dim DestinationFile As String
SourceFile = "C:PCPICSWCAPTURE.BUF"
DestinationFile = "C:INVESTMENT_REPORTSCAPTURE.TXT"
On Error Resume Next
FileCopy SourceFile, DestinationFile
If Error > 0 Then
MsgBox "Could not copy mls file."
End If
On Error GoTo 0
End Function
View 9 Replies
View Related
Mar 6, 2013
Any way to deploy the mde with a batch file? I been looking for way other than the autofeupdater. Can't get it to work since I prefere not to involve the users. I been getting bits and pieces; but it seems like you send a bat file to the users via email and when they run the script; it appends itself to the doc and settings in the users folder??
View 6 Replies
View Related
Nov 27, 2013
I have a table with several thousand records. Each record as a path field that indicates a specific file that is associated with a given record (not just a directory, it identifies a specific file). I'm pretty sure that most of them are correct but I've seen and been cleaning up paths that have had typos in them or were otherwise not setup correctly. Is there a way that I can generate a report or a list of some sort that would tell me exactly which file paths exist and which ones don't? or even just the ones that don't.
View 4 Replies
View Related
Jul 6, 2013
how could I store files such as PDF inside MS access.
View 1 Replies
View Related
Apr 11, 2013
I am trying to do some different things and want to experiment at this time. You may think this is a C# question, but I have searched everything I can and can't find an answer. Everybody seems to understand it differently and do not give good answers. I have found that Access people are more creative, are willing to take a chance, and will understand the question.
I created a C# project. I created a database with a table in C#. Now, I would like to dump my data from Access into that table. The database is an .sdf file. If I can do this, I may use this as an Access FE BE later on.
View 1 Replies
View Related
Jan 22, 2013
Is there a way to import a PST outlook file into Access 2010 or 2013. Or is there a Plug-in needed that can do it.
View 3 Replies
View Related
Jul 28, 2014
I am trying to load a csv file by coding, which is DoCmd.TransferText acImportDelim, "", "tblTempPayments", newFilename, False. One field which I have declared as Text, some rows for the fields are numeric, some rows are text, and some are alphanumeric.of the fields being declared as Text, it is throwing an error by creating an additional table naming temp_importerrors, and having 3 fields for Error, Field and Row, so in my view it is taking the majority of the rows, thinking a data type on the majority of the data type, and others being error out.The only work around that was successful for me, is placing that relevant values wit double quotes.
View 3 Replies
View Related
Nov 8, 2012
A colleague sent me an .accdr file, and since I don't have Access, I was told to download Access Runtime. From other forums I see that I'm just supposed to be able to double-click the file to get it to open, but I cannot. The file is associated with .7s, and since I can't locate the Access Runtime program, I can't change the association.
View 1 Replies
View Related
Feb 28, 2014
I use SendObject to send automatic emails from my application. Can I attach a table or an MDB file to the email? How do I do that? Or do I attach a table and it sends it as a text file?
View 4 Replies
View Related
Jan 6, 2014
I need to import a text file into access 10, the problem is as i understand it access has a db limit of 255 columns.
The text file is delimited by | symbols. As i tried to import, it shows me to have 267 columns and all the columns are unique and needs to be used for my work.
View 1 Replies
View Related
Oct 19, 2012
I have a database with extension .accdb. When I open it, everything is locked. I can't access VB Editor, Navigation Pane, Ribbon, nothing. It just opens a form and the only thing that can be edited are the text boxes on the form. I can't use Shift when opening it, that does nothing. It does not prompt for a password when opening.
View 13 Replies
View Related
Aug 14, 2013
I created a simple macro using the Export with Formatting action to export a table from access to excel. The dates in the excel file are not in the original format of the dates in the access file.How can I save the date and other formats when I export an access table to excel ?
View 1 Replies
View Related
Nov 30, 2013
I have imported some data from a csv file that is generated by a machine. The problem is this the first row of data is the time date stamp and the second, third, forth.... is the live data at that time and date:
So Something like this:
Time;Date;Data1;Data2;
10:00;30/11/2013;
; ;2000.00;3000.00
; ;2100.00;3100.00
What I would like to end up with is this:
Time;Date;Data1;Data2;
10:00;30/11/2013;
10:00;30/11/2013;2000.00;3000.00
10:00;30/11/2013;2100.00;3100.00
As there are some 10,000 records I would like to automate this and have dabbled with update queries and I am not getting far. how to do this either at the import stage or inside access.
View 14 Replies
View Related