I am creating a database that will need to track contractors to projects and subcontractors to parent contractor and project. I would like to make it possible to have unlimited tiers of subs on a project and track the "tree" or "orgchart" if you will. The main purpose of the database is to track labor compliance violations to resolution. The violation parts are easy. How do I set up my tables so that I can have unlimited tier levels of subs. I will need a report that generates a form letter to the violating (sub)contractor and then CC that letter to each of the contractors up the chain. Thanks in advance. Rich
Hello... I have a form I created use MS Access... and near every aspect of the form is just the way the company wants it.
However, my boss would like it to calculate certain values... which in spite of my greatest efforts to decipher the more in-depth aspects of MS Access I am unable to do it.
I also designed it to print on legal form paper 8.5 by 14. And it prints out 3 pages. Although there is nothing but a 1/2 inch line in the middle of the 2 pages.
My boss just gave me the authorization to pay for some help.
I personally would like to pay someone to SHOW me how to do it... rather than to do it for me.
I would be willing to email the form to show you if you're serious and able to help me.
I’ll do the best I can to explain what I would like my program to do, maybe you can give me a little bit more guidance.
Alright – I have a database with the following 3 tables
Assets – Asset ID (PK) Inventory – no PK Preventative Maintenance – no PK
I created corresponding forms for each table, each with the same name.
Here is what I can do as of now:
Assets form - I am able to enter the asset #, description, serial #, hours between PM (preventative maintenance), and starting hours (same as an odometer) which I have set to 0.
Inventory form – Able to enter Part#, Asset ID (this allows the user to distinguish which asset this part was made for), Part Type, Part Description, Vendor, Location, Quantity, Individual Price, Total Price, Tax (Of the currency fields I just mentioned, I have it setup calculate the Total Price by multiplying the quantity * individual price. I also set it up to calculate 7% sales tax within the form)
Preventative Maintenance – The first field is PM# (auto number), Asset ID (distinguish which asset is being worked on), Date Checked In, Time In, Time Out, Current Hours, PM Performed, Part #, Quantity Used.
Well hopefully I haven’t just thrown a lot of information your way. So now that I have given you what my project can do, let me try and explain what I want it to do. And please keep in mind that I have been trying every which way I can to create the proper relationships, or foreign and primary keys, but that concept still passes by me at times.
I want to be able to know that if I have 10 tires for asset 1500, and I perform a PM on Asset 1500 and use 2 tires, that I will have 8 remaining. Maybe I just am missing the simple solution here, but I have been trying for days. Also, that value 8 should be the new on hand value within the inventory. I need it to update.
If I have 10 tires with part # TIR1500, and then I receive 2 more a few days later, how can I get the quantities to correspond? It seems as though I was able to work this out through queries to get the correct info, but due to the relationships I tried setting up, when I got to the PM and the quantity used, it threw my totals off.
I'm working on a database that is quite large. I foreign key that connect all the table is project_id. When I start a new project there a certain table that will not be used for quite some time. I would like them updated when I start the project with the same autonumber that is created for the project table.
There is an input section to add to the project and a view section to navigate through to view all sections of the project ir budget, financing, schedule. The navigate function wont work properly unless I have all project_id's updated.
1)Projects table: - Project ID - Number field (Primary Key) - Project Name - Location - (other fields)
2)Working details: (this table has a form based on it and it's used to enter data by users) - Project ID (this field has a lookup for the same field in the first table) - Project Name (this field has a lookup for the same field in the first table) - (other fields)
My problem is : in the second table, Project Name field has "Number" data type because the relationship between the table is on the Project ID which is number field. I want the Project Name to be "text" data type in the second table.
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
I have a master list of projects, with project reference number, project name, and nature of project.
I have also got a form for individuals to fill in details of project events, with date, time, name, and two or three other fields - also included are project reference and name. I'd like the name field to be auto filled when the user selects the project reference from a combo box; I think? (the list only shows open projects).
I'd did something similar some years ago in Access 2003 (I think) but cannot figure it out in the version I'm currently using 2010.
Hi guys. Back on the development trail having enjoyed a long break after the birth of my son :)
How quick one forgets!!
Project: My father-in-law would like me to develop a DB for his new company. They buy and sell plant hire (all done the old fashioned way, on paper).
His requirements are a little beyond anything I have attempted in the past so was hoping for some sound advice.
He would like to be able to record both Sales and Purchases. I have never worked with Stock before. What is the best method, any examples (did a search on stock prior to posting). He would also like to have VAT as an option (this stumped me on my last project!!).
Hi People, great forum here and i've learned loads in a few hours ive found it :D
im just wanting a bit of information or some pointers as i cant seem to find anything on the forums about it, first off i have a DB (access) with a list of employees in i have variuos reports and other tables etc, what i want to be able to do is get access to work along side Word, -
i need each employee to fill out variuos forms that come in word format , i want to know if A, is it possible to auto fill a word document out with variuos information from the DB, as im pretty new to access and have no working knowledge of VB then im stumped - then B, i want to be able to save this in a folder on a network drive and have access to the form etc or scanned form etc for each employee.
any help would be great on this as my brain is havin an overload and i only have a certain time cale for the project
thanks in advance to anybody who can show me any pointers
this Project about computer company , the Boss of this company want from me to make database help him to know :-
Customer's Information. what the customer's invoce , pay , remain. Supplier's Information. money come , money go.
that's not all , but it's the main points , I just want the any project similar to my project....... or at least , sites have examples for what I want.
NOTE : I attached Company.zip that contain Company.mdb and Company.accdb (they are the same) that what I made until now.
Hey guys, new here and I need a little help with a project my boss wants me to complete.
Basically right now, he has a huge directory of quote sheets that he fills out whenever he wants to generate a quote for a customer (they are excel files, i've attached a picture of one). He wants me to create something that will scan through this directory file by file and extract certain pieces of information from each excel file, and put them into a database. The company I work for isn't too big, so i'm going to use access as the database.
I've also suggested building a new quote sheet in VB, and programming it so everytime the form is closed, the certain pieces of information he wants will be saved into the database. So I guess after this we can forget about Excel. But also, he wants to be able to bring up the entire quote sheet again if need be.
If you guys could please help me out, what would be the best way of going about doing this? Am I heading in the right direction as far as my thinking goes?
hi every one, how r u all i really need your help i asked my friend and he told me about u guys my problem is : i want to create a database for entering student marks ^^ but i don't know much in access so could u plz help me i want to u make the Relations so that i can make any form to enter the data i made the relationships but there is problem " i can't enter marks for new student "
Please help i have to submit it this Saturday
i will appreciate for u guys if u make as soon as possible
Hi, I have a project about creating a data base of Foreign Trade, where I have to choose the country, then to determine the period (years). so, could you please tell me how: 1- to link a combo box with a query (comob box of list of countries) 2- to link 2 combo boxes with a query of starting date and ending date (the criteria is: >=[start date]and<=[end date] ).....should I separate this criteria and put it in to 2 columns of same data (years)...I tried it but it didn't work. 3- to link a Run Query command button with conditions mentiond above. When I established the command button, it showed the whole data base, so how can I link it with 2 conditions above. Waiting your appreciated replies a.s.a.p.
I am new to this forum and to Access. I have expierience with visual basic.
I am making a program in access for saving data when someone borrows something from you, to keep track of all your borrowed stuff.
Here are my questions.
1) How can I write code for buttons to change the records (movenext, movelast,...) + how can I change the current record? + how can I control a scrollbar via code?
2) How can I change the current recordsource via code and how can I run previously made query statements via code?
3) How can I change the ShowDropButtonWhen property from a combobox via code?
4) How can I control a FlexGrid via code?
5) How can I open another Form with a press on a button via code?
6) How can I save and load an OLE/object image and how can I show them via an ActiveX control?
Thats about it folks
If anyone can point me in the right direction or can give me an example database, I would be very happy:)
Ok first off thank you for anyone who even reads this.
Iv been assigned a project in using Access 2003 and only Access 2003. Im stuck and getting frustrated and was wondering if anyone would mind helping me.
What my Prof wants is a Access database with a form to do the following
Ok he wants us to input 1 of each category as if we were ordering
then he wants us to order it and print out a Recipte with the following info.
Sub total Tax Total Purchase How many Calories the entire order is.
Im attaching a .mdb file with what i have come up with but im not sure if its even going in the right direction. I would forever be in debt if someone would help me.
rename the wendys.txt in the zip file too wendys.mdb
Ok, well basically i am trying to write my own database. and i have not the a very good working knowlage of access and some many bits that are over my head, Would any of you guys be willing to help me out with this? I would be willing to pay someone to do this, if you could give me prices per hour ether here if permited. or via Private Message. for comunication purposes i could use skype or msn messanger. as there will probably be some bits i would need to explain. I am a little bit of a perfectionist so i would try and explain as clearly as i can as to what i want. there is no desparate rush on this project altho july would be great, one of my friends was meant to be helping do this as he is good with access but i have been waiting for him to do this for about 6 months.
Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes; Microsoft Access You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded.
can someone point me in the right direction. I think I've been down this road before but forget the correct path:confused:
I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
I am a total NOOB when it comes to access....i am currently taking an access class at my college and its time for our first project. I really need help getting started cuz alot of the terminology is so new to me... I have been provided with a sheet of information and have to create a DB based on said information.
if anyone out there is feeling super generous with their time and is willing to help me through it...just to get me started..my aim is NIPPONLIFE86.ive found that its getting everything going that is the hardest...especially when im creating a database not just inputing data.:confused:
Does Access database support muliple users on the same data update, if so how many. What will be the best way to avoid locking up a field when somebody else is trying to update a different field within the system. It run on server:
I have extensively searched the forum to try and find an answer.
Im trying to develop a Project tracker database which will track the progress of my ongoing projects, does anyone out there have an example or another link to get me started.
I know MS Project would be the answer but we do not ned it in as much detail as this and they definately want it written in MS Access.
Have been asked to "update" an archaic database for a consultancy firm. The existing database is approx 20+ years old and appears to use .DBF files for storing the records.
Now, the DB itself I can do, but I've normally only written DB's for one or two users. So before even considering doing this work, I would be greatful for any advice on the following.
They use a central server linked to 8 user pc's. I assume I will therefore need a FE/BE database. Would it be useful to determine what version of MS Server Client they're using?
Using Standard Access 2000 or above, (i've still to confirm what version they require it written in) can a FE/BE database be created, that will be useable (speed / reliability etc)?, I'm told that they will have ~4 users using the system at any one time. Do I need to consider using SQL Server (and if so what level / version)?
From initial emails, the 4 main .dbf files are 50Mb each. I seem to recall that without using SQL Server, once a standard Access Database starts to exceed 200Mb it starts to cause operational issues. Is this correct?
Lastly, if anyone can point me to a good book / website that discusses the standard coding changes that need to be made when establishing connections etc in VBA for multiple user databases I would be extremely grateful.
I am responsible for creating a database for a school project, and am having some problems relating the two tables of the database together. Please keep in mind that I have no prior Access experience, and know very little about the program. Here is my situation, any help would be greatly appreciated:
Taking the perspective of a product vendor in a store (i.e. selling soda to a grocery store), I am trying to create a database which allows me to run a query for authorized products in certain stores. I have a products table which has all available products the company sells, and then I have a Stores Table for the different stores which carry the company's product. I want to know how to set up and join each table so that if a certain product is not authorized in a certain store, it will not show up in a query.
Again sorry for the shallow description, any help would be greatly appreciated.
