Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Memory
Judy and Leo - 10 Jul 2009 5:15 AM - 2 messages
how do i manage the memory that gets taken up when i am looking at my e mail like yahoo or live.com is there some way to stop them from comming in? ...
Score Relationships
Dave - 10 Jul 2009 2:58 AM - 2 messages
I am working trying to connect two tables.  I have a table of instructors who are certified to teach various units and topics in a police course.  It includes the personal data name, address, etc. but also their State ...
Score subquery?
clyde - 9 Jul 2009 11:53 PM - 4 messages
I'm trying to create a status report that has a task field and a status field that may have multiple entries under a task before the status becomes 'complete'.  At the point the status is complete, I'd like to omit that task ...
Score Access vs. ACT
NJ Pete - 9 Jul 2009 11:47 PM - 2 messages
I'm starting a small business and I need a simple customer database. When I was with a previous employer, we used ACT as a customer database.  Some very useful things were: A reminder feature....it reminded me to call a certain customer on a certain ...
Score Query finding minimum date
Alison - 9 Jul 2009 9:00 PM - 2 messages
Hi, I have a database of projects with four different date columns (DOB, First LWS, First SLDWS, and First SA).  Some of these fields are blank. I want to run a query that will give me the earliest date from these four ...
Score Description column in object viewer in 2007 version
topmind - 9 Jul 2009 4:51 PM - 2 messages
I recently switched to 2007. In prior versions I relied heavily on the "description" column in the object browser (using the "detail" view option, which places it in a column). Now the only way I can see description is right-click and select "properties" per each object. ...
Score TransferDatabase help...totally lost
zmenloans - 9 Jul 2009 2:49 PM - 4 messages
Hi, First off, any help that you can offer with this problem would be greatly appreciated.  It does need to be done (if possible). I am relatively new to Access and can hardly understand coding, so I was hoping for some help. ...
Score Data Transfer
Roger Bell - 9 Jul 2009 9:34 AM - 6 messages
I have inherited a data base with around 20,000 records.  One of the fields is call "NAME" and contains data like: June Bell nee smith, Joan Thomas nee jones etc. What I would like to do is move all the text from nee onwards to a new blank ...
Score Importing dates from fixed-width text files to Access 2007
VickiH - 9 Jul 2009 4:59 AM - 8 messages
In the text file I am using, the dates are in the format DDMMYYYY with no delimeters eg 25102008 = 25 Oct, 2008.  In Access 2003, I could import this data directly to a field designated as Short Date.  Now I get blank fields ...
Score Now function on change
BrowDa - 9 Jul 2009 1:45 AM - 2 messages
I am trying to create a field in which the date time will change when I edit any field in the form.  I can't figure out how to do it even though it is probably quite easy.  Can anyone help me? ...
Score Access 2003 to 2007
Helen - 8 Jul 2009 9:23 PM - 2 messages
I have recently installed office 2007 and now access is saying that I don't have permission to open the 2003 db. I don't have problems with any other program. I only need access to names, adds, tel no's etc nothing else. ...
Score Tab Control
Roger Bell - 8 Jul 2009 9:38 AM - 5 messages
I have a single form with many fields in the Form.  I have added a Tab control to the form with 2 pages, to split the fields onto two pages  The problem is that when I click on either page the fields are repeated.  If I ...
Score Linking to selected fields in an external table
phillbee - 8 Jul 2009 7:51 AM - 5 messages
I want to make an external link to a table on an Oracle database using an ODBC connection. Unfortunately the table in the Oracle database has approximately 300 fields and only the first 255 appear in Access, which I believe is the limit. However, I don't need all of the fields to be linked. ...
Score Sorting based on selected value...Please help!
MadCSS - 8 Jul 2009 7:05 AM - 5 messages
I am trying to create a simple form where the users would enter (or select) the VIN number and all of the repairs that match that VIN number (and ONLY that VIN number) will be displayed.  I cannot save a filter for this because ...
Score Remove Spaces
Roger Bell - 8 Jul 2009 6:43 AM - 5 messages
I have inherited a Data Base where most fields have several spaces after the data. Can I use an Update query to clear the spaces, and if so, how would I write the Update query? Thanks for any help ...
Score Need report to only select the "yes" based on month
Hedwig14 - 7 Jul 2009 10:17 PM - 29 messages
I have a table that shows the company name, start date, id number and a check box (yes/no) fields.  My report currently allows me to select the month I want to report on but I need for it to only select those records in that ...
Score Time Conversion
Bre-x - 7 Jul 2009 5:19 PM - 5 messages
If you have work 1 hour 30 Minutes How do you convert it to 1.50 And viceversa  1.50 to 1h 30m Thank you all, Bre-x ...
Score Oracle to Access
Mohammed - 7 Jul 2009 5:18 PM - 2 messages
I have Oracle database about 50 GB can I Import into access database.  Is it possible.  It will work good.  This access database can support 50 GB data smoothly.  Anyone can help me in this? ...
Score Unwanted Parameter! HELP!
MadCSS - 7 Jul 2009 11:40 AM - 3 messages
There is a parameter (Phone Number) that pops up every time I try to open a related Form or Report.  I changed this field at one point so that instead of just Phone Number, there are now ¨Home Phone¨ and ¨Cell Phone¨ and am pretty ...
Score RE: only calculate business days exclude weekends
Felina - 6 Jul 2009 10:01 PM - 2 messages
where do i post the code at? i tried to post to: form, my scheduled due date, properties, event and then used the code button...please help!! ...
Score Office 2007 ultimate long "configuration" process every time
racerxnico - 6 Jul 2009 9:38 PM - 2 messages
My computer crashed a little while ago.  I used the restore discs and reinstalled Office 2007 ultimate on the computer.   Now, every time I want to use one of the programs, it goes through a lengthy "configuration" process ...
Score ms access as a backend
Bre-x - 6 Jul 2009 5:53 PM - 2 messages
If you create an appliction that uses ms access as a backend do you need to install ms access? Thank you all, Bre-x ...
Score Conditional formatting based on the Row Source in another control.
Aria - 6 Jul 2009 5:06 PM - 7 messages
How do you conditionally format a text box that is based on an IIF statement in another control? This is a sub form (sfrmKeys) with the following SQL: Row Source: SELECT [tblLocks].[LockID], [tblLocks].[Location], [tblWings].[WingDescription], [tblBuildings].[BuildingDescription], [tblBuildings].[Active], IIf([Active]=False,[BuildingDescription] & " ...
Score relationships
Striker - 6 Jul 2009 12:31 PM - 3 messages
I've been asked to normalize a database created in Access 2007.  Originally created for personal use, and make it usable for many.  One of the main tables has a PK field that is text 255 in length.  Looks like he just ...
Score Running procedure on Navigation Button's click
Garu - 6 Jul 2009 5:31 AM - 3 messages
Hi, Is it possible to run a procedure when Next or Previous button of the built-in navigation button (located at the bottom of the window) is clicked? I can't seem to find it in the Form's event properties. ...
Next » 2 3 4 5 6 7 8 9 10