DB Design Up Front

Sep 20, 2006

I am trying to create a Preventive Maintenance Program for my facility,

I will create maintenance tasks:
[ID],[Dept.],[Machine],[Task],[Frequency],[Completed Date],[Due Date]

Simple tasks,

Up front design help,

I will want the task to stay in the task table and the Due Date to be calculated combining the [completed date] & [Frequency]

Simple not a problem,

Here is my problem:
I will need to create a task history table that will contain the Task details and the Completed date each time I complete the task; therefore my thought is that i will need to send the task detail to a history table each time it is complete, so I thought Append Query; but the problem is that it appends all of the records in the task table each time you run it including the tasks that have been appended on previous query runs.

any thoughts on how to capture the task details for a specific record and send them to a history table ?

View Replies


ADVERTISEMENT

Design Changes In Ms Access 2003 Front End Db

Jan 19, 2005

We upgraded to ms access 2003. We used to be able to make design changes on just about anything in access 97 IF a user was not in the particular record/form/object. Now it seems we can't do much of anything in access 2003 unless in exclusive mode. (and we have many many users 24 hours a day) so it's even hard to import changes made off-line.

Is there anyway around this in 2003? Any other suggestions? Other than calling all users on the phone to tell them to log off (and some are logged in and not even there), can we 'boot' everyone off (although this really is not a good option for us either). This is a production database.

It would be good if we could just make quick changes as needed when we want as it was in the version 97.

Thanks

View 4 Replies View Related

Queries :: Crosstab Design Is Slow When Opening And Saving In Design Mode?

Oct 6, 2014

I have had to use my first crosstab queries.

I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.

I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.

View 6 Replies View Related

DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK

May 18, 2007

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line



Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)



Thanks
Rahul

View 1 Replies View Related

Good Design? Bad Design? Problems..

May 5, 2005

I'm going to make up names and values -- I'm interested in the structure.

Table ALPHA:

COLA DAT1 DAT2 DAT3
1 5 7 9
2 4 14 8


Table BETA:

COLA_IND DAT1 DAT2 DATN
1 a b c

Table CHARLIE:

COLA_IND DAT1 DAT2
2 d e

Table DELTA:

COLA_IND DAT1 DAT2
2 f g


Ok, the idea here is that the data in table ALPHA contains data with COLA a key such that selecting 2 would yield the data row "4, 14, 8."

Now, COLA_IND is a "COLA" key for table ALPHA (sorry, I can never remember which side is called the foreign key). So, from tables BETA, CHARLIE and DELTA, I can access any row in ALPHA based on the key "COLA_IND"

Here's the fun part. When I build my query, it wants to use an inner join on the keys from all these tables... In order words:

SELECT blah blah blah INNER JOIN blah ON (ALPHA.COLA=BETA.COLA_IND) AND (ALPHA.COLA=CHARLIE.COLA_IND) AND (ALPHA.COLA=DELTA.COLA_IND)

What I'm looking to do is expand BETA, CHARLIE and DELTA with the information from ALPHA based on the key COLA_IND. I don't think this is doing what I want.

Any comments?

Thanks in advance...

View 1 Replies View Related

Query Design.DB Design Question

Sep 10, 2007

Hey,

I've got this problem and im 95% sure its going to need a query in order to achieve this answer im looking for.

I'm creating a Software Licensing Management db and its all working lovely. However my only problem remains is the graphical representation (text box within one of the forms) of howmany licenses are/aren't(doesnt matter if this number is a +/- number) available.

In order to achieve this answer I dont think you'l need the table structure of any of my tables other than these two:

tblLicenseInformation
License_ID
LicenseDescription
NumOfLicensesPurch
SoftwareOverview_ID

tblHardwareSoftwareLicense
HSL_ID
Hardware_ID
Vender_ID
Software_ID
AppEdition_ID
AppVersion_ID
SoftwareOverview_ID
License_ID

However I would like to add a column to either of these tables named 'Availability' or something similar which will show the licenses available.

I've tried a number of Update/Append queries but all have failed. I want this Available running variable held within the table due to it not changing to much of the current db design as i baisically finished the project and they asked for it! any ideas of how to efficiently achieve this will be much appreciated!

cheers

View 3 Replies View Related

Design View Keyboard Shortcut - Expand Columns In Design View Of A Query

Jun 5, 2014

I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.

What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.

The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.

(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading

Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!

View 4 Replies View Related

Flash Front End

Oct 31, 2005

Hello i want to use as a front end as i can create better forms etc... i want the end user to enter information into a form in Flash and then it automatically updates the access back end? is there a simple way of doing this??

View 2 Replies View Related

Front End Distribution

May 16, 2006

I have read every post here on "distribution" and "deploying" the front end to the users but can't seem to get how to do it. I see many posts regarding updating the front end and using the runtime version to distribute but can't seem to understand how to initially get the database out to my users.

I have a split db and need to distribute it to about 20+ people. The back end will reside on a shared drive that is mapped the same on everyone's machine.
I also have the FE on the same drive and am currently using a batch file run from a link on our website to open it, therefore we are all using the same front end which is what I am trying to eliminate.

Can I just zip up my FE and email it to my users? Will that maintain the links to the back end when they unzip it to their desktop?

Also, I would like to get some feedback on some software I am thinking of buying for pushing out my updated databases in the future. It is called Access Frontend Loader
http://www.frontend-loader.com/

Has anyone used this before? Would appreciate any thoughts on it or any other program you may have used in the past.

Thanks

View 3 Replies View Related

Large Front End Not Much There

Jul 13, 2007

I have a split database, the front end is showing to be 20.5 megs in size but there are only 4 forms and about 6 querys. Can someone tell me how to find what is making it so large?

I did a compact and repair but it did not reduce the size??

Thanks..
Fen

View 14 Replies View Related

Back End And Front End

Oct 19, 2007

Hi friends,

I think I am having some problem with my back end and frond end files. I have a mde file that anytime I enter new data or change some things in the old clients file, it does not update on the mdb file. Anytime I need to change forms or report or any thing at all, I am suppose to copy the BE file and the MDB file to my workstatio, remove the table link, make the changes I want to make on the design mode and then import the files back to the live copy of the mdb file then make another mde file to work with. But When I copy the BE and the MDB files, I don't have the updated client list or new client just added. So as not to affect other users, I can not make changes in the MDE file and even the MDE file will not even let me make any changes in design mode. I don't know If I am making sense but any help will be appreciated

thanks

View 10 Replies View Related

Front End And Back End

Oct 27, 2007

I am having a trouble with a multiuser DB. I have split it using the Splitter Wizard and have put a copy of my FE to a second computer and relinking its tables. When I opening the bound form in computer 1, computer 2 can not open that form and sometimes computers lock and had to restart the machines. But if I open that form in computer 2 first and then the same form in computer 1 , it works fine. I have set full sharing to computer 1. I am using Access 2007 and Windows VISTA.

Both have FE, the BE is located in a shared folder with full permissions in C: in computer 1, the FE of computer 1 is in that same folder. Both computers are connected via a Cat5e Cable.

FE in computer1 table links to c:databaseBE and computer 2 links to computer1_IP_Addressc:/databaseBE


Can anyone help me please!!!

I'd appreciate it a lot

Thank you!!

View 2 Replies View Related

Thoughts On VB.Net Front End

Nov 21, 2007

I have a wonderful database I designed almost 2 years ago. Other than a few hiccups with corrupted data (http://www.access-programmers.co.uk/forums/showthread.php?t=135483), my employer is 100% satisfied with it.

I’m graduating this winter with an AS in computer programming and I would like to update the database to a VB/ADO .NET (VS 2003) front end before I leave. Being a VB developer, I have had my fair share of “quick fixes” when I could not work out a solution with VBA. VBA is the evil twin of VB lol.

Other than PHP w/ MySQL I have never used two separate entities for data management. It’s always been strictly MS Access as the database and front end.

So my question is what major differences should I expect that I took for granted with MS Access’s built in functionality? Such as subforms with master/child properties, navigation, printing reports etc. Will I have to write code for every little detail that MS Access handled for me?

What are your thoughts on using VB.NET as a front end? Did the pros out weigh any cons from your experience with this setup? Any thoughts on using Crystal Reports?

View 3 Replies View Related

Looking For A Front End For Access

Nov 28, 2007

Hello
I'm looking for a web based front end to put on my access database. Due to the way our work site is set up and the people who will be entering some of the data my boss wants it to be accessed through a web browser. Infopath wont let me enter data into an access database through a web browser and with DAPs becoming a thing of the past we dont really want to use them either. Some of the forms will be used for raw data collection while others will be used to fill out spill reports (i work in an environmental department) so we can get the information quickly. We have tried just using access to run everthing but have meet alot of resistance as most of the people who enter the data hate it. I also had someone enter half a spill report into an SQL sequence once..dont even know how he got there. That is the main reason we are looking for a web based data entry system. I dont believe my boss wants to use anything but access for the storage. So basicly we are just looking for a way for people to use a web browser to enter data into an access database. Any advice would be greatly appreciated. Thanks

View 2 Replies View Related

Relationships In Front End

Oct 28, 2004

Hello,

I have a backend database and front end mdb file with forms. I established the necessary relationships in the back end, however when I open Relationships screen in the front end - it opens empty. Do I have to establish same relationships in the front end or can I leave it as it is and still have my relationships work as defined in the front end?

Maybe someone could help.

thanks
giedrius

View 2 Replies View Related

Front End & Back End

Mar 23, 2007

Hi there, :cool:

I've one FE & BE related question here. Ok first of all I've BE in server and each user have copy of FE in local PC. But I've one problem with linked tables between FE & BE.

Is there a way that FE can programmatically create connection to BE linked tables or user is able to link those tables manually, if FE can't find/connect to linked tables in BE? Or do I just have to manually configure each users FE linked tables?

All replies are welcome and well approciated at all costs! :D

View 1 Replies View Related

Zero In Front Of Number

Sep 20, 2004

I have four columns; m_month_birth, m_day_birth, m_year_birth, m_dob

I want the format of the columns to be xx, xx, xxxx, xx/xx/xxxx

However when the month or day starts with a 0 Access seems to strip it. I tried changing the Field Size and Format to no avail. Anyone have any ideas?

I am using ASP to update the database and have made sure that is is writing to the database using the correct format.

View 6 Replies View Related

Using Access For SQL Front End

Oct 8, 2015

I want to use access 2007 as a front end for Sql Server DB. I want to create a basic input form, a search and display facility, and have some reports generated out of the application.

If this would be possible to do using Access in 20 days?

View 6 Replies View Related

Access DB With Excel Front End

May 23, 2005

i am creating a database that will house some supplier information. once designed, the db will be populated with all the data and then it will be used as a reference tool for future projects.

it was requested that an "excel front end" be used for lookup and ease of use to access the data when it is finished... i am not really sure how that works.

also, what is the best way to create contingent variables in access-- for example, if a certain value is in the database then you have a corresponding action. like if there were a field asking how many suppliers there were, and if say the number is 4, then 4 entry windows come up. a sort of if/then statement?

i hope this makes sense. thanks a whole lot

View 5 Replies View Related

Front End Table Access

Sep 7, 2005

I split my database so that users could only edit/view data through the forms but when I opened the front end the tables where still there (linked though) and I could edit and look at them. I assume this is normal so how can I prevent users from seeing the tables. Do I just set them to hidden? Thanks.

View 3 Replies View Related

Updating Front End Strategy

Sep 14, 2005

I have a DB that I just distribute a shortcut to a front end on a network location. Then when I update the front end I delete the old one and give the new one the same name as the old one, so everyone's shortcut still works, but the FE has changed.

I haven't seen anyone else do this, which makes me nervous. Can you see any potential problems with this strategy?

thanks.

View 9 Replies View Related

Using Access As A Front End To MySQL

Sep 16, 2005

I have Microsoft Access on my desktop connecting to a MySQL database at my host, using an ODBC driver. I can read the data just fine. But when I try to add another record, it won't seem to do it.

Is it possible to update a MySQL database from MS Access on my desktop?

I have just one table. Very simple. Is it to do with primary key number generation or something?

Thanks,

Jon

View 1 Replies View Related

Decompile Both Front End AND Back End?

Nov 22, 2005

Hope this isn't too silly, but I've just discovered "decompile". Instructions don't mention back ends and front ends. Do you have to run decompile on the FE and again on the BE, or is it sufficient to do it only on the FE (which has links to tables in the BE).

Cheers,
Christine

View 3 Replies View Related

Front End/Back End Issue.

Jan 26, 2006

I have a db that I have split out into a front end and a back end. The back end is on a network drive, and I have a copy of the front end on each user's computer.

The issue that I'm having is that 2 people can open the front end and 2 cannot.

When the database opens I have a form that loads on startup with a username/password combo.

On the 2 machines it works on, everything loads flawlessly, on the others they get an error message stating "\networkpathaccess.mdb" is in use

we are all using the same version of Access...

they are all using windows xp...

anyone have any ideas I can check out?

View 2 Replies View Related

Auto Front End Updater

Feb 10, 2006

I am running an Access 97 database with the backend on the server and client databases on about 2 workstations. I also have a working model of the frontend on the server that I often update. I then have to go around to each workstation and manually install the new front end from the server. I am looking for an application built in Access 97 that I can apply before the client database opens, it checks the client on the server and if a newer version is available, it copies it to the workstation. Once copied, it then proceeds to open the new front end on the workstation. Tony Towes has an excellent application on the Granite website but I cant use it because it contains a VB programme that I cannot import onto our network (security restrictions).

Grateful if someone could point me in the right direction.

View 11 Replies View Related

Accessing Database From Front End

Mar 31, 2006

Hi there

I have an application that I run in our business.

Everytime I make changes to the code I have to export all the tables from the original into the latest version of the database with the new code.

This is a pain and makes updates time consumming and prone to error.

Is the soloution to have 2 databases. One with the tables and the other with the code (forms), & reports ect

If so, how do I access tables in the 'tables' database from the 'front end' database??

Thanks in advance

OLiver

View 3 Replies View Related







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