| Thread | Last Post | Replies |
|
| Problems Compacting Access in Office 2007 | 20 Jul 2008 05:10 GMT | 12 |
Access 2007 does not appear to compact. For example, I had a database containing 50K records and it created a database size of approx 70MB. I deleted all records and then ran a compact. File size did not change. In 2003, that file would've shrunk to a much smaller size.
|
| Table 'MSysAccessObjects' already exists | 20 Jul 2008 04:51 GMT | 7 |
I am receiving this error message when I attempt to open an Access 2000 .mdb file. I also receive it when I try to import from that file into a new .mdb file. I opened the file with no problem two days ago and closed it normally (as far as I know). The error started appearing ...
|
| Macros blocked in distributed DB | 20 Jul 2008 03:47 GMT | 9 |
I am attempting to distribute a 2007 Access db with mainly VBA code but 2 Macros. The Macros are Autoexe which starts a function and a macro to handle the ribbon. The db has been developed on a machine running Office 2007 under VISTA.
|
| Error when converted to 2007 | 20 Jul 2008 03:40 GMT | 11 |
After converting to MA 2007 from MA 2002 I am getting this error when I try to Create a Holding Invoice Run-Time Error '3709' The connection cannot be used to preform this operation.It is either
|
| Changing a field name in all my queries and reports | 20 Jul 2008 02:39 GMT | 7 |
i tried to search and found alot of stuff that didnt pertain to what i need so ill ask.. i have to change a few fields in some MySQL linked tables. thus i also need to update those changes in alot of queries and reports. is there an easy way
|
| Problems with sending emails with Access after installing Outlook | 20 Jul 2008 01:39 GMT | 5 |
I am using MS Access 2007 and Mozilla Thunderbird. I'am sending automatic email notofications with Access (DoCmd.SendObject). Today I've installed MS Outlook 2007 to check how does it work. When Access was trying to send an email, a window appeared, that says "Warning, something ...
|
| Access 2003 Forms | 20 Jul 2008 01:13 GMT | 5 |
I have created a form, every time I open it an "Enter Parameter Value" box appears, how do I get rid of it?
 Signature GrahamK
|
| ADO Library | 19 Jul 2008 21:29 GMT | 9 |
Starting a new Access 2007 project that will utilize ADO as well as DAO. I have many versions of Microsoft ActiveX Data Objects Library on my machine. Can anyone tell me what is the version that I could expect anyone running
|
| COMBO BOX REQUERY | 19 Jul 2008 20:55 GMT | 9 |
Please help me out of this problem. Because I don't want to use the NotInTheList Event for my combo boxes, I have this code in the Close Event of my Membership form: If IsLoaded("Donations") Then 'Forms!Donations!Donor.Requery
|
| How to autofill in a table | 19 Jul 2008 19:27 GMT | 6 |
For example, there are some fields in a Human Resources table, like 'name', 'sex', 'age' and so on. Now I input a person's name in the salary table which also contains 'name', 'sex' and 'age' fields. I want Access autofill his/her sex, age information when I input his/her name, ...
|
| Many-to-Many Relationship | 19 Jul 2008 14:39 GMT | 13 |
My database is about educational programs. There is a general "program" table that contains four fields about personnel who have roles in the program (i.e., "Program Director," "Assoc. Program Director," "Program Coordinator," and "Assoc. Program Coordinator"). There is another ...
|
| Is Access right for me??? | 19 Jul 2008 02:10 GMT | 14 |
I am wondering if I should start to use access with my team? I support a team of 8 sales reps.. we gather info from contacts and then distribute that info to our partners as a lead. I find that we are retyping a lot of the same information just in different places within word ...
|
| Kluge Access Openings | 19 Jul 2008 01:38 GMT | 4 |
I am having a problem with opening up a shared Access database and was wondering if anyone can advise. Our office has three employees that use this database... with one user, the only way they can open up this database (when another employee is in the database) is to launch ...
|
| Access 2007 Sharing a Database with Multiple Users | 19 Jul 2008 01:31 GMT | 4 |
I have a pc and a laptop that are networked through an adsl router. I have managed to share printers and have created a shared directory on the PC. The laptop has full access to the dirctory and there is an access database in the directory. I am able to open the access database ...
|
| Data access, table data display in adp's. | 19 Jul 2008 01:26 GMT | 4 |
I have an issue with displaying tables in design mode in MS Access to SQL Server. I have 20 or so tables and most will enable the design view from MS Access. Most will show their data simply by a dbl click. Others will not. They do nothing when selected and choose ‘Design’. I ...
|