Archive

Posts Tagged ‘Microsoft Access’

Database Issue

January 2nd, 2012 Comments off

I just ‘took over’ the management of a geneology website, and databases are quite new to me. I need to download the database for this page http://theggg.org/PCESEARCH.STM, so that changes/additions can be made (using Microsoft Access), and then I will be uploading the new database. For right now, all I need is to download the database into a format that can be used by Access. My problem is that I didn’t create this website or the databases – and there are many, and I don’t know which database is…

Microsoft Access Search

December 22nd, 2011 Comments off

I am a novice at Access so this solution has to be simple. I have a few large databases (300,000) records (~12 fields) that I want to be able to search any field. Then export the results to CSV.
Thanks

F Project 2

December 22nd, 2011 Comments off

I need some ne to make me a final year project that is simple my topic is an intelligent system for students to get advice through there academic year (Student Advisory system).
Eg: A students wants to improve his/her gpa they should be able to get an answe to there problem through this system by giving them options to improve there gpa..ETC this is only one example of what the system should do. The programmer who chooses to do my project should use the following:
Microsoft Access when creatin…

Export Mysql Database Into Microsoft Access Database

December 14th, 2011 Comments off

I have a requirement to export some of the fields from my website mysql database into a microsoft access database 2003 SP3 database on a standalone pc
only require a number of fields to be exported to the access database

Access Database

December 6th, 2011 Comments off

Production Database
I am needing a database that will track employee production for a chip/grind operation for a large heavy equipment company. We are a small company that does this work contract.
Employees will be paid per part complete and this needs to be tracked. I will be using Microsoft Access and have minimal experience setting up these databases.
I need to be able to add information from sheets given by each employee that track:

Microsoft Access -disable Controls On Forms

December 3rd, 2011 Comments off

Hello:
am attaching microsft access database:
open database – a form opens up-
Click button [enter time sheet]
name: select Dade Mike
password: 654321
date: 11/19/2011
you can see the form keeps users data ( as long as they hit save)
Problem:
I want users only to be able to edit the current weeks form-
in the example 11/19/2011- i don’t want them to be able to edit the form for week of 11/12/2011 or 11/5/2011 etc……
You can see i tried code in form load procdedure:
and created ‘lo…

Basic Microsoft Access Database

December 1st, 2011 Comments off

A Basic Property Lettings Database, which will hold detials of Interested Parties and allow Direct Mailshots into Word, OR directly to printer. Must be user friendly.

F Project

November 30th, 2011 Comments off

I need some ne to make me a final year project that is simple my topic is an intelligent system for students to get advice through there academic year (Student Advisory system).
Eg: A students wants to improve his/her gpa they should be able to get an answe to there problem through this system by giving them options to improve there gpa..ETC this is only one example of what the system should do. The programmer who chooses to do my project should use the following:
Microsoft Access when creatin…

Microsoft Access Project- Modifying Form

November 28th, 2011 Comments off

Hello,
I am attaching a microsoft access database.
1.Open database- a form opens up-
2.Click the ‘Run Search’ button-
3.Enter 100004670465 in box and click OK
4.You will see this adds 1st record ( most current record) from tbl1 into tblVerification.
————————————————————-
This works okay- but I want form to work like this:
1. user enters serial number- all records with that serial number display-so that user can view ( by date in descending order) -…

Oracle And Microsoft Access

November 24th, 2011 Comments off

Hi,

I have a simple project in Oracle and Microsoft Access. My budget is 75 USD and I need it within 48 hours of accepting the bid.

Question is in CST.4704.Project.Fall.2011 To Be done in oracle.

Use only New York City data for the censor 2. A research as to be made with regards to the demographics 3. The .PDF file is to be used to cross reference with the access file with knowing what everything is such as the number one in the .PDF signifies its Manhattan in Access. 4. Use the Census …

Create Report In Microsoft Access

November 17th, 2011 Comments off

Hello, am attaching a microsoft access database and a excel sheet.
when you open database you will see a table called [tblPrint]-and then you will see a report i created called [repWeekly].
I am able to have data display like this – but I need data displayed like the excel sheet[sample.xlsx] i am attaching- with data across the page-
Is there a way to do this – even if it takes a few queries- I cannot have it where I have to manually change myself.Other people are viewing the report.
thank y…

Microsoft Access Developer Needed

November 11th, 2011 Comments off

Our company is currently seeking a Microsoft Access Developer to hire for a short-term project. Prospective applicants should have an advanced understanding of Microsoft Access version 2000 up to sequel 2008 R2. Please submit resume, cover letter, and salary requirements to for consideration. Thank you.

Microsoft Access And Excel Developer

October 21st, 2011 Comments off

NEED SOMEONE TO BUILD MICROSOFT ACCESS TABLE/ DATABASE

Microsoft Access Time Clock

August 31st, 2011 Comments off

Hello am attaching time sheet ( microsoft access) example
problem with it- if employee comes into work and clocks out for doctor appt. and clocks back in before lunch- this program has does not allow that.
you will open database and see a form.
on form you have 4 buttons- to clock in- go to lunch- return- and leave
you will see the tbl1 – data comes in different records and I have to run qry1 to put all data in same record
project:
can you come up with better way to do this?
and compensate for people who might leave between morning and lunch or lunch and leaving?
is there way to just have a clock in and clock out and behind the scenes – it collects data correctly
thank you
must be done in microsoft access

Access Database Amendments

July 12th, 2011 Comments off

I have an Microsoft Access program that needs to be amended and updated to make more relevant to our business. I have attached a word document outlining all the relevant details.

Please contact should you have any queions prior to submitting a bid.

Thanks

Calulate Fields In Microsoft Access

June 30th, 2011 Comments off

I have an Microsoft access data base and it hase three forms that have some fields in them to calulate. there is also 3 reports with fields to calulate. When it is done i would like to know how it was done. i did it and the fields did not come out as currency $ the were just numbers I will sendthe data base to the sucessful bider.

Bob Fregalette

Sql Database Design 2

June 5th, 2011 Comments off

I’ll need help setting up a relational database design for my new company’s payroll database. Need someone competent in SQL and Microsoft Access.

Details can be shared via private message.

Sql Database Design

May 31st, 2011 Comments off

I’ll need help setting up a relational database design for my new company’s payroll database. Need someone competent in SQL and Microsoft Access.

Details can be shared via private message.

Microsoft Access Form -one Problem

May 4th, 2011 Comments off

Hello am attaching microsoft access database
when datbase opens – form comes up.
if you enter a prenumber – it fills all records in prenumber field.
if I add a different prenumber- i need it to fill the next records – but not to delete the number inputed first.
if i input 100 prenumber number
100 [any number]
100 [any number]
enter 200 200 [any number]
200 etc……….
right now when i enter 200 – the 100 is deleted from prior records
thank you
i need done – now

Template In Microsoft Access 2

January 5th, 2010 Comments off

Need a template in microsoft access to store books
abilty to sort the books by book name-author-refence….
abilty to print in diffrent format…..

Template In Microsoft Access

December 19th, 2009 Comments off

Need a template in microsoft access to store books
abilty to sort the books by book name-author-refence….
abilty to print in diffrent format…..

Microsoft Access Help

September 2nd, 2009 Comments off

Hello

We need someone to work on MS access to complete a project for us in few hours ASAP.

Database consists of Employee, Managers and Survey Questions
Employees report to Manager.

Manager can select from his employee, select survey type and fill out survey form with 1-5 rank for each question

**Above things are almost working, we will send you the existing Access file we have (.mdb file)

You will need to update some logic in current forms to include following Key requirements:

1) Employees must be able to rate themselves, print, save, and all this info goes to the holding table

2) That response form has to be error-free, has to be able to show averages, this response page has to be robust and professional, otherwise, the whole tool is useless.

3) Only filtering out the employees that report to the manager

Thanks.

Regards,

Al

Attendance Spreadsheet

July 10th, 2009 Comments off

REQUEST #1
I need an excel macro with coding that shows me each punch in and punch out for an employee and totals the amount of hours and minutes that the employee has worked for the day.
I’ll try to break the current process I use into separate steps, so that you can more easily follow the logic and create the code.

Data Entry / Microsoft Access

April 6th, 2009 Comments off

Update current data using Microsoft Access. Edit/Delete data by verifying data online. Mostly copy and paste.
About 500 entry to start with.

Bear