Archive

Archive for the ‘Access’ Category

Fix Access Forbidden Error

February 18th, 2012 Comments off

Hi,

My client finds that their Joomla website comes up with ‘access forbidden’ when searched for

https://www.google.com/search?q=glen+edmunds& ie=utf-8& oe=utf-8& aq=t& rls=org.mozilla:en-GB:official& client=firefox-a

See attached screenshot.

I would like someone to fix it.

Thanks

Dashboard In Sql/access_mult Automations And Indiv Reports

February 17th, 2012 Comments off

Overview of Potential Project

Version: MS Access 2010 (I can obtain the Access Web version, if it becomes necessary as part of the project solution), can acquire SQL if that is a better fit for this project

Background for Project:
I am collecting treatment outcome data for patients across multiple time points, using an online assessment platform. As the basic process, patients complete multiple outcome questionnaires online through a link to the assessment platform. As soon as a patient…

Categories: Access, SQL Tags: , , , , , ,

Blocking Country Ip And Access By Password

February 16th, 2012 Comments off

We need to block the web-traffic from a particular country and if someone visits from that country, they need to enter username and password that we set to access the site.

It can be done by using .htaccess file and we already have a code to block all the IP’s of that country but we need to know can any one update it so that it can give password protected access to the users of those country if they know the password.

Please post a bid if you are 100% sure that you can do it or you had alr…

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.

Upload Access File To A Database / Fix A Dropdown Menu Link

January 30th, 2012 Comments off

Just 2 small things on the website www.theggg.org – first – the link at Databases>Naturalizations>Kings County Naturalization is going to the wrong place – it is going to http://www.jgsny.org/brooknats.htm and should be going to http://www.jgsnydb.org/kingsintro2.htm. Also, a new database needs to be uploaded to Databases>Church Databases>The Presbyterian Church in Elmont. In fact, I would prefer that the database be loaded to a ‘hidden’ location so that the group could test it first…

Small .net Programs For Assignment 3

January 30th, 2012 Comments off

I have up to 8 programs to make. Most of these are applications to manage small business e.g an application to manage a ski resort income. Simple and straightforward.

1. Simple but great interface – Most people who will be using these apps are only familiar with yahoo mail and facebook, at best MS Word.

2. Code has to be simple and well documented so that little modifications can be made. Same for the DB.

3. Easy installation and use. It must be easy to install the app and use it witho…

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…

Small .net Programs For Assignment 2 2

January 19th, 2012 Comments off

I have up to 8 programs to make. Most of these are applications to manage small business e.g an application to manage a ski resort income. Simple and straightforward.

1. Simple but great interface – Most people who will be using these apps are only familiar with yahoo mail and facebook, at best MS Word.

2. Code has to be simple and well documented so that little modifications can be made. Same for the DB.

3. Easy installation and use. It must be easy to install the app and use it witho…

Upload Access File To A Database

January 13th, 2012 Comments off

I need to upload a mdb file to a database. The site is www.theggg.org, and I have a new file for the http://theggg.org/Surnamedb.asp to be uploaded. Should be a quick job for someone who does databases.

C# Ms Access Based App Development Using Sdk

January 10th, 2012 Comments off

C#, MS Access based Time-Attendance App (Reference software- http://etimetracklite.com) needs to be developed using corresponding SDK (Dev tools shall be provided). All legal rights on the source code & further development strategies shall remain our’s. Kindly share your best estimate & timeline for the same at the earliest.

Joomla 1.5 Site Returning Restricted Access Error

January 6th, 2012 Comments off

URL: http://dclfoods.com/

Website has been moved to new hosting provider.

Website was buit on Joomla 1.0, but recently upgraded to 1.5. It was working on the old hosing provider. Since the move to a new provider it shows the following error on the home page:

‘Restricted access’

On enabling the ‘System – Legacy’ plugin to accommodate any plugin that might be causing conflict the following error is shown:

‘Fatal error: Class ‘JPathwaySite’ not found in /home/dcl123/public_html/libra…

Ms Access 2003 Query Change

December 30th, 2011 Comments off

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

Ms-access App Modifcation

December 24th, 2011 Comments off

I need an existing MS-Access (2007) application (file) modified…

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

Small Amount Of Visual Basic Code Needed For Visual Studio

December 15th, 2011 Comments off

Here is the small bit of code needed. (Please use these naming conventions http://support.microsoft.com/kb/110264)

Include a new form that is linked to an Access database that you must design and create- you choose the topic, design the database, tables, fields, enter record values, etc., and then connect the form to the Access database. A datagridview control is insufficient for this task. This is completely creative- both the form fields and the Access database are designed by you. Be sure …

Ms Access 2003 Report And Query Work

December 14th, 2011 Comments off

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

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

Convert Access Application To Mysql/php

December 12th, 2011 Comments off

We have a access database application with approx 30 forms and 20 reports that needs to be converted into PHP and MYSQL. We will provide screenshots, example reports etc if you are interested in quoting the work.

Convert Conceptual Model To Logical Model In Ms Access.

December 11th, 2011 Comments off

Conceptual Model from Visio Solution is in attached PDF.
Now we are going to convert our conceptual model into a logical model. Using Microsoft Access perform the following steps:

1. For each entity listed in the Solution file create a table in Access
2. Add primary keys for each table.
3. Set column properties for unique constraints.
4. Update the datatype for your attributes to enforce the domain constraints of the data.
o Dates should have a date datatype
o Surrogate keys sh…

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.

Send Email From Access Database

November 29th, 2011 Comments off

Have a query
I want to send emails using access form.

query email has two fields.

ObjectHyberlink emailaddress

expect
send one email to email thuyly_dyahoo.com
Subset: Please review this (subset can be the same for everyemail)
Body – body of the emails should have the 3 hyperlinks and user can click to go to the websites
IBM Website2
yahoomail
IBM

next do the same for
divangxyahoo.com
send one email to divangx
body of email
IBM3
hotmail

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) -…

Unique Random Access Code Upon Completion Of Paypal Payment

November 20th, 2011 Comments off

Hello,

I almost have the complete process that I need for my website, however I need a solution to the final step of the process. Which is the delivery of a unique randomized access code.

My current process is:

1) The user click a link to make a subscription payment via PayPal.
2) Once payment is complete the user is redirected to a Jotform.com form to submit their personal details.
3)(This is the step I need your help) I need a method of randomly generating a unique access code that …

Digital Access Pass Integration

November 20th, 2011 Comments off

I have a site I need DigitalAccessPass.com’s script installed and configured on.

It’s a membership plugin for wordpress that integrates with paypal and mailchimp.

I need someone that is fast and has total confidence they can bang this out.

Thanks,
Sean

Database Access Or Mysql – And Asp Or Php Pages To Update

November 18th, 2011 Comments off

1. database access or mysql to track sales of online auction profits via a online ingame videogame. I was to resell items within the game and track sales, by both profit in dollars and percentages of markup.

2. I want to run several databases for other users so I can install those to different directories or provia a way to program a new user. I need a password and login for each database so only 1 user can modify their sales.

3. I have a compley formula to calculate the ingame auction…

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…

Extend WordPress Plugin Member-access

November 17th, 2011 Comments off

I need some changes/extensions to the ‘member-access’ plugin for wordpress.

Currently it’s possible to restrict the access of posts and pages for members or non-members.

I need this extended so it’s possible to choose the user-level/type wich will get access the post/page.
This must work hierarchical.

e.g.
When i define for a post that only ‘authors’ have access to this post, also editors and admins will have access, but no contributors or subscribers or non-members.

This must al…

Seeking Microsoft Access Developer

November 16th, 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 and how to convert all database to Microsoft Access 2008. This program is currently connected to SQL 2000 our SQL will be upgraded to SQL 2008 R2 . Need a programmer that is able to help convert the database inside so that it will work with the new SQL 2008. Please submit resume, cover letter, and salary req…

Ftp Access

November 16th, 2011 Comments off

I lost all of my passwords and logins for Everything.

i need immediate access into my site:

http://huntnewsnu.com:2082/login/

Convert Access Database(program) To Php+mysql Program

November 16th, 2011 Comments off

Hi, I have a database file in access which I want to redesign to use on internet php + mysql. Also I need some modifications to lookup email addresses (currently we cannot look this up)

What we want is the whole database system to run online.
All form / tables / queries / reports.
We want to convert the access database to an online Application.

We need a login system password protection.
We need an admin section to administer the database. (add/delete or modify records)

1) We want …

Script Code To Control Access To Pages 2

November 15th, 2011 Comments off

I need a Script code to control access to pages in my site, based in a mysql variable,

i need a simple code , that i can add to my new page html code and then just certain users can access to this page, based in this variable from my mysql database, users mus be login first to access and then the script check i this user is allow or not to se the page, if not redirect to the registration page

Send Email From Access Database

November 13th, 2011 Comments off

Have a query
I want to send emails using access form.

query email has two fields.

ObjectHyberlink emailaddress

expect
send one email to email thuyly_dyahoo.com
Subset: Please review this (subset can be the same for everyemail)
Body – body of the emails should have the 3 hyperlinks and user can click to go to the websites
IBM Website2
yahoomail
IBM

next do the same for
divangxyahoo.com
send one email to divangx
body of email
IBM3
hotmail

Custom Variable To Joomla Session And Verify It For Access

November 11th, 2011 Comments off

I have a few custom PHP scripts that allow a user to create an account provided they have a certain code, they then access protected content based on their email and that code thereafter. Every time they log in, I check the validity of the code against a database and then use a session to keep the person logged in as they view various content.

In a new variation of the site, I need a user to be able to log in using my form and then view areas of a Joomla site exclusive to people who have logged in. I imagine it might make the session viewable in Joomla.

I suppose I’ll need this in a module – or have some method to drop it in to Joomla pages I wish to make code-accessible only. If a person attempts to view one of these pages, I need the module/whatever to redirect them my outside login script. Joomla authentication can and should stay. There are some Joomla pages which do not require the login, so I don’t want to affect those.

Site is in Joomla 1.5.

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.

Protection Against Illegal Access And Proxies.

November 11th, 2011 Comments off

We have a site of adult content whit memberships system (www.walterbosque-art.com). (Argentina), But many Argentineans enter to our website through proxy, they discharge pictures illegally, they distribute them for chains of e-mails, they make blogs with our sessions, etc… This provokes us serious problems with our model ones and it also diminishes the quantity of members in our site.
Economically it is harmful, and it also provokes us legal problems with the models.
I’m using the MaxMind GeoIP service to stop access in my region. So now, I need to install a system to detect illegal connections (anonymous and open proxies for example). What do you recommend me?
I think this may be a solution:
http://www.maxmind.com/app/proxy
http://www.maxmind.com/app/web_services_ipauth_usage
http://www.maxmind.com/app/ccv
Is this true?
I need you to install the filter on my server. How much is it? How many time do you need to installing?

Create Progress Bar In Microsoft Access -importing Xls Sheet

November 10th, 2011 Comments off

Hello,
am attaching ‘testimport.mdb’ ( microsoft access database)
and ‘ExcelSheet1.xls’-
as long as these two are in the same folder-
open database- click import button on form and browse to the ExcelSheet1.xls- it will import the data in.
question:
I also have attached ProgressMeter.mdb ( microsoft access database)
if you open it and look at form ‘frmShowProgress) enter 1000 iterations.
1. I want to have a progress bar display like this in TestImport.mdb when importing the data from ‘ExcelSheet1.xls’
( and be able to understand code)
2. is it possible to create another form? or in the form? that would let user change the values of B1 and F11- if ExcelSheet had different number of records to import??
thank you

Fix An Obdc Access Problem

November 9th, 2011 Comments off

We have a full access to our Plesk administration
We have a full access to our Phpadmin

We try to make a OBDC access to our MySQL database but it doesn’t work, we obtain a 10061 error problem, we think it must be a port problem but are not sure

This is the URL to the phpinfo: http://www.maselection.be/Phpinfo.php

We are looking for somebody who can fix this, so that we can obtain a OBDC access

Categories: Access, Fix, MySQL, PHP, Plesk Tags: , , , , , ,

Create A Password Protect Login Page For Access To A Website

November 6th, 2011 Comments off

Create a simple login page or popup with one word access to access all other pages in a website. Must have a panel to add or remove password. Password should be able to accept any string so we can set it as an email or a word or phrase.

The site is hosted on a godaddy server. www.liliandbert.com

Bear