Right at the moment i'm baisically designing and building a software licensing management system fro my boss at the moment but I have had a snag, the face that its 3pm on a friday is not helping with my concentration either.
Ok so my problem is that i've got 3 tables (tblUser_Informantion, tblSoftware_Information & tblHardware_Information) all of which are related via a 4th table (tblReference) which holds the primary keys of each of the other 3 tables mentioned.
For all intents and purpose's the primary keys are named according to their tables i.e. (User_ID, Software_ID, Hardware_ID, Reference_ID etc...)
On my main form a User can select via a cmbo-box or search for a Person via Surname or search via Machine Asset number. Upon selection this fills a number of pre determinate box's below that containing you typical standard information. However under this is a subform showing what software the user has installed on the machine and on an alternate tab it shows the software license's purchased and assigned to that machine. So far so good.
However I want to create a button in which the user can add software for that particular person in the fields. The user will select the software from a listbox filtered by combo boxes filtering by Software Vendor etc... My problem is that when the user has selected this software title either via double click or an update button i want it to update the tblReference table. So baisically i need this button to grab the User_ID, Software_ID and Hardware_ID and place it in the tblReference table as a new record.
Hopefully i have explained this well enough for people to understand below is a jpg of my current main screen so you can hopefully get a jist of what im trying to say and do. However im open to suggestions if people feel they know a much better way of achieving my goal.. as i sed its friday afternoon and im feeling particulary slow so you'll have to forgive me!
I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare the queries/results to see where the problem was and have found that the changes have automatically updated in the production version. Can anyone explain this? They shouldnt be linked at all. The 2 versions both link to a datawarehouse through an ODBC link, but shouldn't be linking to each other (I'm using Access 2003).
On occasion my access database all of a sudden begins to operate very slowly, I notice the queries take a much longer time to run.
Last week it suddenly began to operate very slowly after idling in excess of 30 mins
Today when I change the screen to design view and then back to form view once again it begins to operate very slowly. (yesterday was working fine on my desktop at home, I have not made any changes to the database with exception to saving and using the file this morning on the shared drive at work) If I shut down and re open it operates well but once again changing to design view causes the same issue. Sometimes compact and repair rectifies sometimes not.
I am planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as i will refer to them as.
Now, would it be possible for me to have a table set up for each location? Will access object to having 400 tables in my data base?? Is there a limit?
I have a split database made in Access 2007. Each user gets their own copy of the frontend from a script. I wanted to be able to edit the design view of the backend tables even if people were using the database so I made all the forms use snapshot source and only allowed data updates through VBA macro update queries. Having any form open locks the backend source table from being edited. In fact, I've found that just having a normal snapshot query open causes the message "Either an object bound to table 'whatever' is open or another user has the table open. Do you want to open the table as read-only?"
Is there some way to have a table be the source for a form or query, but still have it designable under most circumstances?
Attempted to late-bind a recordset on form load; result was the same:
Code: Set rs = CurrentDb.OpenRecordset("Select redacted as ft from tblRedacted ", dbOpenSnapshot, dbReadOnly) Set Me.Recordset = rs Set rs = Nothing
I'm after a bit of advice.... Have developed a booking system for a client, Access 2003 adp front end with SQL Server 2000 backend, they want to offer search and view facilities on their intranet and possibly on the internet. Very broad but Simple question, whats the best way to do it ?:eek: having never done any web development....
It will purely be a couple of combo boxes populated from the SQL server for selection, followed by the display of the results, possibly with an email button.
At a loss as to where I should start, can I do anything in Access or possibly ASP.NET or something else ????
Apologies if this is in the wrong thread, and many thanks in advance for any responses,
Hello everyone. Im relatively new to access, i've only been using it for a few weeks. There are certain aspects that I cannot get my head around.
Is anyone willing to let me email them what I have done so far and the criteria for the database I am making and advise me where I am going wrong and where I need to be heading to get it right?
Thanks very much. Any help will be very much appreciated.
When creating a database is it true that ideally i should avoid using the lookup wizard at table level and instead do that with combo boxes at form level ?
1 tblAssistFMWork in which is stored the fields JobNumber, SiteRefNumber, SurveyorNo 2 tbltable1 which has the field SiteRefNumber, Address1, Address2 etc 3 tblAssistFMSubJobNumbers which has the fields JobNumber, SubJobNumber.
JobNumber is the relationship between tables 2 and 3 and SiteRefNumber is the relationship between tables 1 and 2. There are other fields in each table but these are the relevant ones for this question.
Each JobNumber will have a minimum of one SubJobNumber but may have many. Each SubjobNumber starts at 1 for each new job so this may look like this in the table
JobNumber SubjobNumber 0001 1 0002 1 0002 2 etc Each SiteRefNumber may have one or many JobNumbers
I wish to enter the date a SubJobNumber is completed and have been struggling with pulling the record into a form using a combo box because of the need to enter the JobNumber and also the SubJobNumber. So I decided to create a new table tblAssistFMJobDateCompleted which has the fields
JobNumber, SubJobNumber, DateJobCompleted
I need to report on a jobs status ie done or not done, but when I created the query for this it would only pull the records which have a completed date on them. Could someone please give me some advice as to a way forward.
I have been reading other posts, and this where i should have started from the beginning,I am not very experienced with access (or forums as yous propably know) but can learn anything in no time (hopefully).
I would like to design a database to store all the info about a drag racing event including;
• event info (Event name, track name, event date) • car info (Car name, gearbox type, diff ratio, engine name,) • driver info (driver firstname, driver lastname) • Engine info (make, model, engine compression, carburetor, front carburetor jets, rear carburetor jets, fuel pressure, engine timing at idle, total engine timing) • Race info (track temperature, relative altitude, milibars, humidity, air temperature, tyre type, tyre size, tyre pressure hot, tyre pressure cold, stage RPM, shift RPM, reaction, 60foot time, 330foot time, 660foot time, 660foot MPH, 1000foot time, elapsed time, elapsed MPH, comments.)
My issue is design of tables and relationships. as you can probably see, obviously cars will do many runs at each event, and there engine setups and car setups(diff ratio) can differ each run. there might also be different drivers for the same car. weather info like track temp etc also change from race to race so I think it is possible I might need some sort of race time as-well. My main reason for the database, apart from organizing all my results would be so that I could do a run at an event and search previous races by the current runs weather info (relative altitude, milibars, humidity, etc) as to set the car up similar to keep it’s elapsed times consistent. Please, please, please help as I am at a total loss. Thanks in advance!!
I've created a database from scratch. No data attached anywhere yet - I'm planning to input the data manually through my Form.
Well I have about 15 tables - CustomerInfo_tbl is the main table with the field RefNumber my primary key (it's an Autonumber which is sequentual). The rest of the tables are normal tables which I plan to link.(these tables also have RefNumber fields which are LongInteger) All the tables have about 10 fields in them.
So then I have 2 choices - I can make one big table (about 150 fields) or 15 tables with 10 fields each and the join them. I heard somewhere that it's better to have small tables and then link them up. So I'm going the smaller tables route.
I'll tell you what I did. I joined all the tables to my CustomerInfo_tbl with a one-to-one join. Then I made a Query, and then I set the RefNumber of the other tables equal to the RefNumber of my CustomerInfo_tbl.
I have 1 problem. When I enter some data into the form (I do not enter all the fields I leave some blank) it isn't displayed in the query, but it is displayed in the appropriate table. Only when I enter all the fields it is displayed in the query correctly and also in the tables.
Hi, i got back to working on databases again for the first time in years and ive got confused on the offset.I went to set about desigining my tables and cant figure out how to do it.most of its simple stuff however this one bit stumps me.
Im designing a database to hold stock information in work we manufacture parts for rally cars and when a customer rings up i need to have the price at hand.I can store the prices etc of individual parts,however some people request kits which would have there own stock number and all the same relevant data i.e. Item Name,Type,Cost,Number in stock,Selling Price.......
These kits would consist of several items from the stock table.and when a kit is sold it will be inserted into the Sold Items Table together with the other individual parts a Customer may order.
I have a new project but before I get started, I need some advice on design.
I'm designing a student report card which I'll implement for 1300 students next year. The concept is an ongoing electronic markbook where teachers update the progress of each student and then at the end of the year print a report based on the captured data. The data is then passed on to the next teacher the following year.
My problem is data storage. During the course of a year a teacher may mark off up to 550 things a student can do. After 7 years of schooling (7 x 550) this amounts to a large amount of data. The thing is, I could reduce the number of fields if the multiselect list box stored multiple pieces of data. Option groups are no good because only one piece of data is stored and I certainly don't want thousands of check boxes.
Basically, I'm looking for a way to store multiple pieces of data in the one field. I'm also looking for a way in reducing the amount of clicks (i.e. one click instead of 2 to enter data)
I can't delete data because it's an audit requirement to keep it.
Can someone help me out with the design of my database? I currently have it set up one way and I am running into problems when I need to update information?
here are the attributes I have to put in the database for Printer cartridges:
ProductName Manufacturer Category ProductCode Price Weight Description -------------- There can be numerous products with the same name (for example: C120 is a product name but can be made by HP and by Canon)
There can be numerous products with the same ProductCode (for example: F416301700 is a product code but can have multiple products with that code)
Currently I have it set up like this: 3 Tables -------- PRODUCTS ID PRODUCTNAME MANUFACTURER CATEGORY
DETAILS ID PRODUCTCODE PRICE WEIGHT DESCRIPTION
COMBINE ID DETAILS$ID PRODUCTS$ID
----------------- I have created that combine table to link the two other tables together. I am running into problems now when i want to update a product and I don't know where to take this from here. I think if I have a better design from the get go it will prevent problems in the long run. Can anyone help me with this? Thanks dp3133
Hi, I’m fairly new to access and I’m creating (well, want to create) an employee database. I was wondering if anybody has created an employee database that keeps track of employees information like; personal information, salary, training the employees have taken, performance reviews and much more and if so do you have any suggestions on the design. Pretty much this database will be an electronic version of the employees personnel file.
Or does anybody know of any sample databases, not necessary an employee database that have been shared here in the past that I could look at and get ideas (formulas, qrys, tbls. etc.) from there.
I am designing a db for my car event that happens once a year.
It needs to hold car info like engine specs, car specs. Entrant details and event details, merchandise info. I started out designing on paper (Can’t stress how much this helped a definite must for all noobs and experienced I would imagine) and went from there.
Ended up using northwind and modified it to suit my situation.definately recommend this to beginners as it gives you a good look at databases and great starting point. anyway this db has everything I need I think, the db is for holding info about participants in a car event. There is a form that the entrant would fill out asking there details and the car details. There is also a section on the form to buy merchandise as the car event has its own T-Shirt and DVD.I have added this into the database but I am having trouble finding where to put the T-Shirt Sizes.
E.g. there has been 3 events so far (1 per year), car event 1, car event 2, car event 3.each event has had a T-shirt. this t-shirt comes in sizes, xxs,xs,s,m,l,xl,xxl,xxxl,xxxxl,xxxxxl.my problem is do you add the same t-shirt in the products table 10 times just with different sizes.
also the Entrants form has subform event, where you select the event each year as to not have to enter entrants twice.i can not seem to figure this out either.
Once you look at the db you will have a better idea.
The database only has a very standard form for getting around while I complete the design, all the beautification will come after this stage.
Any other ideas would be greatly appreciated.
Thanks (PLEASE COPY AND PASTE THE LINK INTO YOUR BROWSER OR IT WILL NOT WORK DUE TO REMOTE LOADING)
Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication
Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered.
whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that I can't afford not to but hopefully after a couple of biggies like this it will be possible.
Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get my updates made on time.
I am looking for some advice on how to go about solving a problem.
I created a database 1 primary table with 1 other table, linked in a form with a 1 to many relationship.
The PK is auto assigned for both tables.
I want to have say three different companies use the same database but with some kind of unique ID for each company so when I bring all of the data together into one database it will all merge but be sortable by the company that created the data.
As some of you will note I thought that defining the PK for each record was the way to go but it seems that this is not going to work.
I doing a db that is supposed to show the development plan of some persons.
2 tables: graduates departments
in the graduates table there are among other data about the graduates, four fields for their departments in the next year.
i have called them: rotation 1 rotation 2 rotation 3 rotation 4
these rotations should be choosed from the departments table, so i have created a lookup dropdown list in these fields.
now i want to show a query that shows a list of all the departments with the linked graduates. something like this:
Rot 1: Rot 2: Rot 3: Rot 4: dep 1: Ben John - James dep 2: James Ben John - dep 3: - - James - dep 4: John - Ben - dep 5: - - - John dep 6: - James - Ben
'-' = meaning empty field (onley for illustration in this forum)
My question is how i set up the links between the tables to create a query that show this.
I am combining 12 Databases. I have split all 12 between the server and the desktop. My question is “Should I combing all of the data table on the server into one database or should I leave all of the individual application data tables in separate Databases on the server”. Additionally, is there a limit to the number of tables an Access DB can handle? My inclination is to keep the functionality separated but the problem I have is that some of the functionality within the applications overlap. Recommendations!
I have sort of problem - I'm trying to desing the database for one of the organisations. The entities are: Family, Child, Referral, Voucher, Receipt, Provider, Activity.
That's ok so far. I've been asked to do the option for the new address of the Child - in case if they move to the new place and keep the old one as well.
Family table is the 'child table type' for the Child table - family can have more than one child, but one child can be part of only one family (one to many relationship).
I thought to make a seperate table 'tblAddress' and store all addresses in this table - then link them to the family - this however requires from me to have additional field for - for instance - second address, third address, which in case there was no change in address would remain empty value. The other option - which obviously is absolutely waste of space is to add straight away additional address fields in the 'Family' table itself.
Don't you know of any other, more appropriate solution? If you need more detail - I can send the copy of the database which I have created so far. I would appreciate any help.
I have been asked to look at setting up and access database to do the following
To keep a record of pupils and 9 tasks the pupils have to do and also the total amount of time it took a pupil to do this task They have a total of 25 Hours to do all tasks but this is spread out over the year.
What I need is someone to tell me the best table layout to do this
The pupil record has to have the following First Name Surname Form Total Hours taken for all 9 Objectives A description of what the pupil did to achive each Objectives record if that task is complete Also Date Task was Complete
I have done a test database with just one table in it and inside that table had all of the above but apart from name, form and total hours I repeated the rest nine times. This just does not seem right
What I want is to pull up the pupil name and then select Task say from a Drop down box this would then insert a new field if it did not allready exist in pupil recored and then you can fill in the task details of course if the field/s all ready existed then to open that up to allow you to update this
It would then need to update the total Hours field in the pupil record with the hours it took to do that task/objective.
I have basic Access knowledge but i cannot think of best way to achive this can anyone help please
