Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Using an SQL statment in a report in Access 97
Jack Dawson via AccessMonster.com - 26 Feb 2005 8:26 PM - 9 messages
Let me try to explain this. I am trying to create a sales commision report. In this report I have to give each an itemized list of their sales commisions for the month.  I have it almost done with on minor hitch.  The ...
Score MS Access: How to group records/addresses by category/categories
wattog - 26 Feb 2005 6:33 PM - 2 messages
I am new to Access (2002), and am reading up on it in two books.   I have also checked the online help, but can't find an answer to what I would think would be a very basic question about categories or groups of records. ...
Score How do I creat a Date Range to open Report
Alvin Smith - 26 Feb 2005 1:45 PM - 4 messages
I have a report named ( Pay Hours ). How can I open this report based on start date and end date. Thanks in Advance ...
Score How do I creat a Date Range to open Report
Alvin Smith - 26 Feb 2005 1:45 PM - 11 messages
I have a report named ( Pay Hours ). How can I open this report based on start date and end date. Thanks in Advance ...
Score I locked, now I cant unlock
Claudio - 26 Feb 2005 4:56 AM - 4 messages
I'm sorry for my English as well as the terms I will use here. I don't know much about the names and terms used here. I started my first little project and got to the point I was happy about it, and so I started experimenting other ...
Score how do u make a foreign key
D L Barnard - 26 Feb 2005 1:23 AM - 2 messages
i understand what a foreign key is.  i have forgotten how to assign one.  pls advise.  thank u to whomever respnds.  (university student). ...
Score error user defined type not defined
terry - 25 Feb 2005 9:43 PM - 4 messages
I have this function in global code that I am calling from a query.  I am getting an error message User defined type not defined.  I am a VFP programmer, new to access.  I had originally forgotten to add the "as long" ...
Score page numbers in report restart per record
Shannon - 25 Feb 2005 9:33 PM - 7 messages
How do I get the page numbers to restart (1 of __) for each record in a report?  Right now each record in the report is about 3 pages, which is fine, but when doing several records the first record says 1 of 6 instead of 1 of ...
Score .dba that I can't open
Denise - 25 Feb 2005 7:23 PM - 3 messages
Very new user to Access Trying to pring labels from a .dba someone sent me.  I can't even get it open.  Will Access open it?  Print labels from it? I'm much more familiar with the simple process of creating a database in ...
Score which event?
mcnewsxp - 25 Feb 2005 7:15 PM - 2 messages
my form has a button the puts it in to add new record mode. the caption of the add button changes to say Save New Record. which event do i trap if the user moves off the new record and wants to ...
Score Known issues from A2K to A2003
B.Hammerstrom - 25 Feb 2005 6:40 PM - 1 message
My db was developed under WinXP and Access2000. Now I have a new PC with WinXP and Access2003 and I have a problem with the db freezing when the Jpeg import progress dialog is on screen. The problem is intermittent and I have ...
Score DB Design Question
David - 25 Feb 2005 6:04 PM - 4 messages
Hello everyone, I am trying to create somewhat of a MSProject Database. User will enter employee's name, job (JOBID), Start Date, End Date.  The twist is each JOBID has hrs per day associated to it.  So one employee could ...
Score Need help creating a database
knoxie1 - 25 Feb 2005 6:03 PM - 4 messages
I'm doing some part-time work for my mother's office and she needs a database consisting of students in her program, what classes they need to graduate, the classes they have taken, and their personal inforamtion.  I'm very new to ...
Score Microsoft Graph Problem in Access 2003
Cory - 25 Feb 2005 5:04 PM - 2 messages
I Access 2000 databases and then I upgraded to Office 2003.  Now when I try to open some reports that had graphs in them, I get a message saying that it is trying to install Microsoft Graph.  When the report opens, none ...
Score How do I convert an Office 2000 WDB file to Office 2003?
Fairhaven - 25 Feb 2005 4:45 PM - 5 messages
I have an Address database that I created in Office 2000.  I cannot access it since we upgraded to Office 2003.  It will not open in any of the programs.  Does anyone have a solution? ...
Score Query based form errors
Michelle - 25 Feb 2005 3:37 PM - 3 messages
I've created a form based on a query which has 4 tables that are all related. The form works great and does what it is supposed to. BUT...When I tried to add a fifth table which stores changes to my employees table, but I get an ...
Score relationship & Input for 5 tables in a single Form impossible
Rasoul Khoshravan Azar - 25 Feb 2005 2:35 PM - 3 messages
For some reasons (should be discussed later) I have split out my database to 5 tables all haveing a common field (OrderID) which is a primary key to all. I would like to enter data for all five tables in a single Form (I made a ...
Score Changing the Value of an Autonumber
Sammya66 - 25 Feb 2005 11:03 AM - 4 messages
Hi Im a new user to MS Access. I'm designing a database that requires an Autonumber to be sequential and start from the value of 40000 (QS NUMBER) - This Autonumber is set to the primary Key. At the moment it  starts ...
Score small code problem - IF statement
Lee-Anne Waters via AccessMonster.com - 25 Feb 2005 6:35 AM - 3 messages
Hi, would someone please help with this. i cant get it to work.... if me.AuditSelectNum > "150" & < "280" then     MsgBox "Test"     End If many thanks Lee-Anne ...
Score How do I center text in a column in the database?
silvertopfox - 25 Feb 2005 3:41 AM - 1 message
I have a database set up and have two columns that will just need an "x" in them.  How do I center the text as the column heading makes it quite wide? ...
Score How do I center text in a column in the database?
silvertopfox - 25 Feb 2005 3:39 AM - 3 messages
I have a database set up and have two columns that will just need an "x" in them.  How do I center the text as the column heading makes it quite wide? ...
Score I keep getting a syntex error mising operator
Alvin Smith - 25 Feb 2005 2:17 AM - 3 messages
I am trying to keep up with my hour with straight time over time double and triple time. This is the expression I am using in my subform when I get the message. SELECT DISTINCTROW [Order Details].*, Clng(([Rate]*[SThrs])+([Rate]*[OThrs]*1.5)+([Rate]*[DThrs]*2)+([Rate]*[TThrs]*3) AS [Line Total] FROM [Pay Hours subform]; ...
Score Which Approach?
David - 24 Feb 2005 11:39 PM - 2 messages
Hello everyone, I am trying to create somewhat of a MSProject Database. User will enter employee's name, job (JOBID), Start Date, End Date.  The twist is each JOBID has hrs per day associated to it.  So one employee could ...
Score Can Add but Can't Subtract
DS - 24 Feb 2005 11:03 PM - 5 messages
I Have a form set up with 2 Subforms on it. At the bottom of the Main Form I have a Total field that grabs the totals from each of the subforms.  It works fine when I add records, but ...
Score Concatenate two fields and then make a lookup box
Shannon - 24 Feb 2005 9:59 PM - 3 messages
How do I combine two fields and then make them a lookup box?  I know how to make a lookup box in a table (using the lookup wizard) and know how to concatenate two fields in a Query, but how do I do both?  Would this be using ...
Score Auto fill a box
Donald - 24 Feb 2005 8:55 PM - 5 messages
have a form with a few fields I want auto field. I would like to pull the data from a table that I have set up. Right now im using this code in the after update to fill in the field. ...
Score Does anyone know where or if Office 2003 has a shortcut bar?
Nora - 24 Feb 2005 8:19 PM - 2 messages
...
Score Link database with via FTP
Pat59 - 24 Feb 2005 7:06 PM - 2 messages
Hi, We could link a database on a Network. Can we do this on a FTP site? Thanks Pat ...
Score Allow additions via VBA code
mcnewsxp - 24 Feb 2005 6:45 PM - 3 messages
can i change the Allow Additions daat property via VBA code? if so, how? tia, mcnewsxp ...
Score Require a child record (on Subform)?
D. Shane Fowlkes - 24 Feb 2005 6:31 PM - 2 messages
Hello all! I have a simple form which also has a subform in it where child records can be written to a child table based on the parent record/form.  I would like to make it required that the user enter/pick at least one child record (buy ...
Score how can automate importing many excell .csv file into a access ta.
lamont - 24 Feb 2005 6:05 PM - 2 messages
...
Score Dictionary Thesauras
HB - 24 Feb 2005 6:03 PM - 2 messages
Does anyone no where I can download a data file with all the words in the english language & also possibly a Thesauras. It must be a data file I can download  (or purchase on CD - not a program) ...
Score A little doubt in the access.
Hdrummer - 24 Feb 2005 5:45 PM - 2 messages
I was trying to open a file and the following menssage appeared (not enough space on disk) I tried to delete somes files and nothing happened I would like to solve this little trouble because I am needing too much to open this ...
Score Problem in Stored procedure parameter
Sunny - 24 Feb 2005 4:43 PM - 1 message
This is my stored procedure on SQL server" CREATE PROCEDURE CalculateSales @SalesAmt  money = 0 OUTPUT, @SalesmanId  char(10) AS Begin     code... end Following is the code in vba to call stored procedure: Dim adoCommand As Command ...
Score Error when compacting/repairing
mscertified - 24 Feb 2005 4:39 PM - 1 message
I have a couple of strange things happening in my Access 2000 database. When I try to copy a report I get a message 'Name conflicts with existing module, project or object library'. I dont know what this means, it's a new report ...
Score Disable new records until cmdbutton is pressed
Kinster - 24 Feb 2005 4:29 PM - 1 message
In using a form to input data to a table, the form automatically creates its new record.  I would rather have the user do that with a button when they are sure that all of the data is correct.  I have the button on the form, but if ...
Score Is Access Membership Database Wizard available in Office 2003 as .
Wits End. - 24 Feb 2005 4:23 PM - 2 messages
In Office 97 there was a wizard for Access Membership Database. Now i use a friends computer who has Office 2000 and the wizard is not there. Can it be made available for Office 200O. Iam not the most computer literate person and ...
Score Change type case of data
Timboo - 24 Feb 2005 4:01 PM - 2 messages
Hi, Im executing an append query to import data into a table.  The imported data source has the names in UPPER CASE and I would like to change this upon import to Capital first letter only. I am going to use the following code for standard data entry ...
Score Need help on Stored Procedure
Sunny - 24 Feb 2005 3:20 PM - 3 messages
Can anyone give me sample code, how to call stored procedure from vba with output and input parameter? Thanks. ...
Score How do I create a page of labels in Microsoft Access?
Teacher2000 - 24 Feb 2005 2:29 PM - 3 messages
I created a table with the names of customers that I need to send invitations to.  I would like to know how to create a page of labels using the information I have on the table in Microsoft Access 2002. ...
Score dragging fields in design form view
Rasoul Khoshravan Azar - 24 Feb 2005 2:06 PM - 4 messages
I am using an Asian right-to-left language. So I prefer that labels for fields appear in right and data boxes appear in left. When I drag fields from field list to form design page, lables appear in left and data box in right which is an English format. Is it possible to ...
Score Printing list of forms and tables
Deb - 24 Feb 2005 1:43 PM - 3 messages
Hi all.. Is there a way that I can print a list of all the forms and tables and reports that I have in my database.  I dont want the information in them, just a list of them. ---Deb ...
Score Returning Row Totals for each record entry
Mark - 24 Feb 2005 10:41 AM - 2 messages
Reports: The following fields are in the Details Section: [Name] [Date] [Dressing] [Feeding] [Personal Hygiene].  The [Dressing] [Feeding] and [Personal Hygiene] fields are combo boxes with a value list of 0 1 2 3 4 respectively. (Have I committed the cardinal sin of using ‘Lookup Fields’?) ...
Score Syntax to refer to a control on a subform.
Timboo - 24 Feb 2005 8:59 AM - 4 messages
Hi, I have (below) some code that opens a form(FrmRecUpdate) based on the selected PatientNo in another form called FrmClinic1sub.  'DoCmd.OpenForm "FrmRecUpdate", , , "[PatientNo] = Forms![FrmClinic1Sub]![PatientNo]" This works fine when the form FrmClinic1Sub is opened as a standalone form. ...
Score hi there, i cannot find the send icon on my microsoft outlook, wh.
cathrryn - 24 Feb 2005 8:03 AM - 2 messages
Iannot send emails through outlook, as i cannot see or find a  SEND icon anywhere, could someone show me thanks cathy ...
Score How to?....
Igor - 24 Feb 2005 6:23 AM - 2 messages
Hi, I am not sure that this is a forum for my question, but may be somebody could help me or direct me to the appropriate one. I want to push button on Access form and to produce document that is text ...
Score Problem with Innerjoin and count.
Jimmy Smits - 24 Feb 2005 1:18 AM - 2 messages
Hello, I have 3 tables tblParticipants: Group UserID(Primary) Username PW Email TblPicks: Pickvalue(primary autonumber) PlayerID Pick1,Pick2...Pick63. TblResults: Pickvalue(primary Autonumber) Pick1, Pick2...Pick63. I am trying to find a way to compare the two databases so that I can count ...
Score Cascade Delete / Linked Tables
DS - 24 Feb 2005 1:03 AM - 3 messages
I have a split database..Tables in one, the rest in another. On the tables one I have a cascade delete set-up between 2 tables, this worked fine until I split the database...Now the cascade delete shows in ...
Score Can Not Open Any More Databases
Dave - 24 Feb 2005 12:32 AM - 14 messages
Has anyone encountered the error message "Can not open any more databases" and what did you do to solve it? Thanks, Dave ...
Score relating two tables of similar data type with other tables & queri
PJ - 23 Feb 2005 11:35 PM - 5 messages
I am developing a relational database to track student projects. It uses a many to many junction table to link a student with a project, because over time a student can have more than one project. This works fine in most ...
Score Proper Case
DS - 23 Feb 2005 11:14 PM - 5 messages
I have a textbox, just one, on a form.  I type info into it and transfer it to another field.  How would I get that first textbox to automatically format to Proper Case, I see access can do lower case, it ...
Score How do I number and rank records in Access, based on another field
Heather - 23 Feb 2005 9:11 PM - 2 messages
I am trying to rank the records in my Access database based on a field which contains the sum of other fields.  I need them to be ranked in order from greatest to least and I need the ranking number to be returned (displayed) in ...
Score Is it possible to design Access like excel?
Tess - 23 Feb 2005 9:11 PM - 6 messages
I am new to acccess, we thought we would try it to see if it would be easier for what we are trying to do in excel. In excel I made a workbook up with multiple worksheets for every job. eg: ...
Score Link to dbf file requires selecting an index
ld - 23 Feb 2005 8:35 PM - 7 messages
I'm trying to use MS Access 2003 SP1 to link to a dbf file.  I do not have dBASE or FoxPro installed. When I use the Table wizard to link to an external file, if I choose a file ...
Score DAP Field - Phone number formatting
Tim D - 23 Feb 2005 8:33 PM - 1 message
How do I get a phone number field to diaplay correctly in a data access page. I have my table set with a phone number input mask. When the data display is the DAP it is just a string of numbers. ...
Score button on main form sets up subform for new record
mcnewsxp - 23 Feb 2005 8:30 PM - 3 messages
i need a docmd or something like that to place a subform into new record mode (like nav bar >* ) when i push a button on the main form. this is a quick and dirty app so no lectures please. ...
Score Automatically updating Tables
Heather - 23 Feb 2005 8:13 PM - 5 messages
Hi, I'm trying to set up a database and I need some help.  I need to set up two tables so that when information is entered into one table (call it Table A) it automatically updates into the other (Table B) but not vice versa.  ...
Score Unbound Subform error
Chris - 23 Feb 2005 6:16 PM - 1 message
I have an unbound form containing an unbound subform. I'm using an insert SQL statement to put the data into the table from the subform and binding the controls using standard (controlname.coutrolsource = Rowsource. ) After the record is saved I'm unbinding the controls and using resetControl ...
Score Inventory Database
Connie Wickam via AccessMonster.com - 23 Feb 2005 5:49 PM - 5 messages
I am working on creating a timeshare sales and inventory database.  I am having difficulty with the inventory.  The problem is that one unit could be sold either by odd years, even years or consecutive years.  If a unit is ...
Score Downloading graphics
Terje - 23 Feb 2005 5:37 PM - 2 messages
What does a square with a red X in it mean? ...
Score Buttons and Listboxes
DS - 23 Feb 2005 4:52 PM - 5 messages
How do you set up a listbox that is filled by pressing a command button. I have two buttons, if you press button 1, I want the listbox to fill with certain info, press button 2, it would fill with other info.  The ...
Score Query to find last entry of date
Mark - 23 Feb 2005 4:16 PM - 2 messages
I have an contact history table that contains a variety of fields including contactid and completedate.  The completedate is automaticaly populated with a date when a new history record is added. I now what to write a query that pulls from this table the ...
Score Custom Graph
Blondie96 - 23 Feb 2005 3:59 PM - 6 messages
I need to be able to create a graph that shows the days & hours a person uses a room. I need a color bar to represent the hours of each day used by each person. So there could be multiple bars on the same day (days shown ...
Score Make table loop?
Daniel - 23 Feb 2005 3:52 PM - 3 messages
Hi, I have a very large table that I want to split into chunks so I an paste it into excel. The table is lookup table it onlt has two colmns but is massive. The two cols are code and description. What I would like to do is ...
Score COMBO BOX - 2ND VALUE
Samora - 23 Feb 2005 3:51 PM - 2 messages
Hello Good afternoon i have a Combo box that retrieves me a value CODSAUDE from a table (TCodigos) and placed it on field CodCSaude of table TDet. this i had allready done and is OK. However i want that after update this field  , CodCSaude ...
Score Query must filter out records beginning with text "192"
Rene Wennekes - 23 Feb 2005 11:19 AM - 5 messages
SELECT webstats.Tijd, webstats.Computer FROM webstats WHERE (((webstats.Computer)<>"192.168.0.204")); if i put * after 192 i get a syntax error. with left and ;3 also. I want to filter out what begins with192 How do i do that? ...
Score Criteria with verifying the first 3 characters of a text - how
Rene Wennekes - 23 Feb 2005 8:10 AM - 3 messages
I want to make a querie with a criteria to filter out only the records with text what begins with "192". How do I do that? Rene ...
Score On Screen Keyboard
DS - 23 Feb 2005 3:35 AM - 11 messages
Anyone know wherte I can get an On Scree keyboard for Access.  I don't want the Microsoft one.  Maybe something that I can customize. Does anyone know how to build one? Thanks DS ...
Score No Current Record
Mike Revis - 23 Feb 2005 1:32 AM - 3 messages
Hi Group. Access 2000. Win xppro. I have created a command button to delete the current record on my form. The command button created by the wizard uses the DoMenuItem. It gives me an error of "No Current Record" after deleting the record. ...
Score Views in SQL; whats in Access?
Rahul - 22 Feb 2005 11:45 PM - 8 messages
Hi, I was just getting started using SQLand came accross a construct I plan to use:- CREATE VIEW xyz AS SELECT * FROM abc WHERE condition This does'nt seem to work in Access? I could just make a table using a ...
Score Sorting to exclude with more than one instance of "x"
Kinster - 22 Feb 2005 11:21 PM - 2 messages
i am trying to create a combo box that will allow users to pick a year value from a table and I am trying to limit the choices based on what is in query. example; tbl_years  has a field with the values 1995 through 2005 ...
Score reference a field on a subform from owner form
mcnewsxp - 22 Feb 2005 10:06 PM - 2 messages
i forget how to reference a field on a subform on the owner form. something like form.fieldx.value = forms![subform].[fieldz].value tia mcnewsxp ...
Score Copy to Main Page!
Bob - 22 Feb 2005 9:23 PM - 4 messages
...
Score Use Access to review forecast vs. actuals.
Jerome - 22 Feb 2005 8:09 PM - 2 messages
I am attempting to build an Access db that will allow users from 4 departments to enter forecasted project hours and information for a given month.  Then when needed they can enter the actual hours and/or project information and report against it.  Each dept can have hours for the same ...
Score newbie - sql UPDATE statement
Newbee Adam - 22 Feb 2005 7:33 PM - 3 messages
I am running this command in an access 2000 code module. I am trying to update a table in the same access 2000 db. I need to update this part of the field value: 0301730" to 030173C0. But the first part of the string : ...
Score A query on "This Week"
Robert Gillard - 22 Feb 2005 7:31 PM - 5 messages
I need to run a query against a date field so I can see how many items have been added this week. This needs to be a perminat query ie click a button and it will run without the need to change or incert dates etc. ...
Score how do I query dates
clueless - 22 Feb 2005 6:37 PM - 2 messages
I am setting up a school database of former students.  Right now, I have a "dates attended" column with years entered (e.g., "89-95"), although I know I'll probably need to put this in a better format.  I'd like to be able to ...
Score In a lookup column, looking up multiple fields, can I change whic.
rthunder78 - 22 Feb 2005 5:15 PM - 2 messages
In a table of "internal training", I have a lookup column which looks up an employee key, employee last name, and employee first name.  When I try to include this in a report, only the employee key is displayed.  Is there a way ...
Score Can't find Master Link and Child Link Attributes
Laurel - 22 Feb 2005 4:19 PM - 21 messages
I have a form with 4 tabpages.  I have subforms on two of those tabpages.  I successfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the  "data" tabpage ...
Score data on the web
jc - 22 Feb 2005 3:25 PM - 2 messages
I split my database and uploaded the tables up to our website. Now everytime I try to link the tables I get an error "not a vaild file name".  I'm not sure is what i'm doing can be done to begin with.  I just want to be able ...
Score MAIL- COMMAND or ACTIVEX
Samora - 22 Feb 2005 1:04 PM - 6 messages
Good Morning Is there any chance on Access or do i have to code on Visual Basic a command button in order to open Outlook Express to send an e-mail? i checked all the buttons in Access but i didn't see anyone. ...
Score How could I call a data in a form
filo666 - 21 Feb 2005 9:55 PM - 5 messages
Hi, I have 2 tables: Table1 where I put the employee number with his name and last name and table2 where I put the employee number ( with out name and last name)and his debts, after that I made a Form with the Table 2, what I want to ...
Score Switchboard
Loi - 21 Feb 2005 6:53 PM - 4 messages
Hi, I have a splited database. Please show me how to update its switchboard or send me some websites so that I can learn how to do it. Thank you Loi ...
Score Copy expressions with one change in each of 36 boxes
Sabra DeJournett via AccessMonster.com - 21 Feb 2005 4:11 PM - 9 messages
Here's the deal, I have a report with 36 "boxes" each with 3 expressions that look like this =DSum("[this]","there","[they] = 'who' AND [that] = 17") OK, the "who" changes in each of the three expressions that are in each of ...
Score Display all fields that are yes in a table in one box
Trotsky - 20 Feb 2005 10:46 PM - 10 messages
Hi all, Im trying to create a report & query that displays a list of fields that are checked yes in a table,Rather than displaying All the fields and their status, I would like a text box that only contains only those ...
Next »