	AllExperts > Experts
	Search

About Hernan Sain
(Top Expert on this page)

Expertise
How to build a friendly application using MSAccess to be used to manage a small or medium size business in such a way that the program fit the company before the company fit the program.

Experience
I've been making application for small and medium size companies in Costa Rica for the last three years. I have taught to my clients to use not only the program I made but the MS Access program too.

Organizations
Centro de Estudios Sociales Economicos y Ambientales (Environment, Social and Economical Studies Center)CESEA. http://www.cesea.org

Education/Credentials
I attended analysis of systems in Instituto de Informatica de Entre Rios, Argentina by three years, and worked in area of computer science by almost 17 years.

You are here: Experts > Computing/Technology > Business Software > Using MS Access

Questions Answered By Expert Hernan Sain
In Category Using MS Access

Subject	Date Asked

Access 200 opening forms	10/10/2008
Q: I have a database and I open it from a desktop shortcut. This takes me to the Access screen and then ... A: go to main menu > Tools >Start 1.In the Show Form/Page section of the Start window, click the arow ...
pasar informacion de access a excel	10/9/2008
Q: Hola. Estoy trabajando con una base de datos en excel que contiene 20 columnas y mas de 1000 filas. ... A: debes exportar la tabla de access a excel abre Access y visualiza la ventana de base de datos (F11) ...
Using a combo box to update a field in another table	10/9/2008
Q: I'm using Access 2003 to keep track of people on a number of courses. I have a table set up with the ... A: create a form and attach the primary tabla as the form´s data source open the form in design view ...
Access forms	10/7/2008
Q: The purpose is keep a running log of transfers between stores. I have a form set up for the data ... A: open the form where the combo box is placed in design view wrightclick on the combo box and choose ...
DB throught Network	10/6/2008
Q: if I have server ,which has MS Access Database to be share in local network, in City "AA" and I ... A: I'm sorry but your question's contains is too complicated to be answered in this space. I advice ...
Access 97 to Access 2000	10/6/2008
Q: How are you doing? I'm wondering what should I do if I wanted to convert a file that was created in ... A: First, open Access 2000 Go to File > Open menu Navegate to your Access 97 file (or write down the ...
Numbering	8/12/2008
Q: I am creating a system and i want a field in form to generate numbers in sequence these numbers ... A: you can use this expression as data source in a text box in a form ...
Adding new records through a subform	8/11/2008
Q: This might seem like a simple question but it's boggling my mind. This is using Access 2002. I'm ... A: Hy Isabelle try the follow procedure: open the form containing the subform in design view select the ...
Access 2003 - Using a query to get a date result	8/6/2008
Q: I have created a report, and in this report I create a query and added a field which do a date ... A: dates in access are stored as real numbers these numbers represent date and hour when yoy enter an ...
inserting a picture into an already existing Access database	8/5/2008
Q: I am currently working with Access and have already created a database for students (I work at a ... A: I don't know a real solution for your answer. Here it is what I'll do if I had to put a picture ...
MS Access	8/4/2008
Q: I need to export data from a table to a fixed length text file and keep the order of the records ... A: to order a table by a field, that field must be indexed. open the table in design view and select ...
Print Button	6/4/2008
Q: is there anyway i could put a print button function in a form that order to print a page from ... A: open the form where you wont to put the button in design view open the tools window. clic the tools ...
Parameter Value	6/3/2008
Q: I am a beginner on MS Access, I have a database with information that is sorted through case #'s. I ... A: you can edit the properties of the report open the report in design view clic on the Properties ...
Calculations in a Table	4/16/2008
Q: I have used created Access databases and back in the day I used to create databases in Dos based ... A: you can do calculations in Access forms: say you have two text box in a form, say text_box_A and ...
ms-access	4/10/2008
Q: please i would like to know how to use formulas in access e.g to calculate 5% of a basic salary or ... A: it is a little more complicated than in excel you can use formulas in forms, in visual basic code ...
Display count results in textbox looking at selected item in combo box	4/7/2008
Q: Basically,i want to keep track/count of how many times an item is selected from combo box and put ... A: I´ll try writing a code like thhis: if (control in ComboBox ) = "Professor" then Counter = Counter ...
MS-Access	4/3/2008
Q: I created two programs on two different mdb files(followup and supplier details), I want to link the ... A: try with an hyperlink open the form from where you want to call the other database in design view ...
Access Report Sum Problem	12/26/2007
Q: I am creating a test database about a company's staff salaries. I created a Report called 'summrpt' ... A: You have to set a query as the report's data source instead of a table. Open the query in design ...
Datasheet view of main and sub form	12/14/2007
Q: I would like to create my own contact management db. I have a Companies table that has a 1 to many ... A: You can use the Companies table instead of a form based in Companies table. Open Companies table in ...
Updating multiple tables from 1 form	12/13/2007
Q: Im new to access and wish to be assisted. I have created 3 tables namely Suppliers, Assets, ... A: open the database window open Suppliers table in design view and add the follow field: IdSupplier ...
Switchboard	12/6/2007
Q: I have my switchboard opening on startup but it does not open maximized. I would like it to open in ... A: open the switchboard in design view and click on Properties button click on Events tab and click the ...
Input mask	12/4/2007
Q: I am trying to create a input mask for currency, what I would like it to do is when I type numbers ... A: Click on Windows Start button and open the Control Panel. Click ont REgional and Language Options. ...
Sorted by date	12/1/2007
Q: I am building a database in which I entered customer info in order of the dates I served them. Now, ... A: Click the Start button and open de the control panel (I'm using WindowsXp)if you are using the ...
Combined form?	11/13/2007
Q: I am trying to build my first database with Access 2002. I created two tables: CustomerContact and ... A: Put one table as data source of the main form Insert a subform with the second table as data source ...
example to find maximum in MS-Scess	11/13/2007
Q: How to use Max,Min and Count functions in MS Access Query A: You can use Max Min and Count functions in a continuos Form footer or Report footer to show the Max ...
MS Access Form Field List is Not Available	11/12/2007
Q: All, When I go to pull the field list to populate a text box with a field from my queries/tables, ... A: Are you viewing the form in design view? Open the form in design view, open the Properties box,clic ...
Calculating dates	11/12/2007
Q: , I have query in which i have two columns Actual Date and Exptected Date. I want to display only ... A: Try the follow sql sentence to display in the 3rd column a new field that shows the expected dates ...
Should I use Access?	10/30/2007
Q: I am using a database program to store lab test results. This program has many windows where I can ... A: YYou can use MS Access to build any kind of thatabase. You can get the same levels of functionality, ...
Printing forms	10/25/2007
Q: i have a form and when i go to print it, it comes out blank..not the text boxes, the hold page. just ... A: I never print forms. I think that you spent too much ink printing all graphics of the form, Instead ...
navigation between fields	10/23/2007
Q: How do I navigate between fields in a form using the "Enter" key? Everytime I hit the "Enter" key ... A: Open the form in design view If you can't see the detail section selector of the form, go to View / ...
re: plz help	10/22/2007
Q: i need to kno sum disadvantages for ms access its for my course work i have to compare excel with ... A: using excel, you don't have any way to be sure of not to write a text data type where it is ...
Switchboard	9/14/2007
Q: I have just started creating an access contacts directory. A very simple one I must say. I am a ... A: open the switchboard in design view open the Toolbox if it isn't opened yet (the Toolbox icon is in ...
MS Access Report	9/14/2007
Q: I save the path to a picture in the MS Access database. When I draw a MS Access report, I want the ... A: open the report in design view open the tool box and choose the Picture tool drag where you want to ...
Microsoft Access Scroll Bars	9/5/2007
Q: I am using Access 2003 and have a multi-tabbed database where I can click on various tabs on the top ... A: Open each page you have placed in your tabed form in design view Wright click on the detail section ...
sending e-mails	8/31/2007
Q: I have a database and I want to send some results (payments) to several people from my organization. ... A: You can use the Send Object action in VB code or in a Macro. It is easy to use a Macro and follow ...
Brierley	8/30/2007
Q: I could really use some help here. I took a course on Access a few years ago but still consider ... A: Ill be back in 30 ' Hy go to C:\Program Files\Microsoft Office\Office\1033 and run the file ...
date time split	8/29/2007
Q: I have two columns containing the date/time when an order was originated and when it was completed. ... A: you can use a third column in a form or report using a calculated field build a form with the ...
Rounding a decimal number on a report	8/29/2007
Q: I have a report that displays a Revision Level field as a decimal. The decimal can be less than 1.0 ... A: open the report in design view wright click the Revision Level field text box click on Properties ...
Access Question	8/28/2007
Q: How do I concatonate two text fields in my Access table? A: I don't understand what do you want to do. If you have two fields in a table the are concatenated ...
Brierley	8/28/2007
Q: I could really use some help here. I took a course on Access a few years ago but still consider ... A: when you secured your database, Access created a non secured back up of it. You can look for the ...
Using MS Access	8/24/2007
Q: How can I link a picture in forms and reports for each individual record in MS Access A: Add a field to the source table. set its type as OLE object open the table and copy and paste the ...
query	7/9/2007
Q: i have a field called date of admission in my table for patient and each time the patient is ... A: set the review date as a field in patient's table add the review date field as a text box in the ...
erasing	7/8/2007
Q: Hoe can I delete all data on my database, but leave everything else in tact? Thanx A: You can build a Delete Query for each table you want erase Open the database window clic on queries ...
msacess	7/6/2007
Q: how to calculate the total values in a particular column using msacess A: to place subtotals in a continuos form's row clck the Data tab and click the ellipsis in the Data ...
Security	7/2/2007
Q: I have a password on the database I created. How can I set it so that more than one person can be in ... A: 1) be sure that your database is written in the latest version of MS Access (according to the ...
Add a control to a form using VBA	7/2/2007
Q: I want to add a checkbox to a form using VBA. I try the following DoCmd.OpenForm ... A: Delete all VB code. Close the VB code editor. Open the form in design view Click the Toolbox in the ...
MS Access Questions	6/30/2007
Q: I am wanting to generate a new number automatically in a subform, but it cannot be stated in Design ... A: in the Payment text box of the form, wright click (in form design view), and click Properties choose ...
Filter Form by Combo Box	6/29/2007
Q: Hernan, Good afternoon. Here's what I am trying to do: -Create a form with multiple combo boxes ... A: but that's where you come as the knight in shining armor. I almost sent your question to the Too ...
Password Security	6/29/2007
Q: I am designing a database for 8 different users in MS Access 2003. I need to setup a password ... A: go to Tools, Security, User-Level security Wizard run the wizard and follow the instructions hints ...
SendObject Macro	6/22/2007
Q: I've created a Macro to email customers information, but need Acces to automatically lookup the ... A: You will need to write code to do that, the fucntion send doesn't have this capacity to lookup the ...
Unbinding a control	6/21/2007
Q: I have a query loads the specialty areas and competency levels for a given person. I then have a ... A: You have to have two related tables with the dield SpecialityId, the first table is the mother table ...
VBA code of security	6/19/2007
Q: Goodafternoon. Please could you help me, how could I write a code in VBA to protect one table in my ... A: I suggest you to use the security wizard to set the security of any or all objects in your database. ...
access	6/13/2007
Q: how to perform n get a simple calculation in access? A: The easiest way is in a form: Open a form with a table or query as a data source in design view. ...
AÑADIR NUEVOS CAMPOS EN FORMULARIO	6/11/2007
Q: Hermano, estoy trabajando en una base de datos existente y quiero añadir un campo nuevo a uno de los ... A: Estimado Armando No puedes añadir campos en un formulario si no están en una tabla. Debes añadir ...
A query problem	5/21/2007
Q: I had discovery how to handle to dates in a query I created, but this snytax error keeps coming up ... A: The best way to verify your Visual Basic syntax is using the Query Builder View, set you query ...
Importing a csv file	5/16/2007
Q: I have very limited knowledge of access so could you please explain fully in your reply. Here is myI ... A: Open your Access database. If Database Window is not open, press F11 to open it. Go to File menu Get ...
Sending a record from a form to another table	5/14/2007
Q: in my database, i have information about orders made and they are shown in a form. say for instance ... A: You may use an Update Query Open the Order Form in Design View Put a button using the Tool Box. ...
Selecting records	5/14/2007
Q: I have a table with a 20 fields, 5 of which I want to use for selecting records from the table. ... A: You need to build a Form as a menu of choices. Use the 20 fields Table as Data Source of the Form. ...
what software should I be using?	5/11/2007
Q: I work in an office with 4 networked PCs. 3 are the employees and the last being the supervisor. ... A: it seems you need a real database you can do it using Access or any other database builder. you have ...
Calendar in MS Access	5/10/2007
Q: good morning. Is it possible to have a calendar control in MS Access display the current date ... A: To add a Access Calendar open a form in design view. Click on Toolbox button in the Forms Design ...
MS-ACCESS FORMS AND REPORTS	5/10/2007
Q: Sir, 1. How to include a "BEEP" sound while using a data entry form 2. How to Suppress blank ... A: To include a Beep in a form, you have to open form in design view, open it properties, click on ...
Import cross tab excel report to Access database	5/9/2007
Q: I have a excel cross tab report and I am trying to import this data into Access database. The data ... A: A database table has a rigid structure, that is: columns represent fields and rows represent ...
using ms excel and access simultaneously	5/9/2007
Q: can u please guide for my project, in which i need to use combination of excel and access. and what ... A: You can link Excel with Access both ways: one statically, that is once you have got out your data ...
Switchboard	5/9/2007
Q: i have this problem about my switchboard.. supposedly, the default switchboard opens when you open ... A: Go to Tools item in the menu bar, click on StartUp option. On the Startup window go to the Display ...
Filtering with a combo box involved	5/8/2007
Q: I appreciate your help on the previous problem. This next question is a sort of step up from the ... A: You can use the Control Source of the Combo box. But you will note that that field is only for ...
Query Expression	5/8/2007
Q: I'm trying to retrieve only a portion of the data in a field to update into another table. I don't ... A: you have to use the InStr(String1,String2) to look up for the "(" position, then another InStr for ...
On Click Event Procedure	5/2/2007
Q: I have a Form, displaying 1 record of a table. On the form is a button, that if pressed (check box ... A: I can't understand your problem because I don't know if those fields in your form are bounded to a ...
How to set a unbound text box on a form to a value in a query	4/30/2007
Q: I am trying to set an unbound field on a form to a value in a query (txtRule = qryRuleName1) How ... A: You have to use an Update Query to do that. Right click on the unbound field and open its ...
How to use Search option in Form	4/23/2007
Q: have created a form and would like to use a "search" option which makes it simple for users to ... A: You can build a form with the table(s) you want to search data in as form data source go to design ...
new user using microsoft access	4/17/2007
Q: Can you guide me step by step for using microsoft Access ,as I am a new user. A: that could be out of the scope of this site. what you can do is go to the Internet and look for ...
search...	4/17/2007
Q: good am. how can i create a search form where: 1) the user must choose what field(client, amount, ... A: I don't understand what is the side textbox for. The combo box has a textbox to write in the value ...
Error - Adding data in subform Version: 2000 (9.0)	4/16/2007
Q: I'm trying to add data into a subform and I'm receiving this error: The changes you requested to ... A: the relationship is set main file [field]->child file [PrimaryKey-field] thus, every time you try to ...
date problem	4/16/2007
Q: i just found out that my date on my main form (by the way, my form is an add data form) is dependent ... A: try this: open the form in design view, go to Properties/Events/On Dbl Click and click the ellypsis ...
How do I limit the records I use in forms?	3/22/2007
Q: I want to know what mechanism(s) you can use to limit the data that you modify within a form. ... A: there are several ways. You can use a criteria in the criteria row of the query builder. go to the ...
Command Button Mail Merge	3/21/2007
Q: I am using MS Access 2000 (and 2003). Currently I have a mail merge that runs from a query, however ... A: Can you send me the query? Using code, you can use the follow: DoCmd.SendObject(ObjectType, ...
Hoe accessible is Microsoft access	3/9/2007
Q: You have been always a very helpful regarding any kind of Access problem. I am counting you to make ... A: You can get on line help and tutorials in the Internet. Access is very accessible relational ...
calculating time values	3/9/2007
Q: I set the fields as date/time short time, worked out the total hrs@work using formula ... A: you have four fields: StarWork, StarLunch, FinishLunch and FinishWork. set their format to Data/Time ...
Return to switchboard from a form	3/7/2007
Q: Using a switchboard item I have opened a form. What statements do I need to put in the close event ... A: If you open a new form from the switchboard you will return to the switchboard when you close it ...
MS Access - many questions	3/5/2007
Q: Greetings! I have moved from File Maker Pro to MS Access. I was petty good in File Maker, forgot it ... A: I make volunteer job in this site. I also build professional databases using Access as my profile ...
updating table using visual basic	2/14/2007
Q: i have some code that autamically sets a predetermined amount of days into a table "mytable" this ... A: Robert, I can't figure what your problem can be wihtout see the entire application. You know that ...
Calculations question	2/14/2007
Q: Good Morning: I created a form that sums up the product counts of my main table (i.e. dinner plates ... A: There are several ways to achieve your aim The one could be the simplest is the following: You have ...
Print Record as Report	2/13/2007
Q: I would like to print a form as a report. I have tried several different suggested methods but none ... A: It seems to me that what you need is to build a temporary one record table. To do thi, copy and ...
Identifying New data entries	2/12/2007
Q: I have a database created for entering in names of patient that need to have followed up testing. ... A: it is not possible to apply a filter to the format properties on a form or report field what I have ...
MS Access	2/6/2007
Q: I have 2 tables: Table 1 has Name, Date, Hours... The PK is Name and date Table 2 has Name, ... A: I think that what you want to do is to relate two tables when what you want to obtain as a result is ...
Access validation	2/5/2007
Q: I have a form with a date field.I need to check (validate)against the current date to make sure the ... A: Open the form in design view Point the text box where you placed the date field Click the Properties ...
Creating a email response to adding/changing data	1/31/2007
Q: I have a question regarding generating an e-mail stating changes were made to the database. What I'm ... A: I think all what you want to do is possible and seems to be easy to achieve. You can build an ...
access database and getting entries onto a document	1/29/2007
Q: I have a database and I need to be able to put entries from different tables into a word document ... A: My expertise area in this site is in using MSAccess as it, in order to obtain the maximum of ...
Mass updating a field in a table	1/11/2007
Q: Can someone please tell me if it is possible to do a mass update in Microsoft Access table. I have ... A: you may use an update query open the database window if it is not opened yet (F11) clic on queries ...
Filters	1/10/2007
Q: I have got a report that gets its information from a form called "Customer Complaints", the fields ... A: first: you have to have an Id field in the form's/report's data-source table. open the form in ...
Query Layout	1/10/2007
Q: I would like to use a query but I don't like how it looks like a table and I don't want people to be ... A: You can use a query as a data source for a form. In that form set default view property as continuos ...
Entity Relationship Model	1/10/2007
Q: I am currently building a Sales Estimating system for a company in the transportation industry. The ... A: You can build calculated fields in the select query, using the query builder. Then you can use these ...
update query	1/4/2007
Q: I have a database with names and addresses and some times I have a person with no phone # I need to ... A: make an auxiliary table with one field, no key, the same data type as the main table's phone # write ...
caculations	1/2/2007
Q: is there a way to format numbers in access as accounting numbers. it will let me do it in currency ... A: Custom Formats Custom number formats can have one to four sections with semicolons (;) as the list ...
Access Default Value	1/2/2007
Q: I want the default value in a form to use the value of another field on the form. e.g. in field ... A: It is not possible to do this in normal way. Nevertheless if you really need to do it, you can use ...
database using access	12/31/2006
Q: I am opening my own bail bonding company in three months and have researched many professional type ... A: With access you can build any middle size database that help you to manage your bussiness well. You ...
Using a search function in a query	12/28/2006
Q: I've been trying this very simple thing for days now and i just can't get around it! Here goes... I ... A: what you need is to build a form with a subform. the record soruce of the form must be a mother ...
please help	12/27/2006
Q: I need to know how to merge a table or quiary in MSACCESS with a document in MSWORD. Please try to ... A: you need to build firs a report based on that query or table. 1)design the table or query 2)build ...
Making calculations with different records of a table.	12/27/2006
Q: Hernan, Can You help me ? How can I make calculations between records of a table ? I Need to do ... A: the easiest way is to use a form with that table as record source (you can also, build first a ...
Access producing labels	12/24/2006
Q: I have Access 2002. My program produces addressed labels and shows on each label the number of ... A: You can use the count function. An easy way is to put in the form Footer of a continuos Form, a ...
Dependent Combo Box From Option Group	12/22/2006
Q: What I am trying to do is limit my end-users choices of departments in a drop down list based on ... A: You can put two combo boxes in a form, one for the option A and the other for the option B. The ...
Access	12/22/2006
Q: I have my datas in 'Microsoft Excel Comma Separated Values File' format. I want to dynamically ... A: You can import an MS Excel Comma Separated Values file to an MS Access Table. Go to the File /Get ...
Reports and Parameter Queries	12/21/2006
Q: I have a report based on a parameter query where I have to enter dates as a start and end date. I ... A: When you get the message "#Name?" in a box, that means that the control source of that box is out of ...
caculations	12/21/2006
Q: I am having troubles with my calculated fields in access. For some reason it is not only adding and ... A: I don't know what could be the problem. You can manage calculated fields in several different ...
add a picture to a form	12/21/2006
Q: I want to add a pictur to a form as MSAccess Northwind.mdb Employees form. for each record i can ... A: You can add a OLE object data type field to a table. Then, when you are focused on that field, you ...
Copy-And-Paste From Word 2000 to Access 2000	12/16/2006
Q: I am trying to manually copy (via the Windows clipboard) text data from a large Word document into ... A: you have to convert table to text first. In Word's menu, choose Table / Convert /Table to Text ...
Report	12/15/2006
Q: Well, I am building a small database for my company. After working with it for several weeks, I ... A: i can't understand what do you want to do. what are the query parameters for? are they for filter, ...
Reports	12/14/2006
Q: I have Invoice Print report. I have problem that I have Products and there serial Nos. I want ... A: I don't geto your point. Serial numbers are text data type when you read a serial-number label with ...
Importing from	12/14/2006
Q: i have like 1500 record in excel and one column like one field and each one of them is linked into ... A: try this in your excel file, write links literally in a new column, like this: http://www.yourlink ...
Append Query	12/14/2006
Q: I'm fairly new at this so pelase bear with me. I've created a form in MS Access. After each text ... A: What is the record source of the form? If the form's record source is the table Contacts, you don't ...
Read Only Access	12/14/2006
Q: We have a customized Access Database that we use to enter all of our clients, attendance, etc. What ... A: In the menu bar, choose Tools /Security /User-level security wizard. Follow the wizard instructions. ...
ODBC Failed when trying to open Access Database Form	12/12/2006
Q: Good Afternoon I'm getting the message ODBC Failed when trying to open a Access Database Form Any ... A: I don't know why it may be happening this. It could be due to many things. Access is itself a ...
From "Word" to "Access" automatically	12/12/2006
Q: I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it ... A: In Word you have to convert your table to text. You can do this choosing Convert option of the Table ...
querry help	12/12/2006
Q: I am very new to access so please forgive me if I offer too much info! I have a querry where I have ... A: Supouse you have a TableName with tow currency fields, Field1 and field2. In the query builder ...
entering data into tables using MS Access	12/12/2006
Q: I have created a table called contact_table in Microsoft Access 2002, i have also created a form ... A: In the database window click Table button.Open the Contacts table in design view. Go to the field's ...
counting checks	12/5/2006
Q: I am building a database in which I have a checklist...I am trying to add up total of checks per ... A: I can't see your question. Coul'd you send me futher information like the tables structure and ...
Field Format	12/4/2006
Q: Hey I have a form which has a field set to number (zip code) and has 9 spaces. It is formatted like ... A: sorry to be so late in answer you. You need to use a ten characters long Text Type field. Go to your ...
To Export Datas from table to excel	11/30/2006
Q: I have created a table and a form for data entry.I need your help here every month I have to Export ... A: You can build a report with the same structure and data than your form. (You can easily use the ...
Subform Question	11/28/2006
Q: I'm trying to build a form that one would enter company information on, which I have done, but I ... A: I think I can't see what you want to do. Perhaps if you send me the forms and the linked tables it ...
Adding blank rows to a report	11/23/2006
Q: I've created a simple report showing product code, size, description and price. On the same sheet is ... A: You can automatically add blank lines to your report using this code: RecordNumber = ...
Input data into access	11/22/2006
Q: Is there a way to input data into a microsoft access database using a barcode scanner? A: Actually a barcode scanner reading is like to press a key of the keyboard followed by an Enter or a ...
Copy & Paste between different softwares	11/22/2006
Q: i have two inventories (1 in Word and the other in Excel). I need to transfer that information into ... A: You can import data from Excel to Access using the import data wizard, provided that your Excel ...
AutoNumber - Renumbering	11/21/2006
Q: I have a table which has some autonumbers. I deleted some records and now the autonumbers go like ... A: what you can do is to copy the file in a new temporary file, (structure only). then open both files ...
Output to MS-DOS	11/21/2006
Q: I have been using Access 2000 version for our school database. I have created a number of reports ... A: You have to uninstall Office 2003 and re-install Office 2000. I don't work with Office 2003 because ...
Creating a query	11/20/2006
Q: I have a table with two fields (columns). The first field contains a unique ordinal number for ... A: You can't do it using a query because when you put a criteria in a criteria query row, that means ...
Pictures in MS Access	11/17/2006
Q: Just wondering what is the best possible way to store pictures in a ms access database so that the ... A: In the design view of the report, got to the Insert menu, choose the Picture option and look up for ...
sharing access database	11/17/2006
Q: Good day, I created a database for the team I work with in the office and need to share the database ... A: I'll answer your question assumming you have Windows XP installed in the PCs you wont to connect.Go ...

All Questions in This Category