Home All Groups Group Topic Archive Search About

Getting started with Microsoft Access

microsoft.public.access.gettingstarted
Score Remembering settings
EdMack - 8 Nov 2008 4:49 AM - 4 messages
When I use the run command it does not list past settings, something I need for latex commands. The system does not remember other settings, like internet access, Is ther some way to adjust this? ...
Score Showing a report with records between two dates
jyanks - 7 Nov 2008 9:50 PM - 19 messages
Now I know that the way you display a report with records between two dates is to set the Query criteria to something like: >#2/2/2006# and <#2/4/2006# Say I want to have the user input two dates and then hit a button that ...
Score lookup syncronization
GregJ - 7 Nov 2008 8:51 PM - 2 messages
Newbie User... I have a form with a lookup to a "Company Name" field which works great. Then I have another field that I want to do a lookup on a contact person, and I want the Contact lookup to only display the records that match the "Company ...
Score Form-Query-Entry Question
Cardinal - 7 Nov 2008 3:30 PM - 7 messages
I have a room reservation app that is shaping up OK but it still has some things that I would like to improve on. I have created forms for each of the computer rooms in our organization. The rooms are DLR1, ...
Score Using Access DB from a CD
meg - 7 Nov 2008 2:50 PM - 3 messages
If I have an access database on a CD can I access it, add/change tables and save back to the CD? ...
Score Multiple Records
pupkiss1965 - 7 Nov 2008 7:14 AM - 32 messages
I have a corporate database that has multiple directors, officers and shareholders and would like to list all of the directors in one list box in the form...so if I pull up ABC Company and click on the director name it ...
Score Automatic Operation
Pepper - 7 Nov 2008 12:48 AM - 8 messages
I have a rather interesting challange, made more difficult because my company holds very sensitive information of millions of people. What I want to do is Set Up a Recurring Schedule to automatically Run a Report in Access 2003, convert it to a PDF and Email it to a defined set of ...
Score Turn on Code and turn off Macros
TKM - 6 Nov 2008 11:18 PM - 4 messages
I recided Access 2007 on my Test laptop. For some reason I can only run wizard macros and not Code. I tried writing basic code "docmds" and others and none of the code runs. Even if I conver the macros to code. Code does not ...
Score Web Toolbar
Bre-x - 6 Nov 2008 9:20 PM - 3 messages
using VBA how do you close? Thank you all Bre-x ...
Score Newbie Refresh question
Cardinal - 6 Nov 2008 8:37 PM - 3 messages
I split a database and set the back end tables up on a shared network drive. Then I created mde files and distributed to one other person so we could test. He entered records and I entered records at the same ...
Score Nested IF Function Will Not Return Other Values
Maureen - 6 Nov 2008 8:10 PM - 3 messages
I have written the following Nested IF function: =IF(K13="N","NA",IF(K13="1","A",IF(K13="2","B",IF(K13="3","C",IF(K13="4","D"))))) However, once applied, only the 1st value "NA" is returned when the ...
Score Setting In Relationship for One to Many
TKM - 6 Nov 2008 5:58 PM - 3 messages
How do you get the arro and the two zeros "00" to show when the relationships are set? They use to show in the one to many the arrow means one and the 00 means many. Is there a setting to bring those back in 2007? ...
Score linking tables
dclem - 6 Nov 2008 4:47 PM - 6 messages
I currently work in excel in multiple spreadsheets and we are looking at moving to a database program. I know a little bit about access but not much. Is there a way to link tables together that contain the same information, ...
Score Ole Object Problems
Karen - 6 Nov 2008 4:30 PM - 2 messages
In our database we have an ole field in a table that we insert images such as excel, word and PDFs. The setting for the field is EITHER (embedded,linked). When I look in our table now, we have Package, Imaging, Excel, Word and now ...
Score Installing 2007 runtime app on Terminal Server 2003- issues?
Damon Heron - 6 Nov 2008 4:25 PM - 11 messages
I have an Access runtime app that a user in another state has attempted to install on Terminal Server, and the install routine crashes.  Not sure what the error msgs are at this point, but it appears to be something with "msi" - ...
Score combobox list default
ferde - 6 Nov 2008 4:18 PM - 5 messages
I have a form that generates data to one table.  I would like my combobox list on the form to default to "N/A" when the form opens but when I set the default value on the property box in design mode to "N/A" which is the first ...
Score SUBDATASHEET HELP
LeAnn - 6 Nov 2008 1:57 PM - 6 messages
I am a new user of Access and need some help with subdatasheets. I have a database set up with a one table that has a subdatasheet and that subdatasheet has a subdatasheet. 1. Table 2. Subdatasheet 3. Subdatasheet The problem I am having is when I add a new record in the second data sheet, ...
Score Help Needed: Calculated Fields!
Jen - 6 Nov 2008 10:59 AM - 3 messages
I am trying to create a query with a simple multiplication of fields, ie [Amount]*[Unit Cost] to get a Total for each item.  I know I need to use a calculated field in the query, but I have no idea how to do this!  I have a ...
Score FIlter subform on time-range defined by mainform cboTimeRangeSelec
Mishanya - 6 Nov 2008 12:56 AM - 7 messages
I have Mainform with cboTimeRangeSelector based on tblTimeRange: RangeID     Range         RangeExpression 1               Month         "Between Date( ) And DateAdd("m", 1, Date( )) " ...
Score Field Size: Integer to Double
Bre-x - 5 Nov 2008 10:15 PM - 6 messages
I have this function to download data from a Pervasive SQL into MS Access Public Function get_hrs(WOPRE As Double, WOSUF As Double) Dim sql As String sql = "SELECT * FROM WOLABOR WHERE MTWOLA_WOPRE = " & WOPRE & " And MTWOLA_WOSUF = " & WOSUF ...
Score Nz function not working
Mishanya - 5 Nov 2008 7:44 PM - 10 messages
In the MainForm there is an unbound box MainformTotal showing total from Subform. Its Control Source goes: =[SubformName].[Form]![SubformTotalControlName] and it works perfectly. When the SubformTotalControlName is empty (no records in the Subform), the MainformTotal control shows #Error. I change its Control Source to: ...
Score Show Properties Window in Form-View
Mishanya - 5 Nov 2008 6:46 PM - 4 messages
I've just learnt that some of my forms allow to view the Properties Window and change it parameters without switching to Design View, while others don't let choose the Properties Option once right-clicked and allow this only in ...
Score How to adjust Access 2003 design window please ?
veryappreciative - 5 Nov 2008 5:24 PM - 2 messages
...
Score format question
Steve Goodrich - 5 Nov 2008 1:42 PM - 6 messages
I have a simply query, Two of the fields being First Name and Surname.  All the fields in the database are in upper case. I would like to format the query so I get the Initial only of the first ...
Score Delete query from two tables
SoggyCashew - 5 Nov 2008 8:55 AM - 11 messages
Hello, I want to run a delete query from a button on my form. The form is a continious form and each row has a text box "txtEmployeeID" that shows the UserID. I want to be able to delete the information pertaining to the userID ...
Score Workgroup Administrator
Roger Bell - 5 Nov 2008 6:56 AM - 2 messages
Workgroup Administrator does not appear to be available in Access 2007.  How can you join a Workgroup (System.mdw) in this version, which I know was available under Tools_Security in previous versions. Thanks for any help ...
Score Encoding/Decoding
Roger Bell - 5 Nov 2008 6:54 AM - 2 messages
Can anyone please explain the Benefits of Encoding/Decoding a Data Base and if there are any implications? Thanks for any help ...
Score Permissions
Roger Bell - 5 Nov 2008 5:21 AM - 2 messages
I have installed a working Data Base on another Computer, but when the user attempts to open the Data Base, an error message is recieved "You do not have the necessary permissions to open this data Base" Could anyone advise me what the problem could be and a way to overcome this? ...
Score Populate data in cboBox from another cboBox
SoggyCashew - 5 Nov 2008 4:54 AM - 3 messages
Hello, I have a combo box that im using to display departments in the list using: SELECT tblDepartment.DptID, tblDepartment.Department FROM tblDepartment; for its row source. then in the next combo box it populates a lis of names in that combo box based on what was selected from the department combo box ...
Score vba exporting data
Bre-x - 4 Nov 2008 10:39 PM - 2 messages
Hi, I am exporting data to MS Excel ID, WOPRE, WOSUF, WOOPER 1, 5230, 23, 10 2, 5230, 23, 20 3, 5230, 23, 30 4, 5230, 30, 10 5, 5230, 30, 20 How I can accomplish this: ID, WOPRE, WOSUF, WOOPER ...
Score composite keys and foreign keys
Fred - 4 Nov 2008 10:38 PM - 4 messages
In a response I received to a question, it mentioned that I should create a unique index on the three or four column candidate key. How do I do that? It also mentions that three of my other ID columns constitute a ...
Score Thoughts on Lookup Fields
Stimpy707 - 4 Nov 2008 7:09 PM - 8 messages
I was wondering if a few of you could share your wisdom regarding lookup fields. I could be mistaken but it seems that I have read some posts that have recommend staying away from using the Lookup Wizard on fields in a table and ...
Score error executing command
pstechnology - 4 Nov 2008 6:41 PM - 4 messages
I bought a new computer. XP Home and Office 2003. I copied my access files over to new computer. When I open my access files I get an error. then I click on a button on my access file and I get an ...
Score Daily change label
Striker - 4 Nov 2008 4:23 PM - 7 messages
I have a database that has a main form.  ON the main form is a label at the top.  I have some people who want to cahnge the label randomly each time the DB is opened.  Seems a little silly to me but they want a motivational ...
Score How can we have a field assign a num. automaticly starting with 29
Dan - 4 Nov 2008 3:30 PM - 17 messages
My goal is as follows: We use the 1st two numbers to specify the year our customer sign up & the last four will be there account number.  We would like the program to assign the number so we don't use the same number twice. ...
Score Database Problems
Gary Botha - 4 Nov 2008 10:05 AM - 6 messages
Hi, we have made a database that contains pictures with 1280 records, when the database goes over 1.99 Gig, access goes into repair mode and we lose everything, are the pictures causing the problem or is it file size? Please ...
Score Access 2007 GUI: not(tabbed) ?
Allen_N - 4 Nov 2008 6:38 AM - 3 messages
The tabbed view for forms in Access 2007 can be handy, but I often want to see more than 1 form (or table, or query, or report) at once.  However, I can't find any way to revert to the "classic" views. ...
Score Copy database
Annette - 4 Nov 2008 1:34 AM - 3 messages
Hi everyone, I am new to access and hope that someone can help? We use access 2002 and have several databases on a shared drive. How can I copy a database to practice on but not affect the original database. ...
Score VBA question regarding the me.* in code
iamrdbrown - 3 Nov 2008 4:47 PM - 9 messages
I am just beginning to learn VBA & have run across the following syntax in some of the lessons I am following online: 'Retrieve the hourly salary     HourlySalary = CDbl(Me.txtHourlySalary) My question (that isn't covered in my lesson) is this:  Does the Me._____  ...
Score How to build a database of document links in Access????
nkmcpherson - 3 Nov 2008 3:03 PM - 3 messages
I need to build a document library for databases, where the user can run a query and locate links to documents based on the query they run.  For example, a query for ethics would pull up links to all documents that have ...
Score Microsoft Course
Acc - 3 Nov 2008 2:17 PM - 2 messages
Hi There Im not sure if it is ok to post this question here, I would like to find out if anyone has heard of a course with 'New Horizons". On their website, it states that they are Microsoft accredited, as well as ...
Score Looking Up Records On A Data Entry Form
DataDiva via AccessMonster.com - 3 Nov 2008 1:54 PM - 5 messages
Hello, I have created a tabbed form that has four sub forms. The parent child links are the (PK, AutoNumber) NCMR_Number and PTC_Part_Number. The database is set up to track non-conforming material. I have separated the tabs out by ...
Score compare data in identical tables
David - 3 Nov 2008 1:50 PM - 3 messages
Well their structure is identical. I have 2 tables that have different data. The tables have 204 columns and 10, 864 rows.  Mostly small text fields, date fields and yes/no fields but there are 10 Memo fields. I need to show the rows where any table 2 values are different from ...
Score How to find the time elapsed between 2 events
hcapper - 2 Nov 2008 9:19 PM - 2 messages
Maybe someone here can help me. I have a database of customers with information on their purchases. I need to get the time elapsed between purchases and then get an average of time (in days) between purchases. For example I want to sample 10% of my customers with at least X number of ...
Score Getting subform to open/load with a new record
Mishanya - 2 Nov 2008 8:55 PM - 12 messages
When I select ClientID in the ParentForm, the subform (singleView) is automatically loaded with the first relevant record. I want it to load blank, ready for a new entry. Normally I'd put      DoCmd.GoToRecord , , acNewRec ...
Score A map activated from a form
Johnathon Anderson - 2 Nov 2008 6:22 AM - 4 messages
I work in a school with a catchment area in Stevenage.  Parents of children applying for entrance for their children to the school’s extra curricular activities must live between Farlands and Martins Ways (which basically circumvents the town center).  We have had to set limits as the activities ...
Next » 2 3 4 5 6 7 8 9 10