Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Forms design for one-to-one tables
Babe in the Woods - 4 Feb 2006 8:22 PM - 5 messages
What's the best way to design a form to populate a table (tblPhase2), which is related on a one-to-one basis with another table (tblPhase1) which has already been populated.  I would like the user to enter the data from three ...
Score I am looking for a way to track electrical usage for my home by KW
Angelo - 4 Feb 2006 7:58 PM - 2 messages
...
Score how do i get a free version of office 2004
.......louise........ - 4 Feb 2006 7:38 PM - 2 messages
i dont get it could any one help me ? ...
Score MY PASSWORD NOT OPENING MY DOC
NASIM AHMED - 4 Feb 2006 5:22 PM - 2 messages
file name: REQUEST, PASSWORD: IN CAPS: ANNUSSALEEM, NOT OPENING THE FILE I AM 100% SURE MY PASSWORD, PLEASE HELP ME OUT. ...
Score autonumber error
Mediatalker - 4 Feb 2006 2:58 PM - 3 messages
my "ID" field counts from 1 to 2 in the scend record just fine, but, when I go to the 3rd record "(autonumber) pops up and the form navigation will not allow me to create a 4th record. ...
Score How do I get the initial "Database Window w/Objects"?
Frustrated - 4 Feb 2006 1:07 PM - 4 messages
I am TRYING to find the table, form, and report objects.  Anyone know how to get the Database Window to come up initially so I can name it and begin entering my information, etc.?  I'm very new to Access and have been trying ...
Score Help with relationsips
jro via AccessMonster.com - 3 Feb 2006 9:20 PM - 9 messages
I am trying to design a data base that will track our employees daily register receits. I need to set up the relationships so that each clerk can have a daily financial report  for their shift, but there can only be one ...
Score How to copy OLE fields between two tables
marcm - 3 Feb 2006 8:57 PM - 2 messages
Hi folks, I have an Access database containing two tables.  The first table (tblSource) contains an OLE field in which Word documents are embedded. The second table (tblDestination) is similar to the first one, as it contains also an OLE field for Word documents.  I created a form based ...
Score Protecting a field within a form
sonfitz - 3 Feb 2006 5:10 PM - 9 messages
I am new to the security part of this but I see that you can restrict groups to update a table.  Is there any way that based upon a signon that you can restrict a particular field unless the user has certain permissions? ...
Score How do I convert an all caps document to all lower case?
spin doctor - 3 Feb 2006 3:38 PM - 2 messages
...
Score Find a record in a table, based on a criteria, and use it in another form
Justin - 3 Feb 2006 3:23 PM - 3 messages
Hi All, I have a form that needs to find the next available order number (located in table OrderNumber) and use it in the form when adding a new order. I need to know the following please; -how to open the table from the form ...
Score Outlook 2003
smartin400 - 3 Feb 2006 3:12 PM - 2 messages
I have seven large duplicate emails in my junk email folder.  When I try to delete them, Outlook locks up.  How do I delete them? ...
Score puppy contracts
puppy contracts - 3 Feb 2006 11:30 AM - 2 messages
trying to find a site where I can use the contract to creat apuppy forsale contract>? ...
Score When one field depends on another
JMF - 3 Feb 2006 9:49 AM - 3 messages
I realize this subject has been discussed in various forms other times, but I need to make another pass through it. The last time I saw it was when a poster wrote that he had makes of cars (Ford, Toyota, etc.) and wanted another field to have the specific model. ...
Score How to make a query run after changing criteria from a form??
Rocky - 2 Feb 2006 10:46 PM - 2 messages
Issue: Can't get a responce from a query. Have a form to create records in a table. Using a parameter query to return results to a custom Dialog Box. Custom Dialog Box has 12 combo boxes to reset criteria in the query which ...
Score print command button- multiple copies
Karen TS - 2 Feb 2006 10:12 PM - 2 messages
I have a print command button on my form. Is there a way to get it to print 3 copies when it is selected only one time? Or do I have to select it 3 times? ...
Score Problem in Access mail merge
LouVan - 2 Feb 2006 8:11 PM - 2 messages
I need help in access mail merge please I would like to create a mail merge letter addressed to medical patients. The data source is a list of medical patients, doctors, facilities, dates of service & procedures for each patient of that doctor. ...
Score Anybody ever set up a library catalog in Access?
phenfield - 2 Feb 2006 8:07 PM - 2 messages
I have been given the assignment at my office to create a library for various articles, mostly in .pdf format.  Storage is not the problem, but I would like to create a database that would allow me (or perhaps others) to search ...
Score Cannot find the 'database' for Forms Wizard
frank - 2 Feb 2006 6:37 PM - 2 messages
New to Access. Need to create forms. When I log onto Access, I do not see where the database is to create forms. Can someone provide me the steps? Thanks ...
Score database that contains employee travel details
AJ - 2 Feb 2006 5:51 PM - 2 messages
I have an excel spread sheet that contains employees business travel details with the headings:  Traveller; Travel Date; Cost Centre; Division; Airport 1; Airport 2; Airport 3; Airline; Stadard Fare, Fare Offered; Fare Paid; Taxes; Savings accepted; Savings Declined.  ...
Score data base for driving directions
MsMany - 2 Feb 2006 3:27 PM - 4 messages
I would like to create a data base containing customers addresses and driving directions to their locations ...
Score Bank account database & sum of column
Rasoul Khoshravan Azar - 2 Feb 2006 7:52 AM - 3 messages
I want to make a bank note database in access2000. My fields: TransactionId (autonumber) PK BankName Amount (positive numbers for deposits and minus numbers for withdrawal) I considered one field for deposits and withdrawals but it is possible to take two fields for them separately. They might have their advantage and ...
Score easiest way to use CMS documentation? Word 03
Steve - 2 Feb 2006 4:56 AM - 2 messages
I am in an eng. 102 class and have never used CMS before. I need to know if there are shortcuts to documentation.  Please help me!! ...
Score Access2003 slower.
Frank Martin - 1 Feb 2006 11:23 PM - 3 messages
I upgraded to 2003 from 2000 recently by creating a new empty database in 2003 and then importing all the objects from the old one. But now some parts of Access2003 are slower, such as the use of pop-up zoom boxes and some ...
Score merge names tfrom a spread sheet to one page not a label
Merry Widow - 1 Feb 2006 9:21 PM - 2 messages
i want to usse my list of stucents to make a list.  they are in a spreadsheet with first names in one column and second names in another. i try to do this from a data base also and can't get it to work. my old 3.0 ...
Score Issues with forms and subforms
UncleOli - 1 Feb 2006 9:00 PM - 5 messages
Microsoft Access 2003 I have an "Edit record" button on a subform (as for detail line items in an invoice for a particular customer) to enable allowedits when it is clicked. How do I disable allowedits when moving to a new set of records (as for a new ...
Score XML Import
mcnewsxp - 1 Feb 2006 7:29 PM - 2 messages
anyone have any good ideas about how to import XML files inot access tables using 2000 or 2002.  it seems these versions ignore the DDT and make every column a text field. is this correct? what to do? tia, ...
Score Iif in a Form
Rags - 1 Feb 2006 4:23 PM - 6 messages
Hello,   I'm a new user and trying to figure out how to get iif to work in a form. I have a 'Complete' field (Yes/No) check box and a 'Completetime' field in my record. When I check off the 'Complete' box I want the current date (NOW()) ...
Score Linking to specific Excel spreadsheet from Access form
Decembersonata - 1 Feb 2006 3:51 PM - 3 messages
My access db relies on information that first must be reformatted using Excel.  On my Add New Record form, I want to link to this Excel spreadsheet using a command button.  How do I specifiy the specific spreadsheet to be ...
Score Displaying Query Results on a Form
Angeline - 1 Feb 2006 11:16 AM - 9 messages
Hello, Can someone please help me. I would like to display query results on a form. I have built a database (most of which without VB but using the functions and a little help here and there from you wonderful people), and have a form with ...
Score Access 2000 file format
Jenny - 1 Feb 2006 10:46 AM - 5 messages
Hi all Although all users have Access 2002, my database now says (Access 2000 file format) at the top of the database window when opened on any PC.  Anyone know what I can do to convert it back to 2002 format please? ...
Score How can I put my Access database into flash?
DIMOZ - 1 Feb 2006 8:39 AM - 3 messages
I have my project about using Access as databese and I want to display it in Flash format. What can I do ? ...
Score Copying Data into Access
Mike - 1 Feb 2006 3:17 AM - 3 messages
Is it possible to copy Data into access directly such as this Name    Mike Address 3333 heldfer lane ss# 111-11-1111 The data has the header as well and i want to copy and paste and dump it ...
Score Why are my jpg attachments being received as windata files?
eumikey - 1 Feb 2006 2:24 AM - 2 messages
When I send .jpg files to my friends as an attachment, a lot of them aren't able to open them and I'm told they are in winmail.dat form. How can I fix this problem? ...
Score Cancel still adds record
Tee See - 1 Feb 2006 12:26 AM - 23 messages
On a popup form I have a button to close the form. If the form is open to ADD a record and the user changes his/her mind I'd like to close the form without adding a blank record. The following bit of code (I thought) would ...
Score self publishing a booklet
Christine - 31 Jan 2006 7:40 PM - 3 messages
Hi I am new to this group. I am looking for a self pblishing programme for a booklet. What is the best programme to use?  I have Mocrosft XP installed. Thanks ...
Score Update a table the 1st time the db is opened
Hlewis - 31 Jan 2006 7:07 PM - 5 messages
I have an update query that I want to run the first time a db is opened.  This of course will be based on rather or not a linked table has been updated for that day.  How can I do this? ...
Score Combining tables in a query
Matt T. - 31 Jan 2006 6:26 PM - 5 messages
I am having a bit of difficulty. I have built all the tables that I need (I think) for my spare parts database. It includes information like part number, description, initial qty, qty ordered, qty used, initial cost, new cost ..... ...
Score queries
Jerry - 31 Jan 2006 6:20 PM - 2 messages
I am trying to create a make table query but when I click get the new query dialog box I only have five options for queries and make table is not one of them.  I am using 2003.  How do I get these other queries (append, etc.)? ...
Score Importing Tables
Regi - 31 Jan 2006 5:19 PM - 3 messages
I have 5 tables I need to bring over into Access for a report done every two weeks. This data starts in Impromptu and I've been using Excel to import them into Access.  I have found that in order to update the data(re import it) I ...
Score how to reference nearly common fields
loony - 31 Jan 2006 3:58 PM - 2 messages
I'M NEW TO ACCESS. PLEASE BE PATIENT. I'm setting up a club membership that contains the usual name, and address, email, & phone number etc... For most of the records the mailing address is the same as the home address. ...
Score Linked Excel Spreedsheet
Regi - 31 Jan 2006 3:44 PM - 2 messages
I've linked a couple of Excel Spreedsheets into Access. However, if I try to change the Index for example it won't let me. What am I doing wrong? Thanks ...
Score Compact and Repair
Dryder - 31 Jan 2006 12:31 PM - 6 messages
I have database that is stored on a shared network drive, its size is 685mb, to Compact and Repair I copy the database to my desktop, Compact and Repair and get it down to 73mb, I then copy it back to the network drive. The ...
Score Database for email contact addresses
VickyB - 31 Jan 2006 10:11 AM - 2 messages
I send out a newsletter to my customers and I would like to start to use Access database to keep there email addresses in. I need to sort them ino different groups making sure that I do not duplicate an email address in the ...
Score Auto Add Data
John Calder - 31 Jan 2006 7:06 AM - 6 messages
Hi I run Win2k with Access 2k. I have posted this question a couple of times and although people have tried to help me I just dont get it. This is my problem; I have a table called "Colours" In column 1 (called Code) I have a unique number ie EX90028-D ...
Score Form - seems simple???
KayCarlson - 31 Jan 2006 6:09 AM - 4 messages
I need to add a couple of fields to a form that has already been created. The labels are in the form header and the text boxes in detail.  When I add an item out of the field list I cannot figure out how to get the label in the ...
Score How do I integrate A database with webpages?
Sovietwigglything - 31 Jan 2006 1:45 AM - 3 messages
I am currently working on a project that requires me to integrate an access database with A webpage for my school's alumni assoc. I've got Access, mySQL and knowledge of SQL. What more do I need in the way of programs and/or ...
Score Changing From One Form to Another
Tee See - 31 Jan 2006 1:09 AM - 2 messages
I have a Combo box on frmMyForm1 and a subform which displays the results of the lookup based on the Combo box. I would like to Double Click on one field of the output crlItemCode, close frmMyForm1, open frmMyForm2 and have it display the info about the itemCode ...
Score Changing from capital to small letters
Dimitris - 30 Jan 2006 11:19 PM - 13 messages
Hello I have a table in which there is a field LNAME in which last names have been entered with capitol letters. For example: SMITH. I want to change them to small letters except the first one, so it will ...
Score transfer data in access
Miguel Vivar - 30 Jan 2006 6:20 PM - 3 messages
I understand that the data in tables from Microsoft access can be transferred to Microsoft Excel. However, I wonder if access allows you to tranfer data directly to other programs such as SPSS (statistical program).  This program has some similarities with Excel, but they're not the same, and if this is ...
Score Query similar data
xgirl - 30 Jan 2006 6:02 PM - 4 messages
Hi, I have a list of numbers in an access table that have a leading zero.  The table I am trying to query with has the same list but does not always have this leading zero.  Is there a way to do a similar type query?  The ...
Score Contact management in Access -- the question of emails
Stephen Glynn - 30 Jan 2006 6:01 PM - 2 messages
I understand how to send emails from Access and, with the help of this newsgroup, how to send letters, too.   Consequently, I'll have in the database a record of my outward correspondence that I can sort by ...
Score How do I report no data found in query, other than a blank page?
Percy - 30 Jan 2006 5:40 PM - 4 messages
I am writting a general query builder and need to report to the user that their query did not return any records.  Just a blank piece of paper in not acceptable. ...
Score mdb -> xls
pm - 30 Jan 2006 4:58 PM - 6 messages
hello, does anybody know how can i convert access mdb into excel xls file (mdb table into xls sheet) is it possible at all? i have almost 100 mdbs to convert best regards ps. i hope i wrote on proper newsgroup (if not, please write what ...
Score make some database for membership for some Org.(Coordinations)
Omiad - 30 Jan 2006 3:56 PM - 2 messages
Make 2 Data Base in MS-Access (Tempeletes) one will be  Activities data base and other about membership of NGOs/Org ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I ...
Score what is the nntp server name?
setting up outlook - 30 Jan 2006 3:46 PM - 3 messages
I'm having a hard time setting up the outloox express and adding different e-mail addresses to accessed from my outlook ...
Score Problems opening database
k.roberts@ucas.ac.uk - 30 Jan 2006 12:09 PM - 7 messages
I have created a database and placed it on our network server. People are reporting problems with opening the database, specifically a message on opening the database stating it is read only. I have checked database properties - it is not read only, and have also ...
Score crediting or debiting an account
Bert - 30 Jan 2006 1:53 AM - 4 messages
Hi all, This is my first post here I hope it is clear - any help is useful I have a table with people's account balances. I want to be able to add money or subtract it from their accounts. ...
Score bound fields
ledbyrain - 29 Jan 2006 10:37 PM - 3 messages
Hi again, For the field "prior education," I want to make a drop-down box that has options such as high school, GED, college, etc.  However, I want numbers to appear in the actual datasheet rather than text (e.g. high school = 1, GED = ...
Score Creating reports
JudyT - 29 Jan 2006 10:20 PM - 4 messages
I need assistance creating reports... Ok, I have several tables that are in relationship with my main roster by empNumb. the tables are employees and their training throughout the year.  I have created a report that has a parameter form popup when this report is run ...
Score record keeping for private social club including finances
ubela - 29 Jan 2006 9:41 PM - 2 messages
...
Score question re: adding fields
ledbyrain - 29 Jan 2006 9:32 PM - 2 messages
I'm going to have a few questions today.  I'm sorry to bother people so much. Is it possible to add a field in the datasheet design view and have it show up on my form?  I've already started formatting my form to make it look nice ...
Score changing field name in form
ledbyrain - 29 Jan 2006 9:26 PM - 4 messages
Hello, I am creating a form for data entry.  The data will eventually be exported to SPSS statistical software, which limits field names to 8 characters.  In order to make things easier, I've given all of my field names in Access 8 ...
Score Get Parameter Popup when trying to run
Akrt48 - 29 Jan 2006 8:40 PM - 3 messages
I am having a problem when I try to run this append query, I keep getting a pop up for a parameter query in DDAYS and I can't figure out what I have done wrong.  It was working well and then I corrected the dates to make sense and ...
Score Bookmark
laura - 29 Jan 2006 7:36 PM - 3 messages
I need to know how to save or bookmark a record so I can go back to it when I requery a form. My form is based on a query which I created in the Query Design window. I have a ClientID number which I could save to a variable, ...
Score SUBTRACT DAYS FROM DATE
Akrt48 - 29 Jan 2006 6:50 PM - 4 messages
I have a very simple problem, but can't get it.  I have a date stored in text format, I want to take 7 days from it.  I have tried [date]-7 which works fine until we get one that goes backwards to 2005, then it doesn't work.  I ...
Score Displaying data in lookup table?
Steve - 29 Jan 2006 3:20 PM - 3 messages
Here's some newbie questions that are slowing me down this weekend.  I have a form used for displaying information based on a query using tblApplication and tblPerson.  How do I get the form to display the name of the ...
Score How do I use multiple IFF() condition in Accsess?
Nad - 29 Jan 2006 10:16 AM - 3 messages
I want use multiple Iff condition in Acsess databse like we do in Excel. I am giving an example of Excel. If(A1=1,"One",if(A1=2,"Two","Three")). Pls answer me. ...
Score drop down box question
steve goodrich - 29 Jan 2006 2:10 AM - 4 messages
i have a staff database set up with part of the form for vehicle details, reg, make, model, colour.  at the moment i type the details in manually. i would like to use drop down boxes for the make and model fields.  i know ...
Score Automating Word from Access
Stephen Glynn - 29 Jan 2006 12:19 AM - 3 messages
I've used the code at described in 'How to send the current record to Word 2000 with automation' ([link] to do what it says on the can.   It works by opening a Word document ...
Next »