Archive

Archive for the ‘MS Access’ Category

Ms Access – Rank Subset Of Data In Query

July 10th, 2012 Comments off

I have a dataset, which is attached.

I would like to rank the prices by a Date (subset). My current approach is close, but the rank isn’t always consistent. here are the changes needed…

1. Rank 1 is the highest price
Rank 2 is the second highest price
etc…

2. If the Price is blank in the subset, then I want that rank to be the highest

3. In a separate field, i want to identify by an “X” if two records in a subset is tied. i.e.

Example:

Checkin Hotel Price R…

Usa Cards Form Filling

July 5th, 2012 Comments off

SIMPLE FORM FILLING OF DATA ONLINE IN MYSQL MS ACCESS SERVER ONLINE DATABAASE.
THIS IS DATA OF UNIVERSITY STUDENTS CARDS TO BE PUCNHED MANUALLY IN FORMS.SIMPLE COPY TYPING WORK
GOOD PAYOUTS AND HIGH ACCURACY REQUIRED

Fillable Forms For Iphone Users

July 2nd, 2012 Comments off

We need to create a fillable form that field technicians (read: unsophisticated users) can complete on an iphone and send to the office. I want to have dropdowns, some validation, and calculated fields. It will be about 20 questions.

I would like a printed version to fit on one 8 1/2 x 11 inches sheet. Ideally the data would be automatically captured in (or able to be exported to) a database.

We have an Exchange Server, and we use MS Access and CutePDF Pro, so integrating with those apps…

Simple Excel Calculation

June 21st, 2012 Comments off

I would like an Excel expert to help me to calculate the zigzag technical indicator in excel by using OHLC data from CQG. I will provide an excel sheet containing the data and results to compare against.

I believe this analysis has previously been done for someone else in MT4.

Thanks

Advance Php Mysql Code Generator To Create Custom Web Apps

June 13th, 2012 Comments off

I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : demo _a-t_demo.com | password : demo). The new app should be capable of creating any such web applications…

Export And Import Data For Reporting

June 13th, 2012 Comments off

A new Interface is needed to connect to an existing database in a MS SQL Server and to export specific data from tables and import them into FileMaker and into MS Access. This export function needed to be run from time to time. This means it needs to be considered that the data, when it is imported, will not be overwritten, if it will be imported on a weekly base for example. This means only new data will be imported.

Advance Php & Mysql Code Generator To Create Custom Web Apps

June 11th, 2012 Comments off

I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : demo _a-t_demo.com | password : demo). The new app should be capable of creating any such web applications…

Msaccess / Visual Basic 6 Form Fix

June 11th, 2012 Comments off

Need someone with MSAccess 2003 database experience and VB6 experience to help debug a problem with two forms. When we upgraded to MS Access 2010, we lost the functionality of these forms. One form is very simple, when a user clicks on a checkbox, it opens a form and provides a listbox is suppose to select and hit ok. It does all that, but when the user selects ok, nothing happens. The second form is very small in nature as well.

Online Health Insurance Form Filling

June 9th, 2012 Comments off

This is project of online form filing medical data will be available in jpeg files you have to copy type them in ms access forms each form has 60 fields alphanumeric data punching in empty fields of form.good rate upto 1us dollar of form will be given accuracy above 95 % required teams are encouraged to bid

Php Mysql Code Generator To Create Custom Web Applications.

May 31st, 2012 Comments off

I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : | password : demo). The new app should be capable of creating any such web applications in it as mentioned…

Classic Asp Or Php Developer

May 23rd, 2012 Comments off

I’ve built a website in classic ASP. Most of it is done but I don’t have time to finish it. I am looking to get it finished by either getting someone to finish it in classic asp or rebuild it in PHP/Mysql. The database it is using at the moment is MS Access and I would really rather a MySQL database to hold all the information that will go into it.

I would also be looking for facebook integration so facebook comments can be shown on the website and the client can receive facebook “likes” t…

Php Mysql Code Generator To Create Custom Web Applications

May 23rd, 2012 Comments off

I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : | password : demo). The new app should be capable of creating any such web applications in it as mentioned…

Extract Data From Ms Access And Outlook Backup 2 2

May 23rd, 2012 Comments off

Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)

I’ll need the backups according to certain criteria like creation date, tags etc.
Easy work: $50

Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.

Thanks

Ms Access Expert

May 20th, 2012 Comments off

YOU MUST BE AN EXPERT IN MS ACCESS!!!!!!!!!!!!!!

I need someone to combine two databases, this is NOT an easy job unless you know what you are doing.

I’ve spent hours waiting for people to complete this job only for them to admit they can’t do it.

I cannot mess around with this. I must watch you working on teamviewer so that I know you know what you are doing!!!!!!!!!!!!!

If you can do this, there will be more work.

If you apply for this job and cannot do it I will leave negat…

Php Fox Integration 2

May 18th, 2012 Comments off

Hi everyone,

I am in need of someone who can integrate a phpfox theme for me.

Working concept of the theme should be like the BuddyPress theme; whereby,
i can provide all details by pm

thx

Php & Mysql Code Generator To Create Custom Web Applications

May 17th, 2012 Comments off

I want a php & mysql automated code generator web application in which anyone who does not know programming can also create customized database centric php web applications which can be run online and offline also with help of wamp/xampp. For example you can see www.propertymarket.biz or http://atomicinfosystem.in/transportmanagement/admin_home.php (user type : Data entry user | user name : demo a-t- demo.com | password : demo). The new app should be capable of creating any such web applications…

Simple Php Additions 2

May 16th, 2012 Comments off

Have existing website with admin panel. Need the following additions completed:

1.Need function add/remove pages from website. When I create a page I should beable to add title of page and select category the page list under menu. I should also beable to insert content into the body which will have a ckeditor installed for additing content.

2.Need to beable to edit my users password

3. need a search function to find a user by name or email

4. need to see the last time a user logged i…

Extract Data From Ms Access And Outlook Backup

May 14th, 2012 Comments off

Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file)

I’ll need the backups according to certain criteria like creation date, tags etc.
Easy work: $50

Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail.

Thanks

Csv Bot Modification Barcode Needed

May 12th, 2012 Comments off

We have a csv input (bestsellers.csv) – attached and we use the csv to do a quantity list using a VBA script in an excel file (ShinyNewCSVImportMark4.xls) – attached. The current output (output.xls) – attached

We need some modification in the script.

1. There should be only 5 columns of products -Within A4 width. This is to give more space/width for Barcode. Right now, it is 7 columns. The row number of 6 is to remain same.

2. If the QTY is 2 for a specific SKU, The item should be displ…

Simple Php Additions

May 10th, 2012 Comments off

Have existing website with admin panel. Need the following additions completed:

1.Need function add/remove pages from website. When I create a page I should beable to add title of page and select category the page list under menu. I should also beable to insert content into the body which will have a ckeditor installed for additing content.

2.Need to beable to edit my users password

3. need a search function to find a user by name or email

4. need to see the last time a user logged i…

Transfer Data From Outlook And .mdb To Google Business Apps

May 3rd, 2012 Comments off

I have data from MS outlook and MS access. This is my customer’s data.
I need to transfer this all data to Google Business Apps Account.

Outlook file is some 6 mb and access file is 14 mb zipped.

Anyone who can help?
Please make sure that I’ll be also needing data arrangement like sorting according to suppliers and contractors and normal users etc.

Anyone having idea about google apps will understand that its an easy work. Let me know if anyone can do it real quick.
Have several sim…

Dvd Website – Sql Query Problem – Add-amend-delete

April 23rd, 2012 Comments off

SQL Query Problem – Add, Amend, Delete.

On the Administration page of my website, an Administrator should be able to add, edit, delete entries in the Products and categories, which is a database built in MS Access. They should be able to alter entries in the tables.

I think the Insert, Update, Delete statements need to be tweaked.

Translation Access Database

April 23rd, 2012 Comments off

Looking for an expert in MS Access to develop a translation database.

Database Operations – Concatenate And Update Fields

April 17th, 2012 Comments off

I receive a weekly Access database file with CE Credit information from multiple crediting agencies.

These credit information text fields ([required language] field) must be merged together for each particular course type, and then stored as a memo field in a separate table. The id number of that record must then be stored for the records in a separate table containing date/location information for a particular class.

The end result can be described as follows.

A site visitor sees a cla…

Online Medical Heatlth Insurance Forms Filling

April 13th, 2012 Comments off

This is project of online form filing medical data will be available in jpeg files you have to copy type them in ms access forms each form has 60 fields alphanumeric data punching in empty fields of form.good rate upto 1us dollar of form will be given accuracy above 95 % required teams are encouraged to bid

Bpo Broker Price Opinion Order Auto Accept

April 13th, 2012 Comments off

I need a script that can login, check for for available orders and accept them…

I Need program that can log in to the website, and check for orders and accept them, also have an option so that I can tell how often check for orders.

site that I need script to work on is

ava.altisource.com/webtop/
My budget is very limited on this one, 50-100.
Please serious programmers only. Test your knowledge on ava.altisource.com/webtop/ if you can make your program to log in to the website.

Dvd Website

April 13th, 2012 Comments off

It is a website for purchasing DVDs. It has to have admin roles and customer. Needs to look more dynamic. New home logo and buttons. Add, amend and delete products. Hit counter, calendar. Google maps. Video trailer. More informative errors for failed logins, all code commented with explanation.

Financial News Website

March 28th, 2012 Comments off

We want to design a professional Financial News Website that will be of good standard and have America, Europe, Asia, Africa etc market pages with easy accessible administrative back end, where news can be updated and strategical advertisement posted.

Pulling Text Data Files From A Website Into Ms Access 2003

March 12th, 2012 Comments off

All,

I am doing independent research and need to pull text files from this site http://www.fanniemae.com/mbs/data/mbs/newisspoolstats.jhtml here into MS Access for analysis.

Note:

1) The text files are posted on this site by business day, I need access to pull all the files on this site including the most recent one posted. Thus, Access needs to check once a button is pushed.

2) All text data files will then be dumped into an Access master table

3) Including the data files in the…

Ms Access Database

March 5th, 2012 Comments off

Create a MS Access database containing 4 million records

Thanks

Simple Inventory Managemnt Software

March 1st, 2012 Comments off

Hello,

I need an inventory software for my webstore.

Inventory software should be able to work in mobile barcode computers(PDA) and desktops.
At this moment, i am unable to decide if i need a desktop appilcation or web application.
Desktop application will require a local server but it is FAST loading. Require networking to be done.
Web application will require hosting and is easy to setup but data will be loaded SLOW.
Networking, so that 5 people can work at it at a single time.

Th…

Custom Access 2k Program Conversion To Vb.net V2.0 Framework

February 29th, 2012 Comments off

We have developed a Custom ERM system in MS Access 2000 and would wish it to be converted to VB.NET targeting the 2.0 framework.

The Access front end consists of some 350 forms, 300+ reports and 20+ modules. Estimated at about 250,000 lines of code. The whole system interfaces with a PostgreSQL v8.4 database of about 300 tables.

Wp Php Editions

February 20th, 2012 Comments off

I am using 4 plugins on my wordpress website hosted on my server that I need a couple small features edited. I need a simple drop down search feature in all 4 directories where the user can select the city to display results for the directory.

I need a couple features that are showing now to the user hidden

i need the thumbnail.com featured setup on the plugins to display the thumbnail next to the listing of the website. You can see attached what i mean, where it says “premium listing” is …

Designers/developers Needed

February 17th, 2012 Comments off

I am looking for Developers and Designers to Join as Affiliates in a company selling VPS Hosting Solutions.

By joining as an affiliate you will be able to earn 15% recurring commission for each client you refer, the affiliate commission can be withdrawn immediately to a PayPal Account or other account.

This potentially can become another way to earn money by only referring clients to the company.

Additional information including the url will be sent via PM.

Tasks Management With Ms Access 2

February 7th, 2012 Comments off

I want to develop an Access Database to track the tasks assigned to members of a company. This database should provide to our team a centralized searchable environment to track project tasks, dates, and status. All wishes and constraints are explained in the zipfile attached to this request.

The zipfile contain the beginning structure of the access database and screenshots of what I exactly want. The layout and the easy use of the application are very important. I really want a friendly front…

Adding Highlight To Searchword On Results Page

January 31st, 2012 Comments off

I am using ASP/MS Access and have keyword search box on site main menu. this is showing results in search-results.asp using a form GET parameter.

But the search is bding done on a record field which is the contents of a page so could be 500-600 words long.

I only know how to bind the field in the results page, but what I want is to a)highlight instance(s) of the search word in the returned text and b) trim the binding down so there are just 10-15 words preceding and succeeding the search …

Vba Code For Ms Access Application

January 31st, 2012 Comments off

In short: I need Visual Basic for Access code to use in ms access application, that will do 3 things:

– optimize (resize) images and save them in specific folder (path to do images for optimization is in tblImages)

– generate XML file from defined query

– synchronize XML file and images from local to the web server.

I wrote detailed description of work that should be done (attached), however, Im open to discuss any other solution that you could provide.

Order Entry Db Management Or Work Order Ms Access Or Other

January 26th, 2012 Comments off

Looking to have the most cost effective order entry database created. This only needs to be an offline database, and really only needs to be access on one computer. Does not require multiple logins or anything like that.

I was thinking microsoft access has all of the required abilities to do fairly quickly. I would like to have the ability to create work orders for my business. The work order would need to link to a client database, seperate shipping database, product database, and some o…

Search For Duplicates Software 2

January 22nd, 2012 Comments off

We have many PDF files. which contain a list of People’s names and their addresses. i need a software, where i attach a directory of pdf files. the software will do the following

1. import all the names, addresses and other details into a Database (access)
2. it will also store the file name it was imported from.
3. it will be give me a report and tell me if it found duplicate names, based on … Full name , Fullname and address, Full name and/or other db fields.

this is a social proje…

Search For Duplicates Software

January 21st, 2012 Comments off

We have many PDF files. which contain a list of People’s names and their addresses. i need a software, where i attach a directory of pdf files. the software will do the following

1. import all the names, addresses and other details into a Database (access)
2. it will also store the file name it was imported from.
3. it will be give me a report and tell me if it found duplicate names, based on … Full name , Fullname and address, Full name and/or other db fields.

this is a social proje…