Getting Started

Excel Spreadsheet Data
I am a ice hockey person that keeps the stats for my local club, for my interest only, for now. I am now thinking of expanding this to other clubs, which when you consider the way I do it in Excel would be very hard to accomplished. It works great for one club but not to great for many. I have a very limit... 2 Feb 2007 19:21

how to create a password form to open a form
hi, I just made a form and I want the form can be viewed by certain user only.So,I have prepared a pasword table but I don't know how to make it works. Meant,I just can made a "stand alone" form,please help. ... 29 Dec 2006 15:22

Subform
I have a subform where I am selecting a job code. Each job code has an assigned time value. Example: 4100 1.0 4300 0.3 4137 1.0 4003 0.3 The problem I am having is when you select code 4100 it will display correctly. If you select 4137 (which has the same time as the 4100), the code will display as 4100 ins... 13 Dec 2006 16:46

Opening Access 97 in Access 2003
We have an Access 97 database on our network, used by 110 members of staff, which has been working smoothly for over five years. Four months ago 2 of our staff upgraded to Access 2003 and at first had problems using the Access 97 database. One of our network guys looked into it and as far as I know the probl... 12 Dec 2006 07:14

DIFFDATE
I have a query to list all the WPS data that has been recorded in the last 5 days. The date is stored in Table "TblTransactionsdata" as [transactiondate]. It doesn't work. I must be missing somthing. SELECT TblTransactionsdata.WPS, * FROM TblTransactionsdata WHERE DateDiff("d",Now(),[transactiondate])<5; ... 5 Dec 2006 13:45

Need Help Quickly Database causing severe sleep probs
Hi i get the first bit of coding in and it opens report - but it doesnt show the record that im on - its showing all 200 of them. Would there be another way - iv tried to put a find button on the switchboard but its says `you cant use find/replace now` - i dont mind any type of box or button on switchboard or t... 10 Dec 2006 03:25

Recurring Database glitch + copyright
Hi. I am pleased to discover the recurring database developed by Duane Hookam and hope to successfully adapt it to bookings for a new conference and community centre I am volunteering at. I have read the threads on two questions posted by Kelly S and downloaded the sample database. I have problem entering test ... 5 Dec 2006 15:56

Windows XP Professional PC Reboots when printing from Access 2003
I have a situation where multiple people in a group utilize an Access 2003 database. Only one user has this issue. When she attempts to print to a regular HP LaserJet from the database, her screen goes dark and her PC reboots. When she prints to the MS Office Document Image Writer from this same database, she ha... 17 Nov 2006 07:14

Switchboard here, where's my data?
Help! I am very new to this access programming and having a wonderful time learning. I was just putting the finishing touches on my first program when I was trying to make the switchboard load FIRST. Well, that worked, except now I can't figure out how to get back into my database to do more work on it. H... 15 Nov 2006 20:55

Automation email
I'm working on automating my emails from Access to work through Outlook. I found a nifty code for VBA but it would seem the first line is wrong. It reads Dim objOutlookApp As Outlook.Application. It looks right to me but VB is telling me User-defined type not defined. What is wrong here??? ... 13 Nov 2006 15:01