I am new to these forums, and am an idiot in Access. i work for a small nonprofit and manage a project through our state Division of Rehabilitiation Services in providing Assistive Technology Services tp their clients (DORS is an agency which provides services to people with disabilities to gain meaningful employment, increase their independence or be successful in pursuing educational goals).
I have been trying to create a database to track the authorizations/clients I serve, some of them have worked but are a bit too complicated in which i am sure can be put together easier (more efficiently) and basically I am afraid to implement it as it would probably fail. Mainly a merger between a number of templates avaliable for free.
What my question is, is how much does it cost (in general) to hire someone to create the database for me. I am basically looking for a database that will be able to store client information (name, contact etc... information about their disability and their goals (employment, education etc...) who their counselor is and their contact information (multiple clients per counselor).
Now each client may have multiple authorizations (I.E. An Authorization for an Evalutation and then for training). So I need service records related to the specific authorization and then the ability to store invoices and reports related to that authorization as well. I would like it to link to a report as I create them in word and save them on a server. I would also like the ability to have the reports sent to the counselor via e-mail from the database.
Hope this makes sense, if anyone would have a generalized going price for somthing like this in terms of hiring someone to complete it that would be GREAT. Thank you,
I have inserted two combo box in the form with lookup in the table. Now I want to select values in these boxes and filter the records having those values on click of a command button placed on the form.
How can it be done without using VBA? Is it possible with use of macro?
I am new to programming. I have to design a form in access which contains basic text fields, a combobox and some datefields. I need to use this form to input data to access table and and retrieve data from access table. Can anyone help please.It is very urgent. :confused:
I have constructed a seven table database for dealing with holiday cottages.
The seven tables are:
Bookings Cottages Customers Ratings Owners Regions Sales Reps
I have created the 7 tables and created the primary keys (BookingID,CottageID,CustomerID,RatingsID,OwnersID ,RegionsID,RepID)
The ratings table because cottages come under different ratings (Family, Sporting etc..).
I need to create a form which
*Adds a new booking, and also adds the new customers details *Checks the avalibility of the cottage for the chosen week *allows the user to choose a rating from a combo box, which then filters the cottages availible for selection in that category.
If anyone could help me with this I would be very grateful, I have emailed my lecturer but he is not replying and the assignment needs to be in on the 12th!
While searching for Access help through Google, I found your forum which has greatly helped me in building my database in Access. I got all answers through your forum for many of my doubts and ‘How To’s. I thank all the members for their excellent and simple way of explaining for a novice like me.
As to the Database I built, it is almost complete and working fine. I have built a switchboard with menu choices. I have distributed this to all my colleagues and they are using fine.
I have three problems still to be addressed. I have tried to protect my database tables, forms etc through the security wizard, user permissions etc. But nothing is working. I have hidden all tables, forms etc. and unclicked the ‘Display database window’ in Startup so that only the switchboard is visible. I have also changed the switchboard properties to cover the entire screen and no maximize/minimize/close button. When a user double-clicks the desktop icon the database file opens with the switchboard menu. There is an Exit button in the switchboard which the user can click to he can click the close button of the Access window. Apart from this, the user can do nothing to corrupt the tables, forms etc., so I believed. However, one colleague clicked the ‘View – Design View’ in the Access menu bar and the Switchboard became ready for modification. Is there a method to block the View – Design View’ option in the Access menu bar?
My second problem is that we want a new database file first of January every year. Is there a method to create a new DB file with the same table, form and settings from within Switchboard? (The only option I found was to copy the DB file to another location, delete all records and rename it for the new year). Is there any other procedure?
My third problem is that I designed a Crosstab Query as given in the Help menu with criteria LIKE “*” & [Enter any character to search by: ] & “*” but when I execute the query it displays all records containing the character entered. This is not what I want. My search criteria everytime changes (it is text based). So I am unable to save Query form with a specific criteria as it will execute only defined parameters. Is there a way to make Query form where any user input (i.e. any word or number) is taken for search?
Hi, All I am designing a database to keep track of part prices and their trends, the part numbers and all their related information are stored in a "Unified Parts Database" containing all pertinent information about the parts, their vendor, current price, material, sub-material etc...Now in the new database I am making I wanted to have one table that has these field.
The tables name currently is "Main", fields are as follows:
and then I have a "Prices" table which stores the different price changes for each part number:
PriceID (PKey) PartNumber Price PriceChanged
now I what I am trying to do is have the "Main" table pull all the part numbers and their descriptions from the Unified Parts Table which is a linked table and I am not sure how to get it to fill all this stuff automatically inside a table not a form, would a "Main" Query be the correct way to go and completely skip the "Main" table??
The following code is only for testing the usage of control variable. I want to use set statement to assign the textbox object reference to the varialbe myControl.
When I clicked the button, the system always tells me 'the object reference missing'. It seems the set statement doesn't work, but I don;t know the reason. could anyone of you please spot it out for me?
Many thanks
Option Compare Database Public myControl As control Public frm As Form Set frm = Forms!Form1
Sub Command4_Click()
Set myControl = frm!Text0 myControl.SetFocus
End Sub
Sub Command5_Click() Set myControl = frm!Text2 myControl.SetFocus End Sub
Hey guys , I was wondering if you can help me with this one cos I am clueless. I am in charge of updating this website which sells stationeries, office equipments etc. Well the catalogue in our website is kinda messy since there are lot of the product items inside the catalogue page which has no images.It is embarassing for those customers who wants to buy a product but couldnt see the picture of the items. For example , http://www.mellon.com.sg/catalogue/s_searchresult.asp?searchby=category2&searchfield=laminating%20materials.
The product items are generated from the Access database where I also included a column field in the database called "Picture" where those product items with images have checked(tick) in the box and those without images are unchecked(no tick) in the box I am not sure if I should filter anything or set up any criteria for the pictures from the database. I need help as i am not a total expert in Access
I'm an audio/video technician at a college and wish to use Access for a simple camera booking system, but do not have time to go through all the extensive help menus and tutorials about this program, and none I have viewed seemed to help.
I want four columns in the table. First, the user inputs a student ID number. Now my first problem is that I want the student name to appear in the 2nd column after entering their number. I don't know where to create the list of names or how to link them to their student ID numbers.
My second problem is I would like the 4th column simply to display the date seven days from the current one (as in whenever the db is used) for the return date without having to input it manually.
Any help towards these 2 problems would be most appreciated, and thanks in advance.
I want to make an access database but Im struggling with the relations a bit. I understand the one-to-many and many-to-many concept but seems like there is more then that
I want to make a database that keeps track of things we lend.
I have several items with different properties we lend out:
eg
TANK -ID -Volume -Weight
MACHINE -ID -hours -fueltype
...
I made the following tables to keep track of it:
RENT -ID -Customer -...
One-to- many relationship between these
RENTLINE -ID -RENT_ID -Item
My problem lies with this Item. I want this Item to have a relation with the ID of the different items we lend out. there needs to be a one-to-many relation here. one rentline can exist of one TANK OR of one MACHINE. A TANK or a MACHINE can exist on many orderlines. So I made 2 one to many relationships from Rentline to the id's of Tank and Machine
the problem is that Access does not let me fill in the rentline with the id of a item. If I fill in the ID of a TANK it says a ID of a machine is needed and vice-versa.
I tried to solve it with an intermediate ITEM table that looks like this : ITEM -ID -Sort ( Tank or Machine) -ItemID (Id of the tank OR the Machine)
But this generates the same issue as directly in the rentline...
I guess this is pretty common stuff Im asking here but its confusing me like hell :(
I would like to make a human Resource database that shows in a tabbed form some informations about our employees.
I would like to show per employee: tab 1: general info (name, address, starting date, type of contract, department) tab 2: salary history tab 3: capabilities -whether they are available YES/ NO tick field and for the department the person is assigned to
I am thinking of the following tables: Employees - EmployeeID, Name, address, starting date, type of contract Department - DepartmentID, Capabilities Salary History - EmployeeID, Date, Salary, Notes EmployeeCapabilities - EmployeeID, DepartmentID, Capabilites [Yes/ No]
The only problem I have is to make the correct relations between the lot of them.
here is a link to my website http://www.justevents.biz if there is anyone who would be kind enough to look at it and tell me how to build an access database for the categories and search by zip, etc. i would be greatly appreciative. I have tried all the tutorial helps and built about 15 different databases and can't get a single one of them searchable under any circumstances. I have tried all I know to do.
I want the value to be displayed in a combo box from database , when the form_load is in action
The code is
Private Sub Form_Load() Dim s As String
Set con = New ADODB.Connection con.Open ("PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:stock.mdb") Set rec = New ADODB.Recordset rec.Open "instbl", con, adOpenDynamic, adLockOptimistic, adCmdTable While rec.EOF = False s = "select section from instbl"
I want the value to be displayed in a combo box from database , when the form_load is in action
The code is
Private Sub Form_Load() Dim s As String
Set con = New ADODB.Connection con.Open ("PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:stock.mdb") Set rec = New ADODB.Recordset rec.Open "instbl", con, adOpenDynamic, adLockOptimistic, adCmdTable While rec.EOF = False s = "select section from instbl"
I am new to Access programming. I read in some web page on googling that Access is for developing Desktop database. Books inform that Access projects can connect to Server database.
I would like to know if Access can also be use for Server side programming.
I am looking for a database that can keep up with the full management issues relating to single family houses. Some are on a lease. Some are on owner-financed by use. Any help would be great!
I am willing to pay a designer to program this database for me. Email any samples or questions to babyfacedavid@yahoo.com
i need to design a database but am abit unsure the best way to go about it and am looking for sum thoughts and suggestions.
I need to create a database for part numbers and competitior cross references, however the problem i have is were we list one number a competitior could list upto 5, and where we list 5 numbers a competitior could list one, so there could be literally thousands of duplications per competitior both ways around.
for instance we list DG897, our main competitor would list AB458, AB459, AB 487 etc. Basically the part number is a car part, and we say one part number fits serveral vechicles, but out competitior says its one part per vechicle. (sorry for the poor explaination)
has nebody came up against a database where the possibilty for duplications is so high before and how did they go bout designing the tables, I am far far from a regular user of access, however am very keen to learn.
I am quite new to access and i can grasp things quite easily.
Basically i am make a stock control data base for a food company. I am making it so theres an order table and a stock table. Basically i want to know how to change the Quantity avalible in the stock table fom the orders table.
I dont know if i have explained that very well. But basically i have related the product name in the stock table to the product name in the order table. So i can add a number so that that the quantity of the product will change on the stock table.
If there are any easier ways of doing this rather than having 2 tables it would be useful
Ive tried all types of things and i cant get it to work. Any help would be very much appriceated.
Hi, I am just about to start the implementaion of my A2 computing project, hopefully using both access and pascal to create a bar ordering and stock control system. My question is how and how easy would it be to link both the pascal side of the system and the access application so that they are sychronised? The access application would be used as a front end to my system, and a store of inforamtion where as the pascal code would be used to carry out the necessary calculations.
I know this topic has been discussed, but i could not find one thread on the general purpose of exporting an excel table/form to excel.
I would like to place a command button on my FORM, and let the user click this button and export the data into excel.
I tried using the transferspreadsheet method, but could not corrrectly, if at all get it working, and the help section within access2003 onlu covered importing into access from excel.
Please, if anyone has any links to sites/tutorials/ threads i misssed actually covering this topic/or thier own help, it would be greatly appreciated.
There are multiple employees on a table, each with a period of time for which they worked. I am trying to gather these times together to see how many complete records I have for the time period of 4/1/1999 to 12/31/2004. So, for example,
Employee 1 works from 4/1/1999 to 12/31/2000.
Employee 2 works from 1/1/2000 to 12/31/2004.
(From these two records, there will be 1 complete record of 4/1/99 to 12/31/04 AND 1 remaining record for the year 2000 left over.)
Employee 3 works from 1/1/2000 to 12/31/2004.
(From these three records, 1 complete record + 2 2000 + 1 each for the years 2000-2004.)
Employee 4 works from 1/1/2001 to 12/31/2003.
(= 1 complete + 2 2000 + 2 2001-2003 + 1 2004)
Employee 5 works from 4/1/1999 to 12/31/1999
(= 2 complete + 1 2000 + 1 2001-2003)
And this goes on for all the employees. I need to find out the end amount of how many complete records and remaining dates all the employees have worked. I hope this was at least, somewhat clear. I remember doing something similar to this ages ago in programming class, but since then, my mind has degraded. =P Any help, insights, or advice would be greatly appreciated on how to get this done. =)
I'm kinda lost in here so I'd appreciate some help in pointing me in the right direction please. I've no doubt the answers are out there but I'm having trouble finding what I need, probably because I don't know how to frame my questions!
Basically the story is this - there are three guys covering various aspects of the business, they each visit three separate locations - all guys visit all locations. We have made a "big plan" that has 14 key deliverables in the locations as a "region" .
For each Key Deliverable there will be Actions, some Actions will be done in all locations, some might only be needed in one location. Each owner will describe the Action and link it to the Key Deliverable it supports.
What we want to do are things like Take Location 1 and Guy A and show all the things he is doing to support Key Deliverable X.
or
Show all the Actions in Location 2 that are being done to deliver Key Deliverable Y by all Guys.
That sort of thing - progress reporting and identifying where we have nothing happening to support a Key Deliverable or too many actions in one Location etc
We have all our plans in Excel spreadsheets at the moment, each guy fills in a sheet and at present the idea is that we copy and paste it into the mother of all spreadsheets to present to the Gods - it's not happened yet because it's clumsy and well, it's my job to present it and I thought "there's gotta be a better way!" I can import the sheets into Access but then it all gets a little tricky and I run out of tallent.
OK so if you've read this far you're wondering if I have any idea what I'm talking about when it comes to Access! Well I am pretty much self taught and rusty but I can see that Access could help us get organised and
My limitations - I'm using standard Access 2007, I doubt corportate IT security would allow me to add in any useful plug ins or upgrades etc.
Am I using the right tools? I'm limited to MS Office really so I mean should I stick to Excel or carry on pursuing an Access solution?
I want to retrieve some parameters from file, So for that i want to implement File Open Dialog in One of the form. File Open Dialong is available in Micrososft Common Dialog controls.
When i choose Microsoft Common dialog control from extra toolbars, it gives me error saying that "You don't have licence for using Common Control ActiveX.
I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and column space so that the output can be better tailored to his needs. I have inserted combo boxes on the form to get these parameters from the user, but how am I going to insert these parameters in the report layout through programming. What should be the approach?