Tech Newsgroups: Getting started with Microsoft Access

Outlook Contact Activities and MS Access?

scs - 4 Mar 2006 10:58 PM - 3 messages

I have a button on a customer form that sends a message to the customers email address. When I click the button a new Outlook 2003 message opens with the email address filled in. Very nice. If the customer happens to be in my outlook contacts I can view a log of ...

I have xp pro and powerpoint won't work and I can't find the file

chopperred - 4 Mar 2006 9:40 PM - 3 messages

E-mail attachment that want me to pick a program to open them or go to the web for help end up wanting powerpoint to open the file. I can't seem to locate it to find whats wrong with it. ...

calcuating Total-to-date

sljack63 - 4 Mar 2006 8:20 PM - 2 messages

I have a field in a table that holds the number of title points earned for that record tblAgilityRec.TitlePoint. Each record in tblShow has many records in tblAgilityRec. On my form for tblShow, I have a button ...

Have to cycle through parameter values twice to pull info.

Ron Weaver - 4 Mar 2006 5:16 PM - 12 messages

I have a form with a list box connected to a query. I am trying to limit the list to criteria between two dates. It finally works, but not until I cycle through the beginning and ending dates twice. Once in a while it works on the ...

Error Unbound text calc time

chopper57 via AccessMonster.com - 4 Mar 2006 4:45 PM - 7 messages

I have the following problem with a database that I am working on, the database is for daily reports and it tracks employee hours on the job site. I have a subform for entering: Employee Name, Start Time, Finish Time, Breaks, ...

The IF Staement if suitable to use

Michael to Ed - 4 Mar 2006 9:51 AM - 3 messages

we have about 100 different Players, all held in a Table. i would like to make a Query with an IF statement if thats possible. In my database i have various Tables; Players, Course, Game, ect. and would like to make a Report with the following. each player has a ...

Yes/No field check box

bejewell - 3 Mar 2006 9:45 PM - 5 messages

I have a yes/no field in my table. I have created a form for this table, but the control for this field shows up as a text box. How can I change this to be a check box, so that when the user checks the box the field in the tabls ...

SendObject with multiple strTo entries

JNariss - 3 Mar 2006 9:38 PM - 2 messages

Hello, I have nearly become an expert using the SendObject. However I have now run into a slight problem. I have this one form that did a fantasic job of emailing to a group of 4 people. Not 4 ordinary people but 4 ...

Index, Primary Key Issue

Tee See - 3 Mar 2006 9:19 PM - 4 messages

I receive the message "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data .......etc." The primary key is the only field that is "indexed with NO dulicates". One ...

saving data

alex - 3 Mar 2006 8:19 PM - 2 messages

hi whats the different methods in saving a database i'm alternathing between laptop& desktop and external hard drive.losing data here and there. will "briefcase" help me and or shall i upgrate to ms. sql server currently i'm working with ms.access 2003 ...

why do i keep getting spam

STOP MY SPAM - 3 Mar 2006 8:05 PM - 2 messages

I recently learned that I can send my spam email to missed-spam.comcast.net. I began doing that about a month ago, but the level of spam emails has not decreased. Now instead of deleting the spam, I spend MORE time reporting it ...

Choosing form input on query

NNlogistics - 3 Mar 2006 5:04 PM - 3 messages

Is there a way to choose which form to pick as the input on a query. When I am running a query that requires a date range, I build a form with the dates and reference the form in the criteria. If there were 2 forms that ...

Form sequence

zaps via AccessMonster.com - 3 Mar 2006 4:52 PM - 6 messages

Hi there, I created a form and have added all the fields I need. I then moved fields around, putting this one in front of this one, this one underneath. When I tabb through the form, it goes in the order I put the fields on my form, ...

Best way to add info to a table or query

bejewell - 3 Mar 2006 3:17 PM - 3 messages

This is probably a very obvious question, but being new to Access I am looking for some help... I am tracking registrants for a conference, some of whom will be exempt from paying the attendance fee. I would like to create a form that lists the ...

Re: dups in a query

bejewell - 3 Mar 2006 3:03 PM - 4 messages

I ran across this solution when looking for ways to eliminate dups in a query I'm creating...The SELECT DISTINCT option seems like the answer for me, but I'm not familiar with code in Access...can someone simplify this for me and ...

Crosstab not returning all results

Rob - 3 Mar 2006 11:33 AM - 3 messages

Hi, I am reasonably new to Ms access, I hope someone can point me in the right direction. I have a crosstab query set up with a row heading of "status" and a column heading of "teams". The status is always either ...

Error "You cancelled the previous operation"

Eamonn - 3 Mar 2006 11:06 AM - 4 messages

Hey I have a combo box programmed to return the numeric value selected in an another combo box. However when I click on a value that presents itself in my pull down menu in the combo box the form crashes and presents me with the ...

calculated data from forms to a table.

orsonros - 3 Mar 2006 2:57 AM - 9 messages

Hi! I want to know how to store calculated data from FORMS to a TABLE. Show me or please explain the method. Thanks ors ...

What data validation should I use if I want text but not number?

Chris - 2 Mar 2006 10:15 PM - 2 messages

Hi Please could you help me I want to enter text only (NO NUMBERs ALLOWED) What should I type. Chris ...

Value extract a value

AndyM - 2 Mar 2006 9:40 PM - 7 messages

I have a couple of issues: 1) I'm trying to get a checkbox to become checked if certain values are entered. For instance, if my "date" text box has any value, I'd like the checkbox to become checked. I'm assuming I will have to extract the value ...

Memo Field

Bruce - 2 Mar 2006 8:55 PM - 4 messages

Hi I'm using Access 97 & in a form I have a Memo field restricted to 1200 characters, although you can type away until the limit set by the coding is reached it will not allow me to Tab. Such as ...

records with multiple checkboxes

ocsshrw - 2 Mar 2006 8:00 PM - 3 messages

I'm trying to modify a database created by someone else. I have a table with a TestID, StudentID and results of tests where the results are in checkboxes. Within each test for each student there are 6 strands that I need the total ...

display database window command button

eilime55 - 2 Mar 2006 5:41 PM - 3 messages

I have created a switchboard for my database and would like one of the command button options to be "Display Database Window." There is an example of this in the sample database. The DW will be hidden, but I would like an ...

Schedule a Task in Access

Eric - 2 Mar 2006 5:01 PM - 2 messages

Hello everyone, I did not know where to post this, so I apologize if it is in the wrong form. I am trying to schedule a task in Access 97/Win XP to be able to send a email in Lotus Notes. I have the code for the Lotus Notes, but I am having a ...

Two back-ends, how define relationships?

mscertified - 2 Mar 2006 4:21 PM - 2 messages

I have to maintain an application that I did not write and is set up in a weird way. There are two back-ends, one is protected by a password and contains a mini-application to update referenece tables. There are no relationships ...

Declaring variables - basic question

Will - 2 Mar 2006 11:11 AM - 3 messages

I have found a number of instances in the database I have inherited where variables have been declared "Dim rs, rh, Dt As Recordset". Does this mean that rs, rh and Dt are all declared as recordsets or has the previous ...

create query def and create recordset.. help

SMA007 - 2 Mar 2006 12:12 AM - 4 messages

I am a new access user migrating from Approach. I discovered this code in a previous posting by Van T. Dinh... I have a form based on a table=newhire, I have another table = required, both have a field named "rec_" there are 6 fields of data that I want to ...

Too few parameters error in db.OpenRecordset

Reg - 2 Mar 2006 12:00 AM - 5 messages

I am getting this error: Runtime Error 3061 Too few parameters. Expected 1 at the line: Set rstSector = db.OpenRecordset(strSQL, dbOpenDynaset) ...

Display Search results in a List box

bejewell - 1 Mar 2006 5:57 PM - 5 messages

Please forgive me if this is an obvious question... My database houses a list of files and their locations on our company's network. My master query includes the file name, the file's current location, and its old location, among other things. ...

Dynamic Reports

Hannah B. - 1 Mar 2006 4:11 PM - 3 messages

I need help developing a dynamic report in which the fields in the report change. Not the field values, but the actual fields themselves. If the value of the field is null, then I do not want the field to appear on the report. ...

Sending data to Word or Excel

Bob - 1 Mar 2006 1:50 PM - 3 messages

Hi I have just installed Office 2003 on to a new computer and the links to send Access reports to Word or Excel are not available, where do I go to but this right? Thanks Bob ...

How do I obtain a copy of ?

RichRoShinnick - 1 Mar 2006 12:56 PM - 3 messages

I am having difficulties with MS Access. I want to use the wizard option and it tells me to load XP Professional with Front Page disc. How do I obtain this disc? The computer says I don't have Active X or something to that ...

read only

bob engler - 1 Mar 2006 6:15 AM - 3 messages

I have a Access 2003 table that is loaded with a VBA that works on 1 of my WINXP systems but not the other. It seems the 1 system says the DB is read only but I can't see how to change it. The system ...

Combo Box Display

O Wilson - 1 Mar 2006 1:47 AM - 3 messages

Hello, I have two related combo boxes named "cboIssuedTo" and "cboContact", both pulling data from table "Contacts". As of now, I have only been able to poplate cboContact with one item based on ContactID. I would like to ...

opening a .dbf file in MS Access

capnhud - 1 Mar 2006 12:55 AM - 6 messages

I was wondering how do I go about opening a .dbf file in MS Access because every time that I try to open this type of file I encounter an error. What do I need to do to prevent this from happening over and over. The message ...

listbox

danney - 28 Feb 2006 10:23 PM - 2 messages

how do i add data to listbox of 3 columns from a table ...

Clearing all the entries from form when

elli - 28 Feb 2006 6:44 PM - 3 messages

How do I get all the textboxes cleared when I leave the form or click the button? Tried almost anything and still the last username put to form stays on and on.... -elli- ...

highlight cell that cursor is in

JMspecial - 28 Feb 2006 4:55 PM - 3 messages

I am trying to figure out how to highlight a row all the way across (several columns) a table to show where the curor is. So if the cursor is on row 22 and in the 4th column, I want the entire row to be highlighted. If this is ...

subforms and searches

ragsman via AccessMonster.com - 28 Feb 2006 4:13 PM - 6 messages

I've been searching this site for a simple explanation of what I want to accomplish, but I can't seem to find it. I have a form with a subform in it (database view), and I would like to look ...

triggers

mcourter - 28 Feb 2006 12:44 PM - 5 messages

is there a good way to approximate a sql trigger within access - without using a forms after insert event? ...

Access in Office 2003

Angela Coventry - 28 Feb 2006 11:40 AM - 2 messages

I have update my client listing in access and when I print off the report is shows 'error' in the contacts first names - is there a way of changing this so that the first names are listed in my report ...

Selection of more than one entry on a combo pull down-nasty?? :-)

Eamonn - 28 Feb 2006 8:45 AM - 3 messages

Hey, I have a form set up that allows me to choose a single entry from a range of pull downs and I want to be able to chose two or more a pull down (combo box). Have been told this is very complex to do.... :-( ...

Excel on XP PRo, or SQL on Server 2003?

analyst - 28 Feb 2006 1:36 AM - 2 messages

I need to migrate an Excel app I developed ten years ago, that has evolved into something with a life of it's own. But I know little to nothing about database platforms and development. The Excel file stores info in 60 cells on each line of the spreadsheet, a ...

Spell Check

Ken - 28 Feb 2006 1:06 AM - 3 messages

How do I call Access 2000 spell check from a button controlled by a Visual Basic script? ...

Database Design Process Questions

tfskelly - 28 Feb 2006 1:03 AM - 6 messages

I think this is appropriate for this group, so here goes: I'm creating my first access database for my job. It is a computer/software catalog where I want to keep track of about 20-30 computers and servers, the software they currently have installed on ...

stop each sentence starting with a capital letter

Nana2919 - 28 Feb 2006 1:01 AM - 2 messages

In typing notes and memos in Word, each sentence is suddenly starting with a capital letter. How do I change that. I haven't changed any setting on my computer. ...

Default Values

Tee See - 28 Feb 2006 12:00 AM - 4 messages

When inputing data thru a form to a table I have a button which closes the form and which I wish to keep as that. How can I keep the last entry in the form as the default when I reopen the form? ...

Add a record only if

Tee See - 27 Feb 2006 10:12 PM - 4 messages

I know this has been asked many times before and I know I have the answer in a book but cannot seem to think of what the lookup would be. Want to add a record to a the "orders" table only if the customernumber is a ...

Create and Archive database

Doug_C - 27 Feb 2006 9:13 PM - 9 messages

Hello, Does anyone know of a site that would explain in full detail but yet easy enough to create an archive database that I can dump unused data from the primary database into with a click of a button? I have one on a database a developer created by he is no longer available an ...

My "View" command is missing from my main Access toolbar?

Westaradg - 27 Feb 2006 8:21 PM - 6 messages

I'm new to Access and am using a course on CD to learn how to use it, and the CD is asking me to click on the "View" command on my main tool bar up near "File" "Edit" etc is located and on my friends computer with the same 2003 ...

My curser doesn't work whenever I go to word. What do I do?

TJ - 27 Feb 2006 8:21 PM - 3 messages

...

import email

Strem - 27 Feb 2006 6:02 PM - 2 messages

is there anyway to import from outlook into access? i have a form online that send me the email form and i need to import those emails somehow into access? help sam ...

How do I create an Access training request database?

Michael the Nurse Educator - 27 Feb 2006 5:05 PM - 2 messages

I am a Nurse Educator; I coordinate corporate wellness classes. I would like to create a simple database/class request form that I could post on my company's intranet. The goal is for training managers to use drop-down menus ...

Form with subform suddenly causing Access to crash

GA - 27 Feb 2006 3:25 PM - 4 messages

If anybody can tell me what might be causing my problem, I'd be very grateful. We have an Access front end to a SQL back end. It's been working without any problems but has recently started to crash whenever one of the forms ...

Requiring Data in field on Form with enter new record in Subform

maria.ashby - 27 Feb 2006 3:11 PM - 2 messages

I have an existing table that I now require certain fields to be entered which it does with new records. How do I go about making the user fill in all the missing "required" fields on the main form before ...

Switchboard usage preventing my form loading data form my database

Eamonn - 27 Feb 2006 2:20 PM - 5 messages

Hey, I have a form set up that is working perfectly (it consists of a selection of combo boxes for selecting records from a linked in excel sheet.) I have now completed a switchboard which opens the form. One problem though -when ...

maximum text fieldsize

Reg - 27 Feb 2006 8:21 AM - 3 messages

I am stymied by the fact that the maximum text field size Access lets me have is 256 characters. How do I go about storing large chunks of text in my database? Thanks Reg ...

how do I get budget planner to open on my computer

bronza - 27 Feb 2006 6:57 AM - 2 messages

I bought budget planner and now I can't get it to open on my computer. What do I need to do? or do I get my money back. ...

Merge

Diane - 27 Feb 2006 5:50 AM - 2 messages

I want to create name tents with the name on both sides of the tent. I want to do this as a merge, using data from an exel file. This will require rotating the text on one side of name tent 360 deg.. I would also like to ...

Simple Query Question

Chuck Hildebrandt - 27 Feb 2006 4:59 AM - 11 messages

I want to query for all MLB pitchers who won 20 games and batted at least ..300 in the same season. I successfully linked my Pitchers and Batters table and inserted the calculated field for batting average ([H]/[AB]), ran the query, and it ...

Basic Tables Question

Chuck Hildebrandt - 27 Feb 2006 3:32 AM - 6 messages

I have Access 2003. It seems when I change a record, and go to close the sheet, there is no prompt asking me if I want to save the changes or cancel, which is certainly standard in Excel and Word. Is this by design? If so, ...

Report based on Query by Form User Interface Assistance?

scs - 26 Feb 2006 10:53 PM - 3 messages

I have created a query that uses criteria from 2 text boxes and 1 combo box located on a criteria form. I've added a commnad button on the form to run the query and then open the report in preview (using a macro). Everything ...

Duplicate records

Dr. Brad - 26 Feb 2006 9:54 PM - 3 messages

Good evening, I use Windows XP Pro and Access XP Pro (2003). I have a table with some duplicate records. I want to create a query that will select the records; however, I want only one copy of any duplicate ...

Help with a database design

Stibbz - 26 Feb 2006 7:28 PM - 5 messages

Here is my scenario for a small building which is booked for different occasions. If anyone could help me with the design of this database I would be very grateful. As I am very new to MS Access. 1. The occasional booking's must be made in advance - at least one week but ...

trying to open files already done dont know how

sarah.hannah - 26 Feb 2006 3:51 PM - 2 messages

...

Real Estate - Free post Your ads about property for sale.

WEBs.lt - 26 Feb 2006 3:44 PM - 2 messages

Real Estate - Free post Your ads about property for sale. You can join for free and post your ads about property for sale or for rent. [link] ...

Suggest Alternatives?

DanielWalters6 - 26 Feb 2006 1:30 PM - 5 messages

Can anyone suggest any database programs for MAC that open ACCESS .mdb files? Thankyou ...

need hELP.....

seachell - 26 Feb 2006 11:15 AM - 2 messages

after installing the SecretOneMaker, i put the "windows clean up on". The problem start here. I found out that it erased all my office application settings and system becaomes unstable. What I did next is to restore my ...

Report/Query based on two tables both on them many side.

scs - 26 Feb 2006 2:36 AM - 11 messages

I have the following tables in my database: tblCustomer CustomerID FirstName Etc. ----------- tblVisit VisitID CustomerID Date Etc. ----------- tblPayment PaymentID ...

Calculating an average in a report

Bailey - 26 Feb 2006 12:56 AM - 2 messages

The current database I am working on has numbers entered into the form view. I need those numbers and the average of the numbers to show in the report view and when I print. Can someone help me with this? ...

drop down boxes

Bailey - 26 Feb 2006 12:49 AM - 5 messages

I'm trying to create a drop down box in my form. This is the first time I have tried. Can anyone help me with this? ...