Company Database
Apr 27, 2008Hi.
if anyone has the MS Access database which includes the Employee, Project, Department, Works_on, Dependent tables, plz post here...
Thanks.
ADVERTISEMENT
Table Structure For Company Database
Oct 26, 2004Hi all,
This is a fairly simple one, but im not sure exactly how to go about it...
Lets say a Company can have many Divisions. Each Division has 1 Division Manager (CGM), and manages many Cost Centres.
Each Cost Center has 1 Cost Centre Manager (CCM) and employs many Employees.
Im thinking of 3 tables:
Divisions, Cost Centres, and Employees. And if you hadnt already guessed, CGM's and CCM's are part of the Employees Table.
What is the appropriate table structure and relationships?
Thank you in advance...
General :: How To Share Access Database On Company Intranet
Jan 14, 2015I want to consider ways of sharing an Access database within our company. This could be web-based via our intranet or done some other way.
I understand that Microsoft's preferred way of sharing via an Intranet is to use SharePoint. However, as we don't use SharePoint (we use Atlassian Confluence) the cost of that route would be prohibitive.
Any methods of sharing an Access database across, say, 20 people? Simultaneous read/write access would be required but in reality the usage will be low, so performance is not really an issue. I would like to consider web-based or other methods.
I have chosen Access 2013 simply because we use Office Professional 2013 and Access will be familiar to some developers. We could use a different product. But I would certainly prefer a tool that supports RAD design of forms.
General :: Logging Activity Of Each Employee In Company Database
Dec 11, 2013Just a question, I am developing a database for the company I work for and being new to Access, I have successfully made a login menu when the database starts up. The employee selects there name and begins data entry. Is there any way to log the activity of each employee, which records they inputted, date and time and so on?
View 3 Replies View RelatedTables :: Relinking Record Associations In Company Database
Jan 3, 2014I'm building a database for my company who refurbish computers. I'm wanting to build in functionality for if a hard drive is damaged and it has to be replaced then for us to be able to trace (based on asset and tracking numbers) what hard drive has been removed from a PC and if it has been put into stock or destroyed and if a stock drive has been put into a PC.
Any item that is brought in whether it be a PC, laptop, server or hard drive etc is given it's own unique tracking number. Same is true for any stock we buy in for refurb purposes.
I'm thinking that this will be done by having a field for the original asset number and a field for the 'current' asset I.E. the one it's been put into.
DB For Rental Company
Dec 26, 2007My company rents equipment to our customers. I am looking for a db to track our stuff. There are three possible locations of everything. Warehouse, employee trucks, and Customers. I assume that warehouse can be added to the employee table. I can set up these 2 tables and one for our equipment list, but the hardest thing I am having with is with the table for transactions(I believe it should be a table), this needs to allow batch transations, because typically more than one piece of equipment is moved at a time.
I will need a report that will show each equipment id number in a customers home from date to date (date it was placed and date it was removed), one that will show a list of all equipment locations on a given date, and one more that will show equipment that has been in a customers house for 5 days or more so I can verify that it is still there, becuase equipment typically should never be with a customer for more than 5 days.
Right now I am using excel, but its not working well. I would greatly appreciate some help! The attachment only has the info I need for the 3 tables I mentioned above that I know how to do, and my best guess at what the transaction table should look like.
See atached.
Showing Primary Key As Company Name
Sep 28, 2005how do I set up supplier name in the order table like the example in the
northwind database?
what I mean is set supplier ID so that it shows combo box with names instead of numbers.
How To Pass A Company ID Thorughout All Forms
Jul 5, 2005Hi,
I have a database that controls donations for a Charity. There is to be a sister charity added to the database and a lot of the previously created objects can be used to provide for the new Charity.
My idea was to create a "company" ID and label the categories of the donations. I could then use this company ID to identify to whom the data captured belongs.
I have used the switchboard manager to enable navigation, in this I have a ONload event procedure that requests the Company ID (1 or 2).
That's as far as I have got.
How would I get Switchboard to open each form (some being based on queries - a couple direct on the tables) and filter the data on the company ID?
If there is a better way, please enlighten me!! :)
Many thanks in advance
daz.
Pulling Most Recent Records For Each Company
Jul 10, 2007Hello All,
I've searched and searched and can't find anything but it might be because I'm not sure what to search for.
Here is what I'm trying to do. (I'm simplifying this to make it easier to discuss)
I have a table that looks like this:
Company Date Sales
1 5/5/07 $1,200.00
1 6/5/07 $4,200.00
1 7/5/07 $2,200.00
1 8/5/07 $4,300.00
2 5/5/07 $1,200.00
2 6/5/07 $4,200.00
2 7/5/07 $2,200.00
2 8/5/07 $9,200.00
2 9/5/07 $1,200.00
I need to run a query that grabs the last 3 months for each company.
So the correct output from the above table would be:
Company Date Sales
1 6/5/07 $4,200.00
1 7/5/07 $2,200.00
1 8/5/07 $4,300.00
2 7/5/07 $2,200.00
2 8/5/07 $9,200.00
2 9/5/07 $1,200.00
Any help would be appreciated. I'm sure this has been asked in the past so even if you could help me with a keyword to search for, I would be greatful.
Thanks in advance,
Randy
Company Db With Multiple Product Categories
Jul 12, 2005Hi!
I need to create a database of the info of a few hundred companies. Each company (food producers) specializes in various product categories, not just one. This is my problem/question: each company entry should then have a possibility to have as many product categories as needed. How can I do this without using "free text" fields? The website user should obviously also be able to search the db - by clicking checkboxes with the categories maybe?
(+Also: When the admin user needs to add the info of a new company (with, say, 9 product types) into the database, what kind of an SQL clause I need to INSERT INTO the db? For example if the product categories where laid out as checkboxes, and the user would just click the ones he wants.)
Queries :: Company Two Tables On Same Column?
Aug 13, 2015In query, I would like to compare two tables and get the result but I always get the round robin result.
Table1
OrderQty Company Order# 8 Oop BBS 12 abc AAA 3 abc AAA
table 2
OrderQty Company Order# 7 Oop BBS 12 abc AAA 3 abc AAA
Result I get which I don't want What I want is the last table
Order2.OrderQty Order2.Company Order# Order1.OrderQty Order1.Company 3 abc AAA 3 abc 3 abc AAA 12 abc 7 Oop BBS 8 Oop 12 abc AAA 3 abc 12 abc AAA 12 abc
The result I need. How to get this?
Order2#Company Order# Order1#OrderQty Order1#Company 3 abc AAA 3 7 Oop BBS 8 12 abc AAA 12
Code To Link From Access To Company System
Oct 21, 2004Through word of mouth I hear that you can creat a link that can go from Access and link to the personal company system. Is this true? If it is, is there a standard code to use?
View 2 Replies View RelatedQueries :: Delete Duplicate Company Names
Nov 18, 2014The charity that I volunteer at has a web site through which they receive donations.
Most of the COMPANY names that they receive through their website are JUNK.
I would like to have a system to delete duplicate company names:
A = first programmatically delete all company names that are GOOGLE and this will remove about 60% of their spam
B = next group all Duplicate Company names, which will be removed manually
Making Outbound Call Tracker For Company
Feb 10, 2012I've been asked to come up with a method of tracking outbound calls for my company. This is a new job for me and I'm aiming to impress.. but I'm a touch out of my element so I'm not trying to reinvent the wheel here.
I've found this starting point: [URL] .....
But I'm having difficulty conforming it to function the way I need it to. Basically, I want the applet to
-store the employees name
-store customer names that were called
-a checkbox for whether or not an appointment was set
-a textfield storing an appointment date/time [if applicable]
-four radiobuttons to select which area of the business the call pertains to
The employees would submit new values everyday, and ideally I would like the data to be accessible in a real time line graph.. I totally assumed this would have been done and redone before and that there would be a plethora of templates to choose from online, but for the most part my search has been fruitless and the only solid lead is the one posted above.
Setting To Allow Duplicate Company Names In A Contact Management DB
Jun 22, 2005Hi,
In a contact management DB I want to be able to record the addresses of a number of contact people and braches of the same company. In other words, a company has several branches and I want to record their different street addresses. What settings do I need to specify in the field "CompanyName" or elsewhere?
Another question is how to set a Text box, especifically "CityName," so the name of the city fill out the text box when I start typing the first letter of the city name but without using a predefined list of city names.
Thank you for your help.
Orlando
Web Hosting Company That Supports Data Access Pages
May 30, 2006Hi. Does anyone know a web hosting company that supports Data Access Pages? Thank you.
View 4 Replies View RelatedQueries :: Count Occurrences Of A Company In 3 Separate Tables?
Dec 18, 2014I am trying to count the number of times a client has engaged with our company. I have a company table, a reservation table, a rapid prototyping table and a project table. There is a one to many from the company table to each of the other 3 tables as can be seen in the attached picture.
Is there an easy way, in a single query, to list unique company names that exist in 1 or all of the 3 tables?
Run Query That Will Group All Records By Company And By Date And Provide Sum Of QTY
Jan 17, 2013I have a table (table1)that table has several columns: company / Qty / date / ERT...I want to be able to run a query that will group all the records by Company and by date and provide the sum of QTY - as well as the cumulative totals for each company and date.
My query looks like this:
amonth: MONTH CODE
Group By
assending
Field 1: Alias: Company
Group by
Ascending
Field 2: QTY
Table1
Sum
Field 3: Runtot: DSum("qty","table1","[month code]=" & [amonth] & " And [company]=" & [alias] & "")..I have the query set up - but my runtotal Dsum formula is giving me grief - specifically a #ERROR and I can't figure it out..I basically want it to look like this:
A company 15/Nov/2012 10 10
A Company 16/Nov/2012 10 20
B Company 12/Jan/2012 15 15
B Company 21/Mar/2012 5 20
How To Autofill Company Info In Employee Form By Pressing Button
Oct 6, 2005Hi there,
I am stuck for over a week now, and tried just about everything I am capable off ...
I have two forms: COMP (where I fill in fields for Company Table) and PERS (where I fill in fields for Person Table).
On the COMP-Form I have a button, named: 'Add Person/Employee to Current Company'.
The two tables (Company and Person) are linked by PK - FK (PK_CompanyID & FK_EmployedAtID).
I can't get it to work properly.
The PERS-form must be filled with the company info I filled in the form COMP, after I press the button.
But the PERS-form also must be filled out normally (not via COMP, but seperately), choosing the company in the comboboxfield 'Company Name' on the PERS-form. Do you stick with me?
So I want to start the PERS-form with the filled in company Info by pressing the button.
And I want to be able to start the Form seperately (which I can off course) and choose the company myself , by selecting the right company in the combobox.
I have a attachment sent with this.
Can someone look at this for me, and explain what I am doing wrong.
I tried to do it with a autofill macro, and with some code ...
I just don't seem to get it right.
Thanx in advance for all the help,
Quinten
Tables :: Keeping Track Of Invoice Backlogs For Different Locations Within A Company
Feb 21, 2014I am trying to make a database that will keep track of invoice backlogs for different locations within a company.
Each day a report file is imported into an Access database (2010), and a query will display all locations with the backlog count of invoices for each of them. Something like:
Code:
Location Backlog
00001 84
00002 53
00003 26
Now I would like to be able to store historical data in a new table on a daily basis so that it will be possible to see how the backlogs have fluctuated over time for a given location, but I am not sure how I could do this. I was thinking I could make a table with one row for every date and one column for every location, but then I am not sure how I would populate this table based on the query that shows the results based on the most recently imported report file.
Linking Records Between Multiple Lists - Client And Products For Finance Company?
Oct 8, 2012I am trying to put together a database that tracks individual clients and what products they selected for a finance company. I have setup the CLIENTS list but because each client will have different (and multiple) services I wanted to add the SERVICES list as a separate item and then link each product to the individuals that each record relates to. There may also be two clients on the one product so again it would be ideal if the product (i.e a Home Loan product) was setup in the SERVICES list, and then I could link One or Two clients to that individual mortgage record using their data which is stored in the CLIENTS list.
View 2 Replies View RelatedModules & VBA :: Transfer Company Name From One Form To Another Form
Jan 17, 2014i have a customer form and on the form i got a button to add equipment which opens another form, my question is how can i get the same company name from the customer form to be in the equipment form once i press the button?
i have done this so far
docmd.openform "EquipmentF",,,(not sure what to put here....i've tried "company = '" & company & "'" but this just seems to open the first company)
Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?
Sep 7, 2011I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Forms Count Of Other Database Without Opening That Database Physically
Oct 7, 2005Hello All...
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
Thanks in advance..!!
Modules & VBA :: Open Database / Run A Query / Close Database
Aug 22, 2014i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedGeneral :: Updating From Local Database To Central Database
Sep 12, 2012Database: Access 2007
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
What is the best way to do this?