Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Newbie question: "Same as Previous"?
JMF - 6 May 2006 8:12 PM - 5 messages
This regards table data entry: Using the normal facilities for adding new records to a table, I'd like to be able to set the default value for a field to "same as previous" -- that is, whatever the value was in the last record was added. This is obviously ...
Score Missing 'hash' key?
Jason O - 6 May 2006 6:55 PM - 5 messages
I've just installed Access at home and have realised my keyboard doesn't have a 'hash' key - the No. sign, or noughts & crosses grid (in case 'hash' isn't a universal name for it). _|_|_ _|_|_ ...
Score HELP ASAP? deleting duplicate phone numbers from query
magiccostarica@aol.com - 6 May 2006 4:49 PM - 2 messages
I have asked several times for someone to help me but they keep talkign computer lingo i am new to acces and i am stupid i have a database with 30,000 duplictae phone numbers i know how to do a wuery to find the duplicates, but how do i delete them ...
Score why doesn't my hotmail account work in outlook?
Samantha - 6 May 2006 8:42 AM - 4 messages
it staes that i can use my hotmail account but when sending/receiving i get a erro that states I must sign up for an account. Why? Hotmail is free ...
Score Managing a silent auction
Gary J. Smith - 6 May 2006 4:53 AM - 2 messages
Has anyone designed an Access database to manage a charity silent auction?  I need to be able to keep track of bidders, the items that are bought, the sales price, and also to be able to print invoices at the end of the auction ...
Score Saving from a zip to the hard drive
eamoniveragh - 6 May 2006 3:11 AM - 3 messages
I have data on a zip disk.  I can open it with Access on my computer, but I don't know how to save it to my hard drive.  I do not see a "Save As" option ...
Score In access, where do I enter the sql command for "create table"
NovaM - 6 May 2006 2:10 AM - 2 messages
Hi Boy do I feel dumb ! I need to create tables using the sql command for create table, but I can't find where I need to enter the command for access to make the table Any help out there???? ...
Score Before I get started. . .
Teri - 6 May 2006 1:39 AM - 6 messages
I want to create my own personal database of recipes.  Probably a basic one by the standards of any of the MVPs out there who may be willing to help.  What I want to do is the following:  Table to include the recipe name, ...
Score Getting "500 Unathorized msg. rejected" on emails I send
bb - 5 May 2006 10:30 PM - 2 messages
Sending emails aare causing "Undeliverable" from System Administrator. the bottom states: "500 Unathorized relay msg. rejected" ...
Score Macro - closing a form
murfitUK - 5 May 2006 7:41 PM - 2 messages
I've created a macro that opens a form, copies some records and then closes the form. When the form closes I get the message "You have copied a large amount of information...do you want to save this info?" ...
Score Basic but odd question
Derek via AccessMonster.com - 5 May 2006 6:33 PM - 2 messages
Okay, i'm moving my database over from excel to access and I need to do this: I have an access database with lets make it simple and say two columns, Record # and First Name. Record # is a unique number that i have manually assigned and will never be ...
Score how I can create time clock to employee to punch in and out
Gabriel - 5 May 2006 4:43 PM - 2 messages
I would like to create in access a punck clock for employees to clock in and out. I would like it to display date and time and have a way to make employee friendly. any suggestions or examples out there I can look at? ...
Score Data Entry
adarling - 5 May 2006 4:14 PM - 2 messages
I've created a table in which I have two columns that are yes or no answers (SendInfo & ActiveMember).  I only want to fill in the fields that I have definite yes or no answers on the completed questionnaires I've received - I ...
Score need guidance on where to paste extended code
David Newmarch - 5 May 2006 12:41 PM - 2 messages
Working from the code suggested in the MSOffice Online article  "Basing one combo box on another" ([link]) I have this piece of code which displays an initial value in a combobox on a main ...
Score Can an Access field hold an html document
dennist685 - 5 May 2006 12:37 PM - 2 messages
Can an Access field hold an html document. Not only with different fonts and colors, but with clickable links. dennist685 ...
Score Create report using data from main report
Nicole Walker - 5 May 2006 12:15 PM - 2 messages
I have created a data sheet in several different areas in Access. I used tables, queries, forms, page, report etc. My data sheet consists of various companies from various states. I am trying to figure out how to pull certain ...
Score Wilcard Question
Alastair MacFarlane - 5 May 2006 11:16 AM - 6 messages
Dear All I have a field called Name which has the following values: *Old Rec * Newer Rec New Record How can I query the name field to not display the records with an *? This is a problem when the * is also a wildcard. ...
Score Query to retrieve field names of table
Snowy - 5 May 2006 10:41 AM - 4 messages
Hello all, I need just a query to get the field names from a table using just the table name. Only field names, not type, etc.. something like SELECT fields(*) from thistable do while... loop (Visual basic 6.0 application using Mysql) ...
Score resume creation
cued-in - 5 May 2006 8:06 AM - 2 messages
How do I update/create a resume using windows xp home edition? ...
Score USAGE OF VLOOKUP FORMULA
marolf - 5 May 2006 4:36 AM - 2 messages
if i have two different worksheet and i would like to know if there are items of each worsheet that has the same information. e.g. both worksheet have an item with a similar name how can i do that using a formula? ...
Score Explanation needed of a VBA term
David Newmarch - 4 May 2006 8:43 PM - 8 messages
I'm battling to see if I can adapt the code on the MSOffice Online assistance article called "Basing one combo box on another". ([link]) My problem is that the article deals with one combo box based on another in ...
Score Setting reminders
Kate123 - 4 May 2006 7:38 PM - 2 messages
I am using Access to keep track of contacts that I call and sometimes need to call back at a certain time or day. Is there some way to set a reminder as you would do in a calender, or some other way that I can easily know who I ...
Score Sort Ascending as Default
Andrew Tatum - 4 May 2006 6:52 PM - 2 messages
Alright, When I look at a form I created, it automatically sorts the data by date. However, when I put it as a subform it sorts it by ID. I don't know why it's not taking along that same property. Can anyone point me ...
Score Combo Box Question
Thomas - 4 May 2006 4:59 PM - 3 messages
I have a large database to populate.  in my forms I am using a combo box for selections.  is there a way I can prevent changing that selection while still letting me make a new selection in the next record? ...
Score find invite attendees on toolbar
Dinosaur - 4 May 2006 4:49 PM - 2 messages
I'm sorry but admit that I can't find the tab to change my appointment to a meeting by "clicking on the standard toolbar - invite attendees". Is it on the calendar page or appointment page or what.  I don't see it anywhere.  I ...
Score how do I setup a daily attendence registerfor day centre users
Moses - 4 May 2006 4:13 PM - 2 messages
I would like to use access to record daily attendance at our day centre for users. Houw would I go about setting up such a system ...
Score selecting in 2 different positions in a text box
kavitha - 4 May 2006 1:55 PM - 2 messages
Hi All, I have written a small program in C#, and i want a help from u guys.. i.e, i want the text in a text box to be selected in 2 differnt positions in the same text box, which is a multiline text box.( for instance.. say from ...
Score Combo Box - Can't find source?
Jason O - 3 May 2006 10:22 PM - 4 messages
Hi, I wonder if anyone could help. I'm trying to familiarise myself with a database that a former member of staff set up. Its purpose is to collect telephone survey information, and as such one of the main fields is the ...
Score Passing a Variable Question
David Habercom - 3 May 2006 7:36 PM - 5 messages
On my Main form, I have a Cancel button that closes a subform.  If a particular button (AddID) on the subform has been used (to complete a particular field), the Cancel button performs additional operations.   (The field can be completed manually, but Cancel doesn't need to perform the ...
Score time query
Sam - 3 May 2006 7:05 PM - 4 messages
I need to caculate the difference between appointment time(located in Table) and current time ...
Score Linking to Excel
jd - 3 May 2006 5:33 PM - 3 messages
I set up a database on track and field athletes. I then set up a report to look at the athletes in different age groups. From here I exported to and Excel spread sheet and linked this spread sheet to the data base. I thought ...
Score App for Windows 98?
J Holtendehouzer - 3 May 2006 4:28 PM - 10 messages
I'm a relatively new developer, and I've written a neat little database in Access 2003.  I'm starting to distribute it now, and it works great with Windows XP, but I'm getting requests to produce a version that will work on ...
Score How do I hook up outlook to my exsiting e-mail?
Hooking up outlook - 3 May 2006 2:21 PM - 2 messages
...
Score Resources for building databases
JessK - 3 May 2006 10:19 AM - 2 messages
I am a new Access user and have a project requiring extensive 'interactive' database design.  Rather than starting from a clean slate, are there sources out there for templates of various designs that can be modified for particular applications?  I am looking at an issue tracking database that has ...
Score How do I find all non-common records of 2 tables in Access?
Vikas - 3 May 2006 5:56 AM - 2 messages
I have two tables A and B. I wish to find all records in A that are not present in B. How do I do this? ...
Score Would like to learn how to Alpha numerical data entry numerical
To gain the numbers faster - 3 May 2006 2:23 AM - 2 messages
Would like to learn how to do Alpha numerical data entry and data entry to build up my speed. ...
Score Three tables issue still remains
Engineer1978 - 2 May 2006 10:36 PM - 3 messages
Ok i have uploaded my pic of my relations so maybe you can help me now to tell me how i can unite the three tables, finances function, acc/bookkeeping function and personal tax income into ONE by simply clicking (1-1000) for ...
Score odd situation with dates
gls858 - 2 May 2006 10:00 PM - 3 messages
I import info from a program that fills the last purchase date field with 12:00AM if we've never sold anything to that customer. When I print this field on a Access report it prints 12/30/1899. I would just like it to be ...
Score How do I output Access Report via Word Macro to Word/Excel instead of Printer?
chris - 2 May 2006 9:40 PM - 13 messages
Hi everyone. Im trying to update a Word VB project which accesses an Access database for various things (and the original programmer is no longer available). project originally created in OfficeXP but now using 2003. One section of the VB project prints out an Access report including a ...
Score replace numeric values with county names
Takeadoe - 2 May 2006 6:12 PM - 7 messages
Brand New to the Access game.  I was given a table with a field called county.  Values are 1-88 representing unique counties.  I would like to change these values to the actual county names.  I'm at a loss as to how to ...
Score Is Data Access Pages support more than one concurrent users?
chn - 2 May 2006 6:04 PM - 2 messages
Hi, Is Data Access Pages (in Access 2002) support more than one concurrent users? ...
Score Outlook
omfarz-test - 2 May 2006 5:29 PM - 4 messages
How do I create a custom database? ...
Score Primary keys
tikchye_oldLearner57 - 2 May 2006 3:34 PM - 8 messages
dear community can anybody let me know where can I find examples of a table with more than 1 primary key declared and how and when can I use more than 1 primary key in the data table ? thanks for helping. ...
Score Format large numbers in a table
Onne - 2 May 2006 1:11 PM - 7 messages
Hi I'm facing this problem. In a column in one of my tables really large numbers are stored. This doesn't increase readability. So what I like to do is set a format to this column which turns numbers like 43235489 into 43.235.489. ...
Score I have word perfect 2002 on my hard drive but how do I try it
yssup - 2 May 2006 1:04 PM - 2 messages
How  do I  use  word perfect I hvae  it on my hard  drive  I see it in  remove  and add  but when I   click try it  wants  to  remove  it/ ...
Score half noob question...
gerald - 2 May 2006 12:55 PM - 6 messages
how could I support e-business transaction in access? ...
Score Can I submit a Norwegian doc and have it return in English?
angelbabyjones - 2 May 2006 2:07 AM - 4 messages
I have Microsoft Windows XP and I have a document in Norwegian and I was wondering if I can submit it and have it interpreted for me.  This letter is from my foreign exchange student in Norway, and I need it interpreted.  Just ...
Score Exspression builder does not display folders with tables
Lape - 1 May 2006 10:10 PM - 4 messages
Exspression builder does not display folders with list of tables, fields. what is the problem?How I can fix it? ...
Score Createing a survey in Access
Anna Yevsiyevich - 1 May 2006 9:47 PM - 4 messages
Hi, Is it possible to create a database that resembles Excel in some regards?  I need to create something that if a particular record is selected, then it's value is added to a total.  Similar to a survey.  So, if I have 5 questions, ...
Score Printing Orders
gillj - 1 May 2006 9:43 PM - 3 messages
I am playing around with a simple database, the purpose of which is to input order details in a form and then print the order in question as a report. I have designed the report to accept the order details, but am unable to ...
Score Looking up multiple Records
Sammy - 1 May 2006 8:49 PM - 5 messages
My question might seem a bit novice, but my experience with Access is quite limited. Thank you for your patience. My current database is using three tables (with the following fields): 1 - DATES (date, fiscal period) 2 - LOCAL Revenue on the Books (date, jan, feb, mar, .... dec) ...
Score Requireed value to pop up a new form
Engineer1978 - 1 May 2006 7:52 PM - 5 messages
Hello im stuck. I am trying to simplify a project management database. I have bound clients to Projects and when i open a new project i want to be able to enter a new number (1 - 1000) should open a new table(premade called ...
Score Replication Help
Jason O - 1 May 2006 7:43 PM - 2 messages
Hi, I've inherited a problem with a replicated database at work.  I've been trying to get a general overview of replication at the replication section of support.microsoft but the page won't load for some reason. So, I ...
Score Best strategy for deleting unwanted record?
David Habercom - 1 May 2006 7:16 PM - 2 messages
I have a subform with controls bound to DonorTbl.  When a user enters data in any field, it creates a new record.  Sometimes the user wants to cancel the operation and delete the partially completed record.  What are the best steps ...
Score Split table containing data..possible in this case?
Daniel - 1 May 2006 5:19 PM - 9 messages
Hallo, I am trying to set up a database for the contacts of our company (about 2000). I created 2 tables one for the contacts and the other one for their addresses; I separated them because each contact has 2 addresses. ...
Score Financial
jd - 1 May 2006 4:59 PM - 2 messages
I am trying to select specific items out of the financial statement, such as fuel charges, and find the total cost of these. I have used advanced filter to get the items I want, but the joined "sum" guery gives the total ...
Score How do I duplicate words in Access?
Donald - 1 May 2006 4:43 PM - 6 messages
I'm working on an address database and some of the addresses and company names are the same. What can I do to avoid typing the same words over and over?(auto fill when I type the first couple of letters) ...
Score Why doesn't this SQL work?
David Habercom - 1 May 2006 4:07 PM - 5 messages
I need to delete a record from a table, and I can't see why this SQL statement doesn't see the record: strSQL = "DELETE * FROM DonorTbl WHERE DonANDI = " & Qt(Me.NewANDI) & "" DoCmd.RunSQL strSQL Private Function Qt(s) ...
Score Print single label, not in upper left position
HH subs - 1 May 2006 3:29 PM - 2 messages
Before I create my subscriber database in Access 2003, I'm trying to determine if Access will allow me to print a single label, preferably of the current record (ie, a new entry). I would also like to know if I can instruct ...
Score How do I set up PowerPoint to open files in separate windows?
JD in LA - 1 May 2006 3:05 PM - 2 messages
I would like to run two PowerPoint files at the same time in separate windows.  Is this a PowerPoint option that is available to me?  If so, how would I do this? ...
Score Student and teacher edition 2003
Jules - 1 May 2006 1:07 PM - 4 messages
What information do I need to be ale to register with student and teacher office addition? ...
Score Substracting dates
Andy - 1 May 2006 12:50 PM - 10 messages
Hi Everyone, I have this database and there are two fields, Start Date and End Date. I would like somehow to calculate how many working days are between End Date and Start Date and save the value into another field. ...
Score Forms
Andy - 1 May 2006 12:33 PM - 6 messages
Hi, I am using Access 2000. I have created a small database. One of the fields is a text field and will contain the history of each event. I have added a button to the main form and I would like it to do the following: ...
Score northwind schema
Wilhelm Pieper - 1 May 2006 9:52 AM - 6 messages
Hello, I'm looking for some remarks/explanation of the Northwind database. A link would help. wkr Wilhelm ...
Score how do you add an item to a combo box list in access 2003?
ThunderCat - 30 Apr 2006 10:34 PM - 3 messages
Trying to add an item to an already established combo box list. I can't figure out how to change the list once it's there. I can remove it and rebuild a new one... but, for instance, if I have a drop down box for someone ...
Score Using VBA (or a Macro) to control a tab's visibility
Jack G - 30 Apr 2006 9:54 PM - 5 messages
I'm trying to control which of two tabs will be visible in a form depending on the first letter of the current record's "ProjectNumber".  If the fist letter of ProjectNumber is "U", a tab named "Details-USA" will be visible, ...
Score ADODB.Command object problems
Paul Richardson - 30 Apr 2006 8:33 PM - 3 messages
I have split a database following the directions found in another thread here (the back end only has the tables, the rest is in the front end, including queries).  In my VB code, I instantiate a command object and set CommandText ...
Score Documentcontrol
Pieter geerts - 30 Apr 2006 6:29 PM - 2 messages
Hello Can somebody help an an access database for documentcontrol that i can put  in my own database? I can`t make it myself so ill hope somebody has  something like this where i can get a copy off (or know where to find  ...
Score ACCESS Password
Debora J. Johnson - 30 Apr 2006 3:37 PM - 2 messages
I have Microsoft Access.  When I try to use it, it asks me for a password. How was a password set up if this is the first time I've tried using it and where do I get the password from? ...
Score How can I catalogue books please
Molly Freeman - 30 Apr 2006 9:05 AM - 5 messages
I would like to catalogue about 500 books - to be able to sort by Author - title etc.  I am very new to spreadsheets - any help would be appreciated - thank you. ...
Score setting program expiration
jackel - 30 Apr 2006 8:53 AM - 5 messages
Greetings, One of our employees built a database for our company and was recently terminated for bad job conduct and did something to the company database. The program apparently was set to stop after he left the company. Where do I find the location to repair what he did to make the program work again? I don't know at this point if any data was lost. ...
Score Installing Office 2203 on Laptop...have on desktop
scott3435 - 30 Apr 2006 12:30 AM - 9 messages
I bought a Dell that came installed with student/teacher 2003...can I simply install on my new laptop using the software that they sent with my computer? I also have a trial version on my new laptop which I assume will just be ...
Next »