Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Add new field to table linked to subreport
Elaine - 10 Jun 2006 11:09 PM - 13 messages
I am brand new to this.  I created a table then a subform from that table.  The users then decided to add a field to determine if the customer sent in a stamped envelope.  I added a field to the subform, and one to the table (both ...
Score Error message accessing Help & Support on my computer 2147143679
ReallyRita - 10 Jun 2006 8:20 PM - 2 messages
Error message accessing Help & Support on my computer 2147143679 when I use Start/Help & Support.  Went around in circles on Windows, also IBM Support. ...
Score how to edit a table
susan - 9 Jun 2006 10:55 PM - 3 messages
please could someone tell me how to edit a table especially how to extract a wrongly placed data from one column and place place it into the right column. e.g: how to remove postcodes that were wrongly placed in an address column ...
Score can't find access though word created file for a mail merge
citiproperties - 9 Jun 2006 8:06 PM - 2 messages
I created a mail merge file of addresses which got saved as an access file, now when I try t open the file it says that it doesn't know which file created it, when I look for access in my programs I can't find access.  ...
Score DATA CONVERSION???
ChrisBruell - 9 Jun 2006 7:18 PM - 4 messages
Hi all!!  I work at a university and am in the middle of creating a db with reports.  I'm wondering if there is a way to enter grades as letters and then attach numerical values to them so as to calculate a GPA on a report.  ...
Score Report/query help
Tom - 9 Jun 2006 1:10 AM - 4 messages
I'm trying to design a report that will pull data from scheduled trips.  What I have: controls: "start date"  "end date" check boxes"  "sun" "mon" "tue" "wed" "thu" "fri" "sat" I'd like to: 1. run a report just for today ...
Score Need some tips on the design of a database...(long)
Rhett_Y - 8 Jun 2006 9:23 PM - 5 messages
Hello.. I am putting together a database that will track incidents for our city on the 4th of july...And I started to read about normalization (this is long..please bear with me...) Here is how I have it setup..... ...
Score Making a Form an Access Page
Christian > - 8 Jun 2006 4:16 PM - 2 messages
OK, I've designed all my tables, queries, and forms.  I've got allmy code working right, etc.  Now, I want to make an access page for the office to input into my form, and I'd like it to look exactly like the form.  I don't ...
Score Storing a value for later use in vba or a Macro
Jack G - 8 Jun 2006 3:35 PM - 5 messages
I think this must be a very basic and simple question, but I'm stumped: How do you programmatically store a value from one record to use in another record?  For example, say I have a form displayed which has a customer name ...
Score How to find out the problem? (debug)
fox - 8 Jun 2006 2:20 PM - 7 messages
Hello,    I am trying to maintaining a program. However, when I excute it, it show a error message Run-time error '91'; Object variable or with block variable not set. If I select debug, it went to a line of code, which looks ok. ...
Score how to create labels in access
dilly - 8 Jun 2006 2:02 PM - 2 messages
I am doing my ECDL and am stuck on how to create a label from Access Database from the tables option ...
Score How do I create radio buttons in an Access form?
fiddler_718@yahoo.com - 8 Jun 2006 1:45 PM - 5 messages
Please speak slowly and use small words in replying.  :) I think want to create radio buttons in my form in Access.  Some questions will look like this: What sorts of classes would you be most interested in taking? ...
Score queries that don't allow new input
David Newmarch - 8 Jun 2006 1:36 PM - 4 messages
Is there a general rule of thumb to tell you where to look for the problem when a query (and therefore a form based on that query) doesn't allow you to edit or enter new records (and the navigation button with the star is greyed ...
Score Workgroup file in Office 2003
Derrick - 8 Jun 2006 1:18 PM - 6 messages
Hello everybody! I have a question for everyone about Access 2003.  When we set users to a workgroup file that my supervisor created, it will stay for a couple of days or so.  When that user that is logged into the database ...
Score Outlook should allow atomatic collapse of all group when navigatio
dora - 8 Jun 2006 10:13 AM - 2 messages
Outlook should allow atomatic collapse of all group when navigation. On opening the Outlook 2007 Beta version it shows all the groups  In the inbox( from who the mail is received ) Expanded.  I collapse the groups using view option then collapse all.  All the groups get collapsed however,when I ...
Score using excel syntax as queries in ms access
Abel - 8 Jun 2006 10:03 AM - 2 messages
is it possible to use excel syntax for formulas as queries in ms access? also, is it possible that for two tables that has a common field, once you enter new record in one table, same is also recorded in the child table?i'm ...
Score .xls file sent to xpcomp how to view file?
Jude - 8 Jun 2006 6:09 AM - 3 messages
cant open .no program associated with this. I do not have Excel on comp. pls help how can I view file without spending lotsa money. ...
Score Hey I need help?
Amy - 8 Jun 2006 3:35 AM - 2 messages
When making a website with Microsoft Publisher when you add a sumit on your page how do you add another page saying thanks your email will came to me! and all that junk! ...
Score linking combo boxes
Z - 7 Jun 2006 8:09 PM - 3 messages
I am trying to link info from one combo box to another.  When I use the drop down box in the CustomerID combo box, I want the Customer name to pop up when I select the appropriate ID nubmer. How do I do this? tthanks, ...
Score Export from Access 2000 to .prn
Tom Swanick - 7 Jun 2006 7:13 PM - 2 messages
Hi, Does anyone know of an add-in for Access 2000 which would export to a .prn file similar to the way Excel does? I think not, but maybe somebody knows more. Regards Tom ...
Score Dynamic checklists?
budigila - 7 Jun 2006 5:15 PM - 2 messages
I am trying to find a way to have access to many checklists all grouped the same but with different information contained in each, have it queryable, searchable, and printable.  Would Access 2003 be able to work this for me? ...
Score Every month reports
camilia - 7 Jun 2006 4:23 PM - 6 messages
Hello, I have a database that keeps track of all the equipments that are due for maintenance. I run a report at the end of each month to be able to see what is due for the next month, when the maintenance is completed, the operators ...
Score How do I stop a text field from reoccuring in all pages in access
jim - 7 Jun 2006 3:44 PM - 2 messages
I have an existing form that I added a text field to.  It is an unbound field that allows me to enter in data, however the data I enter into the field defaults across all pages in the form.  How can I turn that default off so I ...
Score Find a missing number in a seqeunce
Topher - 7 Jun 2006 2:50 PM - 4 messages
I need to insert a new record in a table. Each record has a column with a value between 0 and 255. When I insert the new record, it needs to have a number that does not match any of the numbers in and existing ...
Score my linked table is overwrited and i can't open it can any body he
shaimaa makhlouf - 7 Jun 2006 12:25 PM - 2 messages
i had a source table, somehow it becam a linked table and i can't open it any more>>>how can i have my data again from the table... it doesn't want to open ...
Score Time tracking attendance
MGCurz - 7 Jun 2006 10:49 AM - 10 messages
I would like to know if there is any way on a form that you can type in a number e.g. 1234 press enter then in a table it adds 1234, the date and sign in time.Also usin the same form if you type the 1234 in again it will add ...
Score Forms - Section dividing lines
Jay - 7 Jun 2006 6:19 AM - 2 messages
Just a quick question. How do you get rid of the line which divides form headers from the detail section?  I've checked all the format properties but can't seem to find it. Cheers; Jay __ ...
Score Bulid database
Kevin - 7 Jun 2006 3:44 AM - 14 messages
How do bulid a databese can show out Qty In, Qty out and Balance on same Forms? Because I'm new users.. ...
Score Access and customer contact list
Confused - 7 Jun 2006 12:09 AM - 2 messages
For a small business:  is Access the best way to set up a customer contact list?  I also want to be able to create email and regular mail distribution lists from my customer database. ...
Score Newbie
lonles - 6 Jun 2006 10:59 PM - 2 messages
I have created a database in Access and every time I add info to it and then exit, when I come back, I have blank records at the beginning of the table.  What causes this? L. ...
Score Return customer name and between date values from query
gardy - 6 Jun 2006 8:01 PM - 2 messages
I need to be able to retrieve two specific results from a query. One is customer name and the other is a date that is related to the customer name . data is pretty simple customer name, product id, serial number ,quantity date ...
Score Not In List Event--Adding to Table
Christian > - 6 Jun 2006 6:36 PM - 3 messages
I am using the following code for adding to a Combo Box when an item is entered that's not in the list: Private Sub Customer_NotInList(NewData As String, Response As Integer)     On Error GoTo Customer_NotInList_Err     Dim intAnswer As Integer ...
Score mail folders
clay - 6 Jun 2006 6:32 PM - 2 messages
how can i copy mail folders to a disk ...
Score Combol Box and Report
Chi - 6 Jun 2006 6:12 PM - 4 messages
I have a combo box that listed the Department Names. I would like to create a Print View button that will show only the Department which I selected in the combo box. Is possible to do that? Please help. Thanks ...
Score Sync Multiple Combo Boxes
Christian > - 6 Jun 2006 5:02 PM - 4 messages
I have four Combo Boxes: Customers, Contacts, Project Managers, and Superintendents The other three Combo Box values are based on what is selected in Customers using a SQL statement.  For example The Contancts SQL statement is: SELECT [Customer Contacts Table].CC_CustomerContactID, [Customer Contacts ...
Score Access claims relationships still exist... but I deleted all of th
Bigmike - 6 Jun 2006 2:54 PM - 3 messages
I'm trying to resize field lengths in a bunch of my tables, because I wanted to get the design down before I edited field sizes (we really weren't sure at the time how long they needed to be) ...
Score Choosing a package, return all items
Teri - 6 Jun 2006 2:35 PM - 11 messages
Here I am again, still working on my shipping database.  I have a need to be able to select a package in my Order form (for example CCUSB)  and have Access pull together all items that should be in that package (for example ...
Score Basing One Combo Box on Another--Question
Christian > - 6 Jun 2006 2:15 PM - 7 messages
Okay, I got my combo boxes to be limited by what is entered in another and used the following code: Private Sub Insurance_Company_AfterUpdate()     Me.Insurance_Contact = Null     Me.Insurance_Contact.Requery     Me.Insurance_Contact = Me.Insurance_Contact.ItemData(0) ...
Score Form Bound to Query problems
Christian > - 6 Jun 2006 1:49 PM - 3 messages
OK, I've got my form bound to a Query.  My pulldowns don't work when I'm entering the form.  They are blank.  When I open the query and enter data, they work, but not when I'm inputting into a new form... ...
Score Maximize Database from Auto Exec Macro
JPC - 6 Jun 2006 12:50 PM - 2 messages
I am aware of the macro Maximize command, but it doesn't make Access itself maximize.  Is there a way to ensure that the database itself is maximized when opened. ...
Score New user-import & query question
lgkt - 6 Jun 2006 11:56 AM - 2 messages
I need to import 2 excel tables (I already know how to save them in the correct format) into Access then create a query to find the codes that do not match. I can't get both tables to import in and I can't figure out how to create ...
Score MS Access database does not open
Ian4 - 6 Jun 2006 10:10 AM - 2 messages
Record(s) cannot be read; no read permission on 'MSysAccessObjects'.  I have checked all do have full access and access is also reloaded.  What can I do to fix this problem.  It is created in MS Access 2000 and also tried to ...
Score Data disappears for no reason in Access?
Roger Drews - 6 Jun 2006 12:58 AM - 5 messages
I am new with working with Access I am trying to develop a Quality Check sheet using access where up to 6 copies could be opened at the same time.  When people are entering data the data will sometimes disappear for no ...
Score Printing a report from a form
baffled - 5 Jun 2006 9:36 PM - 3 messages
without opening to preview the report I would like the report to print from the command button on the form. this is the last field before going to the next record. the autonumber field is the unigue identifier. i keep getting ...
Score Using Access 2003 to generate word documents
dawnm.jordan@gmail.com - 5 Jun 2006 8:05 PM - 4 messages
~~Reposting with the hopes of getting a response~~ Hi, I am working on a database used to store information, and then generate customized letters.  I have most of it working, (Thanks to the posts in this group =))  I have a button which can be clicked and it opens word ...
Score How do I know if my copy of Office is registered
Michele - 5 Jun 2006 7:04 PM - 3 messages
Our office just purchased a new computer and I am trying to set it up and get registered.  The registration screen opened when I went into Outlook Express and I did enter the Product Key found on my original cd.  I am just wondering ...
Score Lost my delete confirmation...
LongWayFromHome - 5 Jun 2006 6:31 PM - 2 messages
For some reason, Access 2000 no longer asks me to confirm when I delete a table or query, and this makes me very nervous.  I have checked off the option box, but that seems not to change anything.  I am working on some code ...
Score Information is not there
Teri - 5 Jun 2006 6:29 PM - 3 messages
Someday I will have this database done!  I have downloaded a template from Microsoft.com for shipping information.  When I input information into the form regarding the customer, the person taking the order and the dates of the ...
Score Windows installer running on startup of Access
Barry - 5 Jun 2006 4:09 PM - 6 messages
I have been using AccessXP and the rest of Office 2003.  After updating to Access 2003 when starting Access I receive a message, "Please wait while Windows configures Microsoft Office 2003".  I have read that this may have ...
Score How do I import movies to a powerpoint presentation?
little brother - 5 Jun 2006 3:49 PM - 3 messages
I have a powerpoint 2003.  I have tried the old way of dragginh and dropping to import movies to a powerpoint presentation.  This did not work.  I tried the old method of powerpoint "importing".  It did not work.  How do I do it? ...
Score Mail merge
cheekychick - 5 Jun 2006 3:25 PM - 3 messages
Can I run a mail merge from an access based client database? ...
Score connecting tables
susan - 5 Jun 2006 2:55 PM - 3 messages
how do I connect a data set in one table to another table that has an information I need. for example how do I get the address of a client from one table and attach it to another table that has the rest of the client's ...
Score How can change form property
Nova - 5 Jun 2006 9:42 AM - 2 messages
How can I change form property by code (not in design view) like this On data tab property of from allow deletions between yes-no allow Additions between yes-no Data entry yes-no ...
Score How to add new record in VB Form using Dao Library
imtmub - 5 Jun 2006 7:30 AM - 3 messages
Hi i developed some database in access. now i had planned to convert in to vb6.0. i had designed my form and i linked the tables also. when i m using data control. when i will open that form its going to first ...
Score I do not know what I am doing
Ding Bat - 5 Jun 2006 4:07 AM - 2 messages
I have Word and Excell 97. When I moved them on my new XP computer - they were dragged and have not been working correctly. I have the disc for them and also bought Office 2003 (that I can take back) Will the new version make ...
Score Minimize Search
code_warrior - 5 Jun 2006 12:21 AM - 2 messages
I have three tables. Countries, Schools, Groups. Countries table has a feild called Country_Name which contain countries Names. Schools table has a feild called School_Names which contains schools of that country and has a relationship with the Country_Name feild in the Countries table via a ...
Score Problem with data entry
Old Guy - 5 Jun 2006 12:05 AM - 2 messages
How do I get a SAVE button to give an error message, if any form fields are empty, when the user tries to save the form? ...
Score How to search forum
eb1mom - 4 Jun 2006 10:15 PM - 4 messages
I must be phrasing my search criteria incorrectly as I can't seem to find answer in help files here. Is there any way to search this forum for questions that contain  exactly "reports by hour" or "query for date" ? I ...
Score Newbie question regarding blank fields in web database
paul - 4 Jun 2006 8:56 PM - 11 messages
Unsure whether I should ask this question here or in the asp forums anyway here goes... Access is not my strong point but I have got it to do most of what I need apart from the fact that when I create an update page in asap and then try ...
Score Ping Barry Gilbert
Isissoft - 4 Jun 2006 11:13 AM - 6 messages
Barry you were kind enough to help me with a ShellExecute Function - I was trying to run a program from a shortcut from Access - the reason that I wanted to do this was to open the program in a defined folder and a ...
Score Space
Peter Kiss - 4 Jun 2006 7:23 AM - 2 messages
Removing spaces between text i would like to run update query to remove all spaces leaving 1 as in excell with the Trim Formula how do i ...
Score Template Request
Claudia - 4 Jun 2006 1:23 AM - 2 messages
Hi, I was wondering if anyone knew if there was a template available for entering personnel / payroll information.  Our organization is in the process of establishing one and I was wondering if one already existed that I could build on.  Any help would be appreciated.  Thank you ...
Next »