Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Selecting an Individual record by Input
Sean Bishop - 2 Dec 2006 6:27 PM - 5 messages
I am using Access 2000 I have a large database of telephone numbers (1500). I now have to update individual records as and when invoices arrive. I have a form, based on a select query, with all the information and fields ...
Score Date stamp in Query
wolfewl - 2 Dec 2006 6:03 PM - 3 messages
Hello, I have read many posts, but, none seem to fit my situation... I am entering data directly into a query.  I need to date stamp a check mark for job complete.  The only form I use is for data entry, I track directly ...
Score How can I set up a schedule data base in excel?
mccheryl - 2 Dec 2006 3:26 PM - 3 messages
I am a manager at a restaurant, I have 15 employees that I schedule each week to work.  My question, is there a way that I can submit each person day of the week that they can work then download the information on an excel program? ...
Score How can I show 20 rows by 14 columns in a subform
Mike DFR - 2 Dec 2006 12:41 PM - 9 messages
My database shows service dates for machines The coloumns are machine type, serial number, & 12 months, (Jan, Feb, March, etc) The rows are each machine for the selected customer and the service dates or reason for no service. I have tried using datasheet view but this is unstable in Access 2003, (it ...
Score saving e-mails and attachments
Novice - 2 Dec 2006 6:49 AM - 2 messages
I just got a new computer with IE7.  I have been unable to save e-mails or attachments from either of my e-mail accounts to my hard drive.  When I click on the "save as" button, the e-mail closes and the only thing I can save is ...
Score Running a function from a command button
Robin Chapple - 2 Dec 2006 6:46 AM - 4 messages
This is my first use of a function. I have copied a function and edited to suit my purposes. If I use F5 from the function it runs as planned. How do I get it to operate from a command button? ...
Score Employee database
Still learning@work - 1 Dec 2006 9:46 PM - 3 messages
What is the easiest way to design an employee database that will track multiple training dates, certification dates, renewal dates and costs for each employee? ...
Score filtering
Betty - 1 Dec 2006 8:30 PM - 2 messages
I'm new to access.  I have access2002.  I have a very large database that I need to do multiable filtering.  I need to be able to pick records with just fax numbers,  then different states and different positions.  How would I go ...
Score enable theme
mcnewsxp - 1 Dec 2006 3:12 PM - 2 messages
how do i enable an existing form to use a theme? ...
Score Main Menu Command Button
Sue Wilkes - 1 Dec 2006 12:07 PM - 3 messages
Hi Everyone, Could someone please help me to achieve the desired requirements of this command button.  I have a switchboard which has a button to open the form 'ALLFORM'. On allform I have a button which I would like to do several ...
Score Why does date function minus 7 not bring back todays data?
Steve - 1 Dec 2006 10:53 AM - 6 messages
Some records in table reads 01/12/06. When I query using date()-7 to bring back records going back a week no data is returned for 01/12/06 which is todays date. ...
Score Syntax error I can't figure out
Freehal04 - 1 Dec 2006 12:04 AM - 3 messages
The following bit of code appears to have a syntax error.  This line is supposed to tell access where to find the attachment I want attached to my email.  The Compiler is telling me the : after the C is the problem, but I ...
Score Browse command to find hyperlink
fordrules01 - 30 Nov 2006 11:22 PM - 2 messages
I have a form that is to include a large number of hyperlinks to documents on a server. Is there an easy way to put a "browse" button into the form that allows users to find the file and then have access input the hyperlink into ...
Score Database Automation
Freehal04 - 30 Nov 2006 10:38 PM - 8 messages
Here's a question, does the Access Database have to be open to be able to complete a task I have automated? ...
Score Setting forms up
Jane - 30 Nov 2006 7:31 PM - 5 messages
I have to make a form for testing parts.  What I'm doing is put one part number per record and entering each time it is tested.  My problem is I don't know how to be able to keep entering data for different days. ...
Score table fields showing up on all tabs in dataaccess page
Eraspberry - 30 Nov 2006 6:28 PM - 2 messages
How do I show one setof fields on one tab and another set of fields on the other tab?  Currently the fields I have placed in the tab control show up on all the tabs?  I read one post that says cut and paste the fields into the ...
Score Urgent!!! Zip code Look Up
robpiolink - 30 Nov 2006 4:54 PM - 2 messages
I have 2 tables. Table1 has Zip Codes from many cities, also table1 has a field(yes/no) that says "houston". Table2 has zip codes from houston city. I want to be able tu run table2 against table1 to compare ...
Score Form help - please help!!
Access beginner - 30 Nov 2006 3:01 PM - 2 messages
Hello I have created an access database which contains a form.  Part of the form has three boxes that I want to contain dates. The first date that I will enter is a handover date.  The second date to be ...
Score creating controls
Eraspberry - 30 Nov 2006 3:00 PM - 6 messages
I have created a simple database for lead entry at my company.  I am amazed to be stumped on something that seems so simple.  I created a page from a table that has 10 primary fields and 10 additional or secondary fields.  I ...
Score How do I get Access?
Lizziepuff - 30 Nov 2006 2:20 PM - 2 messages
I can't seem to find Access as part of the Microsoft Office suite. What package should I be buying to get Access onto my new PC? ...
Score Can you count the number of Mondays in a month
Box666 - 30 Nov 2006 12:49 PM - 8 messages
I have a series of reports that are sent at at various times of the month. Each report has to be sent out either by a set date or in some case on a set day of the week. These details are recorded in two tables ...
Score Table Relationships
MickeyS - 30 Nov 2006 11:55 AM - 2 messages
I had read someplace that a table name can be change in the relationship window if the table is an alias.  I have tried to "right click" the table, which is what I thought could be done, but this did not work.  Help!! How do ...
Score changing a hyperlink
guy - 30 Nov 2006 8:40 AM - 4 messages
i have not used Access for about 6 years... In an Access2003 table I have 3 columns with hyperlinks, how do i change (via a query) the address they point to? currently they point to filename.csv but i need them to point to ...
Score How do I open a download?
Spaarky - 30 Nov 2006 3:36 AM - 2 messages
I've logged onto Microsoft Access online to learn how to use Access. I downloaded a template but I don't get any further than the extraction; I can't open to use it. Sure would appreciate some help! Thanks ...
Score Keeping Sub Form consitant with Datasheet
Sera - 30 Nov 2006 3:35 AM - 3 messages
I have a form with a sub form set up. My form has information on an individual My sub form has information about each time that individual is searched. The only field that the two forms have in common is the VisitorID ...
Score Storing Multiple selections in list boxes
fordrules01 - 30 Nov 2006 2:10 AM - 6 messages
I am trying to set up a very basic catelogue system of reference material and i'm having problems with the filing system. I have a main form "Item" and in it have a Listbox for the type of item (ie. ...
Score Trouble with form resizing
Mary Hartman - 29 Nov 2006 10:21 PM - 3 messages
Using Access 2000 I have created a  control panel which opens mazimized on_load. Some of the forms its command buttons control are small.  I open them on_load restored. When I click on one of these smaller forms my control panel also ...
Score Need Help Quickly Database causing severe sleep probs
Pammi J - 29 Nov 2006 9:32 PM - 5 messages
i need help badly - im pretty new to this and i have spent ages doing this db for work. I dont know whether i need to adjust it or just plain scrap it. Its for a garage - i have a customer details table and have a form made from ...
Score NULL value
vassilis - 29 Nov 2006 9:24 PM - 5 messages
hello ppl i would like to know if i can use the null value as the defualt value in a "number" data type field and how i can do that...and if i want to make a query is it possible to use tha null value for filtering ( looking all ...
Score using dates in calculations
sarahbeth_17 - 29 Nov 2006 9:17 PM - 2 messages
I am a rather new user of Access and am having trouble understanding the use of formulas or as I believe access is calling them expressions. I have fields called expiration date, status, and sign status, that all depend on each other for their value. I want to create a ...
Score Error Message 3799
toysmom - 29 Nov 2006 7:51 PM - 2 messages
I am having a major problem..a newbie!!!  I have designed a table and when I attempt to save it I get an window with the message "Could not find field 'TempField*0....when I check help I get  that I have ...
Score Help With Date Calculation please
Box666 - 29 Nov 2006 5:55 PM - 2 messages
I have a field that contains a date (say Dte_1) I would like to introduce a calculated field that would give the date of the last day of that month. So if Dte_1= 11/11/2006 then new field would be 30/11/2006 ...
Score Automatic filling of form fields
VT - 29 Nov 2006 5:03 PM - 3 messages
In the Northwind sample database, there is a form for new orders. Once the customer's name is selected from a drop-down list, the rest of the customer's details are sought and displayed automatically in the remaining fields. ...
Score where clause to find record from a table
georgiaboy - 29 Nov 2006 3:56 PM - 19 messages
I want build a form to display the record information from a table by inputting the search criteria in a form text field then clicking on a button to display the record results. For example I have project number with related ...
Score Relationships Window Clear/Delete?
MichiganMan - 29 Nov 2006 3:05 PM - 4 messages
Easy question I am sure...I am a very newbie... When I clear the relationships window, does it delete the relationships? I ask because when I saved the relationships window, it never asked me for a file name. Is this like a chalkboard, only one relationship at a ...
Score Is it possible?
Anthony - 29 Nov 2006 2:47 PM - 3 messages
Is it possible to create a custom Access Object, to appear in the objects list on the left hand side of the database window? Tables Queries Forms Reports Pages Macros Modules My Custom Object ...
Score Linking tables
MickeyS - 29 Nov 2006 11:48 AM - 2 messages
I have two databases, Order Entry and Tank Rental.   If I link Customer from the Order Entry database to Tank Rental database and change the Customer in Order Entry, will the customer link in Tank Rental take on the change?  ...
Score Why does Publisher send 2 pages at a time to the printer Queue
Cameron - 28 Nov 2006 9:07 PM - 2 messages
I am mail merging 1000+ records to print postcards.  There are  4 postcards per 8.5 x 11 sheet.  When printing publisher sends two pages of the print job at a time to the printer.  So the printer fills with 250 print jobs (2 pages ...
Score Can't get this to work
Freehal04 - 28 Nov 2006 5:14 PM - 8 messages
Okay, here is the code I'm using.  I had it working but for some reason now all I get is an error message stating Compile error, user difined type not defined.  Before I was getting a different error.  What's wrong? ...
Score labels causing flicker
mcnews - 28 Nov 2006 4:42 PM - 3 messages
i am having a problem with labels causing a flickering effect on forms that contain tab control. only labels that are not associated with a textbox. these labels also have hyperlink property option in the properties format menu. wazzup? tia, ...
Score Cursor flow in forms following data entry
Will_Harris_ZA - 28 Nov 2006 3:50 PM - 4 messages
Hi there I shifted my fields around when constructing my form. Now how can I make the cursor flow from top to bottom, left to right (there are 3 columns of fields) after entering data? Please help Thanks Will ...
Score DOS ECHO SHELL
mcnews - 28 Nov 2006 2:43 PM - 2 messages
i need to run a DOS ECHO command to LPT1 in WXP. can VBA do this? if yes, syntax please. tia, mcnewsxp ...
Score Thank you
Timboo - 28 Nov 2006 1:21 PM - 6 messages
I would just like to say “thank you” to all those people who spend a proportion of their time to answer the questions posted by myself and others in this forum.  If it was not for people like you, then duffers like me would ...
Score Combo Box
Sue Wilkes - 28 Nov 2006 11:00 AM - 6 messages
I have a combo box on a form which is linked to a table created to populate the list once all the data is entered all the data is then saved in another table.  What I need is for the user not to be able to enter any data into ...
Score "Import Specification"
Robin Chapple - 28 Nov 2006 1:20 AM - 3 messages
I have an "Import Specification" that needs editing but I am unable to find it. Where do I look for it please? Thanks, Robin Chapple ...
Score Access Main Screen
SG - 28 Nov 2006 12:07 AM - 2 messages
Is it possible to change the dark grey back ground within access possibly have a logo appear there? I dont mean on a form but the access back ground. Thanks in advance ...
Score Storing trailing space in text fields
Charlie Mac <> - 27 Nov 2006 10:33 PM - 5 messages
Access Gerus, How can I get Access to save text into a field to include a trailing space if I don't want to use quotes?  I have tried the field's format (space) option to no avail.  What am I missing? ...
Score how do i set up outlook
Sergio - 27 Nov 2006 8:43 PM - 2 messages
hey, my name is sergio and im trying to set up a microsoft outlook account because i bought a smartphone and would like to sync it with outlook. one thing im not sure about is just setting it up in general. i made an email ...
Score Header in Report
Freehal04 - 27 Nov 2006 7:54 PM - 3 messages
My header disappears from my report after the first page.  Is there a way to make it always visable, regardless of what page of the report I'm on?  Just wondering. Thanks. ...
Score Display in form
Freehal04 - 27 Nov 2006 6:46 PM - 5 messages
Here's a simple question.  I have a field in my form that displays a the amount of time (in days) till something is due.  It displays negative numbers for things that are passed its due date.  I was wondering how can I display ...
Score Date in header title?
StargateFanFromWork - 27 Nov 2006 6:43 PM - 2 messages
I seem to remember that there was a way to put today's date in the title text in the report header but I can't find the actual "code" to do that.  I seem to remember it had broken brackets, I think "<>" and text so that when ...
Score Correct VBA Code
Freehal04 - 27 Nov 2006 6:38 PM - 2 messages
I've got my query set up to calculate a 10 day alert 10 days prior to a due date.  Finally, with a lot of help.  I want to set up an automatic email to recipients.  I have code that works, but I am having trouble getting it to ...
Score Get a Column on a report with no volumes on the base table
Box666 - 27 Nov 2006 6:07 PM - 2 messages
I have a crosstab query on which I have based a report. This to be run weekly to show sales per week with columns (previously products from a field) such as apples, pears, nuts, etc. Last thursday when I originated the query there had been sales of all ...
Score Adding new records based on current record
Karen Miller - 27 Nov 2006 6:03 PM - 5 messages
I am trying to add three new records to a table, based on the record that a user has just created using a form.  When the new record is created, I want to add three more records with different record types and clear some amount ...
Score how do I use an Input Mask to add extra caracters to sequence
Damian - 27 Nov 2006 2:47 PM - 5 messages
i am trying to change the following sequence of caracters obtained from an underlying query to include a * at either end. I need to do this within a report only as this will then be used to generate a barcode. ...
Score Parameter query question
steve goodrich - 27 Nov 2006 2:25 PM - 5 messages
I have a very simply query set up due_date    name in the criteria for the due_date I have [Please enter date] I enter the date to see all names that are due for the date entered (simple) ...
Score How do I link Access and outlook
dave_f - 27 Nov 2006 2:04 PM - 2 messages
I am wanting to input data in my outlook calendar and to process and output it in access. ...
Score Data Validation & Cancel Exit Command
Sue Wilkes - 27 Nov 2006 12:52 PM - 6 messages
I have a form with a command button which when clicked returns the users to the main menu on the switchboard.  I have tried to add data validation but when the button is clicked it gives the error message then saves the record ...
Score how do I set up a database to see where and what employees are do
dave_f - 27 Nov 2006 6:29 AM - 2 messages
I want to set up a atabase that will show me where employees are, what they are doing and how long they are going to be doing certain projects. I would like the employees to enter what they are doin on a calendar or time sheet ...
Score export report with graphics to Word
Chris - 26 Nov 2006 8:59 PM - 15 messages
I'm using Access 2000 (XP pro) & have a number of reports with graphics (check boxes, text boxes) that don't export to Word. I want to send the reports as email attachments to non-Access users (can't use snap files). Is ...
Score Confused, please help
SamW - 26 Nov 2006 8:25 PM - 4 messages
Greetings. I'm extremely new to Access (using 2000) and I'm trying to create a tracking system for packages coming into the office to show where the packages are going and how long it takes for the packages to be completed. ...
Score How to access a saved query
tarweesh - 26 Nov 2006 6:03 PM - 8 messages
hi, i created a query joining several tables and saved it in a Microsoft Access database. Now i want to access this query using PHP the same way i access a table but i am getting an error.   $sql="SELECT * FROM q3"; ...
Score Does Excel ORDER_ID in Orders named range exist in ORDER Access ta
jjgray - 26 Nov 2006 3:36 PM - 3 messages
I would like to check a single column within a named range in Excel for potential key violations prior to TransferSpreadsheet.  Ex: Does ORDER_ID in Orders named range exist in ORDER Access table? Any suggestions would be appreciated. ...
Score Automatic reordering of Records in Fields
Bryan - 26 Nov 2006 12:26 AM - 6 messages
If I set up a Table containing Records then in another Table  wish to use that list of records and set the Data Type as Lookup Wizard, the order of the records in the original Table has been automatically set to Alphebetical or ...
Next »