Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Access 2003
Pat B. - 21 Oct 2006 9:28 PM - 5 messages
Access 2003 did not come with my computer as the other office prorgrams did.  I am going to need this program because I am taking a medical billing course online and I will need it.  Can I download this program? I cannot afford to ...
Score TEMPLATE
BARBARA - 21 Oct 2006 6:47 PM - 2 messages
HOW DO I GET BLANK CELLS TO SHOW UP ON MY TEMPLATE I HAVE FOOTERS HEADERS AND ONE ROLL ...
Score Two quick questions
News - 21 Oct 2006 6:06 PM - 3 messages
Hi, Two very quick questions, I hope! 1. Is there anyway to change the default reference for a hyperlink. I have a field of Song Titles which I wish to link to mp3 files. If there is no file I want to link to a file called 'sorry.txt'. When I create a hyperlink it ...
Score invoice
Ray LaPoint - 21 Oct 2006 2:30 PM - 3 messages
I would like to create an invoice that has a ship to bill to and shipped from with each having different addresses. can some one steer me in the correct location to find help on doing this. ...
Score Input Mask Wizard CUSTOMIZE symbols
Alaskadjr1 - 21 Oct 2006 3:15 AM - 2 messages
Where can I find the symbols (for example: /!Lll; ##- etc), what they mean and how to input them to create a custom input mask. Specifically, I am trying to create a custom input mask to enter dates/times in the following format: ...
Score to enter month and year only
Faio Eric - 21 Oct 2006 1:41 AM - 3 messages
I need to construct a table or a form that allows only entering a month and year only. How can I do this? E.g I just need to enter "june 05". Will my my field type a date? or any suggestions apart from text type field? ...
Score Counting multiple Yes/No fields
Dj - 20 Oct 2006 8:46 PM - 4 messages
I have a table w/ multiple yes/no fields (i.e. pass roadtest?, pass  written test?).  I want to a tally the yes'.  How do I do that in a query or report.  Thx, Dj ...
Score Access and Oracle DB
Soddy - 20 Oct 2006 6:16 PM - 4 messages
Hello! I working with Access 2003 and have 'played' a bit with SQL Server 2005 Express and now I'm looking to getting 'familiar' with connecting to an Oracle DB and working with it.  I'm looking at the Oracle 10g Express ...
Score When I open Access, how can I show the database window?
donna - 20 Oct 2006 5:32 PM - 6 messages
I haven't changed any settings, but now when I open the db, there is no db window.  I checked start-up options, and "show DB window" is checked.  I don't have any switchboard.  TIA ...
Score Access Security for tables and queries
Robert Kemp - 20 Oct 2006 4:20 PM - 2 messages
How do i set up multiple security in one file, different users for different tables or queries? ...
Score How to empty all tables to start again new or flesh entry
Faio Eric - 20 Oct 2006 4:13 PM - 2 messages
I am a beginner in Access and we have reached the end of our data entry and therefore would like to start from the begining where we have an empty table to start from. Please show me how. Thanks ...
Score my computer tells me I have an unread message .It is not in my inb
virgin user - 20 Oct 2006 2:49 PM - 2 messages
When I turn on my computer the compaq owner tells me i have one unread message. There is no unread messages in my inbox. ...
Score How do I install Outlook Express using Win 98 on high speed ISP?
WGT - 20 Oct 2006 1:53 PM - 2 messages
Although I followed install instructions from ISP, the ISP (Charter) wants not involvement in the install/use of Outlook Express.  Although the option on one of the last MS Outlook Express gives me the option of choosing LAN (ISP confirms this is correct choice), nothing has happened.  I did not get ...
Score How to get different tallys from same query based on date range
Dj - 20 Oct 2006 12:45 PM - 3 messages
This seems like a very simply task, but I can't figure it out.  I have a table that covers data for the whole year.  I have a query that tally's one field of student's status (i.e. graduated, failed, voluntarily left, never ...
Score Pictures in Access form/report
Sharlene - 20 Oct 2006 3:19 AM - 5 messages
I have finally figured out the instructions from support.microsoft.com on the article ID 210100 from Aug. 11, 2005.  Looked all over this site but everyone was over my head on description and instructions for "New Access User" ...
Score how can i tell if i have powerpoint
jim - 20 Oct 2006 1:36 AM - 3 messages
...
Score Data does not show up in table
David - 20 Oct 2006 12:04 AM - 13 messages
When i manualy enter data into a form it gets displayed in it's table, however data that is generated from a forulma in the form does not get displayed. example: i have the fields "Qty", "RecievedQty" and "OnOrdQty". the control source for "OnOrdQty" is =nz(Qty)-(RecievedQty) ...
Score how do i connect to my Gmail account on outlook
Rick - 19 Oct 2006 10:06 PM - 2 messages
Im tring to email my contacts on outlook thru gmail, but I don't know how to setup outlook Help in Texas ...
Score Access won't run program
Sam - 19 Oct 2006 9:06 PM - 2 messages
I am using a program called "VREF".  This program uses Access "run time" 2000 ..  Everytime I load this program, the first evaluation page comes up, then the program closes.  I cannot use the program. I have called the company programmer, and outside of deleting the program ...
Score importing data from one table to another
Leigh Weems - 19 Oct 2006 7:15 PM - 6 messages
Hi,  I am very new to access and am in need of a bit of help.  I am currently working on an inventory system for our computers, and have all the data entered into Excel.  I have imported the spreadsheet into Access, but I would ...
Score print one record in a form without all the records in the table p
Joe L - 19 Oct 2006 7:12 PM - 2 messages
I am new how do I get the anwser to my question if  someone replies? I am at lun***@verizon.net ...
Score Long Formula's displayed in VB on Screen
Heiko K Stugg - 19 Oct 2006 1:34 PM - 6 messages
Easy One....but how do you break up a formula in VB so that you can see it on the screen without having to scroll right? ...
Score how to open mdb files
sarit - 19 Oct 2006 7:45 AM - 2 messages
how i should down load and open any *.mdb files? what is the appropriate programme to run *.mdb files? how to download these programmes ? please answer to me these questions very fast. ...
Score what happened to my database "Design Master"?
Goldtop LesPaul - 19 Oct 2006 3:08 AM - 3 messages
Ok I'm a simpleton, I just wanted a simple little database for my movie collection. I got it set up and all my data entered then moved the file to an external backup drive and copied it to my briefcases. Later I wanted to ...
Score Auto displaing data
David - 19 Oct 2006 1:41 AM - 5 messages
I have a look up box that i select a part number from, then i want the description to be dislpayed in the next text box. I have a table with all the part numbers and descriptions listed ...
Score how to embed a chart into a current worksheet
Sergio - 18 Oct 2006 11:22 PM - 2 messages
Hi folks I am a VERY VERY new user to computers in general and I am doing certificate 2 in Information Technology (Applications) at TAFE here in Queenstown Tasmania Australia and I am having alot of trouble with access at ...
Score I need help! My access database will not let me enter anymore.
jthhousing - 18 Oct 2006 10:43 PM - 4 messages
I am trying to update my clients for my program. However, my database says I can't leave it NULL> I am trying to enter the next number. It also says it is set to TRUE. Enter a value in this field. ????? ...
Score Search Access fields
Allan - 18 Oct 2006 9:46 PM - 3 messages
I am a new user of Microsoft Access.  I have setup a membership database providing fields for names, address, etc.  My organisation governs 12 clubs so within the database I have a field for each of the 12 clubs. ...
Score Create First & Last Name text string in Access 2003 Forms
murley79 - 18 Oct 2006 8:35 PM - 2 messages
I am newbie with Access database and I am trying to create the text of two fields into a single text string in Access 2003 Forms.  I have tried using "= [FirstName] &" "& [LastName] command but the system is only showing the first ...
Score Limit date input into query parameters.
hotrod1952 via AccessMonster.com - 18 Oct 2006 6:49 PM - 3 messages
I have a query which I have declared two input parameters. Period Start & Period End. I am using these dates in a query for payroll information. The Period start should always be a Monday and the Period End should always be ...
Score show create table - possible?
Mette Dencker - 18 Oct 2006 12:42 PM - 3 messages
Hi Does some command like "show create table <table name>" exist in ms access like in e.g. mySQL? Thanks! ...
Score Everything was working til I saved it in my docs.I can't open pg
Jupiter - 18 Oct 2006 10:41 AM - 2 messages
I had completed my site and all buttons and links were working.  After I saved it to my documents and tried to open it, I can only open my homepage.  When I went back into FrontPage, my pages were not listed on the folder list ...
Score sorting in desending order on access table with a lot of data
Ana - 18 Oct 2006 4:30 AM - 3 messages
Hello, I am a beginner with access and therefor my question might be a bit dumb. I have a table in access, contains 182,256 rows of data. I need to sort by gross sales total which is one of the columns on the table. When I select the ...
Score Form to populate a new table
Moops - 18 Oct 2006 2:43 AM - 7 messages
I have a DB that has three tables.  Two of the tables have data without a relationship.  These tables populate a form and subform.  When the user selects a "add" button on the form, I want to then take all the data from the ...
Score Can I have a record within a record
Rachelle - 18 Oct 2006 2:31 AM - 15 messages
I am creating a client database for my business.  Each of my clients has their own database of clients.  I need to keep their database of clients for each of them.   Is it possible to creat a contact within a contact ...
Score parse field
traygo - 17 Oct 2006 10:28 PM - 6 messages
Is it possible to parse a field without knowing the number of characters? I want to sort a text field that is made up of a value that has a number then Text then another number, such as: 27F821 or 1FD1222 ...
Score Tab Order
Eleanor of Aquitaine - 17 Oct 2006 10:28 PM - 7 messages
I have a form with two Tab Control Pages.  I've modified the tab order for each page.  Is there a way to link the two pages in the tab order?  After tabbing through the first Tab Control Page, I want to be able to go to the ...
Score alphabetize my drop down list in my forms
aaleo - 17 Oct 2006 8:20 PM - 2 messages
My drop down list in my forms is in alpha order but when I added new names to the table and sort ordered them, they do not sort order in the corresponding form.  They show up on the bottom of the list. ...
Score Saving data
Mary - 17 Oct 2006 8:04 PM - 5 messages
I have a purchasing log that I updated.  It seemed to be working fine, but now when you enter data for the part number and save it it changes all the part numbers from previous records to the new part number.  Any ideas of how ...
Score ACCESS 2003
terryr - 17 Oct 2006 7:46 PM - 7 messages
If a DB is set up using ACCESS 2003  will it function properly in the  2000 version? ...
Score Purchasing Log
Mary - 17 Oct 2006 7:42 PM - 3 messages
I updated our purchasing log.  Some of the information that was already saved is missing.  Is there any way to retreive it? I have access 2002. ...
Score Access Short Cut Keys
OldManEd - 17 Oct 2006 6:43 PM - 3 messages
Is there a keystroke combination that copies the contents of the field from the preceeding record into a new record? EdC ...
Score Drop down List Box?
Mary - 17 Oct 2006 6:25 PM - 3 messages
I'm new to access.  I'm trying to put a drop-down list box.  Can someone help me with this?  Thanks in advance. ...
Score go to first field in form
BrokeLady - 17 Oct 2006 4:36 PM - 4 messages
Hi, I am still learning, thanks for your patience. What is best way to have cursor automatically move to first field in a form when a new record is chosen?  Not sure where to enter the condition or exactly what syntax is.  Thanks. ...
Score Microsoft Digital Image 2006 Suite
Bettona - 17 Oct 2006 2:31 PM - 2 messages
I recently purchased MS Digital Image 2006 Suite in the U.S. for use on my computer in Italy.  I want to move my photos from the hard drive to a CD.  On page 119 of the manual which came with the product, to archive it says on ...
Score objword.document.open
Chris - 17 Oct 2006 2:25 PM - 4 messages
Hi Group. I would normally use objword.document.open("C:\file.doc") However, what if the document is already open and I am going to need to manipulate it?  What do I do then? ...
Score I need to have a macro to search VB code
Jcuster - 17 Oct 2006 1:48 PM - 3 messages
I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change it to ".FirstPageTray = 16642" inside the code. I also need to do the same thing with ".OtherPagesTray = xxxxxx" I do not want to do this by hand because I would have to visit over 200 ...
Score Continious forms record source loop
Chris - 17 Oct 2006 11:04 AM - 3 messages
Hello group, I have a main form (frmMain) and a subform (frmCrane) On frmMain I have a check box that when ticked will make all the checkboxes in the subform ticked. frmcrane is a continious form and therefore has around 19 tickboxes (1 for ...
Score maximum records in form view
Jotwo - 17 Oct 2006 10:13 AM - 7 messages
I have always used File Maker Pro because it is easy. However it does not support Hebrew, so I have Hebrew Access. I have designed a simple, flat database and made the form look just like what I used in FMP. ...
Score Need Help & Ideas
Stephanie Munden - 17 Oct 2006 2:55 AM - 2 messages
Hi... I have just bought a new Macintosh machine, and I am getting started in Microsoft Entourage, Though I am very familiar with Microsoft Outlook 2003 Small Business Edition, This is quit different... I was wonderring is there a way to get a password up there so that no one besides me can access ...
Score data ranges don't appear in access import wizard selection box
TechyTemp - 16 Oct 2006 8:06 PM - 3 messages
Can anyone tell me why my named ranges in excel won't import into access tables?  When you select the named ranges box in the import wizard the selection box lists a bunch of named ranges that don't even exist and none of ...
Score Old telephone Icon in office 2003 excel
Hastings - 16 Oct 2006 8:04 PM - 5 messages
What happened to the telephone Icon one could use to dial out in excel? ...
Score Records in a Table will not show up on Form.
wvl444 - 16 Oct 2006 7:06 PM - 3 messages
How do I get existing records in a Table to show up on the Form that I enter the data in? ...
Score Creating Phone Directory
Illini Josh - 16 Oct 2006 5:30 PM - 7 messages
I'm working on a emergency contact list that will be divided into departments and I'm wondering the best way to tackle it.  I used Lotus Approach years ago when I was in the Marines, but of course Access is a little different and I'm ...
Score Creating a new Access project
Mike@DMAS - 16 Oct 2006 5:04 PM - 2 messages
I need to create a new data base and have no problem with the database objects, forms, reports etc.  Where I fall flat is on the programming behind the scenes part.  Is there a model database out there that has a way to ...
Score Help with Notes field and Date Stamp
femfrog - 16 Oct 2006 5:02 PM - 6 messages
Hi, I've created a database to keep track of content in web pages. Since this is a rather large site encompassing pages from several different department, I would like to have a Notes field in a form to keep track of activities. ...
Score Reformatting partitioned HD into one partition
bobpa-215 - 16 Oct 2006 4:33 PM - 4 messages
My main HD is partitioned into c: d: e: and f:. I recently bought a 400G external. I'd like to reformat my 80G into one c: partition. How do I copy everything onto the 400G and then back again onto the c:? Is there good software ...
Score Conditional formatting
Chris - 16 Oct 2006 4:29 PM - 3 messages
hello Group, I need a continious form that can be edited by the user without updating the table. My thoughts are; Put unbound txtboxes onto the form and make them equal the bound controls. Then make the boound controls invisible ( or as near to invisible as they ...
Score creating forms?
Mary K - 16 Oct 2006 3:38 PM - 7 messages
I am very new to access.  I'm trying to creat a form by using autoform.  The problem that I'm having is my fields in my table are to long.  I need everything that I put in my table.  The form is wider then my paper.  It is ...
Score Compact an Access 2000 database within a macro
ricky.kimball - 16 Oct 2006 2:55 PM - 3 messages
I have an application (processing.mdb) database with most table linked to another access database (data.mdb)  I delete from interim processing tables as I'm finished with them, but data.mdb gets too big and I need to compact it.  I'd like to add a command within a macro in ...
Score Problems Installing Acces
Hicks - 16 Oct 2006 2:38 PM - 4 messages
I currently have MS Office Basic Addition 2003 on Laptop. I purchased Access 2003 thinking this would be correct version. Install stops and says " The product key you entered requires a version of MS Office 97, 2000 or XP to upgrade". I don't understand what the problem is. ...
Score Mouse Wheel -- Visual Basic
Mac@440th - 16 Oct 2006 1:33 PM - 2 messages
Greetings to All! I am currently using Access 2003 and I am having a very irritating problem with the Microsoft Optical Mouse w/Wheel.  I have no problem using wheel on forms, etc, but when I bring up the Visual Basic window, ...
Score How to copy and paste using Access
Kathrina - 16 Oct 2006 12:24 PM - 2 messages
Is it possible to copy the first line of a certain field down to the last line using MS Access without any rule at all. I tried but i am not successful. Am i missing something or it can't be? ...
Score just set up a 3-tab form but it won't let me enter data? just beep
cathknits - 15 Oct 2006 8:09 PM - 6 messages
Access 2003 it also will not let me add a new record, i.e., student? Form is to enter new students Tabs are: General Info, Education and Degree Info, and HR Info Some tables had more data than others. I'm trying to use this form to help ...
Score Northwind
Christo Yssel - 15 Oct 2006 5:59 PM - 3 messages
Hi, I can not seem to find the purpose of the order subtotal qry in the Northwind database which I think shipped with version 2003 Thanks Christo ...
Score Fill Field in same value
Hamoud Alrashid - 15 Oct 2006 4:51 PM - 4 messages
Hi, there I want to put "A" ltr in a filed in all records. Please help Have a great time ...
Score add 60% to value
add 60% - 15 Oct 2006 3:42 PM - 2 messages
how can i add 60% to totals on spreet sheet ...
Score I WANT HELP ABOUT MS ACCESS DATA BASE PLEAS PROVIDE HELP.
iftikhar ahmed - 15 Oct 2006 7:26 AM - 3 messages
SIR SEND ME GUIDE BOOK ABOUT THAT PROBLEM. ...
Score new field based on another field in the same table
David Ruderman - Chapman University - 15 Oct 2006 3:36 AM - 2 messages
I need to create a 5-digit zip field from another zip field that has a combination of 5 and 9 digit zips.  In Excel, I would just create a new column using left(zip code,5).  How do I do this in Access?  The table is too ...
Score random sample
JayL - 15 Oct 2006 1:31 AM - 3 messages
All - I have a table with just over 100,000 records.  I need to select a random sample of 10% and isolate that sample somehow. I remeber doing this in Excel using the @RAND function but I don't have a ...
Next »