Alot Of Help With Redesign

Mar 22, 2006

I really need some help. I am supposed to have a rough working copy of the database ready by Friday and at this rate I am not going to have it done. I have an Access database now that we enter units in and track through our manufacturing plant to shipping. We are bringing an AS400 ERP system on line in two weeks that will replace this. The problem is we lose a lot of the tracking reports that we are accustomed to.

What I have been tasked to do is redesign our Access interface to work with the AS400. One of our programmer's has taken an AS400 report and exported it to a .csv file. I am using this file to update and insert into 2 Access tables. My problem is I need to automate this. I cannot get this to work. I have the code set under Frontier update on the menu that appears. My prepare for table query is no longer working. It was working in Access 2003 but I started getting an error on the main table update so I switched back to 2000 and now it not's working at all. I get an undefined function error with MID. Also, I am not sure of the best way to set this up. Users currently have an interface with the backend being on the server and all tables are linked. The way I am setting this up the users will be updating to a local table in their interface. Is this the best way? I need the update to occur every few minutes as the users will be updating in the AS400 and then Access will retrieve this new information from the .csv file be exported every few minutes. If I can do this on the backend that would be great, but I would need some kind of job scheduler right?

One of the other problems I am having is I need Access to create WOSD (Work Order Start Date) and WODD (Work Order Due Date). This is based on the DelDate, DrStyle and Prefin. For example, if the DrStyle is RP22, the the WOSD should be 6 days before the delivery skipping weekends. I am not sure how to get Access to update this when we do the update. If the deldate changes which is will (part of the reason for the update) then I need it to recalculate the WOSD and WODD as long as the Status in the Tracking table is In Contracting, In Layout, or Ready for Production anything past that point is already being built and the WOSD is not relative.

I would greatly appreciate any help I can get. I am still learning and will be taking some classes within the next month but I need to have this ready for testing ASAP.

Thank you!!!

View Replies


ADVERTISEMENT

Help With ALOT!

Nov 17, 2005

Ok, I'm a little rusty with the Access program. But i'm trying to create a database to track documents with a login screen for users to enter their user name and password, then this would check it against a table but also enter it into the form where the user enters in all the tracking information. **this user name that is entered into the ORIGINAL FORM must not be able to be changed.**

Then I'm trying to make it so that these documents are added into a table but each time they click on "Create a New Tracking Document" it would automatically generate a new document with a number ID one higher than the previous one. Then they click "save" and it would then save all the data back into the original "documetn" table.

Could someone help me with this so I can get started on it. Because I found this forum and hope that I can learn a lot along with asking a bunch of questions, with getting answers.

Thank you,

G

View 1 Replies View Related

Tables :: Redesign A Database To Include More Complex Relationships Between 3 Variables

Feb 21, 2015

I need to redesign a database to include more complex relationships between 3 variables non of which are mutually exclusive.These are my 3 tables/fields. Each field is unique in its table.

T_Project.JobNo
T_Accession.AccessionNo
T_Reports.ReportNo

There is no clear relationship between the variables - ie they can all be 1 to 1 or 1 to many or do not have to exist at all. So I realise now (after 14 years of working with this data), that I need to have what I would think of as holding tables between the primary tables that hold combinations of the variables. Do I do this in one table that holds all 3 variables in non-repeating combinations (although this would need to allow nulls) or do I do it in 3 separate holding tables?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved