Does anyone know how much of the market Access holds? Is it gaining or losing ground? If it does lose ground, how hard is it to pick up some of the other app's like Oracle?
I'm somewhat functional with Access now, and ready to start tackling programming, but I'm confused. This may be a dumb questions, but what is the difference between VBA and SQL? It seems I've been tripping over both interchangeably.
There are courses nearby in Visual Basic. How readily...
I have a query set to show only those files created by CurrentUser(). I want to also set it to show all files for the Administrator, Bruce. How do I code that?
It seems like I need to tell the query that if CurrentUser = Bruce, then there is no criteria. Is this something I can't put into...
We just had our first experience at working with two users at two different remote sites and it didn't go well. A message that we were "in sync" apparently couldn't be trusted, one person's download of the site was apparently banged up and didn't show up until she tried to upload...
I'm using the list box wizard, it asks me if I want it to "Remember a specific field value for later use." I say yes, but then I can't find anywhere in the properties where that value has been stored, what it's called, etc. I have no idea how to access this info "for later...
I've been trying to use the list box wizard to set up a form that will list all clients entered by a specific counselor, then when I select the client I want, clicking will open the main form in edit mode, calling up that client's record. The wizard creates some code under...
I have a long input form that I'm using the tab feature with, which isn't working properly at this point. My initial table's primary key is autonumbered, called ID, then all subsequent tables are linked with the "relationship" tool to that primary key, through an "ID" field...
I've created a large database for an AA type organization. They have a long form for clients, asking a lot of very personal questions. I've set up a basic security logon with the wizard which allows the counselors access. In addition to that, we want each counselor to only be able to view and...
I wanted to give the switchboard wizard a try, so I went to "Tools - Add-ons." The Add-ons box was empty, the folder's empty. I tried repairing, re-installing, then removing and re-installing Access. I set it up to install all the available Access options. Still nothing in the...
I'm experimenting now with getting a multiple page form set up as subforms, accessed by tabs. I have a main form, which is basically just being used as the header at this point, with fourteen pages of tabs under it where the fields to be input are. In testing it out, I get an error message...
I'm creating a very long input form for an AA-type counseling group, about eight pages long with many, many fields. I found early on that I needed to break it down into smaller tables. Now I've created forms for each table. I'm creating a navigation that will lead us from one page to the...
The Dreamweaver User's Guide states this, page 379 "Documents created from a template inherit the template's page properties, except for the page title. If a document is based on a template, you can change that document's title, but any changes you make to its other page properties are...
The manual tells me that if I use a template on my web pages that I should be able to rename the title of each page, but it's not doing that. I save the title this way and that way, but it's clearly locked out by the template as an uneditable zone. Any clues?
Also, I've been trying to set...
I'm setting up a form. It will be quite long and use a number of subforms. Is it customary in Access to let a long form just scroll on and on, or should/can it be set up in short discrete pages that the user advances to by clicking a button, (as most websites are set up)?
Anyone have any titles they'd recommend for learning Access quickly and well? I know many other app's and I programmed dBase in the DOS days so I don't want anything too basic. I'm using Access 2000 presently. I'd like some well written tutorials that will leave me fluent in most functions.
I'm trying to run Access. I'm new to it. I programmed dBase a lot years ago, and am trying to get my bearings. I've created a database, which I broke down into a number of tables. I crashed running it several weeks ago, used WinFix to restore my Windows, completely uninstalled Office and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.