Search results

Lets try a bit of regular code here to ask a few questions about our tour. Lets assume we have a booking record for a customer. Ok, lets display the Tour name, and the hotel a user is booked into. Lets just assume that the user is booked to tour in the tours table (the tour table will define...

Ok, first up, there ARE reasons to start building some class objects to deal with business logic. HOWEVER, and it is a big one, in 99% of cases? Keep in mind that when you build a form + VBA in access, you ARE building a class object! Why would I want to use a class object in ms-access? The...

My answer? don't try and do this in VBA!!! Ok, keep in mind there are 3 types of .dll’s that are “common” used with Access. First type: - windows .dll with entry points A standard windows .dll, one with entry points. These are the ones that you use VBA declare statements. Such as this one...

I outline the concept of splitting here: http://www.kallal.ca/Articles/split/index.htm And here is a great primer of mine on running multiple users on a LAN and WANS: http://www.kallal.ca//Wan/Wans.html Regards, Albert D. Kallal (Access MVP) Edmonton, Alberta Canada

You can send the back end tables up to SharePoint/365, and then continue to distribute the front end to your users. The “trick” with SharePoint (SP) tables is there are several considerations: During the up-size process, the PK (auto numbers) are changed. This means that ALL of your...

As for using x64 bit version of office. That is not currently recommend (using x32 office on BOTH x32 and x64 machines is what everyone been doing since windows 7 came out). And having a mix of x64 and x32 office is going to be a source of HUGE issues The word merge code should run just fine...

Actually, you do NOT want to change nor remove the DAO prefix in your VBA code (doing so will make things WORSE and more difficult to tell if you have messed up references). All of your existing DAO code, even code going back to Access 97 should continue to run in 2013. The ONLY change I am...

Actually, since Access 2007, we do NOT need a DAO reference. JET has been replaced with a new version called “ACE”. By default the DAO reference should not be checked, and not be used and in most cases will not be checked if you create a new blank database. So for Access 2010, you use...

The steps are outlined here: http://office.microsoft.com/en-us/access/HA102004941033.aspx The above is for 2007, but just go file->get external data, and the steps are then the same as above outlined if you using a previous version. Albert D. Kallal Edmonton, Alberta Canada kallal@msn.com

Well, you have to setup and install sql server. the process is then VERY much like running a split data base. the up-sizing wizard built into ms-access will move up your data to sql server. HOW TO: Convert an Access Database to SQL Server (a97,a2000)...

You face two major problems: The fact that you split or do not split does not change if this will work. The problem is when you don’t split you wind up with a very unreliable application. If your application is so unreliable your users will not like you anymore, and they lose complete faith in...

Well in theory it does. But this will only work if the users around the world can see and view the folder with that back end mdb data file resides. So if I want a use the word file on your computer, or PowerPoint file, or in this case a standard mdb file, Then I’ll have to have access and be...

No, when you use sql server, you are not linking to a file. You NEVER even a specify a file location when using sql server. You are linking to a server box. In fact, this means that you can use an IP address and even link to a server over the internet. Thus, when you use sql server, ms-access...