Archive for January, 2010

Is there an online school program that i can access in the middle east?

Saturday, January 30th, 2010

i am going to jordan for a year and need a free online school that i can access from my laptop over there and have my credits count towards my senior year when i come back to the states.

What grade are you in? is this for high school or college.

Here are a few links that should help:
http://www.collegedegree.com/courses/foreign-programs
http://www.usembassy.gov/

good luck

Where can I get Microsoft Access 2003?

Saturday, January 30th, 2010

I have searched everywhere to find that either it’s discontinued or out of stock. I know that there is 2007 now but I need 2003 (specifically) – ebay doesn’t have it, neither does amazon – any other places? Thanks

I have 2003, but I’m curious why you need this particular version.

When you configure Access you can tell it to open in prior versions. This sometimes don’t require any conversion from your part.

The only problem is when you have used ActiveX Controls that are only available in the newer version. If that is the case you can get the OCX files from the machine you coded the application and register them on the old computer. You do this by looking the broken ("missing") links on the VBA Reference section.

You place the OCX and DLL files on a folder that is for this purpose only. Then you can browse to the directory from the VBA Reference section to fix the broken links. Some DLL’s require registering. There is a command like "regsvr32" that you need to use for this.

Another option is to get the Access Developers Edition and compile the code for a distributable package that can be installed in any computer that needs it. It will contain the Access Run libraries.

If you need more info let me know.

How i can match my mail account of Outoook web Access with Outlook 2003?

Saturday, January 30th, 2010

I want to administrate my mail account of Outlook Web Access in Outlook 2003 so i synchronized this pop3 mail account but when i transfered e-mails these are transfered 2, 3 or 10 times, so if i have 1000 emails and i synchronize, in a few hours i’ll have 10000. I tried many many options but anything work.

you need the newer version

Where can I find a good tutorial on how to use SSL certificates?

Saturday, January 30th, 2010

I’m creating a website which will let users access personal information. Where can I find a tutorial that could help me set up a SSL certicate so my users can access the site over https?

bodo here is your link learn

http://www.instantssl.com/ssl-certificate-support/guides/ssl-certificate-index.html

http://www.msexchange.org/tutorials/SSL-Enabling-OWA-2003-Using-Free-3rdParty-Certificate.html

http://www.digicert.com/web-pki-manager-tutorial.htm

http://www.netshinesoftware.com/security/using-an-ssl-certificate-with-your-joomla-website.html

http://www.freessl.com/ssl-certificate-guides/index.htm

now my friend if you want more links then try this

http://www.satyamshiva.com/

Is there a way to run SELECT queries on an Access 2003 database from Access 2.0?

Saturday, January 30th, 2010

I have an Access 2.0 application that I need to interface with an Access 2003 MDB. The only thing that needs to be run on the Access 2003 MDB are SELECT queries, nothing else. Is there a way that I can do this? If I have to set up an ODBC connection, that’s fine.
Importing the queries is not an acceptable solution. The queries MUST be run from the Access 2.0 side. And the queries must also run programmatically, not via the frontend.

see if you can IMPORT the queries into the 2003 DB. Run them from the front end.

How to convert an Access 2000 file to an Access 2003 file?

Saturday, January 30th, 2010

My instructional book tells me that once I try to open an Access 2000 file in Access 2003, it will automatically ask me if I want to convert to the new version. But my never asked me… so help please! thanks

Open your file, then go to Tools/Database Utilities/Convert Database.

There you will find the 2003 Conversion. I think you need to choose a new name for the DB at that point…you end up with two files.

How do I access the Control Panel/Windows Restore without the use of the start menu?

Saturday, January 30th, 2010

My desktop no longer shows up anymore and typing explorer.exe does not fix it. Is there a way to access the control panel or skip that part and access windows restore because I’m no techy at all but I think my virus protector deleted my desktop. Please Help.

If you have vista you can right click and go to personalize. Then look at the top right hand corner and type system restore in the quick start search box.
For xp Press these keyboard keys in sequence: Alt + Ctrl + Delete

Windows Task Manager should pop-up.
From there, look to the bottom for ‘New Task…’

Another pop up will appear. Where it says ‘Open:’ , type in: Control Panel and then click the ‘OK’ button.
Hope this helps

I have problems to make a search engine in MS Access database ?

Saturday, January 30th, 2010

I have made an access database for a company, I made a great form with many futures, but do not know how to make a search engine for the database. For example if I want to know how many male staff do I have or how many female do I have. Or searching a group of people by grades, or by SRLs or by names. any idea how to make this will be appreciated?

By building a query in the queries section.

how do I load reports in a Microsoft Access form?

Saturday, January 30th, 2010

I have dozens of Microsoft Access reports and I would like a method to easily look for a certain report. I have been attempting to create an Access form using combo boxes and command buttons to select the report I want and display it. The reports are numbered from "1" to "53", and I have tried using a series of "if else" statements to load reports based on what is selected in the combo box, but with no luck.

Can anyone tell me how this can be done?

Press shift then f2

How can I convert a MS Access file into a stand alone application?

Saturday, January 30th, 2010

I’ve made a MS Access file (extension mdb) with tables, queries, forms and macros, so they interact with eachother without being necessary the use of the default menu. When the file is double-clicked it goes directly to a specific form I’ve made. Yet, it only works on computers with the MS Access software installed. How do I convert the file into a stand-alone application (for instance exe file extension)?

MS-Access is generally regarded as a backend tool (a tool for storage of data). You have to use some front end tool like VB with Access. In such a case you have to write snippets that manipulate the data and return a result from the backend. Inturn this front end can be converted into an executable file.

VB is just an example of front-end tool that can be used . You can also use ASP, PHP, CFML, Flash files as the front end.