Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Drilling down
Mike Lang - 14 Oct 2006 11:27 PM - 7 messages
I'm building an order entry system where any orders place on a client's behalf show as a list e.g. ordernumber, supplier. Is there a easy way to click on one of these orders and have it 'drill down' and show the full ...
Score main Access 2003 Menu Bar
Soddy - 14 Oct 2006 5:20 PM - 3 messages
Hello! I'm developing a 'StartUp' form and in this form I would like to make 'invisible' the main Access 2003 Menu Bar.  On my 'close' button, I will make if visible again...  So, not sure if I could use the 'DoCmd' or not... ...
Score Re-Learning Access
Tom Hall - 14 Oct 2006 4:01 PM - 7 messages
My recent return to Access has underscored one glaring fact: I've forgotten almost everything I learned about the program in the two one-day courses I took back in '97 or '98. In 2001 I was tested on Access by an employment agency and given an ...
Score loss
samicole246 via AccessMonster.com - 14 Oct 2006 1:23 PM - 2 messages
hi when i set my form and change its startup configuration..just experimenting things..then when i uncheck all the checkbox my form loose all the tools etc. how will i get it back...?? ...
Score Embedding an image into field
phenix - 14 Oct 2006 11:46 AM - 3 messages
Greetings.  Is there any way to DIRECTLY embed an image into an Access (2000) database field from a camera or scanner? (without saving the image to a folder then using the "insert object" from file!).  Many Thanks in advance. ...
Score Print out differs from form
Dsperry101 via AccessMonster.com - 14 Oct 2006 11:39 AM - 3 messages
Hey    I have a form that has nmany text boxes and some combo boxes etc. I have tried to duplicate a paper form and it looks great on the screen, but when I print it alot of the lines I used to border the text box lists ...
Score reports
samicole246 via AccessMonster.com - 14 Oct 2006 1:57 AM - 5 messages
how will you print a report with a limited forms? ...
Score Stepping through a table
Mac@440th - 13 Oct 2006 7:23 PM - 3 messages
I have a form (for these purposes, let's call it Form A) that is based on a query with 38 rows of information, each row containing 7 fields. I have a second form (Form B) with the same primary key as the table on ...
Score compile....
samicole246 - 13 Oct 2006 5:53 PM - 6 messages
how to compile into 1 your database or forms made from ms access?i mean how will i make my form as .exe? ...
Score How can I open an old "MS Works" database in Access?
Arty - 13 Oct 2006 5:35 PM - 4 messages
I'm trying to save my old customer mailing list that I crested using the WORKS database utility. I sure hope I don't have to manually enter the 1000+ records in my new Access2003 program. ...
Score Is it possible to change a control properties from within VB
RayC - 13 Oct 2006 4:51 PM - 4 messages
Here is my issue. I hav a Text Box in a form that is bound to a Table and when I want to display a Field in a Record that is fine but I also want to have the user select from a Combo Box in order to change or enter information ...
Score steps to convert mdb to adp ??
Maggie - 13 Oct 2006 4:30 PM - 12 messages
what are the exact steps to create a mdb to adp ?  I have a mdb - database/screens,etc.  I want to create an adp.  I have seen the database utilites - upsizing and make mde file. The documentation isn't helping much.  ...
Score Read Text table
AccessNow - 13 Oct 2006 3:37 PM - 15 messages
I have an access db that has a table with 3 fields in it and in the last field it is all text with delimitors. My question is how do I read this field (PERFDATA), so that I can separate ...
Score What is the best way to duplicate a record?
J - 13 Oct 2006 2:07 PM - 4 messages
I need to be able to duplicate a record in VB and then return the primary key so I can make changes to it.  What is the best method for doing this? ~J ...
Score HELP ME!!!!!
Johnson - 13 Oct 2006 1:31 PM - 3 messages
I need to find the cheapest in a range of data and then display the cheapest as a name (text), using Excel. So if I had Dog  £50 Cat  £67 Goldfish £20 ...
Score goto record on form
MikeLostinWoods - 13 Oct 2006 12:59 PM - 3 messages
I have a text box for searh criteria on a form and a button to bring up records showing on another form.  Every thing works great except, all the other records lock out.  (Default where no records match brings them all up ...
Score set form.recordsource with a query string
Dsperry101 via AccessMonster.com - 13 Oct 2006 12:34 PM - 8 messages
Hey y'all    I'm trying to make a form recordsource from a previous form combo box , I keep getting "you cancelled previous operation" regardless of which event I put the following code: Private Sub cmdGo_Click()    MWONumberSelected = cboMwoselect.Column(0) ...
Score steps to create an adp
Maggie - 12 Oct 2006 10:44 PM - 2 messages
hi, I cannot remember how to do this.  I want to create an adp project from my mdb database.  What are the steps?  I know that  I need to create an adp and an ade file which should be distributed, but i can't find it now. Can you ...
Score Page Break
cacacaconnie - 12 Oct 2006 10:41 PM - 2 messages
On a purchase order....how do I creat a page break and repeat the header only when I have more line items that will fit on one page? ...
Score how can I global delete in Access 2000?
keith c. - 12 Oct 2006 9:52 PM - 3 messages
I am trying to delete the same phrase "w/vocals" in 50,000 rows. ...
Score Expression and VBA Code
cacacaconnie - 12 Oct 2006 9:09 PM - 4 messages
I'm a new user of Access 2003, what's the best method for learning VBA code? ...
Score Getting lookup list info to replace id#s
Cheese_whiz - 12 Oct 2006 5:35 PM - 5 messages
I'm still a little confused about the whole "lookup" table issue.  From what I can figure, you're alright as long as your table doesn't have a combobox type control in it, but that's not really my question. ...
Score what is the max number of records for access 2000&2003 table?
Randy Pfarr - 12 Oct 2006 5:23 PM - 8 messages
what is the max number of records for access 2000&2003 table? we have encountered table corruption above 15000 records in access 2000. ...
Score Address label
Beyan - 12 Oct 2006 5:19 PM - 3 messages
Is there a solution for this problem: Man: Dr. Name Female: Madam dr. Name Man, no title: Sir Name Female, no title: Madam Name How to omit Sir when the person is a Man and keep -Dr. Name- only. How to make the “Dr.” appear in small case when the person is a female ...
Score Multiple Counts By Month?
Roger Tregelles - 12 Oct 2006 2:08 PM - 7 messages
Hi Folks, I need to create a query that I can use to create a chart from within Access. I create monthly reports that show a 12 month snapshot of our records (bar charts by month). The main information I would be getting from ...
Score autonumber incrementation
forumware - 12 Oct 2006 12:02 PM - 3 messages
Hi. I would appreciate it if someone could help me with this: Table 1 internal id = autonumber Now i want the internal id in table 2 to point to internal id of table 1 and add a suffix: table 2 ...
Score How do i change the check box value in a form?
xneiax - 12 Oct 2006 6:24 AM - 3 messages
Say I have created a form. One of the headings read "Type of Damage" and I have 2 optons to select for that. Option 1 - "Struck" and Option "Damage". How do I format it:- 1. so some one can only select ONE of the options. ...
Score how do i change the check box value in a form to be reflected in m
xneiax - 12 Oct 2006 6:23 AM - 2 messages
Say I have created a form. One of the headings read "Type of Damage" and I have 2 optons to select for that. Option 1 - "Struck" and Option "Damage". How do I format it:- 1. so some one can only select ONE of the options. ...
Score errors in access
Moni - 11 Oct 2006 11:31 PM - 2 messages
I am getting weird symbols, boxes and errors in only one record in my database...what does this mean? And how do I fix it? ...
Score where is the connection string defined?
Maggie - 11 Oct 2006 10:20 PM - 4 messages
hi, I can't find the connection string properties in my database project. Where are they defined?  I was looking for a connection string , but I can't find one. How is this done ?  All of the forms are bound, so i don't know if there ...
Score How do I redefine 1st Quarter in Access
gemolo - 11 Oct 2006 7:18 PM - 6 messages
I wish to make the fist Quarter of the year = April 1 to June 30 ...
Score customer count?
bobbygo - 11 Oct 2006 5:54 PM - 3 messages
I have an access database with specific date and time information for individual customers. I need to create a report showing the hourly customer flow by month...how can I set up the query to do this, without showing each unique time, but ...
Score Image insert Help
scott - 11 Oct 2006 5:40 PM - 2 messages
information on property owners water service. In my datatbase I made a place for drwaings; each owner has a seperate drawing but not all owners need a drawing. The drawing's are use for water vavles that may be hard to find or ...
Score Insert Bitmap Help!!!!!
scott - 11 Oct 2006 5:37 PM - 2 messages
I am fairley new to building a data base. The database that I built records information on property owners water service. In my datatbase I made a place for drwaings; each owner has a seperate drawing but not all owners need a ...
Score Start up Options
zaps via AccessMonster.com - 11 Oct 2006 3:19 PM - 3 messages
Hi there, I seemed to have lost my start up menu.  I have been reading lots of posts about holding down the shift key when opening the database or using the F11 button.  I have tried both of these, and I still can't get at the start up ...
Score Save records ONLY if the save button is pressed.
DiSepe - 11 Oct 2006 2:39 PM - 7 messages
I'm using a form and sub-form to both enter and display entries from a table. I was able to set it up so that, on open, the form goes to the next record.  However, I only want to save the data in the new record when the save button ...
Score Simple Database Question (I hope)
Tom Hall - 11 Oct 2006 1:57 PM - 10 messages
A while ago I created an Access database simply to contain the list of all Stargate SG-1 episodes, ordered by season number and disk. I thought I was being smart when I assigned the episode number field as an ...
Score "label wizard" in MS Access 2003
mtravali - 11 Oct 2006 1:26 PM - 4 messages
I used to use Office 97 with Access.  We just converted our computer and it uses Access 2003.  The features are different, but the one thing I cannot locate is the "Label" wizard.  The query wizard is there, but not one for ...
Score Gift Certificate
sand - 11 Oct 2006 12:29 PM - 3 messages
I am looking for a blank gift certificate for a 8 year old granddaughter. ...
Score Adding Letters to Numbers
DS - 11 Oct 2006 12:25 PM - 3 messages
I want to add a letter after a number... 1 1A 1B 1C So if I start with 1 when I push a command button the next highest letter would come up no matter where I start in the sequence. ...
Score Frustrated at work
northwestox - 11 Oct 2006 5:38 AM - 2 messages
Can anyone explain to me the following concept? How do I auto populate a checkbox in one table based on data from another table? Basically, everyone that has an entry in Table A needs to have a check in a field in Table B. ...
Score can not open saved file,dialog box is open
lee - 11 Oct 2006 4:16 AM - 2 messages
saved off a web site, but when I try to open I get a command cannot be performed because a dialog box is open. Click ok, and then close open dialog boxes to continue. When I click ok everything goes away ...
Score Is there a good template for a post meeting de-briefing?
MGD - 11 Oct 2006 2:46 AM - 2 messages
I am trying to find a good template or reporting style for an assignment that I have been given from my boss.  I have to do a follow up to a Team meeting that he headed. ...
Score Don't want the mouse to scroll
Mommio2 - 11 Oct 2006 1:29 AM - 2 messages
Hi,      I have a form which is used to update student data.  I have buttons to move to the next record and to search for a particular record.  However, the mouse scroll wheel scrolls through all the records instead of just down the ...
Score Help me with Access 2002. The installer is not properly installed
Johanne - 10 Oct 2006 11:46 PM - 2 messages
The message says this: "The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer is not correctly installed. Contact your support personnel for assistance. What do I do now? I need this program to work an application and I have to ...
Score Are Office and Works interchangeable?
sarwoody - 10 Oct 2006 10:57 PM - 3 messages
If I have Microsoft Works, can you use the database with Microsoft Office? ...
Score Package Wizard
Christo Yssel - 10 Oct 2006 10:15 PM - 6 messages
Hi, I am trying to create a distributable database using the package wizard from the developer extentions.  I need to install the .mdb on a computer which does not have access installed.  Everything seems to work fine, but once I ...
Score DoCmd over-rides form settings.
ga - 10 Oct 2006 4:01 PM - 3 messages
Can someone please tell me how I change - DoCmd.OpenForm stDocName, , , stLinkCriteria so that when my form opens, it stays in data entry mode rather reverting to edit mode. Thanks GA ...
Score Sub Sub and Circular
Dan - 10 Oct 2006 3:08 PM - 2 messages
I want to make a database with Subjects of contact.  Companies of contact. And, Names of contact. The "Names" fields (with phones and extention, email, etc.) are unique to certain "Companies" fields (with addresses, faxes, etc.). Further the "Companies" fields are unique to certain "Subject" fields (jobs offered by ...
Score Mystery pop-up
Novice2000 - 10 Oct 2006 2:07 PM - 4 messages
Hi, I have a pop-up every time I try to run my report. It is an "Enter parameter value" pop-up requesting input. I just click it off, but it is very annoying. I have no idea what data is requesting input, since this field doesn't seem ...
Score Minimum Fees
Novice2000 - 10 Oct 2006 2:05 PM - 12 messages
The fee is calculated in excel, brought over into an access report, and the field is displayed on a report. I am trying to apply criteria that would set a minimum fee of $25 for group 15 and for every other entry a $75 minimum fee. ...
Score can you send me coursework templates?
hassan ali waheed - 10 Oct 2006 12:51 PM - 2 messages
how r u ...
Score Data entered is not displaying
Sarah E - 10 Oct 2006 11:43 AM - 6 messages
Access Microsoft 2003 - I have entered data through one of my tables, but it is not displaying in the select query/form I have created for the data. How do I get it to display? ...
Score Help me do this, urgent!
smith - 10 Oct 2006 11:42 AM - 2 messages
I have to have the data transfered automatically in the fields. 1. Data in Field A= data in Field B* data in Field C/ 100.How to do this in the "Forms"? 2. data in Field C= data in Field D+12. How to do this in the "Forms"? ...
Score Search Button in SubForm not Working
Jen - 10 Oct 2006 10:57 AM - 7 messages
Dear All I'm sorry to trouble you with such a basic question, but...(!) I have a form of event details, and a subform within with person details.  I have put a command button in the subform to search (find a record).  When I ...
Score question about macros
ales - 10 Oct 2006 9:55 AM - 3 messages
Hello, I would like to launch automatically a macro in opening my data base. Could anybody tell me how to do it, please....? (the macro opens a form). Thanx in advance! -- ales ...
Score Calendar
Mike Langensiepen - 10 Oct 2006 6:40 AM - 11 messages
I have a Kitchen Sales application that stores various date categories - measure date, delivery date, install date etc. Does anyone know of a calendar application that will scan through the database and display a calendar for a specific month with all the events shown? ...
Score 'firing' a Button!
Soddy - 9 Oct 2006 10:11 PM - 4 messages
Hello! I use to know how to do this, but I have forgotten!!  I have an event procedure on a form for a textbox (txtBox_GetFocus).  When this control 'gets the focus' (in the txtBox_GetFocus event), I want it to 'fire' a Button ...
Score can I send clip art from my home to my work computer
Carol - 9 Oct 2006 8:46 PM - 2 messages
Is it possible to forward some of my clip art from my home computer, to my work computer, by inserting intoan emai? ...
Score can I send my clip art from my home computer to my work compter
Carol - 9 Oct 2006 8:35 PM - 2 messages
How can I send some of my clip art from my home to my work computer? ...
Score how do i transfer data from excel into access?
Michelle L - 9 Oct 2006 7:03 PM - 4 messages
I really don't know anything about access, but my office is trying to transition into access for some of our employee files.  If I already have some information on excel worksheets, how can I transfer that data to access? ...
Score Sending e-mail
OldManEd - 9 Oct 2006 6:09 PM - 5 messages
I have a membership data base. Most but not all member's records includes an e-mail address. How do I use this to send a general announcement to the members with e-mails? EdC ...
Score calculated controls
Pat - 9 Oct 2006 5:28 PM - 6 messages
I'm a student.  I am creating a query that for illistration purposes wants to merge the LastName and FirstName fields in a query.  The query is based on a table.  This demo is suppose to shol calculated fields.  when I enter ...
Score access combo box inserted same infomation in all forms
Stonewall Jackson - 9 Oct 2006 5:20 PM - 8 messages
When I make a combo box in a form. The information I type in any one form is repeated in all forms. ...
Score assign value to field
skopp - 9 Oct 2006 4:48 PM - 4 messages
I'm creating my first Access (2003) database and I think this should be a simple question. I've created a form that enters information from the user in a table. When they click the button to "Add new record", I want to ...
Score Word Files
milcar - 9 Oct 2006 1:56 PM - 2 messages
Everytime I open an existing word file a copy of the file is saved underneath the original with two two signs in front one is a squiggle and the other is like a dollar sign and the file iname is  faded. Why is this happening. ...
Score I Hate Math - An Expression
Novice2000 - 9 Oct 2006 1:39 PM - 13 messages
This is the best one yet. I have a Fee for services on my report. It works perfectly from my point of view. It rounds the calculated fee from $545.52 to $546. My boss says he wants it to round up to the nearest "even" dollar amount, ...
Score Day
Chris - 9 Oct 2006 12:58 PM - 2 messages
How Do I display the date as; Friday 02/04/2006 Basically I only need a way of finding out what todays' Day (Mon, Tues, etc) is and I can append it onto the ddmmyy date. ...
Score Multiple Table Relationships
Gopher - 9 Oct 2006 3:36 AM - 2 messages
I have created an employee table with a unique employee ID(also my Primary Key) for each employee.  I track each employee's various trainings attended and the date they completed each training.  I established a one-to-many ...
Score Relationship Help Please
Gopher - 9 Oct 2006 3:34 AM - 2 messages
I have created an employee table with a unique employee ID(also my Primary Key) for each employee.  I track each employee's various trainings attended and the date they completed each training.  I established a one-to-many ...
Score Can I exxecute a String?
RayC - 8 Oct 2006 10:55 AM - 3 messages
Is it possible to execute a String? e.g. if I type in something like "TextBox1.Visible = True", the code executes that line and makes the TextBox1 Visible. What I am asking is would it be possible to have strString1 ="TextBox1" and strString2 = ...
Next »