Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score access 2003
john - 23 Sep 2006 11:00 PM - 4 messages
how do i design an access database table for compiling all the laws to help prepare me for taking a bar examination? ...
Score Simple but profound
kennykee - 23 Sep 2006 9:56 AM - 8 messages
Hi, I have a question which cracks my head. Assume I have a table with a field with the name "Date" and in fact it is a date field. Usually, user will fill the date fill with {[month][day][year]}. However, I ...
Score How to use a many-to-many table to retrieve (query) data for a for
Michael_Randall - 23 Sep 2006 5:27 AM - 2 messages
Hello, I saw an earlier posting that related to this question but the response didn't quite answer my question. I created the following Access tables and fields. tblWriter WriterID - Autonumber WriterName - text tblProject ProjectID - Autonumber ProjectName - text tblWriter_Projects - (many-to-many joining table) ...
Score where do i locate the font various sizes?
Eleanor Hutcheson - 23 Sep 2006 2:50 AM - 2 messages
I need to make LARGE very LARGE  letters for the  cover of a book. HOW do I do this ? ...
Score Access hidden objects ??
Mike Revis - 23 Sep 2006 1:21 AM - 2 messages
Hi group, Access 2000 win xppro I'm not sure if this is the correct group but here goes anyway. I have a small application that I use in my business. I have been using it without problems for about 3 years. ...
Score 3.5 disk
MLWX1 - 22 Sep 2006 7:52 PM - 3 messages
How to erase just one folder from a 3.5 disk, without erasing the entire disk? ...
Score how down load access file to excel
Holly - 22 Sep 2006 7:11 PM - 7 messages
The table has over 50K rows, but I can't export all the rows into excel. ...
Score how export access table to excel
Holly - 22 Sep 2006 7:04 PM - 2 messages
The access table has 50K rows, but I can't export all rows to excel. ...
Score junk characters in query result
mcnewsxp - 22 Sep 2006 6:44 PM - 9 messages
when i use a kind of large (150 characters or more) text field as the main sort criteron in a query i get a single japanese or other unexpected character in the text field instead of my text. anybody else seen this and know what to do about? ...
Score followhyperlink
zachnjoe - 22 Sep 2006 6:30 PM - 2 messages
I would like to open a specific Word document based upon what is selected in a combo box on my form.  I figured out how to open a document by clicking on a control box so now I'm ready for the next step.  Here's what I have. ...
Score how to add to field from previous record
Blondie - 22 Sep 2006 5:26 PM - 5 messages
if i want to update a value from a previous record by adding to it how would i do that. If the cumulative value in the first record shows 100 kilometres and the next record asks trip distance and i input 25 kilometres i want the ...
Score plan for job presintation
jason - 22 Sep 2006 1:55 PM - 2 messages
i need something to present to customers.   not sure how to do it excactly, i want something to put in a folder to take with me when im out, that shows what i do, how much i do it for and what ever else that should go with it. ...
Score Junction tables and data entry
Cheese_whiz - 22 Sep 2006 1:26 PM - 5 messages
I was told some time back that my project needed a couple of junction tables. Specifically, I'm working on a legal case database, and I need to collect data about the parties involved in every case.  The primary tables for the ...
Score how to import from excel
Blondie - 22 Sep 2006 11:03 AM - 4 messages
I am trying to import data from excel into access and the problem i have is that access has the fields going across the page in the datasheet view of a table layout whereas in my spreadsheet the data that i want to use is laid ...
Score How do i set up command buttons on a form
Jamie76 - 22 Sep 2006 10:11 AM - 3 messages
Hi, I have created a form and want to put two buttons on it to a) find a record and b) add a new record. Can anyone tell me if this is relatively straight forward? Thanks Jamie ...
Score Action query - help please
Jack Sheet - 22 Sep 2006 9:04 AM - 11 messages
Hi all. I have a database with two tables: T_Clients T_Tasks T_Clients has two fields: ClientID = autonumber, primary key ClientName = text, indexed, no duplicates T_Tasks has three fields: TaskID = autonumber, primary key ClientID = number Date = date/time There is a one(T_Clients)-to-many(T_Tasks) relationship between ClientID ...
Score help!... urgent and i'm new on this area
Kurosagi85 - 22 Sep 2006 8:48 AM - 4 messages
i need help and its urgent... i have created a table with fields: ItemNo, ItemName, IncomingStocks and also DateReceived. The IncomingStocks and DateReceived are volatile. it is expected to change several times during the life of a record I have tried the simple append query ...
Score Have date automatically go into another form
Bianca - 22 Sep 2006 8:31 AM - 8 messages
Hellllllllllllllllllllllllp!!  Okay I literally know nothing about programming or access - but I did manage to create tables and forms. My question is this:  I have two forms one form is an application for a discount card that the company I work for sells - the second form is the ...
Score One-to-one relationships
Jack Sheet - 22 Sep 2006 8:24 AM - 4 messages
When creating a one-to-one relationship between two tables, does it ever make a difference which table you drag across to the other?  If it does, could someone please in layman's terms briefly explain the significance? Thanks ...
Score How do I reregister my microsoft?
Stefanie - 22 Sep 2006 4:46 AM - 2 messages
Upon registering my free trial version of Microsoft 2002 it brought me to an external link on the internet in which I started to complete then I became unsure of myself and exited the window. When I tried to see if Microsoft was ...
Score how do i add follow up calls in access so they pop up on the date.
fizgig - 22 Sep 2006 2:46 AM - 2 messages
How do I make access more intuitive and able to record relevant information in a sales scenario.I'd like to have my future call dates simply pop up on my computer when I open access to remind me of the calls I need to make. ...
Score How do I use the IIF expression
Afrosheen - 22 Sep 2006 12:59 AM - 6 messages
I am trying to use the iif statement to have it either display/print or if nothing is in the field  skip that field. The field is a text field The way it used to be done is: if [field] <> "" then display [field] ...
Score Re: somebody please tell me how I delete an ".LDB" file
William Hindman - 21 Sep 2006 8:28 PM - 9 messages
....is there a day care center for this community? William Hindman ...
Score Is there a better way
RayC - 21 Sep 2006 8:13 PM - 4 messages
Just trying to find out if I am writing my code in the correct way. The Block should be self explanitory but is there a better way to write it? Public Function util_GetNewContractNo(a As Long) As Long '*****************************************************************=********************** ' Name:    util_GetNewContractNo               :- Utility Number  2 ...
Score Re: somebody please tell me how I delete an ".LDB" file
John Spencer - 21 Sep 2006 7:40 PM - 4 messages
As far as I know, you cannot delete the .ldb if it is in use by Access. There is no setting to tell Access not to delete the file. If the file is still there after all users have exited the database, then ...
Score How do I merge data from 2 identical databases?
FatBoy - 21 Sep 2006 7:04 PM - 3 messages
I have three databases, structures are all identical. There is supposed to be only one database, but users have been entering data in all 3, so all of them have different data. Is there a way to union the data in ...
Score Chart Control
zachnjoe - 21 Sep 2006 4:06 PM - 2 messages
I have software(Chartrunner) that automatically pulls data from my database and creates a chart.  I would like to have the chart appear on my database form.  How can I have my form call out the file name of the chart I want ...
Score When to default Number fields to 0?
Mark - 21 Sep 2006 3:40 PM - 3 messages
I have just been looking at a database where all number fields are set to default to 0 at table level.  I know this is the default setting but I previously I have either always set number fields to default to null or a ...
Score After checking on an update - stop user proceeding on a condition
Isis - 21 Sep 2006 3:29 PM - 4 messages
John kindly gave me a way to check on the existence of a file that the user is inputing - if the test fails - the file does NOT exist - I want to stop the user proceeding with the add and maybe clear the form ? ...
Score Checking for the existence of files ?
Isis - 21 Sep 2006 12:29 PM - 3 messages
I am setting some variables with file names and want to check for their existence before proceeding in my VB code - how do I do that ? All files will be held on a local hard drive. Thanks for any help ...
Score Really BASIC question, sorry
Jack Sheet - 21 Sep 2006 9:31 AM - 3 messages
I have a database containing just 2 simple tables: T_Main Fields are: MainID (Autonumber, primary key) MainField (text) LookupField (text) T_LookUp Fields are: LookupField (text, primary key) LookupRate (currency) There is a one(T_Lookup) to many(T_Main) relationship based on LookupField ...
Score Help With Query
Lucien - 20 Sep 2006 10:54 PM - 2 messages
I have a query that is returning results and records from various tables and I need to set up some type of conditional expression or something that will provide the results I need.  The fields I am working with contain: ...
Score field formating...
JayL - 20 Sep 2006 9:31 PM - 3 messages
All - I have a field in a table that is numeric. It should be 11 characters but the table is omitting the leading zero's. Ex: 00092557589 is showing as 92557589.  The problem is I need the leading zero's. ...
Score Automate a filter button on a form
Rod ElEd - 20 Sep 2006 6:15 PM - 2 messages
I would like a command button on a form that will ask which field to search and what word(s) to search for. These are memo fields with info on books. I have scanned posts in this group and discovered the following string that ...
Score MVP Question
Trey Davis - 20 Sep 2006 4:36 PM - 5 messages
Is it possible for me to become an MVP? And how do I block messages from a particular user? Is there a way to identify a user's IP address, and block this IP address so that message doesn't show up in my Outlook Express? ...
Score Formula
Bonni Wilbourne - 20 Sep 2006 3:33 PM - 2 messages
I am having problems with a formula - I did not write it originally and am not very skilled at formula's either.  Does something appear to be missing? =IIf([blocktotal]=0,[Sum Of SumOf# of Contracts1],([Sum Of SumOf# of ...
Score Error Handling Code Library
Excel 009 - 20 Sep 2006 3:22 PM - 9 messages
Does anyone know a good source of error handler code library that I can just copy and paste into my module and is ready to use?  Thanks in advance. - 009 ...
Score Search and see One Record
Sophia - 20 Sep 2006 1:13 PM - 4 messages
I managed to import a large excel spreadsheet for my database successfully.  How do I create a report/query that gives me a screen shot status of any particular record.  Ideally, I'd like a form where you type in the name, hit ...
Score Allow Edits
RayC - 20 Sep 2006 12:52 PM - 9 messages
I have a form that is bound to a Customer Table. On that form, I have 4 different methods of searching the Table that are done through Unbound Combo Boxes, Customer Name, Account No etc. In setting Me.allowedits = True, I ...
Score Access Library Inventory
jlydon - 20 Sep 2006 4:50 AM - 3 messages
I have an Access database with 6,000 books entered.  I have barcodes in the books and want to do a year end inventory.  I will scan the barcode and would like that to show up as present in the database. Finally ...
Score HELP! Select behaves differently inside code and in Query builder
Laurel - 20 Sep 2006 1:13 AM - 4 messages
I have a select statement as follows. Select * from qryClassSummaryDetail WHERE [class_code] = 'ML2' AND Student_ID <> -1 I use it in a bit of code in this way (as_where works out to be the clause above.) li_i = fncRefreshQuery("qryClassSummaryDetailBase", ...
Score Write a query returning names beginning with the letter "a"?
MWB - 19 Sep 2006 9:56 PM - 5 messages
How do I write a query returning all contact names begining with the Letter "A"? ...
Score Running a Report
Bonni Wilbourne - 19 Sep 2006 8:56 PM - 5 messages
I have multiple users that run reports off of my database - each of them have security to run the reports.  Only one user gets an error when trying to run reports - The error message says "there was an error executing the command"  ...
Score What best training course to get started with access quickly
Rick M - 19 Sep 2006 8:55 PM - 5 messages
I am a self trained user of Word and Excel and have been using these programs for years. I imagine I only take advantage of 30% of the Excel features.  I am looking to get started with Access and have limited time, is there a ...
Score Multiple select listbox not holding on to values
LoriInMD - 19 Sep 2006 7:51 PM - 4 messages
Hello. I created a multiple select (extended) listbox field in my table and then selected it from my field list to add to my form. When I select values in the listbox and then move on to the next record, the field does not hold ...
Score Can I display a msg box after form has loaded?
Laurel - 19 Sep 2006 6:57 PM - 5 messages
I'd like a message box to display after the form has loaded, but I can't find an event to use.  Open and Load cause the message box to appear before the data is loaded into the form.  Anything else I try doesn't execute, or ...
Score Need to retrieve record using one or two fields of input
Cheese_whiz - 19 Sep 2006 3:33 PM - 3 messages
I have two questions, which are related somewhat but not reallly. I want to take several data input forms I have and kind of combine them into a tabbed setup.  Am I going to basically have to combine all three froms into ...
Score how do I set up a data base report with drop down menu's?
cracker2 - 19 Sep 2006 1:36 PM - 5 messages
...
Score Access 2003: Reports
oceanmist - 19 Sep 2006 1:31 PM - 5 messages
I selected a layout from the six offered and I don't like it. How can I change it? ...
Score database
Mary K - 19 Sep 2006 1:03 PM - 6 messages
I am real new to access.  I need to make a customer service database.  I'm not sure what I should use.  Tables, forms, or reports.  I need to be able to enter customers name, address, phone number and a comment area of what the ...
Score tbl
Mike - 18 Sep 2006 8:12 PM - 3 messages
lotteryID    lotteryPackNumber    lotteryName    lotteryUPC    lotteryRetail    lotteryAddedDate    lotteryModifiedDate    lotteryStartSerial    lotteryCurrentSerial    lotteryEndSerial    lotteryActive    lotteryMultiplier    Sold                    ActualTicketNumber ...
Score Close from and open a new form on exit event?
Simon Webb - 18 Sep 2006 7:00 PM - 3 messages
I have a form where the operator enters some text in a box. After they have entered the text - a security code - on tabbing out  I want to i) close the current form. ii) open another form. conditional on the operator having entered the correct security code. If I ...
Score Loosing data in the backend
SpookiePower - 18 Sep 2006 5:39 PM - 10 messages
I have split a access database into a frontend and backend. The frontend and backend are placed on two different computers. I have tryed many times where the user have entered a lot of data into the backend and then a few hours later, the data ...
Score Moving an inserted picture
PattiPatti - 18 Sep 2006 2:10 PM - 3 messages
How do I move a picture I have inserted into a doc in MS Word ...
Score making labels for dvd or video using access or excel
boatsman - 18 Sep 2006 12:51 PM - 2 messages
I have a list of films on dvd and cd in a table in excel and I want to print out labels size 70mm x 38mm on A4 label sheets. How do I do it? Would be glad of any assistance as I know nothing of either excel or ...
Score Set default web pages opening full-size (maximized)?
Kenmore - 17 Sep 2006 9:24 PM - 2 messages
When web pages l;oad, they open 1/3d size.  Rather than clicking on the "maximize" button, is there a setting for opening them full-sized? ...
Score To: Albert D. Kallal
Laurel - 17 Sep 2006 7:36 PM - 5 messages
Today you've addressed two of my mysteries with some degree of depth. Would you mind looking "Repost: Yet another problem with 'No current record'", in Access.formscoding, dated August 26? I was just about to take a vacation day ...
Score 2 Related field or Auto fill up 2nd field after 1st field entered
Kaoli - 17 Sep 2006 10:32 AM - 2 messages
I have 2 related field in a transaction table Example "Taxi Number" (1st Field) "Taxi Driver" (2nd Field) Let say i have a table having latest or default Driver driving which taxi record as per below TaxiNumber                TaxiDriver ...
Score How to return information from a form?
Laurel - 17 Sep 2006 12:32 AM - 4 messages
I have a little form that is opened by a couple of other forms, which allows the user to mark the students in a class present or absent and the data is saved in the database.  This info is then used by the main form to retrieve ...
Next »