20 Most Recent Microsoft Office Access 2003 (077-02871) for PC Questions & Answers


The easiest and fastest way to learn the basics of any of the main office programs is with multimedia tutorials. Ranging 5-10 times faster than text. More can be learned in this way in a shorter time.
In regards to VBA, if you only want to work with macros and scripts within an application, a minimal knowlege is all that is necessary. If you are wanting to use VBA across applications, you will need a little more depth of knowlege (at least in my case) is needed. May I suggest Microsoft's 'inside out' series of books. It looks intimidating but you only need the section you are studying.
There is something special about getting tutorials and learning information from the actual program manufacturer. They are the authority and free.
Okay, my suggestion is to first go to Microsofts website and view the tutorials available for your application: MS Office tutorials
Then, if you find your thirst for knowledge unquenched:
4db359c.jpg
  • Third party online tutorials are often quite good. But often the depth knowledge like VBA will turn into a 'tips and tricks' rather than the foundation needed.
  • Get some of the multimedia learning, all it takes is a few 20 minute segments. Titles like Mastering Access 2003 by Magic Media, includes VBA.
Learning some of these applications can be very daunting. It is estimated that your typical user will use only around 10% of the programs capabilities. And they keep adding capabilities! Anyway start easy and work your way up to the complexity you want.
For the other users that have similiar problems, the real answer is to learn the above. But to convert numbers to words you need to redefine the field as text, and enter numbers.
And if you are setting up a search criteria for multiple text boxes using IF condition, it depends on what you are comparing. If you are comparing to a set quantity it would look something like this: IF field/text box = "Fixya" THEN performed action. Endif. If you are comparing two or more text boxes to each other it may look something like this: IF field/textboxA = fieldtextboxB or fieldtextboxC THEN action Else action. Endif

Hope this helps!
Ted

Microsoft Office... | Answered on Mar 19, 2018


Ms. Access is part of Microsoft Office and you cannot download for free.
But you can download Ms Access database viewer from here

Microsoft Office... | Answered on Feb 02, 2018


see if the LDB file still exist and delete it...

Whenever you open an Access database, a file with the same name as the database and an extension of LDB will be opened automatically. For example if you open Northwind.mdb in the samples directory of your Access/Office installation, a file called Northwind.ldb will be generated. This new file keeps track of users and the objects that require some form of locking in the database. When all users have exited gracefully from the database, the LDB file is closed down and deleted.

thanks for rating

Microsoft Office... | Answered on Oct 12, 2017


NO
You PAY for MS Office, try http://www.openoffice.org/
FREE word processing program.

Microsoft Office... | Answered on Oct 21, 2016


accdb extentions must be opened with 2007 or later. 2007 and up will open ext.mdb. 2007-2010 will convert an mdb to accdb. 2013 will not convert but will open them.

Microsoft Office... | Answered on Feb 23, 2015


Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!

Microsoft Office... | Answered on Feb 23, 2015


install an antivirus app. most have privacy setting that can block a particular number.

only for android.

Microsoft Office... | Answered on Oct 17, 2013


check the folder type it may be just set for read only. the administrator has the option on the interface to see if the database is read only for others or if it is editable.

Microsoft Office... | Answered on Jan 10, 2013


First, make sure that the tables that you are using have some sort of Primary Key so that the correct records can be linked.

Next, choose 'Tools' -> 'Relationships' from the top menu.

Add the tables for which you want to link together. Drag the correct field from one table to the next table. A popup window should appear.

In the window that appears, choose the 'Enforce Referential Integrity' and 'Cascade Update Related Records' options.

Now, whenever you change the field in one of those tables, the corresponding filed in the other table should change as well.

Microsoft Office... | Answered on Dec 12, 2012


its hard to fully explain but you can download this file as an example to how you can solve the problem via running a simple query from which you can copy the new phone numbers for the new phone column and paste it on the old phone column . its just that easy .
go to http://drop.io/dalhelo
download the file ]sample.mdb[

all the best


Microsoft Office... | Answered on Jun 07, 2012


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Microsoft Office... | Answered on Nov 30, 2011


I don't really understand your problem. Is it a table you cannot see? or a Query? You may not be able to see some things unless you have a default printer set up on your computer. Access is weird about that. Please get back to me with more specifics. Thanks!

Microsoft Office... | Answered on Mar 16, 2011


make sure microsoft is compatble to your system 64+32bit.

Microsoft Office... | Answered on Feb 11, 2011


To parse a Text field that contains two words separated by a comma, follow these steps:
  1. Open any existing database.
  2. Create a table with the following structure: Table: Parse2Words
    ------------------
    Field Name: Empl
    Data Type: Text
  3. View the Parse2Words table in Datasheet view and type the following three records in the Empl field: Smith, John
    Callahan, Laura
    Fuller, Andrew
  4. Create the following query based on the Parse2Words table: Query: QueryTest
    ------------------------------------------------------------------
    Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1)
    Show: True
    Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1)
    Show: True

    NOTE: You can modify the QueryTest query to account for spaces between the two parts in the Empl field. For example, if the text in the Empl field is "Smith,John" without spaces, remove the -1 from the FirstName field expression.
  5. Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below: FirstName LastName
    --------------------
    John Smith
    Laura Callahan
    Andrew Fuller

Microsoft Office... | Answered on Jan 08, 2011


Microsoft Office Access 2003 product key

Microsoft Office... | Answered on Nov 12, 2010


If you mean free, you can download it from torrent sites like btjunkie and isohunt. You will need a torrent client like utorrent

Microsoft Office... | Answered on Oct 02, 2010


The easiest way to achieve your goal, would be to use a second interfacing application to hand the database operations. I suggest VisualBasic.

Microsoft Office... | Answered on Sep 07, 2010

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

85 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Office Microsoft

  • Office Microsoft

Most Popular Question

download microsoft office

  • Computers & Internet
Loading...