Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score repair document
Lisbeth - 20 May 2006 4:17 PM - 2 messages
I was copying and pasting a document. I accidently deledted the first two sentences. The document was pasted. How do I repair my document and send it again? ...
Score Need help changing a database
Jim - 20 May 2006 1:03 PM - 6 messages
We receive payments from clients on either a monthly or quarterly basis. We then print a simple report listing each clients name, payment amount, and day of payment in a column with the total payment at the bottom of the ...
Score #name? message in control box
zachnjoe - 19 May 2006 8:10 PM - 5 messages
I have the following expression as my Controlsource.  [PEN] is calculated elsewhere on my form and [PEN_MAX] is pulled from table [WPS Data].  I keep getting the error message. =IIf([PEN]=[WPS Data]!PEN_MAX,"Bad","Good") ...
Score Adding two fields together to total another field.
MLoftus - 19 May 2006 7:59 PM - 2 messages
Hi, I am trying to create a database for a service department. I want to sum up all of the hours in each field to total the "total collectable hours" field. I heard that you shouldn't do it in the actual table, so where and how ...
Score RunCommand in a macro
Ted - 19 May 2006 6:47 PM - 6 messages
I am getting an error that tells me the "Run" command is not available in my db when I execute a macro. I am trying to use a macro to execute an append query. I used to do this all the time in Access 2000, but now that I have ...
Score HOW DO I SEARCH FOR AN ITEM IN MULTIPLE CALENDER'S
PS1 HAWORTH - 19 May 2006 6:21 PM - 2 messages
HOW DO I SEARCH FOR AN ITEM IN MULTIPLE CALENDER'S ...
Score Conditional Average in Query
Jay - 19 May 2006 6:05 PM - 12 messages
Hi, I have a table with a number of numerical fields. Each of these fields has a related checkbox field.  What I want to do in the query is average the numerical fields if the related check box is ticked. ...
Score how do i open a database?
las - 19 May 2006 5:10 PM - 5 messages
Everytime I try to open a database that is from a disk the message "THE FILE YOU HAVE TRIED TO OPEN MAY BE CORRUPTED OR MAY BE A FILE TYPE THAT THE DATABASE CANT OPEN" Does anybody know how I succeed in opening a database ...
Score can I print a one month/page calender?
LMW - 19 May 2006 4:27 PM - 2 messages
I would like to post a printed monhly calender. Just of that month. Can I do this? ...
Score report and subreport problems
wildmantaz - 19 May 2006 4:08 PM - 2 messages
Hi, There I'm new at this stuff so forgive me. I have a main report: "PurchaseOrders" in this report I need a subreport "Inventory Transactions" that has the same PurchaseOrderID as the Main report. I can get them to show up but as soon as i create another Purchase ...
Score multiple choice questions
Raiya - 19 May 2006 1:03 PM - 4 messages
Hi, I'm new in this forum and you can say I'm a new M Access user. Is it possiple to use M Access to make a programe that displays multiple choice questions for sudents? ...
Score Access table & form: find word entered by user anywhere in table
Arlene - 19 May 2006 12:13 PM - 3 messages
User will enter a word on a form and I then want to search ALL the fields of a table for that word. How? ...
Score Combo Box Problem
GregInOz - 19 May 2006 7:48 AM - 4 messages
Hi guys, I have a few very basic tables that i would like to combine into a query that a combo box can lookup. example: Table : OilFilter Fields: OilId (autonumber)           Oil Filter ...
Score More than one user at once?
Jay - 19 May 2006 6:21 AM - 7 messages
I have been attempting to ensure more than once person can use a particular database at once.  Going on previous advice I received here, I checked the network folder holding the database , as was advised that all users of the ...
Score Validation Rules
Jay - 19 May 2006 6:11 AM - 24 messages
I have two date fields in the same table & I want a validation rule to ensure that date2 >= date1, for each record. I have tried the same syntax as, say a select statament (square brackets etc.) but can't get it to work? ...
Score Make one selection and saving other results
Valdoe - 19 May 2006 1:20 AM - 2 messages
Please help I am trying to make an order form What I need is to select a category and when I do it gives me the list of products in that group only that i can choose from am novice talk English not techo - step by step please or example ...
Score Sending Data in an E-mail
Miguel - 18 May 2006 10:23 PM - 2 messages
I created a database to keep track of employees. When there is an issue related to that employee I need send the information to the person who can help. For example John Doe can not log into System A. So I enter the ...
Score Append records to create new record
MaxWedge426 - 18 May 2006 8:24 PM - 7 messages
OK, this is apparently too newbie a question for the macros forum, so here it is: All one table.  Column 1 = "BI3," and the values are numbers, e.g., "74389." Column 2 = "Date" and the values are mm-dd-yyyy with a leading zero, e.g., ...
Score Updating
shikha - 18 May 2006 6:53 PM - 3 messages
HI, I have 2 combo boxes and the way they are set up... 2nd combo box values are dependent upon what selected in combo 1. I got it working to a point that if A is selected from Combo 1 - then it ...
Score Adding a field to a query
Tracy "Forced to Use Access - 18 May 2006 5:51 PM - 3 messages
I have one table that is broken down in 6 different queries.  I need to created a field that will populate back to the table, if possible, to let me know which query it was on.  Is this possible? ...
Score Does a filter query? 2nd Post Please Help!
troy - 18 May 2006 2:56 PM - 4 messages
I have an update query based of a filter query but showing the wrong results. It show the results from the target table and not the source table. Here is the set up. Update Query.. Tbl 1 is source tbl based off filter query ...
Score Three tables to link
mohd21uk via AccessMonster.com - 18 May 2006 2:30 PM - 5 messages
I have three tables in Access where I am trying to link using a common field. The common field in each table is provided below: tbl_CN43 WBS Elem tbl_CN42 Proj Def tbl_CATS WBS code The trouble is that tbl_CN43  and tbl_CATS have similar values that is the ...
Score Pick last date
mohd21uk via AccessMonster.com - 18 May 2006 12:45 PM - 4 messages
I have a table where I have a list of users and dates. I have created unique codes which are used to identify a project. These codes are used by these users to add time to. I have a field called code and a field called date. I ...
Score List box in report
CK - 18 May 2006 11:32 AM - 2 messages
Hhi. I have searched the discussion group but haven't come up with the answer to what I would imagine is a common question. Perhaps someone can direct me please? One of the fields in the report is drawn from a listbox. The report shows ...
Score Reports and data presentation
CK - 18 May 2006 11:23 AM - 9 messages
Hi I wonder whether anyone can help me with a report problem. Creating a report from patients, symptoms, blood tests, diagnoses, etc.  Each patient can have many symptoms, but only one blood test. The problem with the report is that for each patient, the blood test result (for example) ...
Score Preserving date format
mohd21uk via AccessMonster.com - 18 May 2006 10:46 AM - 3 messages
I have imported a table from Microsoft Excel. This table has the date set in the mm/dd/yyy format. However, the table recognises the date in the dd/mm/yyyy format nad changes the format to accommodate this. Is there any ...
Score Update Blank Field with Combination of Data from 2 Other Fields
Paul - 18 May 2006 9:22 AM - 2 messages
This seems so simple but I can't get it.  I've read the many posts on this subject but I still don't get it.  Worse, I know I've done it before. tblAttendees has fields FirstName, LastName, and Username.  Username is ...
Score Select query in Combo Box
zachnjoe - 18 May 2006 12:25 AM - 2 messages
I have a combo box with a pull down list of WPS, CE Number, PEN_MIN and PEN_MAX pulling data from [WPS Data].  The pull down list works good but I only want store WPS in my other table.  All items from my pull down list are ...
Score How do you get past the 8 entry limit in switchboards
Kurt - 17 May 2006 9:50 PM - 4 messages
The Database I am trying to set up will not allow me to have more then 8 entries in a switchboard. I need at least 17 on one switchboard. How do I overcome the 8 entrie level thanks ...
Score Referencing Sub-form field from the main form. ------H E L P
lalexander - 17 May 2006 6:58 PM - 5 messages
I have a  Form &  Sub-Form What is the proper syntax to reference a field in the sub-form or visa versa. I tried accessing the field from the subform below: but this doesn't seems to work. ...
Score Syncronizing combo boxes
iridium - 17 May 2006 6:37 PM - 5 messages
Is there a way to automatically query and select the first data on the second combo box when I make a change in the first one? ...
Score Runtime
Bruce - 17 May 2006 6:10 PM - 5 messages
In work we are changing over from Office 97 to Office 2003. To save money it has been decided that in future only a few people will have the full Access program the others using the Access files will use some sort of view ...
Score Keep getting .NoMatch!
David Habercom - 17 May 2006 5:28 PM - 4 messages
The help I found here has much improved my prospects for making this form do what I need, but this code fails to find the record, though it runs.  It runs from VBA, and MchDonANDI is a field in the form's RecordSource query.  Where ...
Score Properly using a Select Statement
zachnjoe - 17 May 2006 4:53 PM - 5 messages
As example: I have a table called "WPS Data" containing the following data "WPS" and "CE" WPS           CE 1A1457       212287 1A1468       212288 ...
Score How do I get into the Business Template for Access?
Karen_Marchman - 17 May 2006 4:44 PM - 2 messages
As a new user of access database, I would like to use the business template.  But when I click on the template, I can only go so far.  When I click the template, it indicates an error has occurred and indicates a pop up block is ...
Score logic of tables
turkey - 17 May 2006 2:15 PM - 15 messages
i really would like some input on how i should set up tables on a db that holds manufacturing information.  parts that are made up of many parts and other subassemblies.  i've went through help information for the past week ...
Score Running an application from its 'shortcut' not .exe using VBA ?
Isis - 17 May 2006 11:45 AM - 4 messages
I am trying to call a program from a DB - I need to use the programs shortcut as opposed to the actual .exe file as I want to start the program in a specific folder - like the 'Start In' on a windows shortcut. ...
Score Mouse scrolling in a form causing problems
Isis - 17 May 2006 10:18 AM - 3 messages
In Access if you scroll the mouse wheel (usually inadvertently) you can end up scrolling through different records and ending up on new record which the user then tries to close only to get an error because of null key ...
Score How to undo all record in subform
Nova - 17 May 2006 9:42 AM - 3 messages
My subform is datasheet, How can I write code to undo all record just edit or insert new. My data source of subform come from only one table ...
Score Access
Cass - 17 May 2006 5:10 AM - 2 messages
I am trying to register Active X Controls in Access but my computer won't save them? Am I doing something wrong? ...
Score Use info from one table to search in another
nowuome - 16 May 2006 9:51 PM - 2 messages
I have created two tables in the same database.  I would like to use one table's information records to search in another table.  I have a list of 1044 numbers that I need to match up to their corresponding info in another ...
Score List Box Madness
Jay - 16 May 2006 7:56 PM - 6 messages
The telephone girls at work use a call log database. The main form where call details are input *should* be pretty simple. The first item is a pulldown list of customers. The second is a list box for customer location, ...
Score Copying and Pasting Trouble
Craiger - 16 May 2006 7:17 PM - 7 messages
I  can't copy or paste  rows in my database table.  I highlight the row and right click to copy but cannot.  Sometimes I am able to copy but not paste cells. ...
Score Global Settings for New Users???
Roman B. - 16 May 2006 7:13 PM - 2 messages
Whenever a new user logs onto an XP machine and gets a new profile, I have to go into their MS Access and clear some check boxes in their options in access. The Options have to do with Confirmations in the TOOLS , OPTIONS MENU ...
Score checkbox doesn't filter query
rbchildrn - 16 May 2006 5:35 PM - 8 messages
Hello.  I have a table that includes a yes/no column for whether or not we send mail to each record.  I need to run a query that doesn't show those who have the box unchecked.  I can't find an answer for this ...
Score Change the font and button size in a switchboard.
elitt2 - 16 May 2006 5:29 PM - 7 messages
Is there a way to change the displayed size of the font and button in a switchboard?  How can I make the switchboard maximized when the db is opened? ...
Score how do you make a page in word into 4 seperate boxes
leexrayshady - 16 May 2006 5:20 PM - 3 messages
how do you make a page in word into 4 seperate boxes ...
Score Search
JasonM - 16 May 2006 5:17 PM - 2 messages
I am learning acces by the trial and error method and I can not figure out how to make this work is even possible to accomplish this? I have a parameter query which is run from a command button. I want to copy the criteria ...
Score Right to left view
r - 16 May 2006 4:03 PM - 5 messages
how can i change the direction of the tables to be from right to left? I am using  Access 2003 Thanks ...
Score formula "like"
r - 16 May 2006 3:56 PM - 12 messages
under the object "table" : i designed the following table using Design View I made a filed called "ID" and I chose Data Type "number". In the field size I chose "long integer" in validation Rule area i typed the formula..  Like "023?" ...
Score Best strategy for this?
David Habercom - 16 May 2006 2:59 PM - 2 messages
I have a table, MtchTbl, with two text fields: DonID and EndwID, which can contain any number of matches.  In VBA, I need to find all the instances of a particular DonID, say "D100", and place each of the matching EndwID codes ...
Score Auto start a Switchboard.
elitt2 - 16 May 2006 2:32 PM - 6 messages
Is there a way to auto start a switchboard when a user double-clicks the db icon on the desktop? ...
Score Insert title of clipart automatically
Kriscruse - 16 May 2006 2:21 PM - 4 messages
I want to insert photos into a word document and have the title of the picture automatically appear below the picture on insertion. ...
Score SENDOBJECT - Sending Email on Behalf of another User
lalexander - 16 May 2006 1:54 PM - 2 messages
I'm using the SendObject to programatically send emails , which is working great. I recently got a request from management to send email on behalf of another user, say sa***@anycompany.com I know how to do this from within Outlook using the Delegate option in ...
Score SENDOBJECT - Sending Email on Behalf of another User
lalexander - 16 May 2006 1:51 PM - 3 messages
I'm using the SendObject to programatically send emails , which is working great. I recently got a request from management to send email on behalf of another user, say sa***@anycompany.com I know how to do this from within Outlook using the Delegate option in ...
Score table relationships - multi field
dwc - 16 May 2006 1:51 PM - 2 messages
I have three tables - Customer (customer ID is key). Contact - key is[Customer number]&"*"& [Contact ID] Contract (key is [Customer number]&"*"&[Contact ID]&"*"&[contract Year] 1) How do I set up the relationships between the three tables? ...
Score Hours of service
jjpittman via AccessMonster.com - 16 May 2006 12:19 PM - 3 messages
I really need help to calculate hours that are available to drive.  A driver can drive a total of 70 hrs in 8 days.  I am having difficulty trying to get this accomplished.  Within 8 days a driver is off for a day the hours ...
Score Access/VB muliple checkbox issue
dotcommillionaire - 16 May 2006 12:09 PM - 5 messages
Dear All, I have two tables participating in a many to many relationship. In resolving this, I have brought in a composite table - Visit_Enquiry. Analogically put, a Visit by a Student can be for many Enquiries. Table student - pkRegNo Table Visit - pkVisitid, Visitdate, fkRegNo ...
Score Post code/zip code
rberry - 16 May 2006 8:39 AM - 5 messages
I'm lazy and when typing a postcode into a psotcode control field on a form, I want to a) pull the address information into the other address fields from an attached table awhich already contains full address information and b) ...
Score Columns
Andrew T - 16 May 2006 12:11 AM - 4 messages
I need to print a report showing the students that are going on a field trip. I have the query worked out but the names only print in one column. I do not know how to make a report do multiple columns. I also do not have the ...
Score 8 hrs working on it and wont work
Jribs - 15 May 2006 11:29 PM - 7 messages
I am a new to Access.  I have been working on trying what should be a simple task.  I have read and re-read multiple post on this, but cannot get anything to work right.  I simply want to have an account number  fill in (to a text ...
Score Access2003 too slow.
Frank Martin - 15 May 2006 11:25 PM - 2 messages
I have upgraded from Access2000 to Access2003 by creating a new empty database in Access2003 and then importing all the objects (via the wizard) from the old Access2000. Was this the correct method?   If not is there a better method, and can other ...
Score Where to learn Access?
Hanr3 - 15 May 2006 9:20 PM - 5 messages
I am new to Access, and up till I found this site thought I had a good handle on Excel. I have taken a couple of classes on Access, and have one large book. Where is a good source to learn more about Access? ...
Score Need Macro to do Basic Repetitive Tasks
Lung - 15 May 2006 9:12 PM - 11 messages
I've been using Access to run some monthly reports, manually changing data in a Query and the title in a Report (which utilizes the Query) each month.  That works fine except it's a bit repetitive since I do 6 different runs each ...
Score Basic Coding Help
WillM - 15 May 2006 5:59 PM - 3 messages
Hey guys,    Not sure if I'm in the right forum or not, if not could someone point me in the right place?     Basically, I have a list of 16000 addresses that I need to divide into ...
Score Is there a tool to tell me where things are used?
Max Moor - 15 May 2006 5:49 PM - 6 messages
Hi All,         I have a fairly large database app I built some years back that I'm digging back into.  Unfortunately, I wasn't much of a documentarian back then.  I want to do some clean up, and have found a couple queries and ...
Score New to Access, simple question?
Eric - 15 May 2006 4:39 PM - 10 messages
I'm trying to edit an Access report someone else wrote and I apparently don't understand how Access works. They have multiple tables with multiple reports.  Each report is somehow tied to one table. I tried to add a field to one report and print data from a different table. ...
Score Replication
One confused underwriter - 15 May 2006 2:45 PM - 5 messages
I've been working on a database for sometime (that someone else has created...I'm just fixing the issues after that person left the company). The database is set up to be replicated and has been working just fine for some ...
Score Calling a Windows Address Book (*.wab) without getting a security warning
Isis - 15 May 2006 2:08 PM - 3 messages
Can this be done ? At present I am using the; Application.FollowHyperlink (followed by the path & filename) It opens the WAB after telling you it might be dangerous - can I eliminate the warning. Thanks ...
Score Set a Control Visibility from a command button on a previous form
wilcoit - 15 May 2006 2:06 PM - 8 messages
How do I set visibility of a control on a form from a command button on a previous form which is opening the new form? ...
Score microsoft access
cwkyle - 15 May 2006 1:53 AM - 2 messages
what is the purpose of a parameter query? ...
Score Adding to OEM Office Basic Edition 2003
WilhelmGGW - 15 May 2006 1:02 AM - 2 messages
I bought my computer with an OEM Office Basic Edition 2003 (Excel, Outlook, Word) already installed on it -- and working fine as a suite.  Now I'd like to add Access 2003 to that same computer.  It looks like I can only/best do ...
Score Run-time error '2046'
MiG - 14 May 2006 8:06 PM - 2 messages
When I use this code DoCmd.RunCommand acCmdCopy in the -On Get Focus- event of a combo box record (possible in the case of cmb?), it generates this error!! Any thoughts on why this occur? Thanks, MiG ...
Score Date Format Question
Jay - 14 May 2006 12:04 PM - 9 messages
Hi, Is there any way to have Access recognise dates entered in the usual UK order, namely: dd/mm/yy I have tried the different date formats avaible in the format section of the 'General'tab for the Date field's properties (table design view), but the ...
Next »