Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Delete Type Query
Paul3rd - 29 Nov 2007 4:39 PM - 2 messages
Hello, I have a project where I have an Appointment table (ApptDis) consisting of the fields ApptDate; ApptSheet; ApptID; (&) Path. There is a form with this query as Data source. I'd like to put a "housekeeping" combo box control on the form with all 12 ...
Score WAY NOT MAITREYA
IVANOV KONSTANTIN - 29 Nov 2007 6:01 AM - 1 message
GOTHD... ? ...
Score Table Display
mel_strom1228 - 28 Nov 2007 10:28 PM - 5 messages
I have two columns:  document number and document version.  I want the table to display only the most recent version (which would be the highest number) of a document.  How can I do that? ...
Score Can you use external changing databases with Access 2003?
hoteljen - 28 Nov 2007 3:36 PM - 3 messages
I need data from 3 external databases, with date variables being a consideration.  is there a way to set up access 2003 to pull timely or historical data from them without having to enter every number? ...
Score WHAT IS BLOCKING MY Z TO A SORT? A to Z works fine.
bill - 28 Nov 2007 3:07 PM - 2 messages
I want to sort a text field within a table from Z to A but cannot.  A to Z works fine. Why? ...
Score Delete two tables with Delete Query
Chad - 28 Nov 2007 11:20 AM - 8 messages
I have two different tables and I need to run a delete query to delete all information pertaining to an employee when he/she is expired threw a button on a continious form which uses one of the tables that needs deleted. How ...
Score Field must be completed if another field is checked
Critt - 28 Nov 2007 11:16 AM - 5 messages
I have a table which contains several fields - one is a check box called "Completed" and another is a Date field called "Date Completed".  How do i get it that if I check the "Completed" box is doesn't allow you to come off ...
Score #Num! numeric overflow query problem
Andy - 28 Nov 2007 10:14 AM - 3 messages
Hi This one's driving me mad. I am trying to 'copy' a linked table into my database. The table is three fields: two that are text fields and one that is a number. The first record is dodgy and has a empty second text field and #Num! instead of a number. I ...
Score typing in datasheet view
buglovesboo - 28 Nov 2007 3:12 AM - 2 messages
My computer or whatever won't let me type more than four letters in each column.... ...
Score Going back to the original command
mclay - 28 Nov 2007 3:10 AM - 2 messages
I've created a database and I'm pleased with the way it looks and functions, but I want to know how to go back to the first command after clicking the add record command (add record being the last command). I want the cursor to ...
Score migrating mdb(s) from Access 97 to Access 2003
anatoly.duzhansky@gmail.com - 27 Nov 2007 10:16 PM - 2 messages
I am migrating mdb(s) from Access 97 to Access 2003. I have never used MS Access before. (I'm PowerBuider developer.) I understand that I have to install MS Access first (of course!) then MS Access 03 -> Tools -> Convert database ->Access 2002-2003 file ...
Score migrating mdb(s) from Access 97 to Access 2003
anatoly.duzhansky@gmail.com - 27 Nov 2007 10:15 PM - 2 messages
I am migrating mdb(s) from Access 97 to Access 2003. I have never used MS Access before. (I'm PowerBuider developer.) I understand that I have to install MS Access first (of course!) then MS Access 03 -> Tools -> Convert database ->Access 2002-2003 file ...
Score Database with Linked tables
benny - 27 Nov 2007 9:42 PM - 2 messages
I am trying to write a database for medical chart reviews.  Each month a certain number of charts are reviewed for complaince to certain procedures (i.e. certain abbreviations are not allowed to be used).  I have created a ...
Score Text in a numeric field
VeryGreen - 27 Nov 2007 8:29 PM - 3 messages
I am a new user and I am struggling.  I have a field that I have designateed as numeric.  It contains room numbers.  The room number are four digits, a ., then 2, 3 or four more digits and can also contain an alpha character at the ...
Score Main form disappears
Brian Snelling - 27 Nov 2007 8:21 PM - 4 messages
Hello,     I have a main form "frmDailyRecords" and a subform "dailyRecordDetails"(in datasheet view). When I enter or change anything in the subform, the main form disappears and will only reappear by closing and reopening. Merely looking at records does not provoke this. Any suggestions ...
Score Uninstall Access 2007
Larry - 27 Nov 2007 8:12 PM - 2 messages
Operating System: Vista Ultimate.  Office Enterprise 2007.  How do I uninstall Access alone.  I want to leave all other programs. ...
Score creating a form
homezone - 27 Nov 2007 7:18 PM - 5 messages
I'm creating a switchboard using an unbound form.  I have a command button to open a form.  I want the form to open in datasheet view, but it's opening in form view.  How do I get it to open in datasheet view?  Any help would be ...
Score Formula help
Chad - 27 Nov 2007 6:27 PM - 4 messages
I have a check box on my form and when I bring up my report I want to have a text box display inactive if the check box was checked and dont dispaly anything if it wasnt checked like visable=false..How would I do this? Thanks! ...
Score Transferring all fields from a table to a query *
socalblondie - 27 Nov 2007 6:02 PM - 4 messages
Hello, How do I transfer all of the fields from a table into a query?  When I use the *, it just puts everything into one field.  Is there an easy way to spread them out so that each title has it's own field? ...
Score Product Components
glenn - 27 Nov 2007 4:34 PM - 3 messages
I am doing a spreadsheet for the price break down of various products. On the first page of the workbook is the components and the prices. On the next pages are what makes each product and the costings. Many of the products have ...
Score Switchboard
Gazie - 27 Nov 2007 4:27 PM - 5 messages
I have setup a switchboard in switchboard manager. When I choose access options / current database /display form. The switchboard is not an option. Am I doing this correctly? ...
Score Addressing items in tables with similar functions, but dissimilar fields
LurfysMa - 27 Nov 2007 4:13 PM - 2 messages
I am workng on a little database application. I have Version 1 working, but ran into a problem. I think I have a solution, but a friend, who is also more or less a beginner with databases, disagrees with me on one of the design considerations. I would appreciate the ...
Score Add records of one table to another table
randy bedore - 27 Nov 2007 3:40 PM - 8 messages
We are transitioning from Paradox to Access. In paradox, when I wish to add a lot of new records to my main table,  I build a table containing the new records, strutured the same as the main table, except that the new record ...
Score duplicate button
steve goodrich - 27 Nov 2007 1:22 PM - 2 messages
I have a duplicate button on my form to duplicate a record that has been working ok for years.  Now when clicked I get an error message "Invalid use of null" Has anyone any idea why this message should appear and a possible solution ...
Score Help with updateing chk box in tbl
Chad - 27 Nov 2007 12:47 PM - 2 messages
Hello, I have a continuous form named "frmUpdateEmployees" which I need to update employee information like name, date of hire and employment status. On this form I have a chk box named "chkStatus" and if checked I want it to ...
Score i'm searching for database wizzard ,music collection.mdz
tony - 27 Nov 2007 12:16 PM - 2 messages
i'm looking to compile a database for my lrg collection of vinyl records but cant fing a suitable database template to use any have any suggestions ...
Score Users setting a password
SF - 27 Nov 2007 11:34 AM - 1 message
Hi I'm currently designing a small database which will be distributed to users most probably using the access2007 runtime. I would like to be able to ship the database with a default username and password. Is this possible in acces ...
Score import .ATT file
mel - 26 Nov 2007 8:23 PM - 4 messages
I receive data files from a customer on a regular basis that are in  .ATT  Format. What I would like to do is import these data files into an access database.  I have tried searching in the search engines, but I am not having a lot of ...
Score Update information in Table
Arlene - 26 Nov 2007 7:27 PM - 2 messages
Help please, I am trying to update information from one program to another.  I have a payroll system and want to update the information in the employee table to the information in a production program.  I have made sure the ...
Score Password protecting database
Lorraine R - 26 Nov 2007 6:11 PM - 5 messages
In Excel you can attach a password to the spreadsheet.  How do I secure my database in Access 2000?  I have a "huge" database containing all the user login information, etc.  There are a select few who will be responsible for ...
Score Change Data from Now() to Date() Format - ** H E L P * *
Jasmine - 26 Nov 2007 2:58 PM - 15 messages
I've been entering data ( for some time ) in one of my field in a database with the Now() format - eg: 11/26/2007 9:52:0a AM I've now discovered that I should have used the standard date() format - eg: ...
Score Mailing list
cantgetit - 25 Nov 2007 10:33 PM - 2 messages
I have created a mailing list and now have to delete some names.  This leaves a blank label when I go to print.  Can anyone tell me what I am doing wrong or how I should be doing this.  Christmas cards are going to be very late ...
Score Newbie's question abut date function
Jorge Cervantes - 25 Nov 2007 2:37 PM - 5 messages
I would like to add/type  a date function (e.g., November 25th, 2007) to a design view of 2003 Access.   Please advise what it is.   Cervantes ...
Score Search Criteria
JohnM - 25 Nov 2007 11:12 AM - 3 messages
I have a telephone data base - at the moment I can search by Comany, Name etc but I have to enter the names exactly how they have neen entered in the database. How do I set the query to work so that all I need to enter (when asked ...
Score Can Access 2007 generate an email receipt after details entered?
Jan Mushroom - 25 Nov 2007 2:45 AM - 4 messages
I am creating a database for our club using Access 2007 and I am a beginner. I want to know if I can set up the database to automatically generate an email receipt when the treasurer enters member details and receipt number. ...
Next »