Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Help Panel Titlebar Behing Taskbar
JamesJ - 29 Apr 2006 9:50 PM - 4 messages
I set the windows Taskbar to remain in front of other windows but when I click Microsoft Office Access Help it's titlebar is behind the taskbar preventing me from closing it. Any ideas why? Thanks, James ...
Score Using a Parameter Query: from VB.
Ed Warren - 29 Apr 2006 1:10 PM - 3 messages
Query1 PARAMETERS DateStart DateTime, DateEnd DateTime; SELECT DISTINCT FinalSchedule.Client_ID, FinalSchedule.CData FROM FinalSchedule WHERE (((FinalSchedule.Date) Between [DateStart] And [DateEnd])) ORDER BY FinalSchedule.CData; How does one call Query1 with parameters from VBA? Thanks, Ed Warren. ...
Score Calculate A Payout Figure
GregInOz - 29 Apr 2006 9:10 AM - 7 messages
Hi guys, I have a simple calculation in Excel that i would like to re-create in Access somehow.  There's a snipit of the excel spreadsheet below. Payment    Month    Loan    Interest    Loan+Int    Repaymen  Payout Figure ...
Score Queries: Values from previous records
Pankaj - 29 Apr 2006 5:18 AM - 3 messages
I have two columns in a query - OpgStock and ClgStock. I want OpgStock values to be equal to ClgStock values of the previous records. Pls guide. ...
Score Date Updated Last
GregInOz - 29 Apr 2006 12:57 AM - 3 messages
Hi All, I have a subform "Notes" within a main form "ClaimForm" and would like to create a filed "lastupdate" on "ClaimForm" and later a report that displays/populates "lastupdate" with the most recent date from the subform "Notes". Thanks ...
Score I can't get acNewRec to work in a list box in a subform
David Wilch - 28 Apr 2006 10:49 PM - 28 messages
This is driving me crazy. First, I'm a novice at access and VBA. I'm using Access 2003. I have a form "Athlete_Registration" This form works great. I can edit old athletes from the table "Athlete" using a listbox to find them quickly or add a new athlete. ...
Score adding a column
jd - 28 Apr 2006 10:31 PM - 3 messages
New user question. Using a financial database and want to sum one columns in a query. Just can't seem to do it. Any help appreciated. ...
Score Sum in Report
Bruce - 28 Apr 2006 8:18 PM - 2 messages
I have an Access Database in Office 97. In a Report based on a Query I need to calculate how many cases there are that fall in "Segment 1" and have a tick in a check box in field Enq Not Taken Up. ...
Score selectable options
thebigmac via AccessMonster.com - 28 Apr 2006 8:02 PM - 4 messages
I'm working on a database that is based upon the following concept: * A customer buys a product that has a unique serial number (primary key). * Each product can be "customized" with numerous options. * Each option has a unique number (may be a primary key) associated with it. ...
Score Switchboard doesn't open the form with the correct view
Dino - 28 Apr 2006 7:30 PM - 5 messages
I have a switchboard button that opens a form. When I open the form manually it opens to datasheet view, which I have set up as the default and only allowed view. When I open the form using the switchboard button, it always ...
Score AfterUpdate doesn't happen?
David Habercom - 28 Apr 2006 7:06 PM - 3 messages
I want to use the AfterUpdate event when a field (Me.NewANDI) has been filled.  The field can be completed manually or auto-filled by a button.  AfterUpdate gets triggered as it should when I manually fill it.  But when ...
Score How can data updates from one table be copied to another?
Emma Young - 28 Apr 2006 6:46 PM - 3 messages
I maintain a db that contains membership info.  That info is also available online to the members, I don't do that part.  What I need to do is, get any corrections or changes that I make in my version of the db, to the person who ...
Score how do you put a list box into a form?
Ron - 28 Apr 2006 5:53 PM - 3 messages
I am working on a form in word. The drop down box seems to work, but how do I get a list box that allows multiple selections, and how do you control the formating of the output from the list box? ...
Score how to convert text deliminate file into excel
Linda Hubbard - 28 Apr 2006 3:46 PM - 2 messages
I received two attachement in excel format.  When I open the attachments they were in text deliminate status.  I tried saving the files to excel and word but the file still reflect the text version. ...
Score Detect missing records
Topher - 28 Apr 2006 2:30 PM - 12 messages
How can I use a query compare two tables with the same structure and detect which records that are in Table A are missing from Table B? ...
Score Working in contacts, I need to enlarge my typing area to fit more.
Linda - 28 Apr 2006 2:23 PM - 2 messages
I'm having difficulty tring to enlarge my trying area where the persons name is to go.  I need like 2 lines for more typing information ...
Score accessing my db from my intranet
Dj - 28 Apr 2006 1:36 PM - 7 messages
I was under the impression that I could not access an Access Database from the web.  I don't know why I thought that, but I did.  My boss thought differently so he told me to check into it.  I quickly put a hyperlink on my ...
Score New To Access
Dave - 28 Apr 2006 12:43 PM - 10 messages
I am trying to create an Access Database from scratch and have never used Access before. I am using Access 2003. Could someone please help me in very simple terms to explain to me how the best way is to view what I want to see please. ...
Score Combo Box Problem
GregInOz - 28 Apr 2006 6:50 AM - 3 messages
Hi, I have a subform called "Notes" on the main form "ClaimForm". In the subform i have a combobox called "code".  In this field is staff member initials e.g  MJW                 GBE ...
Score Convert date into text
Akrt48 - 27 Apr 2006 11:50 PM - 3 messages
Could someone please explain how to convert a date back into text.  As in 31/03/06 to 20060331.  Thanks ...
Score Problem with linked forms
dbnDavid - 27 Apr 2006 10:29 PM - 8 messages
I used the wizard to link two forms by means of a command button (cmdOpenSubs) on one form (frmAgents) that opens a second form (frmSubclients) filtered to display the records that relate to a control value on the currently displayed first form. ...
Score Sub-switchboard
Dino - 27 Apr 2006 8:46 PM - 5 messages
I have a switchboard that has several buttons on it. I would like one of the buttons to open up another switchboard with a few more buttons on it. How do I do that? ...
Score Update query
Topher - 27 Apr 2006 7:18 PM - 3 messages
Scenario: 1) I run a Make Table query that creates a table filled with records that are the results of a complicated query against a set of inter-related tables. 2) I then change something in the tables that will alter the output ...
Score Reseting Autonumbering
Chris - 27 Apr 2006 5:38 PM - 2 messages
Does anyone remember if and how to reset previously autonumbered records? Thanks. ...
Score How to make 'Autocomplete' Boxes that are not limited to a list?
Jack G - 27 Apr 2006 5:22 PM - 4 messages
I would like to have a text box that autocompletes itself and fills in several other text boxes in the same manner that the Northwinds sample works for Customer Names in the Orders form.  But in my case I've had over 1000 ...
Score how do I convert a number and save it as a field in a table?
CK - 27 Apr 2006 4:35 PM - 4 messages
Hi, I'm hoping someone may be able to help me. 200+ people have filled out heights and weights on a questionnaire, which I need to put into a table. They have entered their weights as either kg or stones/lb and their heights as cm or ft/inches. Rather than manually ...
Score DiffDate Question
Dj - 27 Apr 2006 4:04 PM - 7 messages
I'm using a DiffDate on a form to calculate student's age.  It works fine on my screen, but when another employee pulled up the same form, they got an ?name error.  We're both using Access 2002.  When she clicks on the error ...
Score Form window
Dino - 27 Apr 2006 4:00 PM - 2 messages
How does one make sure that a query result table opens at maximum window size, or at least at the size that maximizes the contents? One of my tables insists on opening at a minimum size. I use a form to display the query ...
Score Is it possible to use Excel 2000 to sen an E-mail throuth lotus
Excel user - 27 Apr 2006 2:30 PM - 2 messages
Looking at the possibility of using Excel 2000 to send out email through Lotus Notes.  I use the spreadsheet to track project and would like to use the spreadsheet to send out emails of any changes to the members of that ...
Score Import problem - Date field
Berkshire - 27 Apr 2006 1:13 PM - 2 messages
I'm fairly new to Access.  Have a spreadsheet I am trying to copy / import that has a date field.  This date field is in a Month-Year format, i.e. Apr-06.  I have entered the data in Excel as 4/1/06.  I have months that go ...
Score Mapped drives in Linked Table Manager
Timboo - 27 Apr 2006 12:47 PM - 3 messages
Hi there, I have split my DB and the Linked Table Manager now lists the linked tables.  However this reference is via a mapped drive (p:\mydb\etc) which means that each user of the system must have their P: drive mapped to ...
Score trouble with default value for a control
dbnDavid - 27 Apr 2006 12:38 PM - 3 messages
I have a form frmClntsAgents for which the Record Source is qryAgents which filters the table tblGlobalClnts for the value “agent” in the ClientType field in a related table tblClientType  -  tblClientType has two fields: ClientTypeID and ClientType. ...
Score relationship problem
dhir77 - 27 Apr 2006 5:26 AM - 4 messages
hi all i need the help regarding realtionship between tables.i have 4 main tables with one to many relationship - result,sample,site,location as location can have many sites,each site has many samples,each sample have different results.there are few other tables like analyst,site ...
Score Top N value
GEORGIA - 27 Apr 2006 1:45 AM - 6 messages
Hi.  I have originally posted this question and got the answer but I cannot seem to find the original post.  so sorry, I am posting again.  My question was, I wanted to created a combo box or dropdown list with such values : "10, ...
Score General Query question
troy - 26 Apr 2006 9:46 PM - 11 messages
If you have 4 or 5 tables with data in them and one or more fields get changed or updated, and you would like to up the main master table with this data. What would be the best query to use in this instance? I have 5 tables ...
Score In a resume, what do you put for the objective
Resumes...Help - 26 Apr 2006 9:01 PM - 3 messages
I am TRYING to create a resume and I can't get past the objective. How do I start it off? How so I end it? How do I do the whole thing. HELP... I am so confused and my head is starting to hurt. ...
Score TOTAL BY FIELD
Jan via AccessMonster.com - 26 Apr 2006 8:22 PM - 6 messages
I created a query based on a table that totals pieces of defective items using simple expressions ([Total SV Ctns 1]*[Pieces per Ctn 1]).  Entries are made to this db daily to record defective production.  Each record has an ...
Score Record vs. addressid
Bob - 26 Apr 2006 8:02 PM - 2 messages
Hello, I deleted a lot of records in the db. Now I have 85 records, with addressid's in the 500's. Is there a way to reorder the addressid's so they reflect the current records in the db. ...
Score How to count number of times a city name appears in query in Acces
CarlaB - 26 Apr 2006 6:54 PM - 5 messages
I need to report the number of times each city name appears in a query of volunteers located around the country. Results should be one "City Name" and the "number value" of times it appears for each city in the data base. I am ...
Score Help...create a report that pulls from multiple tables
kozamel@hotmail.com - 26 Apr 2006 6:28 PM - 2 messages
I am a VERY new Access user... I have 15+ tables, each with identical field names (linked sprdshts from Excel), and each containing schedule information for a specific project. I am trying to create an interface that would allow each project manager to ...
Score Non-date field sorting by correct month order
JoeIBM - 26 Apr 2006 6:05 PM - 2 messages
I'm pretty new to access, but not so new to DB's.  Alas - I'm slightly more proficient with SQL than with Access 2003's GUI tools like expression builder, and specific microsoft things like VB Script. </preamble> ...
Score help!! im in excell class and i need to do a project for my princi
Hillary - 26 Apr 2006 3:51 PM - 2 messages
Can you move words in a drop down box to another call. ...
Score Problem with dates
Andy - 26 Apr 2006 2:35 PM - 20 messages
Hi Everyone, I am very new to this but so far have managed to create a small database with a few tables linked together and a few queries. I have also created some reports and forms. Using the switch board I would like to open a form, which has been filtered ...
Score view by category
Angel_1 - 26 Apr 2006 1:34 PM - 3 messages
Hi, Please can someone help me. I am trying to set up a form so that I can view my records by category.  I have tried many different ways with no luck.  Do i need to have a main form ...
Score linking tables
logquality - 26 Apr 2006 1:12 PM - 2 messages
Our company has two plants each with their own scales (to weigh logging trucks). I need to combine two tables to get a total weight delivered. I have common fields in both tables: contractor, date delivered, & net weights.  I ...
Score Internet Explorrer-very urgent
sudarshan - 26 Apr 2006 12:57 PM - 2 messages
I accidentally gave a 'shred' comad to my IE6 icon on my desktop.Now I am not able to ue it at all.Can someone pls. suggest as how to take this forward. ...
Score scanned and saved resume, all y's on page
Maggie - 26 Apr 2006 12:41 PM - 2 messages
...
Score Radom records from a table
kotesh - 26 Apr 2006 9:01 AM - 3 messages
hi, can some body help me out in generating a random records from a table. for example i have some questtionaire in my table which i want to pick up random questions. but the problem is, the questions have different levels like Basic, ...
Score Displaying data from a different table on a form
Gazza - 26 Apr 2006 7:44 AM - 5 messages
I want to display data on my form in textboxes.  Some of these textboxes need to show values from different tables which are linked to the main table the form is based on. For example: I have a JOB table with the field CLIENT_ID which is a foreign key to a ...
Score Multi-user problem
Jason O - 26 Apr 2006 6:33 AM - 9 messages
Hi, I seem to have inherited the maintenance of a fairly simple database set up by a previous employee who has since left the company. However, the users have reported that only one person can use it at once. All they are using is ...
Score Print button in forms
Dino - 25 Apr 2006 9:33 PM - 7 messages
I would like users to print, using a print button shown on my forms. I already have the buttons created and properly labeled, and I have reports already made for each of my forms. What VBA code do I enter in order to make ...
Score Access and the Web.
Thomas - 25 Apr 2006 8:08 PM - 7 messages
i created simple 1 table database then created a form for it. i was able to simply save in my root folder and post it to my site. I am wondering if i make changes to it will returning visitors be able to ...
Score SQL Question; Populating one table with data from another table.
Jan T. - 25 Apr 2006 7:31 PM - 7 messages
I have a database containing table "tblCustomers" and table "tblPayments". Now, I want to run a query to Insert new payments for certain customer that have some criteria. That is, if the customer has StatusID <> 2, a new record should be added to the table ...
Score Can you replace values on report?
Eric - 25 Apr 2006 6:00 PM - 5 messages
Say I have a table with 4 fields: Jobid <autonumber> <key> Jobname <text> Jobcost <currency> Costknown <yes/no> After entering data to this table, is there a way to print a report showing ...
Score PRINTERS
RHAB - 25 Apr 2006 5:41 PM - 2 messages
Put INFO in for each type of printer. Setups are different I use a HP DESKJET 3650 & I cannot figure out how to print across the 11" side & in the middle of the page. I see how to indent & all the BS but no where do I see CENTER. ...
Score The design of accounting databases
Isis - 25 Apr 2006 5:23 PM - 10 messages
Anyone have any good links to info on how general accounting databases are set up ? I am putting something together in Access to link my inventory and invoicing system with but would like an idea of the general layout of the ...
Score Help with designing Tables
Ed - 25 Apr 2006 4:14 PM - 3 messages
Hello I'm a new user to Access. I am designing a database and I have so far 4 tables: -Office Directory -Client Directory -Project Directory -Suppliers Directory I don't know which would be the best way to do so... for example each person ...
Score Importing templates; Why is the import button inactive?
Sevans - 25 Apr 2006 3:58 PM - 2 messages
I am trying to import a template in Front Page 2003; I go to Tools, Packages and the Import button is inactive.  How to I import a template? ...
Score Table Field Auto Update?
Dj - 25 Apr 2006 3:11 PM - 11 messages
My table has the following...   Last Name (Smith)   First Name (John)   Full Name (Smith, John) (The short reason why is because different departments have different needs/wants). My question; with just entering Last and First, can I have Full populate ...
Score Having a field auto update
Dj - 25 Apr 2006 3:07 PM - 3 messages
My table has the following... Last Name First Name Full Name ...
Score Order by property and date field
Gazza - 25 Apr 2006 2:13 PM - 5 messages
I am trying to sort my records on a form by a date field called [Job_Due] however when I set the order by property of the form to [Job_Due] it doesn't seem to do anything.  What could I be missing ? ...
Score Adding Subreport totals to Main Report to get Grand Total
ejike_discuss - 25 Apr 2006 10:05 AM - 8 messages
hi I have created a Report that has totals and within it is a Subreport that has its own total. What i want to do now is to add these two sets of totals together to create a Grand Total but i really do not know how to go about it. ...
Score Can't edit record in a query field
dbnDavid - 25 Apr 2006 10:04 AM - 5 messages
I can't edit certain records in query fields. I have, for example, a table tblClients with a lookup field to a table tblClientType (which has just one field, ClientType). I have no problem choosing a different ClientType value for a record in datasheet view of the ...
Score how do i Calc in fields
Hassan Merzha - 25 Apr 2006 9:04 AM - 4 messages
Hi I know it could be simple but i do not know how to do it in access! My Question is how can i calculate fields?let me explain. i got two field called "N1" and another Field Called "A1".so i want when i ...
Score SQL - Printing Dates With 0 "Count" Records
scadav - 24 Apr 2006 9:45 PM - 10 messages
Hi, I am trying to run a query in access and the users of the system would really like to see a report with dates even though there are 0 values for the dates.  For example, we are calculating how many times an ...
Score Synchronize access
iridium - 24 Apr 2006 7:41 PM - 5 messages
I have a database that runs on our network (Access 2000).  We have service engineers that go out to our clients sites. I want them to have a copy of the database that they can update on the road and once they ...
Score How do I find reoccurring data in a column?
riotgear - 24 Apr 2006 6:33 PM - 3 messages
I'm looking to set a column as a Primary key, but it keeps telling me that I have reoccurring data, which I can't find?  Is there a way to search for it? ...
Score Relationships
Nokia8310 - 24 Apr 2006 6:01 PM - 2 messages
I have a Contact Details Table which has a Primary Key number. I also have a Property Details Table which has a Primary Key Number. In my Contact Details Table there can be up to three different people per contact Id number (this is because they could all be buying the same house) ...
Score Editing app while open somewhere else
Tom G. - 24 Apr 2006 6:01 PM - 2 messages
I am new to developing in access for multiple users. We have the database residing on a server so differernt people can use it. Is it possible to work on the database app (add, edit forms, modules etc...) while other people are ...
Score MDAC 2.8
John - 24 Apr 2006 12:03 PM - 3 messages
Hi, Please if you can read and help me in this questions, as I am beginner in programming. I am using ADO connection to MS Access database (DAO is not an option) in VB.NET 2005 project and I have to setup deployment of program. ...
Score opening different forms when opening database
Daniel - 24 Apr 2006 11:49 AM - 9 messages
My be a stupid question but is it possible to open different forms using different shortcuts for the same Access database? Daniel ...
Score Converting a 2003 database to an earlier version
Paul Mackman - 24 Apr 2006 10:46 AM - 2 messages
Can anyone tell me if it is possible to save as an earlier version please.  I have Office 2000 and would like to use an Access 2003 template available on the MS site.  Can I get a 2003 user to save it as an earlier version for me ...
Score combine different product tiers into single drop-down list?
dbnDavid - 24 Apr 2006 10:05 AM - 4 messages
I'm constructing a database for a journal and I want to set up an orders form where orders can be placed either for an annual volume (two, occasionally three, issues) or for a single issue. I'd like it to be possible for a volume ...
Score How do i remove outlook mailbox
deby frye - 24 Apr 2006 12:13 AM - 3 messages
I did not want microsoft office mailbox to override my original people pc one. How do I undo that? ...
Score How to edit imported data in Access
Cat - 23 Apr 2006 8:21 PM - 6 messages
I imported a database from MS Works into Access in the csv format.  It missed the end characters of data in some fields.  When I try to type in the missing characters it just beeps at me and won't allow me to enter anything.  How do ...
Next »